onpload file format

Posted in 2010

Topics: Migration, Import/Export & Data Conversion

ALI SHAHNAZI — Wed, 20 Jan 2010 05:40:49 — source: IIUG Forums & Mailing Lists

Hi, I want to unload data to a flat file through onpload tool like unload command output. I mean a file like this : 100|Arnold|CA| 101|Donald|US| or something like this. Can anyone help me? I created a job and could unload data, but unload file has another structure. Regards Ali

↪ replying to ALI SHAHNAZI

Martin Fuerderer — Wed, 20 Jan 2010 08:15:50 — source: IIUG Forums & Mailing Lists

Hi, the format that you want is called the "delimited format". Please check the documentation for this term. It should be described how to do this with HPL/onpload. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management IBM Deutschland Research & Development GmbH Chairman of the Supervisory Board: Martin Jetter Board of Management: Dirk Wittkopp Corporate Seat: Boeblingen, Germany Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294 ids-bounces@iiug.org wrote on 01/20/2010 06:40:49 AM: > > Hi, > > I want to unload data to a flat file through onpload tool like > unload command > output. I mean a file like this : > 100|Arnold|CA| > 101|Donald|US| > or something like this. Can anyone help me? > I created a job and could unload data, but unload file has another > structure. > > Regards > Ali > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to Martin Fuerderer

JACK PAPA — Thu, 21 Jan 2010 03:12:34 — source: IIUG Forums & Mailing Lists

you can do: unload from "filename.unl" DELIMITER "|" select column from tablename you can use dbload to load the data. make sure to set the DB in "No logging" mode (onblog) before loading.