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 Searching a table for the field name? socker_dad COBOL Programming 8 Sat Mar 31, 2018 2:57 am
No new posts Need inputs on DB2 tablespace/table r... ashek15 DB2 3 Sat Mar 24, 2018 11:49 pm
No new posts COBOL declaration for table Poha Eater DB2 3 Mon Feb 26, 2018 6:58 pm
No new posts load and delete table through JCL wit... ram_vizag JCL & VSAM 9 Thu Feb 01, 2018 12:47 am
No new posts Unloading DB2 table in CSV format alo... grvtomar COBOL Programming 7 Sun Jan 28, 2018 2:05 am

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