Ascii function

Posted in 2003

Demeis, Tony — Tue, 13 May 2003 19:57:59 — source: IIUG Forums & Mailing Lists

Hi, I'm trying to check the contents of a 10-byte character column for non-alpha, non-numeric and non blank values. I have not been able to find an Informix function to check for the ascii values. Any ideas here? Thank you. Tony

↪ replying to Demeis, Tony

Jean Anderson — Tue, 13 May 2003 21:02:23 — source: IIUG Forums & Mailing Lists

For IDS 9.x, the SqlLib bladelet provides an ascii UDR: http://www7b.boulder.ibm.com/dmdd/zones/informix/library/techarticle/db_sqllib.h tml You have your choice of C and Java implementations. -jean Jean T. Anderson Extender & DataBlade Development, IBM Data Management email: jander@us.ibm.com web: http://www.ibm.com/software/data/informix/ web: http://www.ibm.com/software/data/developer/informix "Demeis, Tony" <Tony.Demeis@moh. To: ids@iiug.org gov.on.ca> cc: Sent by: Subject: Ascii function [1127] forum.subscriber@ iiug.org 05/13/2003 12:57 PM Hi, I'm trying to check the contents of a 10-byte character column for non-alpha, non-numeric and non blank values. I have not been able to find an Informix function to check for the ascii values. Any ideas here? Thank you. Tony