inverting and concatenating a column of values

Myron Miller

inverting and concatenating a column of values
I've had the request to take a SQL set that contains a lot of different values
(300-1000) that is stored as individual rows and have the individual rows
changed such that the entire row set is on one row and contained within a
single column.

In other words, having something like this

A1
B2
C3
D4,
etc

become A1B2C3D4.

It's pretty easy to do this when the number of rows and values for those rows
is a fairly limited number (say less than 20) but I could easily have well over
5000 different values and the values change during the year. So we'd have to
be constantly maintaining the SQL to check on the new values (using a CASE
statement on the values).

What I don't know is how to get this done where I have no clue as to the number
of possible values nor how many of them I can expect. The max number will have
to be less than 500 due to size limitations of the output field (less than 32k)
but that's the only restriction on the size.

Suggestions? The programmer involved wants us to build another table that is
maintained and has the values stored in the table that way. I'd prefer to do
it via SQL as that's less long term maintenance but I've got no clue now on how
to accomplish this,


Myron

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on December 7th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Phil Grainger

Re: inverting and concatenating a column of values
(in response to Myron Miller)
I'd be reaching for my REXX (or COBOL or whatever) at this point

It's SO easy NOT to do this in SQL, why would you want to do it any
other way??

Eg

String = ''
Declare c1 cursor for .........
Open c1
Fetch c1 into :var
Do until sqlcode = 100
String = String || :var
Fetch c1 into :var
End
Etc etc etc

The answer is not always "SQL"


Phil Grainger
CA
Product Management Director
Phone: +44 (0)1753 577 733
Mobile: +44 (0)7970 125 752
eMail: [login to unmask email]

Ditton Park
Riding Court Road
Datchet
Slough
SL3 9LL

CA plc a company registered in England and Wales under company
registration number 1282495 with its registered office at the address
set out above. VAT number 697904179.



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Myron Miller
Sent: 06 December 2007 12:38
To: [login to unmask email]
Subject: [DB2-L] inverting and concatenating a column of values

I've had the request to take a SQL set that contains a lot of different
values
(300-1000) that is stored as individual rows and have the individual
rows changed such that the entire row set is on one row and contained
within a single column.

In other words, having something like this

A1
B2
C3
D4,
etc

become A1B2C3D4.

It's pretty easy to do this when the number of rows and values for those
rows is a fairly limited number (say less than 20) but I could easily
have well over 5000 different values and the values change during the
year. So we'd have to be constantly maintaining the SQL to check on the
new values (using a CASE statement on the values).

What I don't know is how to get this done where I have no clue as to the
number of possible values nor how many of them I can expect. The max
number will have to be less than 500 due to size limitations of the
output field (less than 32k) but that's the only restriction on the
size.

Suggestions? The programmer involved wants us to build another table
that is
maintained and has the values stored in the table that way. I'd prefer
to do it via SQL as that's less long term maintenance but I've got no
clue now on how to accomplish this,


Myron

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion
listserv that are being implemented to improve reliability and the
overall user experience of DB2-L. These changes are coming on December
7th. Details at http://www.idug.org

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on December 7th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Brian Bear

Re: inverting and concatenating a column of values
(in response to Phil Grainger)
If this is in a program, your programmer could use a Global Temp table
instead of building a static object.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Myron Miller
Sent: Thursday, December 06, 2007 7:38 AM
To: [login to unmask email]
Subject: [DB2-L] inverting and concatenating a column of values

I've had the request to take a SQL set that contains a lot of different
values
(300-1000) that is stored as individual rows and have the individual
rows
changed such that the entire row set is on one row and contained within
a
single column.

In other words, having something like this

A1
B2
C3
D4,
etc

become A1B2C3D4.

It's pretty easy to do this when the number of rows and values for those
rows
is a fairly limited number (say less than 20) but I could easily have
well over
5000 different values and the values change during the year. So we'd
have to
be constantly maintaining the SQL to check on the new values (using a
CASE
statement on the values).

