deepaannjohn
New User
Joined: 23 Feb 2006 Posts: 19 Location: Bangalore
|
|
|
|
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 |
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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. |
|