MVSFORUMS.com

[nadh]

Hi,

I extracted a table into a file. while creating a file which is to be loaded into table i moved a length of varchar field into a column in the fild. In the same way while extracting the table will the length filed will be kept in the extract file? My understanding is while extracting it will use the dclgen structure of that table. so length field will be there in that extract file. Please clarify.


thanks in advance
nadh

[kolusu]

Nadh,

If you are using DSNTIAUL for extracting the varchar data from the table then the first 2 bytes of the field will contain the length of the varchar column.

Hope this helps...

Cheers

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu