Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

DB2 V7: unload-utility and delimiters in output-dataset

0 views
Skip to first unread message

Klaus Fischer

unread,
Mar 30, 2002, 3:37:58 AM3/30/02
to
Hello,

in DB2 V7 (OS390) there is the new UNLOAD-Utilty.

Does anyboy knows, whether one can unload Rows, where the columns ares
stripped from blanks and separated by a delimiter in the output-dataset
?

Thanks ?


Klaus Fischer

--
Software-Service Telefon (089) 81009015
Wulf Schupp GmbH Telefax (089) 81009016
Spieljochstrasse 34 Email mailto:kfischer...@t-online.de
81825 Muenchen WWW http://www.swsgmbh.de


Rolf Loeben

unread,
Apr 5, 2002, 1:54:34 PM4/5/02
to

"Klaus Fischer" <kfis...@swsgmbh.de>

> in DB2 V7 (OS390) there is the new UNLOAD-Utilty.
>
> Does anyboy knows, whether one can unload Rows, where the columns ares
> stripped from blanks and separated by a delimiter in the output-dataset
> ?
Klaus,
UNLOAD does not have a delimited output.
You might try converting from fixed length to variable length for string
data to strip training blanks; however, I doubt it will remove trainling
blanks.

Regards Rolf


Ramana

unread,
Apr 5, 2002, 7:26:04 PM4/5/02
to
you can unload the data with delimited string using File Aid for DB2 .
Thanks Ramana
"Rolf Loeben" <rolf....@t-online.de> wrote in message
news:a8krpg$qh8$1...@news.boulder.ibm.com...

Rolf Loeben

unread,
Jun 21, 2002, 5:55:41 PM6/21/02
to
"Ramana" <rama...@hotmail.com> schrieb im Newsbeitrag
news:a8lfu1$23f6$1...@news.boulder.ibm.com...

> you can unload the data with delimited string using File Aid for DB2 .
> Thanks Ramana
> "Rolf Loeben" <rolf....@t-online.de> wrote in message
> news:a8krpg$qh8$1...@news.boulder.ibm.com...
> >
> > "Klaus Fischer" <kfis...@swsgmbh.de>
> > > in DB2 V7 (OS390) there is the new UNLOAD-Utilty.
> > >
> > > Does anyboy knows, whether one can unload Rows, where the columns ares
> > > stripped from blanks and separated by a delimiter in the
output-dataset
> > > ?
> > Klaus,
> > UNLOAD does not have a delimited output.

Correction: the V7 UNLOAD can produce delimited output.

Sorry Rolf


0 new messages