Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Unloading a table using BMC unload

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
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    Post subject: Unloading a table using BMC unload
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

Site Director


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

PostPosted: Sun Jun 24, 2007 11:51 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
No new posts PC (UTF-8) -> z/OS (EBCDIC) -> ... prino All Other Mainframe Topics 4 Fri Sep 01, 2017 1:47 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us