noorkh
New User
Joined: 06 Mar 2006 Posts: 76 Location: Chennai
|
|
|
|
Hi,
I am trying to unload one table using DSNTIAUL utility in Jcl which (Table) has varchar field.
While browsing the unloaded file, varchar field has been populated with hex value inspite of spaces. Even i declared my cobol copybook as
03 varchar
49 varchar-len s9(4) comp
49 varchar-text x(80)
For length it is showing properly. But varchar-text is not coming properly. means if varchar-text is 'hallo' only hallo is coming properly the remaining 75 bites is coming hex value.
Can any one of you tell me should i need to incorporate any Keyword for Varchar field to select it?
Thanks in advance
Noor. |
|
martin9
Active User
Joined: 01 Mar 2006 Posts: 290 Location: Basel, Switzerland
|
|
|
|
hy noor,
if you define the length as 80,
then the following characters will be space,
if you put spaces into the text field.
means: in a varchar you define exactly the
needed length for a field.
in your case: 'hallo' is five bytes,
therefore it makes sense to give a length of 5.
if you read this field now, you will only get
the length in a proper way, the rest of the field,
(not stored in db), will be set to hex'00'.
note: you should always determine the length field first,
because, if you have length = zero, the field is empty,
and empty means really empty, all is hex'00'.
all clear, just ask more...
martin9 |
|