What I don't know is how to get this done where I have no clue as to the
number
of possible values nor how many of them I can expect. The max number
will have
to be less than 500 due to size limitations of the output field (less
than 32k)
but that's the only restriction on the size.

Suggestions? The programmer involved wants us to build another table
that is
maintained and has the values stored in the table that way. I'd prefer
to do
it via SQL as that's less long term maintenance but I've got no clue now
on how
to accomplish this,


Myron

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion
listserv that are being implemented to improve reliability and the
overall user experience of DB2-L. These changes are coming on December
7th. Details at http://www.idug.org

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on December 7th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Myron Miller

Re: inverting and concatenating a column of values
(in response to Brian Bear)
I have to use SQL as that's the only thing the third party tool COGNOS
understands. We're in the process of doing it with a UDF.

interestingly, Oracle, Sysbase and MySQL and others, all have simple provided
functions in the syntax that will do this for the user. Wonder why Z/OS DB2
doesn't.

Myron
--- "Grainger, Phil" <[login to unmask email]> wrote:

> I'd be reaching for my REXX (or COBOL or whatever) at this point
>
> It's SO easy NOT to do this in SQL, why would you want to do it any
> other way??
>
> Eg
>
> String = ''
> Declare c1 cursor for .........
> Open c1
> Fetch c1 into :var
> Do until sqlcode = 100
> String = String || :var
> Fetch c1 into :var
> End
> Etc etc etc
>
> The answer is not always "SQL"
>
>
> Phil Grainger
> CA
> Product Management Director
> Phone: +44 (0)1753 577 733
> Mobile: +44 (0)7970 125 752
> eMail: [login to unmask email]
>
> Ditton Park
> Riding Court Road
> Datchet
> Slough
> SL3 9LL
>
> CA plc a company registered in England and Wales under company
> registration number 1282495 with its registered office at the address
> set out above. VAT number 697904179.
>
>
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
> Behalf Of Myron Miller
> Sent: 06 December 2007 12:38
> To: [login to unmask email]
> Subject: [DB2-L] inverting and concatenating a column of values
>
> I've had the request to take a SQL set that contains a lot of different
> values
> (300-1000) that is stored as individual rows and have the individual
> rows changed such that the entire row set is on one row and contained
> within a single column.
>
> In other words, having something like this
>
> A1
> B2
> C3
> D4,
> etc
>
> become A1B2C3D4.
>
> It's pretty easy to do this when the number of rows and values for those
> rows is a fairly limited number (say less than 20) but I could easily
> have well over 5000 different values and the values change during the
> year. So we'd have to be constantly maintaining the SQL to check on the
> new values (using a CASE statement on the values).
>
> What I don't know is how to get this done where I have no clue as to the
> number of possible values nor how many of them I can expect. The max
> number will have to be less than 500 due to size limitations of the
> output field (less than 32k) but that's the only restriction on the
> size.
>
> Suggestions? The programmer involved wants us to build another table
> that is
> maintained and has the values stored in the table that way. I'd prefer
> to do it via SQL as that's less long term maintenance but I've got no
> clue now on how to accomplish this,
>
>
> Myron
>
> IMPORTANT NOTICE:
>
> IDUG is pleased to announce a series of upgrades to the DB2-L discussion
> listserv that are being implemented to improve reliability and the
> overall user experience of DB2-L. These changes are coming on December
> 7th. Details at http://www.idug.org
>
> ------------------------------------------------------------------------
> ---------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
> home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
> page select "Join or Leave the list". The IDUG DB2-L FAQ is at
> http://www.idugdb2-l.org. The IDUG List Admins can be reached at
> [login to unmask email] Find out the latest on IDUG conferences
> at http://conferences.idug.org/index.cfm
>
> IMPORTANT NOTICE:
>
> IDUG is pleased to announce a series of upgrades to the DB2-L discussion
> listserv that are being implemented to improve reliability and the overall
> user experience of DB2-L. These changes are coming on December 7th. Details
> at http://www.idug.org
>
>
---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
> "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
> The IDUG List Admins can be reached at [login to unmask email] Find
> out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
>

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on December 7th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Philip Sevetson

