[DB2-L] DB2 V8 Z/OS Null indicators and host variable

Brian Goldberg

[DB2-L] DB2 V8 Z/OS Null indicators and host variable
Steve,

That has been my experience. I've often asked developers to initialize host
variables prior to a DB2 call when the application doesn't need to know the
difference between null and spaces or null and zeroes. It removes
IF-THEN-ELSE statements later in the code, and can prevent data exceptions
if the field is inadvertantly referenced.

Brian
----- Forwarded by BRIAN GOLDBERG/QVC on 12/05/2007 09:02 AM -----

"Wallace,
Stephen"
<stephen.wallace@ To
LANDG.COM> [login to unmask email]
Ext: cc
Sent by: DB2 Data
Base Discussion Subject
List [DB2-L] DB2 V8 Z/OS Null indicators
<[login to unmask email] and host variable
ORG>


12/05/2007 08:02
AM


Please respond to
DB2 Database
Discussion list
at IDUG
<[login to unmask email]
2-L.ORG>






Hi Group,
This is a question I recently received from a developer.


If a host program sets a field to spaces then that program receives a value
of a nullable column into that field and its associated null-indicator
where the "value" in the column is null can it be assumed that the field
still contains spaces.


I hope this makes sense.
Regards,
Steve Wallace
Mainframe DBA
Legal & General Assurance Society
Work: 01737 374308 (7100 4308)


**********************************************************************
This email (and any attachments) may contain privileged and/or confidential
information. If you are not the intended recipient please do not disclose,
copy, distribute, disseminate or take any action in reliance on it. If you
have received this message in error please reply and tell us and then
delete it. Should you wish to communicate with us by email we cannot
guarantee the security of any data outside our own computer systems. For
the protection of Legal & General's systems and staff, incoming emails will
be automatically scanned. Any information contained in this message may be
subject to applicable terms and conditions and must not be construed as
giving investment advice within or outside the United Kingdom.


Legal & General Group plc is registered in England under company number
1417162 and is a holding company.


The registered office for all companies in the Legal & General group is One
Coleman Street London EC2R 5AA.


The following subsidiary companies of Legal & General Group Plc are
authorised and regulated by the Financial Services Authority: Legal &
General Partnership Services Limited, Legal & General Insurance Limited,
Legal & General Assurance Society Limited, Legal & General (Unit Trust
Managers) Limited and Legal & General (Portfolio Management Services)
Limited.


Legal & General International (Ireland) is incorporated in Ireland under
company number 440141 with its registered office at Alexandra House, The
Sweepstakes, Ballsbridge, Dublin 4 and is authorised by the Financial
Regulator in Ireland and by the Financial Services Authority for the
conduct of insurance business in the UK.


Full details can be found at http://www.legalandgeneralgroup.com/


**********************************************************************


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 November 30th.
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 November 30th. 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: DB2 V8 Z/OS Null indicators and host variable
(in response to Brian Goldberg)
I was taught (by Jon Sayles, back about V2.2) that it wasn't safe to
assume that -- that you might get garbage in the associated field, and
should always check the indicator field (and don't do anything with the
value field if the indicator shows a null value for the column).

--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]
________________________________________
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Wallace, Stephen
Sent: Wednesday, December 05, 2007 7:52 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 V8 Z/OS Null indicators and host variable

Hi Group,
This is a question I recently received from a developer.
If a host program sets a field to spaces then that program receives a
value of a nullable column into that field and its associated
null-indicator where the "value" in the column is null can it be assumed
that the field still contains spaces.
I hope this makes sense.
Regards,
Steve Wallace
Mainframe DBA
Legal & General Assurance Society
Work: 01737 374308 (7100 4308)
**********************************************************************
This email (and any attachments) may contain privileged and/or
confidential information. If you are not the intended recipient please
do not disclose, copy, distribute, disseminate or take any action in
reliance on it. If you have received this message in error please reply
and tell us and then delete it. Should you wish to communicate with us
by email we cannot guarantee the security of any data outside our own
computer systems. For the protection of Legal & General's systems and
staff, incoming emails will be automatically scanned. Any information
contained in this message may be subject to applicable terms and
conditions and must not be construed as giving investment advice within
or outside the United Kingdom.
Legal & General Group plc is registered in England under company number
1417162 and is a holding company.
The registered office for all companies in the Legal & General group is
One Coleman Street London EC2R 5AA.
The following subsidiary companies of Legal & General Group Plc are
authorised and regulated by the Financial Services Authority: Legal &
General Partnership Services Limited, Legal & General Insurance Limited,
Legal & General Assurance Society Limited, Legal & General (Unit Trust
Managers) Limited and Legal & General (Portfolio Management Services)
Limited.
Legal & General International (Ireland) is incorporated in Ireland under
company number 440141 with its registered office at Alexandra House, The
Sweepstakes, Ballsbridge, Dublin 4 and is authorised by the Financial
Regulator in Ireland and by the Financial Services Authority for the
conduct of insurance business in the UK.
Full details can be found at http://www.legalandgeneralgroup.com/
**********************************************************************


