 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 7 matches |
| Author | Message |
|---|---|
 Topic: converting spaces to zeros |
|
| new user Replies: 5 Views: 10987 |
 Forum: Utilities Posted: Tue Oct 26, 2004 7:13 am Subject: converting spaces to zeros |
| Hi Kolusu
i am trying to use the same SYSIN card to convert SPACES,LOW-VALUES and HIGH VALUES to zeros for the same field (starting 168). in the OUTREC, i am stating OUTREC FIELDS=(001,167,CH ... |
|
| Topic: date parameter in SQL |
|
| new user Replies: 4 Views: 3542 |
Forum: Database Posted: Sun Oct 24, 2004 2:16 am Subject: date parameter in SQL |
| Hi Kolusu
Thanks for your reply. That was a good suggestion. But is it possible to achieve something like this : //UNLOAD EXEC PGM=IKJEFT01,DYNAMNBR=100 //SYSTSP ... |
|
| Topic: date parameter in SQL |
|
| new user Replies: 4 Views: 3542 |
Forum: Database Posted: Thu Oct 21, 2004 4:10 am Subject: date parameter in SQL |
| Hi,
In one of my DB2 UNLOAD JCL, the date range is specified in the WHERE clause of the SQL as WHERE DATE (INSERT_TIMESTAMP) BETWEEN '2003-09-05' AND '2004-09-05' Is it possible to rep ... |
|
| Topic: populating SMALLINT |
|
| new user Replies: 3 Views: 2894 |
Forum: Utilities Posted: Mon Oct 18, 2004 9:49 am Subject: populating SMALLINT |
| Thanks a lot Frank and Kolusu.
it really helped Regards -new user |
|
| Topic: populating SMALLINT |
|
| new user Replies: 3 Views: 2894 |
Forum: Utilities Posted: Fri Oct 15, 2004 12:28 pm Subject: populating SMALLINT |
| Hi
i have a sequential file of 80 bytes (FB). i am adding a identifier field of length 1 (which takes value 1,2) at position 81 using DFSORT and finally loading the values to a DB2 table. The h ... |
|
| Topic: converting spaces to zeros |
|
| new user Replies: 5 Views: 10987 |
Forum: Utilities Posted: Fri Oct 15, 2004 12:11 pm Subject: converting spaces to zeros |
| Thanks a lot Frank and Kolusu.
it really helped regards -new user |
|
| Topic: converting spaces to zeros |
|
| new user Replies: 5 Views: 10987 |
Forum: Utilities Posted: Tue Oct 12, 2004 10:29 am Subject: converting spaces to zeros |
| Hi
i have a sequential file (FB) of length 270. The field starting from position 168 is defined as S9(3) COMP-3 and for certain records - this field contain spaces. i need to convert the spaces to ... |
|
All times are GMT - 5 Hours |