DB2 V8 Z/OS not equal operator

Norman Daley

DB2 V8 Z/OS not equal operator
Hello list,
I admit at failure searching the archives for an answer to this. I know I read a while back that V8 has trouble with 'not equal' when using the funny sideways-dash-like symbol (which is not on my keyboard). I think <> is OK? Can someone refresh my memory, or is my aged memory just too far gone? Thanks.

Norm Daley

---------------------------------------------------------------------------------
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

Glen Sanderson

Re: DB2 V8 Z/OS not equal operator
(in response to Norman Daley)
The preferred syntax is column <> value. That is portable.

In COBOL z/OS you can use the column ¬= value. The ¬ is created by shift-6. This is not portable.



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Daley, Norman
Sent: January 25, 2007 14:26
To: [login to unmask email]
Subject: [DB2-L] DB2 V8 Z/OS not equal operator



Hello list,
I admit at failure searching the archives for an answer to this. I know I read a while back that V8 has trouble with 'not equal' when using the funny sideways-dash-like symbol (which is not on my keyboard). I think <> is OK? Can someone refresh my memory, or is my aged memory just too far gone? Thanks.

Norm Daley

--------------------------------------------------------------------------------- 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

"MMS <safeway.com>" made the following annotations.
------------------------------------------------------------------------------
Warning:
All e-mail sent to this address will be received by the Safeway corporate e-mail system, and is subject to archival and review by someone other than the recipient. This e-mail may contain information proprietary to Safeway and is intended only for the use of the intended recipient(s). If the reader of this message is not the intended recipient(s), you are notified that you have received this message in error and that any review, dissemination, distribution or copying of this message is strictly prohibited. If you have received this message in error, please notify the sender immediately.

======

---------------------------------------------------------------------------------
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

Ava Collins

Re: DB2 V8 Z/OS not equal operator
(in response to Glen Sanderson)
Yesm my understanding is that <> is preferred to ^= .

Jacquie


-----Original Message-----
From: [login to unmask email]
To: [login to unmask email]
Sent: Thu, 25 Jan 2007 3:26 PM
Subject: [DB2-L] DB2 V8 Z/OS not equal operator


Hello list,
I admit at failure searching the archives for an answer to this. I know I read a while back that V8 has trouble with 'not equal' when using the funny sideways-dash-like symbol (which is not on my keyboard). I think <> is OK? Can someone refresh my memory, or is my aged memory just too far gone? Thanks.

Norm Daley
--------------------------------------------------------------------------------- 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
________________________________________________________________________
Check out the new AOL. Most comprehensive set of free safety and security tools, free access to millions of high-quality videos from across the web, free AOL Mail and more.

---------------------------------------------------------------------------------
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

Richard Fazio

Re: DB2 V8 Z/OS not equal operator
(in response to Ava Collins)
Also keep in mind that != (Exclamation point equal sign) is also
valid....most of the time. Some non-IBM API's (go figure) don't care
for it.



Check out SQL Ref/Utility Ref.



"!" means not...so: != !> !<



Watch out for code page issues.

Have fun!

Or should I say, Not Have Fun! ....darn double negatives



Faz

Rich Fazio

Information Architecture



TransUnion, LLC

Marketing Services, 8th Floor

555 West Adams St. Chicago, IL 60661

Phone (312) 985-3270 Fax (312) 466-6453



Talk to teach - Listen to learn





________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Daley, Norman
Sent: January 25, 2007 14:26
To: [login to unmask email]
Subject: [DB2-L] DB2 V8 Z/OS not equal operator



Hello list,
I admit at failure searching the archives for an answer to this. I know
I read a while back that V8 has trouble with 'not equal' when using the
funny sideways-dash-like symbol (which is not on my keyboard). I think
<> is OK? Can someone refresh my memory, or is my aged memory just too
far gone? Thanks.

Norm Daley

------------------------------------------------------------------------
--------- 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

"MMS <safeway.com>" made the following annotations.
------------------------------------------------------------------------
------
Warning:
All e-mail sent to this address will be received by the Safeway
corporate e-mail system, and is subject to archival and review by
someone other than the recipient. This e-mail may contain information
proprietary to Safeway and is intended only for the use of the intended
recipient(s). If the reader of this message is not the intended
recipient(s), you are notified that you have received this message in
error and that any review, dissemination, distribution or copying of
this message is strictly prohibited. If you have received this message
in error, please notify the sender immediately.


======


------------------------------------------------------------------------
--------- 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

---------------------------------------------------------------------------------
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

Peter Vanroose

Re: DB2 V8 Z/OS not equal operator
(in response to Richard Fazio)
> In COBOL z/OS you can use the column ¬= value. The ¬ is created by shift-6.

"<>" is indeed the only portable "not equal" in SQL, also outside DB2.

Just want to mention that it depends on your keyboard whether the ¬ is on shift-6 or not.
(It's not on mine, for example...)
The ¬ does not even have a fixed place in the EBCDIC code table: is's on 0xBA (186) in the intl.
code page, and on 0x5F (95) in the American one.

-- Peter.





_________________________________________________________
Flyger tiden iväg? Fånga dagen med Yahoo! Mails inbyggda
kalender. Dessutom 250 MB gratis, virusscanning och antispam. Få den på: http://se.mail.yahoo.com

---------------------------------------------------------------------------------
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

john travis

Re: DB2 V8 Z/OS not equal operator
(in response to Peter Vanroose)

Norm,
From our experience it is V7 where the problem appears since V8 converts
¬ and ^ to ! when converting EBCDIC to UNICODE for parsing. Check out APAR
UK09292.

Regards,
John Travis

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Daley, Norman
Sent: 25 January 2007 20:26
To: [login to unmask email]
Subject: [DB2-L] DB2 V8 Z/OS not equal operator


Hello list,
I admit at failure searching the archives for an answer to this. I know I
read a while back that V8 has trouble with 'not equal' when using the funny
sideways-dash-like symbol (which is not on my keyboard). I think <> is OK?
Can someone refresh my memory, or is my aged memory just too far gone?
Thanks.

Norm Daley
----------------------------------------------------------------------------
----- 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 message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.

---------------------------------------------------------------------------------
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