Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us