MVSFORUMS.com

Bithead · Posted: Thu Jul 28, 2005 12:05 pm Post subject: Batch DB2 Unload

I have a file that is in the format XXX YYY which I need to duplicate using a DB2 batch utility. If I use DSNTIAUL and say SELECT COL1, COL2 FROM MY.TABLE, the resulting file is in the format XXXYYY, that is, without the space. If I say SELECT COL1, ' ', COL2 FROM MY.TABLE, the resulting file is in the format XXX.. YYY where .. is the length attribute.

Is there a way of creating this file in the correct format?

kolusu · Posted: Thu Jul 28, 2005 12:17 pm Post subject:

Bithead,

yes you can create it in the desired format. When you use a simple space, the unload utility treates it as varchar and pads the extra 2 bytes when unloading. so you need to use the function CHAR to avoid the extra 2 bytes.

i.e

Bithead · Posted: Thu Jul 28, 2005 12:19 pm Post subject:

Thanks Kolusu. That worked great.

kolusu · Posted: Thu Jul 28, 2005 12:23 pm Post subject:

Bithead,

Glad that worked. If you want N spaces between the 2 columns, you can simply specify it on the char function as shown below.