COPY & DROP ON Variable Block File



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

COPY & DROP ON Variable Block File

Postby gopal_NKP » Tue Jun 14, 2011 8:58 pm

hi,

Using File-Aid in batch mode, I want to copy the files . and also some records needs to be skipped.
I am not sure on how to specify the matching string starting location for Vriable Block files. Please help me.

thanks
gopal_NKP
 
Posts: 22
Joined: Fri Feb 25, 2011 11:47 am
Has thanked: 0 time
Been thanked: 0 time

Re: COPY & DROP ON Variable Block File

Postby dick scherrer » Wed Jun 15, 2011 12:46 am

Hello,

Hopefully, the starting position to compare is the same in each record. . .

Suggest you post a few sample input records and the output you want when this input is processed.

Mention the recfm(s) and lrecl(s) of the input and output files (the sample data you post could be different).
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: COPY & DROP ON Variable Block File

Postby mprobst » Tue Jul 12, 2011 1:10 am

In Fileaid batch you would need to start with column 5 since columns 1-4 are the VLI (Variable Length Indicator) on Variable files.

for example:
$$DD01 DROP IF=(5,EQ,C'WHATEVER')

will DROP records that contain 'WHATEVER' in the first column of a Variable Length record file.
mprobst
 
Posts: 5
Joined: Tue Apr 05, 2011 9:34 pm
Has thanked: 0 time
Been thanked: 0 time


Return to File-AID

 


  • Related topics
    Replies
    Views
    Last post