1. learn REXX,forget CLIST
2. numerics are always zero suppressed. If you want more than 1 zero for the value zero, make it alpha with format instruction. (don't remember if fomat is a clist instr..)
Search found 940 matches
- Thu Dec 18, 2014 8:02 pm
- Forum: TSO, CLIST & REXX
- Topic: Leading zero values in clist
- Replies: 1
- Views: 3203
- Mon Dec 15, 2014 8:43 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: DB2 query with performance improvements
- Replies: 1
- Views: 3225
have you tried:
or
Code: Select all
and ( (t3.dateid1 in t9.dateid1) or (t3.dateid1 in t2.dateid1) )
Code: Select all
and ( (t3.dateid1 in t2.dateid1) or (t3.dateid1 in t9.dateid1) )
- Mon Dec 08, 2014 6:34 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Problem with CURRENT DATE in SQL - DB2
- Replies: 1
- Views: 3452
- Mon Dec 08, 2014 6:30 pm
- Forum: COBOL
- Topic: How to check if a field contains thai char
- Replies: 2
- Views: 4437
i imagine in your mainframes codeset, there are thai characters. they will have their own, unique hex value. determine the hex values for thai characters in your codeset and either use sort to do-what-ever or code a routine in your favorite programming language (this includes rexx, unless you have l...
- Mon Dec 01, 2014 7:15 pm
- Forum: JCL
- Topic: Creation of test data file through JCL
- Replies: 1
- Views: 2986
- Mon Nov 17, 2014 7:45 pm
- Forum: JCL
- Topic: GDG Versions created on same day
- Replies: 3
- Views: 7551
- Mon Nov 17, 2014 7:42 pm
- Forum: JCL
- Topic: access dataset on other sysplex
- Replies: 2
- Views: 3868
Re: access dataset on other sysplex
Hi gurus, Any DD-parameter, which tells, on what sysplex a dataset is located ? I believe discs that are assigned to a sysplex can be referenced from another, but I don't remember how they need to be defined. but, I think the real problem here is that you don't understand sysplex. are jobs not 'run...
- Mon Nov 17, 2014 7:32 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Query on Multi row fetch CPU time performance improvements
- Replies: 2
- Views: 4479
maybe because the multirow fetch only has affect on the result table, which (by looking at the sql) is the resouce user and not the fetch. i think that you will also find that the documentation concerning multirow fetch does little discussion of complex queries (in the sense of JOIN, UNION, subselec...
- Mon Nov 03, 2014 7:48 pm
- Forum: TSO, CLIST & REXX
- Topic: Filename Edit from 3.4 console
- Replies: 1
- Views: 3403
- Mon Oct 27, 2014 7:39 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Receiving SQLCODE -911 for CICS-DB2 module
- Replies: 1
- Views: 3578
are you also performing a syncpoint after the updates? the inserts will not give you a deadlock, but the updates in one task could cause a dealock for the updates in a second. have you considered running only one task? have you considered running this process in batch. what you are describing is 'ba...
- Mon Oct 13, 2014 6:49 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Need to update only the year in DATE format
- Replies: 2
- Views: 4516
- Mon Oct 13, 2014 6:43 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Check on low values in table
- Replies: 3
- Views: 5576
probably resource intensive but I imagine you will not be running this regularly (because the input program should be corrected),
the CONTAINS Function will provide you with what you need.
there are examples at the bottom of the page in the manual.
the CONTAINS Function will provide you with what you need.
there are examples at the bottom of the page in the manual.
- Thu Oct 09, 2014 7:31 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Check on low values in table
- Replies: 3
- Views: 5576
- Mon Sep 15, 2014 7:06 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Not able to do a Numeric check using sort.
- Replies: 5
- Views: 7357
- Thu Aug 07, 2014 3:48 pm
- Forum: EASYTRIEVE
- Topic: variable as an argument in the sum function
- Replies: 3
- Views: 7639