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
gopal_NKP
Posts: 22
Joined: Fri Feb 25, 2011 11:47 am
Skillset: vsam
Referer: FRIENDS

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

User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am

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.

mprobst
Posts: 5
Joined: Tue Apr 05, 2011 9:34 pm
Skillset: Mainframe Test Tools
Referer: internet search

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.


  • Similar Topics
    Replies
    Views
    Last post