Topic
No replies
SystemAdmin
SystemAdmin
17917 Posts
ACCEPTED ANSWER

Pinned topic Use of HPU

‏2012-11-27T06:29:50Z |
Hi,

I am SHUBHA SHIVANNA from INDIA.

I am using HPU (High Performance Unload) Utility for Unloading. The query given down is the one we are using:

GLOBAL CONNECT TO ${DATABASE}
UNLOAD TABLESPACE
HEADER NONE
SELECT * FROM <TABLE_NAME>
OUTFILE("{OUTFILE_LOC}/${DATA_FILE}" REPLACE)
FORMAT DELIMITED COLDEL '${DELIMITER}' CHARDEL '' MODIFILED BY STRIPLZEROS; -- THIS WAS TRIED OUT WITH DIFFERENT SYNTAXES

FORMAT DEL COLDEL '${DELIMITER}' CHARDEL '' MODIFILED BY STRIPLZEROS;
MODIFIED BY COLDEL '${DELIMITER}' CHARDEL '' STRIPLZEROS;
FORMAT DELIMITED COLDEL ${DELIMITER} CHARDEL '' MODIFILED BY STRIPLZEROS;

But none of the above queries are not working. Everytime the Error thrown is INVALID LEXEME

We are using AIX OS. We dont know how to get the version of the DB2 used.

Please send us the correct usage of the HPU query ASAP.

Thanks in advance
SHUBHA SHIVANNA