Re: inverting and concatenating a column of values
(in response to Myron Miller)
I freely admit that I'm not familiar with the limitations of the WITH
statement and recursive SQL... but isn't this a candidate for that kind
of syntax? (Is Joe Celko on this list? This looks like something he'd
enjoy cracking.)

--Phil Sevetson, NYCAPS DBA Support
Financial Information Services Agency of The City of New York
450 West 33rd Street, 4th Floor
New York, NY 10001
phone: (212) 857-1688
mailto: [login to unmask email]
-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Myron Miller
Sent: Friday, December 07, 2007 10:31 AM
To: [login to unmask email]
Subject: Re: [DB2-L] inverting and concatenating a column of values

I have to use SQL as that's the only thing the third party tool COGNOS
understands. We're in the process of doing it with a UDF.

interestingly, Oracle, Sysbase and MySQL and others, all have simple
provided
functions in the syntax that will do this for the user. Wonder why Z/OS
DB2
doesn't.

Myron
--- "Grainger, Phil" <[login to unmask email]> wrote:

> I'd be reaching for my REXX (or COBOL or whatever) at this point
>
> It's SO easy NOT to do this in SQL, why would you want to do it any
> other way??
>
> Eg
>
> String = ''
> Declare c1 cursor for .........
> Open c1
> Fetch c1 into :var
> Do until sqlcode = 100
> String = String || :var
> Fetch c1 into :var
> End
> Etc etc etc
>
> The answer is not always "SQL"
>
>
> Phil Grainger
> CA
> Product Management Director
> Phone: +44 (0)1753 577 733
> Mobile: +44 (0)7970 125 752
> eMail: [login to unmask email]
>
> Ditton Park
> Riding Court Road
> Datchet
> Slough
> SL3 9LL
>
> CA plc a company registered in England and Wales under company
> registration number 1282495 with its registered office at the address
> set out above. VAT number 697904179.
>
>
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
> Behalf Of Myron Miller
> Sent: 06 December 2007 12:38
> To: [login to unmask email]
> Subject: [DB2-L] inverting and concatenating a column of values
>
> I've had the request to take a SQL set that contains a lot of
different
> values
> (300-1000) that is stored as individual rows and have the individual
> rows changed such that the entire row set is on one row and contained
> within a single column.
>
> In other words, having something like this
>
> A1
> B2
> C3
> D4,
> etc
>
> become A1B2C3D4.
>
> It's pretty easy to do this when the number of rows and values for
those
> rows is a fairly limited number (say less than 20) but I could easily
> have well over 5000 different values and the values change during the
> year. So we'd have to be constantly maintaining the SQL to check on
the
> new values (using a CASE statement on the values).
>
> What I don't know is how to get this done where I have no clue as to
the
> number of possible values nor how many of them I can expect. The max
> number will have to be less than 500 due to size limitations of the
> output field (less than 32k) but that's the only restriction on the
> size.
>
> Suggestions? The programmer involved wants us to build another table
> that is
> maintained and has the values stored in the table that way. I'd
prefer
> to do it via SQL as that's less long term maintenance but I've got no
> clue now on how to accomplish this,
>
>
> Myron
>
> IMPORTANT NOTICE:
>
> IDUG is pleased to announce a series of upgrades to the DB2-L
discussion
> listserv that are being implemented to improve reliability and the
> overall user experience of DB2-L. These changes are coming on
December
> 7th. Details at http://www.idug.org
>
>
------------------------------------------------------------------------
> ---------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
> home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
> page select "Join or Leave the list". The IDUG DB2-L FAQ is at
> http://www.idugdb2-l.org. The IDUG List Admins can be reached at
> [login to unmask email] Find out the latest on IDUG
conferences
> at http://conferences.idug.org/index.cfm
>
> IMPORTANT NOTICE:
>
> IDUG is pleased to announce a series of upgrades to the DB2-L
discussion
> listserv that are being implemented to improve reliability and the
overall
> user experience of DB2-L. These changes are coming on December 7th.
Details
> at http://www.idug.org
>
>
------------------------------------------------------------------------
---------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home
> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select
> "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org.
> The IDUG List Admins can be reached at
[login to unmask email] Find
> out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm
>

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion
listserv that are being implemented to improve reliability and the
overall user experience of DB2-L. These changes are coming on December
7th. Details at http://www.idug.org

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