=========
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 November 30th. 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

Ray Price

Re: DB2 V8 Z/OS Null indicators and host variable
(in response to Philip Sevetson)
Hi Steve,



I found this in the "Application Programming and SQL Guide":



When DB2 retrieves the value of a column, you can test the indicator
variable. If the

indicator variable's value is less than zero, the column value is null.
When the

column value is null, the value of the host variable does not change
from its

previous value.





Regards,
Ray Price
Dresdner Kleinwort
London

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Wallace, Stephen
Sent: 05 December 2007 12:52
To: [login to unmask email]
Subject: [DB2-L] DB2 V8 Z/OS Null indicators and host variable



Hi Group,
This is a question I recently received from a developer.

If a host program sets a field to spaces then that program receives a
value of a nullable column into that field and its associated
null-indicator where the "value" in the column is null can it be assumed
that the field still contains spaces.

I hope this makes sense.
Regards,
Steve Wallace
Mainframe DBA
Legal & General Assurance Society
Work: 01737 374308 (7100 4308)

**********************************************************************



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 November
30th. 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


--
This e-mail is confidential and the information contained in it may be privileged. It should not be read, copied or used by anyone other than the intended recipient. If you have received it in error, please contact the sender immediately by telephoning +44 (0)20 7623 8000 or by return email, and delete the e-mail and do not disclose its contents to any person. We believe, but do not warrant, that this e-mail and any attachments are virus free, but you must take full responsibility for virus checking. Please refer to http://www.dresdnerkleinwort.com/disc/email/ and read our e-mail disclaimer statement and monitoring policy.

Dresdner Kleinwort is the trading name of the investment banking division of Dresdner Bank AG, and operates through Dresdner Bank AG, Dresdner Kleinwort Limited, Dresdner Kleinwort Securities Limited and their affiliated or associated companies. Dresdner Bank AG is a company incorporated in Germany with limited liability and registered in England (registered no. FC007638, place of business 30 Gresham Street, London EC2V 7PG), and is authorised by the German Federal Financial Supervisory Authority and by the Financial Services Authority ('FSA') and regulated by the FSA for the conduct of designated business in the UK. Dresdner Kleinwort Limited is a company incorporated in England (registered no. 551334, registered office 30 Gresham Street, London EC2V 7PG), and is authorised and regulated by the FSA. Dresdner Kleinwort Securities Limited is a company incorporated in England (registered no. 1767419, registered office 30 Gresham Street, London EC2V 7PG), and is authorised and regulated by the FSA.


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 November 30th. 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

Raymond Bell

Re: DB2 V8 Z/OS Null indicators and host variable
(in response to Ray Price)
Hi Steve,

I think Mr. Sevetson has it right. The only way to know a host variable
contains a null value (or is intended to represent one) is to check the
indicator variable. The contents of the actual host variable could be
anything. I wouldn't trust the host variable to retain its original
value, especially if the variable is in a comm area - they have a habit
of being overwritten when you'd least expect it.

See you next week,


Raymond

_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Wallace, Stephen
Sent: 05 December 2007 12:52
To: [login to unmask email]
Subject: [DB2-L] DB2 V8 Z/OS Null indicators and host variable

Hi Group,
This is a question I recently received from a developer.
If a host program sets a field to spaces then that program receives a
value of a nullable column into that field and its associated
null-indicator where the "value" in the column is null can it be assumed
that the field still contains spaces.
I hope this makes sense.
Regards,
Steve Wallace
Mainframe DBA
Legal & General Assurance Society
Work: 01737 374308 (7100 4308)
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 November
30th. 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 November
30th. 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 November 30th. 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: DB2 V8 Z/OS Null indicators and host variable
(in response to Raymond Bell)
From Pg. 70 of the Application Programming and SQL Guide V7, the host
variable value does not change from it's previous value. I only
remember this because I recently quoted it to our developers.



