View previous topic :: View next topic |
Author |
Message |
newcobol Beginner
Joined: 20 Apr 2006 Posts: 88 Topics: 22
|
Posted: Mon Mar 03, 2014 10:19 am Post subject: Is unload from image copy always a vb file |
|
|
I see a step in my shop with an unload from an image copy. the next step uses sort to 'convert file from variable to fixed'. when unloading from image copy, does it always give u a variable file, and is it standard procedure to then use a sort to change from vb to fb to make it easier to use as input to a program, as is the case here? |
|
Back to top |
|
|
papadi Supermod
Joined: 20 Oct 2009 Posts: 594 Topics: 1
|
Posted: Mon Mar 03, 2014 12:45 pm Post subject: |
|
|
Why is it difficult to use the vb file as input
I suspect >80% of our batch jobs use vb input. _________________ All the best,
di
Last edited by papadi on Tue Mar 04, 2014 12:51 pm; edited 1 time in total |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12375 Topics: 75 Location: San Jose
|
Posted: Mon Mar 03, 2014 1:34 pm Post subject: |
|
|
newcobol,
You can use the VB file to load the DB2 table as the load utility does not differetiate between a VB or an FB file. It basically looks at the SYSPUNCH/PUNCDDN dataset and pulls in the fields specified and the positions where it needs to pull the information from.
Kolusu |
|
Back to top |
|
|
newcobol Beginner
Joined: 20 Apr 2006 Posts: 88 Topics: 22
|
Posted: Mon Mar 03, 2014 2:10 pm Post subject: |
|
|
i appreciate the info provided but my ? still remains. does the image copy always produce a variable file? |
|
Back to top |
|
|
newcobol Beginner
Joined: 20 Apr 2006 Posts: 88 Topics: 22
|
Posted: Mon Mar 03, 2014 2:22 pm Post subject: |
|
|
i have related questions. when working with an unload from the table directly. i believe when using the unloaded file as input after, the fields are the same as in the dclgen, it is fb, and this way(unloading from image copy), i have to do some work in between |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12375 Topics: 75 Location: San Jose
|
Posted: Mon Mar 03, 2014 4:07 pm Post subject: |
|
|
newcobol wrote: | i appreciate the info provided but my ? still remains. does the image copy always produce a variable file? |
The default is VB and you can override that to FB if you want on the Image copy job.
Kolusu |
|
Back to top |
|
|
|
|