Home > IT Answers > Database > Need help with FILEAID in BATCH
Help

Question

  Asked: Jun 23 2008   6:31 PM GMT
  Asked by: Jonty Walker

Need help with FILEAID in BATCH


DB2, JCL, FILEAID, Visual Basic, VB

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?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Jun 25 2008  7:11 PM GMT  by Msenatore@fisa




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
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Database, DataCenter and DataManagement.

Looking for relevant Database Whitepapers? Visit the SearchOracle.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Jonty Walker  |   Jul 7 2008  4:51PM GMT

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) ?