I forgot to mention, I am on windows.
Can there be any workaround on windows ?

--Rahul Singh


-----Original Message-----
From: d [mailto:db2udbdba-ezmlmshield-x76174925.[Email address protected]
Sent: Tuesday, December 26, 2006 5:13 PM
To: LazyDBA Discussion
Subject: Re: Import Command

Hi,

no, there is no such option for IMPORT.
But it is no problem to write a small script that is putting 4 lines
into one.
Try this (for UNIX):

> awk 'BEGIN{i=1}{printf("%s;",$1); if (i==4) {i=1;printf("\n")}else
{i++} }' file.txt>out.txt

Cheers

Detlev

Am Dienstag, 26. Dezember 2006 10:27 schrieb Singh Rahul:
> I am having a file having four rows as
> 2342
> 234234
> 345
> 234253
> Now I want to import them in a table so that all four lines goes
> into 4 different columns(A,B,C,D) in a single row in a table. Is
> there any option in Import Command ?
>
> Regards
> Rahul Singh
>
>
>
> -------------------------------------------------------------------
>-- TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To
> post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html

--
Eine besinnliche Weihnachtszeit und
einen guten Start ins neue Jahr wünscht

Detlev Kuntze

Das Tauschforum Stuttgart im Internet:
http://www.tauschforum-stuttgart.de


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page