MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Is unload from image copy always a vb file

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
newcobol
Beginner


Joined: 20 Apr 2006
Posts: 88
Topics: 22

PostPosted: Mon Mar 03, 2014 10:19 am    Post subject: Is unload from image copy always a vb file Reply with quote

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
View user's profile Send private message
papadi
Supermod


Joined: 20 Oct 2009
Posts: 594
Topics: 1

PostPosted: Mon Mar 03, 2014 12:45 pm    Post subject: Reply with quote

Why is it difficult to use the vb file as input Confused

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
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose

PostPosted: Mon Mar 03, 2014 1:34 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website
newcobol
Beginner


Joined: 20 Apr 2006
Posts: 88
Topics: 22

PostPosted: Mon Mar 03, 2014 2:10 pm    Post subject: Reply with quote

i appreciate the info provided but my ? still remains. does the image copy always produce a variable file?
Back to top
View user's profile Send private message
newcobol
Beginner


Joined: 20 Apr 2006
Posts: 88
Topics: 22

PostPosted: Mon Mar 03, 2014 2:22 pm    Post subject: Reply with quote

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
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose

PostPosted: Mon Mar 03, 2014 4:07 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group