IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Unloading a table using BMC unload


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
deepaannjohn

New User


Joined: 23 Feb 2006
Posts: 19
Location: Bangalore

PostPosted: Sun Jun 24, 2007 9:11 pm
Reply with quote

Hi,

While unloading a table using BMC unload, I am getting a variable block file with 90 as the length.

05 id pic s9(9) comp
05 d-desc.
10 d-code pic x(2)
10 d-text pic x(78) -> this field is varchar

4 + 2 + 2 (for length of varchar) + 78 = 86 bytes and FB was what I expected. Why am I getting VB?
(I checked the BMC website, but did not get the answer)

Regards,
Deepa
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Sun Jun 24, 2007 11:51 pm
Reply with quote

Hello,

If, in fact, there is a variably defined field, i believe the unload will genrate VB output (this happens with other than BMC also). Keep in mind that when a file is vb, space must be allowed for the rdw (record descriptor word). From my perspective, the vb/90 appears correct.

If you want to sort that file, remember to account for the rdw when you specify displacements within the record. If you read this file into a cobol program, the access method handles the rdw, but when you use sort, you must allow for it.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Remote Unload of CLOB Columns DB2 6
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Check data with Exception Table DB2 0
Search our Forums:

Back to Top