Rahul
Agree with everything Nick and D have advised, but your requirement is not
clear: if you have 8 records on your import file, do you want a 1 row table
with 8 columns or a 2 row table of 4 columns? If the former, and you're
limited to Windows and no 3GL, you could also consider the 'pivot table'
function in Micro$oft Excel to manipulate the data.
Regards
Alex Levy

-----Original Message-----
From: dbaguru
[mailto:db2udbdba-ezmlmshield-x4009461.[Email address protected]
Sent: 26 December 2006 18:09
To: LazyDBA Discussion
Subject: RE: Import Command


Rahul,

What Detlev said for Unix holds true for Windows as well. If you only have
4 lines in your file, open the file in an editor and manually create a
single row. However, if you're looking for a technique that will handle a
file of unknown number of lines, I'd recommend importing the file to a
table, then writing a stored procedure that will reformat four lines into
one line and insert that to your real target table. I'm sure there are
other ways to handle this problem too, this is just one.

Nick

-------------- Original message --------------
From: "Singh Rahul " <db2udbdba-ezmlmshield-x25959637.[Email address
protected]

> 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
>
>
>
>
> ---------------------------------------------------------------------
> 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
>


---------------------------------------------------------------------
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



-----------------------------------------------
Scanned by 186k-NetCleanse, spam and virus protection



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