View previous topic :: View next topic
|
Author |
Message |
dharani.nagarajan
New User
Joined: 11 Nov 2010 Posts: 21 Location: India
|
|
|
|
Hi,
I have 5 Jcls that unload data from imagecopy of 5 DB2 tables.
I have used BMCUNLD utility for this.
For 3 unloads the output files is created in FB and for the other 2 the output unload files are in VB format.
But in the JCL the RECFM is specified as FB only but when the job runs it creates in VB format. Please find the below specification
//SYSREC DD DISP=(NEW,CATLG,DELETE),
// UNIT=SYSDA,
// SPACE=(TRK,(25000,2500),RLSE),
// DCB=(BLKSIZE=0,RECFM=FB,LRECL=659),
// LABEL=RETPD=42,
// DSN=TEST.UNLOAD.TABLE1
Can anyone please help me in this.. I need to have the file in FB only.
Also can you please tell me why this is happening.
Thanks for your help
Thanks,
Dharani |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
Quote: |
Also can you please tell me why this is happening. |
most probably because the tables differ on column type definition and attributes
null/not null, varchar ...
browsing the unloaded data might give You more hints |
|
Back to top |
|
|
dharani.nagarajan
New User
Joined: 11 Nov 2010 Posts: 21 Location: India
|
|
|
|
Hi Enrico,
Thanks a lot for the information.
Is there any way that I can create them in FB format.
Thanks,
Dharani |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
Please check the below options and what values have been set in your SYSPRINT of unload step.
|
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
Quote: |
Is there any way that I can create them in FB format. |
Why ?
and do not give the stupid reply "that' s the requirement" |
|
Back to top |
|
|
dharani.nagarajan
New User
Joined: 11 Nov 2010 Posts: 21 Location: India
|
|
|
|
Hi Enrico,
I want to know is there any way if I can do this.
Else I can add a step to convert this file to FB.
I saw the DCLGENs for these tables.
For the tables with VARCHAR fields the unloads are created in VB format.
As you said it is because of the data types.
Thank you
Thanks,
Dharani |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
Hint:
in unload card. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
You did not reply to my question ... Why force an FB format |
|
Back to top |
|
|
dharani.nagarajan
New User
Joined: 11 Nov 2010 Posts: 21 Location: India
|
|
|
|
Hi Gnana Sekaran,
The code worked find for me
FIXEDVARCHAR YES
Thanks a lot for your help.
Hi Enrico,
The programs that use this file is expecting a FB file so I need to have the file in FB only.
Since I have more number of programs I thought of trying to create FB file.
If I would say in another way its the requirement (Hope you dont mind).
Thanks,
Dharani |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
I just do not care...
if Your organization is happy with a silly approach... we are happy |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Quote: |
if Your organization is happy with a silly approach... we are happy
|
Speak for yourself Enrico |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
Hi Enrico,
Quote: |
...with a silly approach... |
Sorry for this. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
nothing to be sorry
my comment was not for Your solution, but for the overall approach on TS organization side
and how they throw money down the sewer
and I am still happy |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Hi,
Option FIXEDVARCHAR is only available in BMCUNLOAD? |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
gylbharat wrote: |
Hi,
Option FIXEDVARCHAR is only available in BMCUNLOAD? |
NOPAD |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Thanks GuyC.... |
|
Back to top |
|
|
|