=========
Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
=========



IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on December 7th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Avram Friedman

Re: inverting and concatenating a column of values
(in response to Philip Sevetson)
You wrote

"I have to use SQL as that's the only thing the third party tool COGNOS
understands. We're in the process of doing it with a UDF."

The code in UDFs and Stored procedures is invisable to the calling program.
Personally if COGNOS understands the SQL call statement a stored procedure
may be a better choice.

It is also worthwhile to mention this seems like a new requirement based on
the fact that you are busy developing a solution. Variable Repeating groups
espically a group imbeded in a single column is decidedly non releational ... to
the extent that I recall my DBA and DA traning it violates first normal form.
Perhaps an insufficent amout of time was spent in the design phase of this
project.


You also wrote

">> What I don't know is how to get this done where I have no clue as to
>the
>> number of possible values nor how many of them I can expect. The max
>> number will have to be less than 500 due to size limitations of the
>> output field (less than 32k) but that's the only restriction on the
>> size.
"

A few points
If you use a LOB you can exceed the 32k limitation.
If you don't use a LOB you can't reach the 32k limitation ... does the new
table have a key? Do you plan to make the field variable length.
How many inserts do you expect to happen in this table per day, Have you
reviewed how DB2 does space management for variable length rows?


Best wishes
Avram Friedman



On Fri, 7 Dec 2007 10:45:25 -0500, Sevetson, Phil
<[login to unmask email]> wrote:

