Need help with FILEAID in BATCH

105 pts.
Tags:
DB2
File-AID
JCL
VB
Visual Basic
I'm new to FILEAID, so I'd be grateful for some sage guidance on FILEAID command syntax's and statement for use in a JCL. My problem is that Ihave a datafile which appears be a VB file type with a leading 2 character string ahead of my data. I'm trying (desperately) to create a work-around in order to remove these extra characters. I colleague suggested a FILEAID copy "starting at column 3 of each record". How do I accomplish this?
ASKED: June 23, 2008  6:31 PM
UPDATED: July 9, 2008  6:31 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi Jonty,

How big is the file? How many records does it contain? What is the maximum record length?

If I learn this, I may be able to recommend a solution.
Thanks,
MS

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Jonty Walker
    Record length is 133 bytes (typical of DSNTEP2), but there are close to 3000 records in the total file. Multiple SQL queries all tucked into the same file. I'm trying to remove SPUFI-batch type headers and record numbers. Sample below: +----------------------------------------------------------------------------------+ | | +----------------------------------------------------------------------------------+ 1_| 114172661 CL PR 6000 IRC | 2_| 104903018 CL PR 6000 IRC | 3_| 107241739 CL PR 6000 IRC | 4_| 111020004 CL PR 6000 IRC | 5_| 120371273 CL PR 6000 IRC | 6_| 244498143 CL PR 6000 IRC | 7_| 263222895 CL PR 6000 IRC | 8_| 441944311 CL PR 6000 IRC | 9_| 444692578 CL PR 6000 IRC | 10_| 456048321 CL PR 6000 IRC | 11_| 463144782 CL PR 6000 IRC | 12_| 467557237 CL PR 6000 IRC | 13_| 472485762 CL PR 6000 IRC | 14_| 476317797 CL PR 6000 IRC | +----------------------------------------------------------------------------------+ 1PAGE 2 +----------------------------------------------------------------------------------+ I've also got SQL statements in the OUTPUT file. Do you think FILEAID can 'save me' :o) ?
    105 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following