|
View previous topic :: View next topic
|
| Author |
Message |
magesh23586
Active User
Joined: 06 Jul 2009
Posts: 213
Location: Chennai
|
|
|
|
I have a file, which has lot of packed decimal format, I could view it via fileaid, i need the file aid output to be moved to a flat file, so that i can read the file directly, rather than going to file aid option, I need this because i need to export this file in readable format. Kindly help..
| Code: |
File-AID - Edit - ZZZZZ.QUERY.RESULT ------------------ COLUMNS 0000
COMMAND ===> SCROLL =
xxxxxxxx YYYYYYY ZZZZZZZZ qqQ SDSDS SDSDFSD ASDFSDFA
2/BI 2/BI 2/BI 2/PS 3/PS 3/PS 3/PS
(1-2) (3-4) (5-6) (7-8) (9-11) (12-14) (15-17)
1------- 2------- 3------- 4------- 5------- 6------- 7-------
****** ***************************** TOP OF DATA ******************-CA
000001 23 2011 11 25 65 41888 41888
000002 23 2011 11 25 65 41452 41452
|
Advance thanks,
Magesh |
|
| Back to top |
|
 |
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| You could use FA Batch to produce a file. |
|
| Back to top |
|
|
magesh23586
Active User
Joined: 06 Jul 2009
Posts: 213
Location: Chennai
|
|
|
|
Thanks for the kind response.
Could you please explain how do i do that using FA Batch, You mean to say Fileaid ==> UTILITIES ==> INTERACTIVE, if yes where do i specify the Layout, or a copy book information ?
Tried this way, but doesnt help.
| Code: |
//STEP01 EXEC PGM=FILEAID
//*
//SYSUDUMP DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSLIST DD SYSOUT=*
//SYSTOTAL DD SYSOUT=*
//DD01 DD DSN=xxxxx.QUERY.RESULT,DISP=SHR
//DD01O DD DSN=xxxxx.QUERY.RESULT1,DISP=OLD
//SYSIN DD DSN=xxxxx.R1.WORK(TABSEC),DISP=SHR
|
Advance thanks,
Magesh |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| Probably you can tell FA to execute in batch in stead of foreground. Like in the reformat option (option 9?). |
|
| Back to top |
|
|
|
|
