Convert PD to ZD using File-Aid



Compuware's data management products: File-AID for IMS, File-AID/MVS, File-AID for DB2 and DBA-XPERT for DB2

Convert PD to ZD using File-Aid

Postby ranga_subham » Thu May 14, 2009 7:13 pm

Hi,

Would you please give the File-Aid batch job to convert a PD (COMP-3) field to ZD.

TIA.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: Convert PD to ZD using File-Aid

Postby nayanpatra » Tue Jul 07, 2009 10:19 am

//JOBNAME JOB ...
//STEPNAME EXEC PGM=FILEAID
//SYSPRINT DD SYSOUT=T
//SYSLIST DD SYSOUT=T
//SYSTOTAL DD SYSOUT=T
//DD01 DD DSN=...
//DD01O DD DSN=...
//DD01RF DD DSN=...
//SYSIN DD *
$$DD01 REFORMAT REFOUT=ALL
/*
nayanpatra
 
Posts: 19
Joined: Mon Jul 06, 2009 4:35 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Convert PD to ZD using File-Aid

Postby dick scherrer » Tue Jul 07, 2009 11:58 pm

Hello,

Suggest you provide clarification. . .

The posted "solution" does not show how to convert a packed-decimal number to zoned-decimal.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Convert PD to ZD using File-Aid

Postby Naveen@Uppi » Thu Jul 16, 2009 12:30 pm

HI,

I think this can easily done using the IEBGENER utility

//SYSUT1 DD DSN=OLDFILE, etc.
//SYSUT2 DD DSN=NEWFILE,UNIT=DISK,V=S=5,DISP=(NEW,KEEP),
// SPACE=(TRK,(2,1)),DCB=(LRECL=36,BLKSIZE=720,RECFM=FB)
//SYSIN DD *
GENERATE MAXFLDS=4
RECORD FIELD=(9,1,,1)
RECORD FIELD=(20,10,,10)
RECORD FIELD=(4,30,PD,30)
RECORD FIELD=(7,34,ZP,38)
/*

Thanks and regards,
Naveen N
Naveen@Uppi
 
Posts: 36
Joined: Wed Jul 23, 2008 6:49 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Convert PD to ZD using File-Aid

Postby dick scherrer » Thu Jul 16, 2009 11:49 pm

Hello,

I think this can easily done using the IEBGENER utility
The request does not mention iebgener. . .

This could also be done with the sort . . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to File-AID

 


  • Related topics
    Replies
    Views
    Last post