MVSFORUMS.com

[sree_sen]

Hi,

The records to my i/p file are pre-formatted as below -

[Ram]

Sree,

The below JCL will give u the desired results. I am assuming a FB file of record length 80.

[sree_sen]

Thanks a lot, Ram, Its working perfect...
_________________
-Sree

[sree_sen]

Ram,

What if my file is a VB one? The '|' delimiter and other records are in the same columns though.
Basically this problem I am facing while migrating from the Platinum Unload utility to DB2 High performance utility called INZUTILB- in the platinum utility, we were using the following -

FASTUNLOAD
LOAD-CONTROL NONE
OUTPUT-FORMAT COMMA-DELIMITED
SQL-ACCESS ONLY
COMMA X'4F'
QUOTE X'40'

before the Select command. I have coded my DB2 card as

UNLOAD TABLESPACE
Select .......
......
....
....
OUTDDN ( SYSREC00 )
FORMAT DELIMITED SEP '|' DELIM ' ' ;

This implies my Platinum card interprets Character as Spaces and places a space for the timestamp field which is 26 bytes. But my DB2 card cannot do such.


Any help in this regard would be appreciated.
Thanks,
_________________
-Sree

[kolusu]

Sree_sen,

If your input file is vb then you need to consider the rdw. The following JCL will give you the desired results.

[sree_sen]

Hi Kolusu,

I tried the snippet u provided -
I am getting the following as my o/p -

[kolusu]

Sree_sen,

What is the exact position of the timestamp field ?. As per ram's example the timestamp field starts at 19. But looks like your timestamp field actually starts at pos 20. Since it is a vb file we need to add the RDW.

so try the following control cards.

[sree_sen]

Hi Kolusu,

Thanks, it worked finally, but with a slight modification. Here is my snippet -

//SYSIN DD *
SORT FIELDS=COPY
OUTREC FIELDS=(1,4,5,20,X,25,26,X,51)
/*
//*

The TS field would be at 21st position- so I just added ur position param by 1 byte and it worked.

Thanks a lot, once again, Ram and Kolusu.
_________________
-Sree