Joined: 28 Jan 2011 Posts: 2 Location: springfield,virginia
I am using SYNCTOOL to Read in sorted file then put data to heading report foramt.
[2]Sorted input file: (DSN=TEST.DVL.USER.S01)
col 1-9 col 10-24 col 25-34
001111111AAAAAAA FFFFFFF A00111BBBx
002222222BBBBBBBBBB GGGGG B00222BBBB
003333333CCCCCCCC HHHHHH C00333BBBx
004444444DDDDDDDDDD IIIII D00444BBBx
005555555EEEEEEEE JJJJJJ E00555 BBBx
006666666FFFFFF LLLLLLLL C11166CCCO
col 1-9 ID-number x(9)
col10-24 Last name x(15)
col25--34 First name x(10)
col35-38 loc-id x(4)
col39-40 code x(2)
col41-44 office x(4)
[2]Ideally, I'd like to extract the first 3 byte of col41-43 office which has "BBB" type of records. I put all required records to heading format as below:
DATE: current date official use only TIME:current time
User report page 1
User Last name First name Loc-id code office
------------- ------------ ------------ ------- ----- -------
001111111 AAAAAAA FFFFFFF A001 11 BBBx
002222222 BBBBBBBBBB GGGGG B002 22 BBBB
003333333 CCCCCCCC HHHHHH C003 33 BBBx
004444444 DDDDDDDDDD IIIII D004 44 BBBx
005555555 EEEEEEEE JJJJJ E005 55 BBBx
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
Andy, it would probably be helpful if you would double-check your job to make sure you've accounted for all of the necessary DD statements (I updated your code to be syntactically correct) and then posted the output of your TOOLMSG and DFSMSG DD statements.
Joined: 28 Jan 2011 Posts: 2 Location: springfield,virginia
Kevin:
Thank you for issue solutions.
I read SYNCTOOL DD statement menu. It seems I only need INDD/TOOLMSG/DFSMSG or PRINT/ USER DD statements for my query report. However, after job ran, I got below message "code 12".