Formatting table row printing and SQL in DB2

SUBSCRIBE DB2-L Anonymous

Formatting table row printing and SQL in DB2
Is there a way to turn off formatting in batch SPUFI and QMF? Would like
just row output/print with fixed length columns (blank or comma separated).

Also is there an IBM tool or open source tool that can be used to format
unformatted DB2 SQL?

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Raymond Bell

Re: Formatting table row printing and SQL in DB2
(in response to SUBSCRIBE DB2-L Anonymous)
Yeah, there is - an open-source SQL formatter. A customer of mine sent me the link to it awhile ago but since then I've had to rebuild my laptop and have lost the link. I'll ask him again. I don't need it as the few times I do want SQL formatted there are also ISV tools that do that - and I kinda have access to a good chunk of 'em. Can't think why...

Anyway, I'll get the link and send it ya.

Cheers,


Raymond

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of David
Sent: 12 January 2010 17:01
To: [login to unmask email]
Subject: [DB2-L] Formatting table row printing and SQL in DB2

Is there a way to turn off formatting in batch SPUFI and QMF? Would like
just row output/print with fixed length columns (blank or comma separated).

Also is there an IBM tool or open source tool that can be used to format
unformatted DB2 SQL?

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Richard Fazio

Re: Formatting table row printing and SQL in DB2
(in response to Raymond Bell)
That would be an unload (see dsntiaul) or if you are trying to use this
data in a rexx, you can access the data directly with the Rexx/DB2
interface.

faz

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of David
Sent: Tuesday, January 12, 2010 11:01 AM
To: [login to unmask email]
Subject: [DB2-L] Formatting table row printing and SQL in DB2

Is there a way to turn off formatting in batch SPUFI and QMF? Would
like
just row output/print with fixed length columns (blank or comma
separated).

Also is there an IBM tool or open source tool that can be used to format

unformatted DB2 SQL?

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our
website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Mark Arnold

Re: Formatting table row printing and SQL in DB2
(in response to Richard Fazio)
I like SSLinForm: www.sqlinform.com

Thanks,
Mark

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Bell, Raymond
Sent: Tuesday, January 12, 2010 11:09 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Formatting table row printing and SQL in DB2

Yeah, there is - an open-source SQL formatter. A customer of mine sent me the link to it awhile ago but since then I've had to rebuild my laptop and have lost the link. I'll ask him again. I don't need it as the few times I do want SQL formatted there are also ISV tools that do that - and I kinda have access to a good chunk of 'em. Can't think why...

Anyway, I'll get the link and send it ya.

Cheers,


Raymond

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of David
Sent: 12 January 2010 17:01
To: [login to unmask email]
Subject: [DB2-L] Formatting table row printing and SQL in DB2

Is there a way to turn off formatting in batch SPUFI and QMF? Would like
just row output/print with fixed length columns (blank or comma separated).

Also is there an IBM tool or open source tool that can be used to format
unformatted DB2 SQL?

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Raymond Bell

Re: Formatting table row printing and SQL in DB2
(in response to Mark Arnold)
My customer friend sent me the link again. Looks like what I vaguely remember: http://www.dpriver.com/pp/sqlformat.htm

It's web based. Paste in your SQL and it gets layed out in the bottom window. Looks nice - for free software... ;o)

Cheers,


Raymond

________________________________________
From: IDUG DB2-L [[login to unmask email] On Behalf Of Arnold, Mark S [[login to unmask email]
Sent: 12 January 2010 17:46
To: [login to unmask email]
Subject: Re: [DB2-L] Formatting table row printing and SQL in DB2

I like SSLinForm: www.sqlinform.com

Thanks,
Mark

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Bell, Raymond
Sent: Tuesday, January 12, 2010 11:09 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Formatting table row printing and SQL in DB2

Yeah, there is - an open-source SQL formatter. A customer of mine sent me the link to it awhile ago but since then I've had to rebuild my laptop and have lost the link. I'll ask him again. I don't need it as the few times I do want SQL formatted there are also ISV tools that do that - and I kinda have access to a good chunk of 'em. Can't think why...

Anyway, I'll get the link and send it ya.

Cheers,


Raymond

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of David
Sent: 12 January 2010 17:01
To: [login to unmask email]
Subject: [DB2-L] Formatting table row printing and SQL in DB2

Is there a way to turn off formatting in batch SPUFI and QMF? Would like
just row output/print with fixed length columns (blank or comma separated).

Also is there an IBM tool or open source tool that can be used to format
unformatted DB2 SQL?

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L
_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Cuneyt Goksu

Re: Formatting table row printing and SQL in DB2
(in response to Raymond Bell)
How about this one?

http://www.dpriver.com/pp/sqlformat.htm


Cuneyt


>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of David
> Sent: 12 January 2010 17:01
> To: [login to unmask email]
> Subject: [DB2-L] Formatting table row printing and SQL in DB2
>
> Is there a way to turn off formatting in batch SPUFI and
> QMF? Would like
> just row output/print with fixed length columns (blank or
> comma separated).
>
> Also is there an IBM tool or open source tool that can be
> used to format
> unformatted DB2 SQL?
>
> _____________________________________________________________________
>
> * IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference? Many of the
presentations were recorded and are available on our website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference? Many of the
presentations were recorded and are available on our website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Sudhir Raj

Re: Formatting table row printing and SQL in DB2
(in response to Cuneyt Goksu)
You can format your SQL in IBM's Optimization Service Center for DB2 (it's now rebranded as Optim something!)

Sudhir
RealTime-DBA


________________________________
From: Cuneyt Goksu (Gmail) <[login to unmask email]>
To: [login to unmask email]
Sent: Wed, January 13, 2010 10:24:56 AM
Subject: Re: Formatting table row printing and SQL in DB2

How about this one?

http://www.dpriver.com/pp/sqlformat.htm


Cuneyt

>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of David
> Sent: 12 January 2010 17:01
> To: [login to unmask email]
> Subject: [DB2-L] Formatting table row printing and SQL in DB2
>
> Is there a way to turn off  formatting in batch SPUFI and
> QMF?  Would like
> just row output/print with fixed length columns (blank or
> comma separated).
>
> Also is there an IBM tool or open source tool that can be
> used to format
> unformatted DB2 SQL?
>
> _____________________________________________________________________
>
> * IDUG North America * Tampa, Florida, * May 10-14 2010 * 
http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference? Many of the
presentations were recorded and are available on our website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference? Many of the
presentations were recorded and are available on our website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *  http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar!  RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L



_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

SUBSCRIBE DB2-L Anonymous

Re: Formatting table row printing and SQL in DB2
(in response to Sudhir Raj)
I appreciate everyone for your very helpful and prompt responses on
formatting SQL and table rows. It is nice to now have several good options
thanks to the generosity and helpfulness of the DB2 posters.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L