IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to move a file aid vfmt format output into flat file


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
magesh23586

Active User


Joined: 06 Jul 2009
Posts: 213
Location: Chennai

PostPosted: Tue Dec 18, 2012 10:49 am
Reply with quote

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
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2477
Location: Netherlands, Amstelveen

PostPosted: Tue Dec 18, 2012 12:07 pm
Reply with quote

You could use FA Batch to produce a file.
Back to top
View user's profile Send private message
magesh23586

Active User


Joined: 06 Jul 2009
Posts: 213
Location: Chennai

PostPosted: Tue Dec 18, 2012 12:36 pm
Reply with quote

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
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2477
Location: Netherlands, Amstelveen

PostPosted: Tue Dec 18, 2012 1:21 pm
Reply with quote

Probably you can tell FA to execute in batch in stead of foreground. Like in the reformat option (option 9?).
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts Convert PS to TXT file using jcl JCL & VSAM 7
This topic is locked: you cannot edit posts or make replies. Sort to include records of file 2 int... Java & MQSeries 1
No new posts define 1 DCB parms for multiple outpu... JCL & VSAM 9
No new posts How to modify file content using REXX CLIST & REXX 3
No new posts VB file copy COBOL program gives erro... COBOL Programming 3
Search our Forums:

Back to Top