| Author |
Message |
Topic: Integer to Varchar |
delta403
Replies: 11
Views: 15804
|
Forum: Database Posted: Thu Jul 05, 2012 4:09 pm Subject: Integer to Varchar |
OPTION ZDPRINT
INREC BUILD=(1,12,SFF,TO=ZD,LENGTH=12)
SORT FIELDS=(1,12,A),FORMAT=ZD
SUM FIELDS=(1,12,ZD)
OUTREC FIELDS=(1,12,ZD,EDIT=(SIIIIIIII.IT),SIGNS=(,-)
Consider the above as an exa ... |
Topic: Integer to Varchar |
delta403
Replies: 11
Views: 15804
|
Forum: Database Posted: Tue Jul 03, 2012 1:24 pm Subject: Integer to Varchar |
Please do as below:
Step1: Reformat your input file as per the syspunch by using SORT utility.
OPTION ZDPRINT
INREC BUILD=(1,12,SFF,TO=ZD,LENGTH=12)
SORT FIELDS=(1,12,A),FORMAT= ... |
Topic: EXIT. vs CONTINUE. |
delta403
Replies: 9
Views: 11327
|
Forum: Application Programming Posted: Fri Jun 22, 2012 4:13 pm Subject: Exit and Continue |
First let me describe the difference between EXIT and Continue;
Exit - It will come out the section and control will flow down the section; You can use this, when your program is written in the form ... |
Topic: Compression |
delta403
Replies: 6
Views: 6125
|
Forum: Database Posted: Fri Jun 08, 2012 10:29 am Subject: Compression |
| Are you getting any error while loading; Please share. |
Topic: Recovering a deleted file |
delta403
Replies: 7
Views: 9179
|
Forum: TSO and ISPF Posted: Wed May 09, 2012 4:24 pm Subject: Recovering a deleted file |
| try this: HRECOVER dataset.name on command prompt (normally tso;6) |
Topic: DFSORT MATCH with existing Dups on Files! |
delta403
Replies: 16
Views: 19345
|
Forum: Utilities Posted: Thu May 03, 2012 10:18 am Subject: DFSORT MATCH with existing Dups on Files! |
| @dbz: SPLICE will sort the records automatcially, we don't need to specify any sort step for this. |
Topic: DFSORT MATCH with existing Dups on Files! |
delta403
Replies: 16
Views: 19345
|
Forum: Utilities Posted: Thu May 03, 2012 9:55 am Subject: DFSORT MATCH with existing Dups on Files! |
Please use the ICETOOL utility for this purpose.
COPY FROM(IN1) TO(TEMP)
COPY FROM(IN2) TO(TEMP)
SPLICE FROM(TEMP) TO(REPORT) ON(1,6,CH) WITH(23,24)
Please Do Not advertise here |
| |