Parallel loader (HPL) constants

Posted in 2006

Topics: Migration, Import/Export & Data Conversion

STEVE RITCHIE — Tue, 19 Sep 2006 10:33:50 — source: IIUG Forums & Mailing Lists

Hi Having a problem with the HPL that I can't seem to get around. I generate a job for a table but want to unload constants in addition to the data. I modify the SQL from select * from tableto select "A", *, "B" from table The table unloads without the "A" or "B" and no delimiters for them either. I played with the format and added columns for this table and the delimiter for the column appeared but the "A" and "B" does not. Any suggestions welcomed. Thanks

↪ replying to STEVE RITCHIE

Celso Cabral Coimbra — Tue, 19 Sep 2006 11:51:31 — source: IIUG Forums & Mailing Lists

If I understand, you´ve created the job, format, map and after all you've correct the query and the format putting the "A" and "B". have you corrected the map adding the relation of query and format too? Celso Coimbra ClearTech Ltda E-mail: ccoimbra@cleartech.com.br -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]Em nome de STEVE RITCHIE Enviada em: terça-feira, 19 de setembro de 2006 07:34 Para: ids@iiug.org Assunto: Parallel loader (HPL) constants [7492] Hi Having a problem with the HPL that I can't seem to get around. I generate a job for a table but want to unload constants in addition to the data. I modify the SQL from select * from tableto select "A", *, "B" from table The table unloads without the "A" or "B" and no delimiters for them either. I played with the format and added columns for this table and the delimiter for the column appeared but the "A" and "B" does not. Any suggestions welcomed. Thanks ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to STEVE RITCHIE

Jack Parker — Tue, 19 Sep 2006 12:37:16 — source: IIUG Forums & Mailing Lists

Did you alias them in the query? select "A" col1, *, "B" col2 ... j. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of STEVE RITCHIE Sent: Tuesday, September 19, 2006 6:34 AM To: ids@iiug.org Subject: Parallel loader (HPL) constants [7492] Hi Having a problem with the HPL that I can't seem to get around. I generate a job for a table but want to unload constants in addition to the data. I modify the SQL from select * from tableto select "A", *, "B" from table The table unloads without the "A" or "B" and no delimiters for them either. I played with the format and added columns for this table and the delimiter for the column appeared but the "A" and "B" does not. Any suggestions welcomed. Thanks **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.