MVSFORUMS.com

[danm]

To export QMF report to EXECL spreadsheet:

1. Run the query under qmf
2. Export data to a dataset (column are delimited by '0000'x)
3. Convert '0000'x to ',' or ';' since EXCEL doesn't allow me to specify the delimiter in hex format (providing data doesn't contains ',' or ';')
4. Download data to PC
5. Open downloaded file in EXECL with delimiter ',' or ';'

Is it possible to to skip the step of converting the deliminer '0000'x to ',' or ';' first?

[kolusu]

danm,

1. Simply unload the data using dsntiaul by specifying the columns.

ex:

[danm]

Kosulu,

But there is one problem. If any columns in the table contains a ';', then the delimiter ';' will not work in EXCEL.

[kolusu]

[danm]

Kolusu,

It works fine now. Thanks.

[Jamylady]

I have been thinking of asking this question.
Why am I getting the output as follows
2004..|089|001 when I use the following SQL to unload?
SELECT STARTX_YR,'|',DEPT_SYS_CD,CHAR('|')
FROM BXNA45.TABLE01?
If I dont use the CHAR, i am getting the '..'. Where is it coming from?

Thanks
JA

[kolusu]

Jamylady,

When you code a character string within quotes DB2 assumes that it is a varchar string and adds the 2 extra bytes which contain the length of the string. By adding the CHAR function it is treated as the character string and you will not see the additional 2 bytes.

Hope this helps...

Cheers

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

[Jamylady]

Thanks many