>I freely admit that I'm not familiar with the limitations of the WITH
>statement and recursive SQL... but isn't this a candidate for that kind
>of syntax? (Is Joe Celko on this list? This looks like something he'd
>enjoy cracking.)
>
>--Phil Sevetson, NYCAPS DBA Support
>Financial Information Services Agency of The City of New York
>450 West 33rd Street, 4th Floor
>New York, NY 10001
>phone: (212) 857-1688
>mailto: [login to unmask email]
>-----Original Message-----
>From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
>Behalf Of Myron Miller
>Sent: Friday, December 07, 2007 10:31 AM
>To: [login to unmask email]
>Subject: Re: [DB2-L] inverting and concatenating a column of values
>
>I have to use SQL as that's the only thing the third party tool COGNOS
>understands. We're in the process of doing it with a UDF.
>
>interestingly, Oracle, Sysbase and MySQL and others, all have simple
>provided
>functions in the syntax that will do this for the user. Wonder why Z/OS
>DB2
>doesn't.
>
>Myron
>--- "Grainger, Phil" <[login to unmask email]> wrote:
>
>> I'd be reaching for my REXX (or COBOL or whatever) at this point
>>
>> It's SO easy NOT to do this in SQL, why would you want to do it any
>> other way??
>>
>> Eg
>>
>> String = ''
>> Declare c1 cursor for .........
>> Open c1
>> Fetch c1 into :var
>> Do until sqlcode = 100
>> String = String || :var
>> Fetch c1 into :var
>> End
>> Etc etc etc
>>
>> The answer is not always "SQL"
>>
>>
>> Phil Grainger
>> CA
>> Product Management Director
>> Phone: +44 (0)1753 577 733
>> Mobile: +44 (0)7970 125 752
>> eMail: [login to unmask email]
>>
>> Ditton Park
>> Riding Court Road
>> Datchet
>> Slough
>> SL3 9LL
>>
>> CA plc a company registered in England and Wales under company
>> registration number 1282495 with its registered office at the address
>> set out above. VAT number 697904179.
>>
>>
>>
>> -----Original Message-----
>> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
>> Behalf Of Myron Miller
>> Sent: 06 December 2007 12:38
>> To: [login to unmask email]
>> Subject: [DB2-L] inverting and concatenating a column of values
>>
>> I've had the request to take a SQL set that contains a lot of
>different
>> values
>> (300-1000) that is stored as individual rows and have the individual
>> rows changed such that the entire row set is on one row and contained
>> within a single column.
>>
>> In other words, having something like this
>>
>> A1
>> B2
>> C3
>> D4,
>> etc
>>
>> become A1B2C3D4.
>>
>> It's pretty easy to do this when the number of rows and values for
>those
>> rows is a fairly limited number (say less than 20) but I could easily
>> have well over 5000 different values and the values change during the
>> year. So we'd have to be constantly maintaining the SQL to check on
>the
>> new values (using a CASE statement on the values).
>>
>> What I don't know is how to get this done where I have no clue as to
>the
>> number of possible values nor how many of them I can expect. The max
>> number will have to be less than 500 due to size limitations of the
>> output field (less than 32k) but that's the only restriction on the
>> size.
>>
>> Suggestions? The programmer involved wants us to build another table
>> that is
>> maintained and has the values stored in the table that way. I'd
>prefer
>> to do it via SQL as that's less long term maintenance but I've got no
>> clue now on how to accomplish this,
>>
>>
>> Myron
>>
>> IMPORTANT NOTICE:
>>
>> IDUG is pleased to announce a series of upgrades to the DB2-L
>discussion
>> listserv that are being implemented to improve reliability and the
>> overall user experience of DB2-L. These changes are coming on
>December
>> 7th. Details at http://www.idug.org
>>
>>
>------------------------------------------------------------------------
>> ---------
>> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
>> home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
>> page select "Join or Leave the list". The IDUG DB2-L FAQ is at
>> http://www.idugdb2-l.org. The IDUG List Admins can be reached at
>> [login to unmask email] Find out the latest on IDUG
>conferences
>> at http://conferences.idug.org/index.cfm
>>
>> IMPORTANT NOTICE:
>>
>> IDUG is pleased to announce a series of upgrades to the DB2-L
>discussion
>> listserv that are being implemented to improve reliability and the
>overall
>> user experience of DB2-L. These changes are coming on December 7th.
>Details
>> at http://www.idug.org
>>
>>
>------------------------------------------------------------------------
>---------
>> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
>home
>> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
>select
>> "Join or Leave the list". The IDUG DB2-L FAQ is at
>http://www.idugdb2-l.org.
>> The IDUG List Admins can be reached at
>[login to unmask email] Find
>> out the latest on IDUG conferences at
>http://conferences.idug.org/index.cfm
>>
>
>IMPORTANT NOTICE:
>
>IDUG is pleased to announce a series of upgrades to the DB2-L discussion
>listserv that are being implemented to improve reliability and the
>overall user experience of DB2-L. These changes are coming on December
>7th. Details at http://www.idug.org
>
>------------------------------------------------------------------------
>---------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
>home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
>page select "Join or Leave the list". The IDUG DB2-L FAQ is at
>http://www.idugdb2-l.org. The IDUG List Admins can be reached at
>[login to unmask email] Find out the latest on IDUG
conferences
>at http://conferences.idug.org/index.cfm
>
>
>=========
Confidentiality Notice: This e-mail communication, and any attachments,
contains confidential and privileged information for the exclusive use of the
recipient(s) named above. If you are not an intended recipient, or the
employee or agent responsible to deliver it to an intended recipient, you are
hereby notified that you have received this communication in error and that
any review, disclosure, dissemination, distribution or copying of it or its
contents is prohibited. If you have received this communication in error,
please notify me immediately by replying to this message and delete this
communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author
and do not necessarily represent the opinions of the agency or the City.
=========


>
>IMPORTANT NOTICE:
>
>IDUG is pleased to announce a series of upgrades to the DB2-L discussion
listserv that are being implemented to improve reliability and the overall user
experience of DB2-L. These changes are coming on December 7th. Details at
http://www.idug.org
>
>--------------------------------------------------------------------------
-------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-
l.org. The IDUG List Admins can be reached at [login to unmask email]
l.org. Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on December 7th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm