[DB2-L] AW: [DB2-L] Scalar function STRIP used in a SPUFI SELECT

Georg Peter

[DB2-L] AW: [DB2-L] Scalar function STRIP used in a SPUFI SELECT
See you in Prague for a beer ?

With kind regards - mit freundlichen Gruessen,
G e o r
-----Ursprüngliche Nachricht-----
Von: IDUG DB2-L [mailto:[login to unmask email] Im Auftrag von Todd Burch
Gesendet: Donnerstag, 10. Februar 2011 18:46
An: [login to unmask email]
Betreff: Re: [DB2-L] AW: [DB2-L] Scalar function STRIP used in a SPUFI SELECT

I'm 0 for 2 today. Sorry about that Georg.


i-bin/wa?A0=DB2-L is the home of IDUG's Listserv


Abonnieren Sie unseren Infobrief und erfahren Sie regelmäßig die neuesten Nachrichten über unsere Lösungen, aktuellen Projekte und Entwicklungen. Melden sie sich an mit diesem Link http://www.datenzentrale.de/Info-Brief
_______________________________________________________________________________

Datenzentrale Baden-Württemberg, Anstalt des öffentlichen Rechts
Krailenshaldenstr. 44, 70469 Stuttgart
Telefon (0711) 8108-20, Telefax (0711) 8108-21350
E-Mail [login to unmask email], Internet www.datenzentrale.de
Vorstand: Karl Tramer (Vors.) und Harald Schätzle, Vorsitzender des Verwaltungsrats: Gunter Czisch
USt-Id-Nr. DE147794223
_______________________________________________________________________________

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

Todd Burch

Re: AW: [DB2-L] AW: [DB2-L] Scalar function STRIP used in a SPUFI SELECT
(in response to Georg Peter)
I wish. I've heard they have very good beer in Prague. I'll take a
rain check.

I'll reciprocate when you come to South East Texas.

Todd


On Feb 10, 2011, at 12:08 PM, Peter, Georg wrote:

See you in Prague for a beer ?

With kind regards - mit freundlichen Gruessen,
G e o r
-----Ursprüngliche Nachricht-----
Von: IDUG DB2-L [mailto:[login to unmask email] Im Auftrag von Todd Burch
Gesendet: Donnerstag, 10. Februar 2011 18:46
An: [login to unmask email]
Betreff: Re: [DB2-L] AW: [DB2-L] Scalar function STRIP used in a SPUFI
SELECT

I'm 0 for 2 today. Sorry about that Georg.


i-bin/wa?A0=DB2-L is the home of IDUG's Listserv


Abonnieren Sie unseren Infobrief und erfahren Sie regelmäßig die
neuesten Nachrichten über unsere Lösungen, aktuellen Projekte und
Entwicklungen. Melden sie sich an mit diesem Link http://www.datenzentrale.de/Info-Brief
_______________________________________________________________________________

Datenzentrale Baden-Württemberg, Anstalt des öffentlichen Rechts
Krailenshaldenstr. 44, 70469 Stuttgart
Telefon (0711) 8108-20, Telefax (0711) 8108-21350
E-Mail [login to unmask email], Internet www.datenzentrale.de
Vorstand: Karl Tramer (Vors.) und Harald Schätzle, Vorsitzender des
Verwaltungsrats: Gunter Czisch
USt-Id-Nr. DE147794223
_______________________________________________________________________________

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA
*
* If you are going to attend only one conference this year, this is
it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

Roger Hecq

Re: AW: [DB2-L] AW: [DB2-L] Scalar function STRIP used in a SPUFI SELECT
(in response to Todd Burch)
And you'll treat him to a Lone Star long neck?

Roger Hecq
MF IB USA DB Support
203-719-0492 / 19-337-0492

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Todd Burch
Sent: Thursday, February 10, 2011 1:17 PM
To: [login to unmask email]
Subject: Re: [DB2-L] AW: [DB2-L] AW: [DB2-L] Scalar function STRIP used in a SPUFI SELECT

I wish. I've heard they have very good beer in Prague. I'll take a
rain check.

I'll reciprocate when you come to South East Texas.

Todd


On Feb 10, 2011, at 12:08 PM, Peter, Georg wrote:

See you in Prague for a beer ?

With kind regards - mit freundlichen Gruessen, G e o r -----Ursprüngliche Nachricht-----
Von: IDUG DB2-L [mailto:[login to unmask email] Im Auftrag von Todd Burch
Gesendet: Donnerstag, 10. Februar 2011 18:46
An: [login to unmask email]
Betreff: Re: [DB2-L] AW: [DB2-L] Scalar function STRIP used in a SPUFI SELECT

I'm 0 for 2 today. Sorry about that Georg.


i-bin/wa?A0=DB2-L is the home of IDUG's Listserv


Abonnieren Sie unseren Infobrief und erfahren Sie regelmäßig die neuesten Nachrichten über unsere Lösungen, aktuellen Projekte und Entwicklungen. Melden sie sich an mit diesem Link http://www.datenzentrale.de/Info-Brief
_______________________________________________________________________________

Datenzentrale Baden-Württemberg, Anstalt des öffentlichen Rechts Krailenshaldenstr. 44, 70469 Stuttgart Telefon (0711) 8108-20, Telefax (0711) 8108-21350 E-Mail [login to unmask email], Internet www.datenzentrale.de
Vorstand: Karl Tramer (Vors.) und Harald Schätzle, Vorsitzender des
Verwaltungsrats: Gunter Czisch
USt-Id-Nr. DE147794223
_______________________________________________________________________________

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA
*
* If you are going to attend only one conference this year, this is
it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.

E-mails are not encrypted and cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities
or related financial instruments.


UBS reserves the right to retain all messages. Messages are protected
and accessed only in legally justified cases.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

Carol Anne Sutfin

Re: AW: [DB2-L] AW: [DB2-L] Scalar function STRIP used in a SPUFI SELECT
(in response to Roger Hecq)
That and BBQ at the Salt Lick outside Austin.


Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
[login to unmask email]



From: Roger Hecq <[login to unmask email]>
To: [login to unmask email]
Date: 02/10/2011 12:40 PM
Subject: Re: [DB2-L] AW: [DB2-L] AW: [DB2-L] Scalar function STRIP used
in a SPUFI SELECT
Sent by: IDUG DB2-L <[login to unmask email]>



And you'll treat him to a Lone Star long neck?

Roger Hecq
MF IB USA DB Support
203-719-0492 / 19-337-0492

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Todd Burch
Sent: Thursday, February 10, 2011 1:17 PM
To: [login to unmask email]
Subject: Re: [DB2-L] AW: [DB2-L] AW: [DB2-L] Scalar function STRIP used in
a SPUFI SELECT

I wish. I've heard they have very good beer in Prague. I'll take a
rain check.

I'll reciprocate when you come to South East Texas.

Todd


On Feb 10, 2011, at 12:08 PM, Peter, Georg wrote:

See you in Prague for a beer ?

With kind regards - mit freundlichen Gruessen, G e o r -----Ursprüngliche
Nachricht-----
Von: IDUG DB2-L [mailto:[login to unmask email] Im Auftrag von Todd Burch
Gesendet: Donnerstag, 10. Februar 2011 18:46
An: [login to unmask email]
Betreff: Re: [DB2-L] AW: [DB2-L] Scalar function STRIP used in a SPUFI
SELECT

I'm 0 for 2 today. Sorry about that Georg.


i-bin/wa?A0=DB2-L is the home of IDUG's Listserv


Abonnieren Sie unseren Infobrief und erfahren Sie regelmäßig die neuesten
Nachrichten über unsere Lösungen, aktuellen Projekte und Entwicklungen.
Melden sie sich an mit diesem Link http://www.datenzentrale.de/Info-Brief
_______________________________________________________________________________


Datenzentrale Baden-Württemberg, Anstalt des öffentlichen Rechts
Krailenshaldenstr. 44, 70469 Stuttgart Telefon (0711) 8108-20, Telefax
(0711) 8108-21350 E-Mail [login to unmask email], Internet www.datenzentrale.de
Vorstand: Karl Tramer (Vors.) und Harald Schätzle, Vorsitzender des
Verwaltungsrats: Gunter Czisch
USt-Id-Nr. DE147794223
_______________________________________________________________________________


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA
*
* If you are going to attend only one conference this year, this is
it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it!
*
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.

E-mails are not encrypted and cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities
or related financial instruments.


UBS reserves the right to retain all messages. Messages are protected
and accessed only in legally justified cases.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it!
*
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

Todd Burch

Re: Scalar function STRIP used in a SPUFI SELECT
(in response to Carol Anne Sutfin)
lol. If that's what he really wants, yes! And some pecan smoked
beef jerky too.

Seems like Friday today....

Todd


On Feb 10, 2011, at 12:39 PM, Roger Hecq wrote:

And you'll treat him to a Lone Star long neck?

Roger Hecq
MF IB USA DB Support
203-719-0492 / 19-337-0492

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Todd Burch
Sent: Thursday, February 10, 2011 1:17 PM
To: [login to unmask email]
Subject: Re: [DB2-L] AW: [DB2-L] AW: [DB2-L] Scalar function STRIP
used in a SPUFI SELECT

I wish. I've heard they have very good beer in Prague. I'll take a
rain check.

I'll reciprocate when you come to South East Texas.

Todd


On Feb 10, 2011, at 12:08 PM, Peter, Georg wrote:

See you in Prague for a beer ?

With kind regards - mit freundlichen Gruessen, G e o r -----
Ursprüngliche Nachricht-----
Von: IDUG DB2-L [mailto:[login to unmask email] Im Auftrag von Todd Burch
Gesendet: Donnerstag, 10. Februar 2011 18:46
An: [login to unmask email]
Betreff: Re: [DB2-L] AW: [DB2-L] Scalar function STRIP used in a SPUFI
SELECT

I'm 0 for 2 today. Sorry about that Georg.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

Raymond Bell

Re: AW: [DB2-L] AW: [DB2-L] Scalar function STRIP used in a SPUFI SELECT
(in response to Todd Burch)
Ahhh... the Salt Lick. Mmmm... Never been quite so stuffed on ribs in my life. Gimme a Sierra Nevada any day. ;o)

Laters,


Raymond

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of [login to unmask email]
Sent: 10 February 2011 18:48
To: [login to unmask email]
Subject: Re: [DB2-L] AW: [DB2-L] AW: [DB2-L] Scalar function STRIP used in a SPUFI SELECT

That and BBQ at the Salt Lick outside Austin.


Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
[login to unmask email]



From: Roger Hecq <[login to unmask email]>
To: [login to unmask email]
Date: 02/10/2011 12:40 PM
Subject: Re: [DB2-L] AW: [DB2-L] AW: [DB2-L] Scalar function STRIP used
in a SPUFI SELECT
Sent by: IDUG DB2-L <[login to unmask email]>



And you'll treat him to a Lone Star long neck?

Roger Hecq
MF IB USA DB Support
203-719-0492 / 19-337-0492

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Todd Burch
Sent: Thursday, February 10, 2011 1:17 PM
To: [login to unmask email]
Subject: Re: [DB2-L] AW: [DB2-L] AW: [DB2-L] Scalar function STRIP used in
a SPUFI SELECT

I wish. I've heard they have very good beer in Prague. I'll take a
rain check.

I'll reciprocate when you come to South East Texas.

Todd


On Feb 10, 2011, at 12:08 PM, Peter, Georg wrote:

See you in Prague for a beer ?

With kind regards - mit freundlichen Gruessen, G e o r -----Ursprüngliche
Nachricht-----
Von: IDUG DB2-L [mailto:[login to unmask email] Im Auftrag von Todd Burch
Gesendet: Donnerstag, 10. Februar 2011 18:46
An: [login to unmask email]
Betreff: Re: [DB2-L] AW: [DB2-L] Scalar function STRIP used in a SPUFI
SELECT

I'm 0 for 2 today. Sorry about that Georg.


i-bin/wa?A0=DB2-L is the home of IDUG's Listserv


Abonnieren Sie unseren Infobrief und erfahren Sie regelmäßig die neuesten
Nachrichten über unsere Lösungen, aktuellen Projekte und Entwicklungen.
Melden sie sich an mit diesem Link http://www.datenzentrale.de/Info-Brief
_______________________________________________________________________________


Datenzentrale Baden-Württemberg, Anstalt des öffentlichen Rechts
Krailenshaldenstr. 44, 70469 Stuttgart Telefon (0711) 8108-20, Telefax
(0711) 8108-21350 E-Mail [login to unmask email], Internet www.datenzentrale.de
Vorstand: Karl Tramer (Vors.) und Harald Schätzle, Vorsitzender des
Verwaltungsrats: Gunter Czisch
USt-Id-Nr. DE147794223
_______________________________________________________________________________


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA
*
* If you are going to attend only one conference this year, this is
it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it!
*
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.

E-mails are not encrypted and cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities
or related financial instruments.


UBS reserves the right to retain all messages. Messages are protected
and accessed only in legally justified cases.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it!
*
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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

Phil Grainger

Re: AW: Scalar function STRIP used in a SPUFI SELECT
(in response to Raymond Bell)
Maybe it’s not so elegant, but I usually use SUBSTR to shrink those columns to their pre-long name lengths (and just hope there aren’t any long names to be truncated)

Phil G

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Peter, Georg
Sent: 09 February 2011 14:55
To: [login to unmask email]
Subject: [DB2-L] AW: [DB2-L] AW: Scalar function STRIP used in a SPUFI SELECT

Thank you, Walter - and see you in Duesseldorf........

Okay, some of the catalog table columns became greater (e.g. from 18 to 128 byte).
And therefore each SPUFI output line becomes longer and longer ;-(

With kind regards - mit freundlichen Gruessen,
G e o r g H . P e t e r
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Development and Product Support (E3)
Krailenshaldenstrasse 44
Ground Floor, Room 018
70469 Stuttgart, Germany, Europe
e:mail [login to unmask email]
Phone 0049-711-8108-27271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de < http://www.dzbw.de/ >
----------------------------------------------------------------------


-----Ursprüngliche Nachricht-----
Von: IDUG DB2-L [mailto:[login to unmask email] Im Auftrag von Walter Janißen
Gesendet: Mittwoch, 9. Februar 2011 15:19
An: [login to unmask email]
Betreff: [DB2-L] AW: Scalar function STRIP used in a SPUFI SELECT
Hello Georg

Long time, no see.

I think, you are wrong, because STRIP does not change the format, which the data is presented in. So for your second example you get 3 columns, the first with a width of 128, while for the first example you get one column.

P.S. Hope to see you at the next GUIDE here in Duesseldorf in April

Mit freundlichen Grüßen
Walter Janißen

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Systeme Laufzeitarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

Vorsitzender des Aufsichtsrats: Jürgen Vetter
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Ina Kirchhof, Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schön
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996



________________________________
Von: IDUG DB2-L [mailto:[login to unmask email] Im Auftrag von Peter, Georg
Gesendet: Mittwoch, 9. Februar 2011 15:11
An: [login to unmask email]
Betreff: [DB2-L] Scalar function STRIP used in a SPUFI SELECT
Environment: DB2 z/OS version 8 NFM
Interface : SPUFI (Process SQL statements)
-------------------------------------------------------------------

When I do a spufi SELECT against a catalog table, e.g.

select sTRIP(creator) !! ' ' !! strip(name)!! ' ' !!
encoding_scheme
from sysibm.systables
where creator = 'ORDN'
……..

The strip function works and The result is okay:


ORDN DAA001 E
ORDN DAA003 E
ORDN DAA013 E
ORDN DAA022 E
ORDN DAA031 E
ORDN DAA041 E
ORDN DAA101 E


The same spufi statement without concatenation but with comma-separated column names:

select sTRIP(creator), /* varchar(128)*/
, strip(name)! /* the same */
, encoding_scheme /* CHAR(1) */
from sysibm.systables
where creator = 'ORDN'
……..

now the strip function does not work in spufi:

ORDN
ORDN
ORDN
ORDN
ORDN

HMMMM……SPUFI cannot deal with the strip function, when the columns in the select are comma-separated ?????????

Any info that anybody can provide on the above would be greatly appreciated.

With kind regards - mit freundlichen Gruessen,
G e o r g H . P e t e r
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Development and Product Support (E3)
Krailenshaldenstrasse 44
Ground Floor, Room 018
70469 Stuttgart, Germany, Europe
e:mail [login to unmask email]
Phone 0049-711-8108-27271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de < http://www.dzbw.de/ >
----------------------------------------------------------------------




Abonnieren Sie unseren Infobrief und erfahren Sie regelm��ig die neuesten Nachrichten �ber unsere L�sungen, aktuellen Projekte und Entwicklungen. Melden Sie sich an mit diesem Link http://www.datenzentrale.de/Info-Brief

_______________________________________________________________________________

Datenzentrale Baden-W�rttemberg, Anstalt des �ffentlichen Rechts
Krailenshaldenstr. 44, 70469 Stuttgart
Telefon (0711) 8108-20, Telefax (0711) 8108-21350
E-Mail [login to unmask email] <mailto:[login to unmask email]>, Internet www.datenzentrale.de< http://www.datenzentrale.de >
Vorstand: Karl Tramer (Vors.) und Harald Sch�tzle, Vorsitzender des Verwaltungsrats: Gunter Czisch
USt-Id-Nr. DE147794223
_______________________________________________________________________________

________________________________

[ http://www.idug.org/images/stories/db2/db2_10_savings.jpg ] < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

________________________________

[ http://www.idug.org/images/stories/db2/db2_10_savings.jpg ] < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

Abonnieren Sie unseren Infobrief und erfahren Sie regelmäßig die neuesten Nachrichten über unsere Lösungen, aktuellen Projekte und Entwicklungen. Melden Sie sich an mit diesem Link http://www.datenzentrale.de/Info-Brief

_______________________________________________________________________________

Datenzentrale Baden-Württemberg, Anstalt des öffentlichen Rechts
Krailenshaldenstr. 44, 70469 Stuttgart
Telefon (0711) 8108-20, Telefax (0711) 8108-21350
E-Mail [login to unmask email] <mailto:[login to unmask email]>, Internet www.datenzentrale.de< http://www.datenzentrale.de >
Vorstand: Karl Tramer (Vors.) und Harald Schätzle, Vorsitzender des Verwaltungsrats: Gunter Czisch
USt-Id-Nr. DE147794223
_______________________________________________________________________________

________________________________

[ http://www.idug.org/images/stories/db2/db2_10_savings.jpg ] < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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