variable length file filtering



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

variable length file filtering

Postby kamal » Thu May 29, 2008 8:05 pm

I have a Input file of length 1004 and is variable length.
I want to copy all records from this file into a file of same properties (Variable length +LRECL=1004) which are having 'S' character at position 1.
tried following code but it's not working

//STEP1  EXEC PGM=FILEAID,REGION=0M,TIME=5         
//DD01     DD DSN=INPUT.VL1004.FILE,DISP=SHR       
//DD01O    DD DSN=OUTPUT.VL1004.FILE,
//         DISP=(,CATLG,DELETE),UNIT=SYSDA,           
//         SPACE=(TRK,(5,1),RLSE),                   
//         DCB=(LRECL=1004,RECFM=VB,BLKSIZE=0)       
//*                                                   
//SYSIN DD *                                         
$DD01 COPY IF(1,EQ,C'S')                             
/*                                                   
//SYSUDUMP DD SYSOUT=*                               
//SYSPRINT DD SYSOUT=*         


the desired o/p is not coming...Is there any fault in Control card ...mean should it be
$DD01 COPY IF(5,EQ,C'S')
as it's variable length file..tried this also o/p is empty( yet not working ...)
Help at earliest would be appreciable.
Thank you.
kamal
 
Posts: 48
Joined: Wed Aug 22, 2007 2:49 pm
Has thanked: 0 time
Been thanked: 0 time

Re: variable length file filtering

Postby kamal » Thu May 29, 2008 8:07 pm

moderator pls remove the o/p dataset name
kamal
 
Posts: 48
Joined: Wed Aug 22, 2007 2:49 pm
Has thanked: 0 time
Been thanked: 0 time

Re: variable length file filtering

Postby dick scherrer » Thu May 29, 2008 11:51 pm

Hello,

The output dsn has been changed.

Is your output ddname spelled correctly?

Please post a bit of the data from the front of the input file. Please post the sysout created by this run.
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: variable length file filtering

Postby kamal » Fri May 30, 2008 11:54 am

Thanks for the response and action.
Seems ther is some syntax error
the error msg is like :
$$DD01 COPY IF(1,EQ,C'S')                                                     
1...5...10...                                                                 
INVALID KEYWORD IN ABOVE CARD, CHECK DATA STARTING IN COLUMN 13               
.....SKIPPING TO NEXT $$DD CARD                                          RC=4 
                                                                               

Any suggestions ?
kamal
 
Posts: 48
Joined: Wed Aug 22, 2007 2:49 pm
Has thanked: 0 time
Been thanked: 0 time

Re: variable length file filtering

Postby kamal » Fri May 30, 2008 6:57 pm

yeah '=' missing on 13 th column...
Thanks !!
kamal
 
Posts: 48
Joined: Wed Aug 22, 2007 2:49 pm
Has thanked: 0 time
Been thanked: 0 time


Return to File-AID

 


  • Related topics
    Replies
    Views
    Last post