Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 500 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

 

Excluding characters from AS/400 DB2 SELECT statements prevents mapping errors

Available for Members. This is an off-site link. Please review our Terms of Service (bottom of page) for additional information.


 Article Abstract:

(Kent Milligan) We are running a unicode DB2 for JD Edwards. The CCSID is 13488. I am trying to create a view where we convert one of the alpha fields to a numeric field. We have nulls in some of the records,.so I am using SELECT IFNULL(INT (GLSBL),0) AS AB8, to convert the field. However, I am not getting 0 for the null values, but ++++++++ instead. The info message says to use VARCHAR to convert. Can this be done and will it convert my alpha values to numeric and null values to 0?
(R)

 Read this article...


Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

No Comments/Feedback Posted Yet. Post Your Comments/Feedback

Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   



 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004