When DB2 retrieves the value of a column, you can test the indicator
variable. If the

indicator variable's value is less than zero, the column value is null.
When the

column value is null, the value of the host variable does not change
from its

previous value.



brian





________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Bell, Raymond
Sent: Wednesday, December 05, 2007 9:43 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V8 Z/OS Null indicators and host variable



Hi Steve,



I think Mr. Sevetson has it right. The only way to know a host variable
contains a null value (or is intended to represent one) is to check the
indicator variable. The contents of the actual host variable could be
anything. I wouldn't trust the host variable to retain its original
value, especially if the variable is in a comm area - they have a habit
of being overwritten when you'd least expect it.



See you next week,





Raymond



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 November
30th. 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 November
30th. 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 November
30th. 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 November 30th. 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: DB2 V8 Z/OS Null indicators and host variable
(in response to Brian Bear)
Ooops, sorry for the dupl. post. I see Ray already sent the same
response. Thanks Ray.



________________________________

From: Bear, Brian
Sent: Wednesday, December 05, 2007 9:55 AM
To: 'DB2 Database Discussion list at IDUG'
Subject: RE: [DB2-L] DB2 V8 Z/OS Null indicators and host variable



From Pg. 70 of the Application Programming and SQL Guide V7, the host
variable value does not change from it's previous value. I only
remember this because I recently quoted it to our developers.



When DB2 retrieves the value of a column, you can test the indicator
variable. If the

indicator variable's value is less than zero, the column value is null.
When the

column value is null, the value of the host variable does not change
from its

previous value.



brian





________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Bell, Raymond
Sent: Wednesday, December 05, 2007 9:43 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V8 Z/OS Null indicators and host variable



Hi Steve,



I think Mr. Sevetson has it right. The only way to know a host variable
contains a null value (or is intended to represent one) is to check the
indicator variable. The contents of the actual host variable could be
anything. I wouldn't trust the host variable to retain its original
value, especially if the variable is in a comm area - they have a habit
of being overwritten when you'd least expect it.



See you next week,





Raymond



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 November
30th. 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 November
30th. 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 November
30th. 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 November 30th. 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

Nick Dordea

Re: Fw: [DB2-L] DB2 V8 Z/OS Null indicators and host variable
(in response to Brian Bear)
Hi ,

The answer is provided by the sqlcode -305 message.

"The null value can not be assigned to output host variable number .....
because no indicator variable is specified".

Therefore in the event of a "null" column a select a-null-collum into :HV:IV
sets the IV to -1 and will not modify the field associated with :HV.

Nick

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 November 30th. 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

Gary L Joehlin

Re: Fw: [DB2-L] DB2 V8 Z/OS Null indicators and host variable
(in response to Nick Dordea)
Just a friendly note and observation that should help in the debugging
effort:

Each shop should strongly consider a standard for program
self-diagnosis, that when an undesirable SQL code is discovered, lots of
really useful information can be gleaned from the SQLCA, particularly,
the "token-list" which is in SQLERRMC.

A good generalized way to have the program help you and anyone else help
in the diagnosis is to use the DSNTIAR (batch) and DSNTIAC (CICS)
routines to format the message, then you add code to print or put to a
message queue.

The 'fill in the blank' portions of the message, in the DB2 messages and
codes manual are filled in by the information in this token list. This
is also very helpful for DBA's in helping you with -904's, as there are
probably hundreds of possible reasons for why you have a resource not
available and this token list will save HOURS of research.

Best,
Gary Joehlin
Colorado Springs, CO

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Nick
Sent: Wednesday, December 05, 2007 9:57 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Fw: [DB2-L] DB2 V8 Z/OS Null indicators and host
variable

Hi ,

The answer is provided by the sqlcode -305 message.

"The null value can not be assigned to output host variable number .....
because no indicator variable is specified".

Therefore in the event of a "null" column a select a-null-collum into
:HV:IV
sets the IV to -1 and will not modify the field associated with :HV.

Nick

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 November
30th. 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 November 30th. 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