Re: Special characters handling in Net.Data

I think there is a function built into the language to handle this. You should be able to see it in the docs in either the string handling stuff or in the SQL language environment stuff.

Matt

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Peter Connell
Sent: Wednesday, May 20, 2009 4:36 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Special characters handling in Net.Data

Peter,
Does your problem arise only with an SQL statement used in a DTW_SQL
function or does it also arise when using STRSQL?

For example, if a file has a text field with the word %stuff embedded in
it, then this presents a problem when you wish to select records where
this text field contains the word %stuff, for both DTW_SQL and STRSQL.

But SQL provides the escape-expression syntax for handling this. For
example, the syntax to select any record where column name ESDESC
contains a percent sign would be:

where esdesc like '%+%%' ESCAPE '+'

Peter


-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Peter_Vidal@xxxxxxxx
Sent: Thursday, 21 May 2009 7:42 a.m.
To: web400@xxxxxxxxxxxx
Subject: [WEB400] Special characters handling in Net.Data

Hi list:

I saw somebody had this issue reported in the archives but no answers
were
replied to it. In my case, I am dealing with facility ids (6/A) with
special characters in it, like &, %, etc. and that is blowing up my
SELECT
statements.

Does anybody knows a simple workaround solution on this? We do not want

to present the alternative to change any data because we are talking
about
thousands of combinations that will be involved.

Any recommendations will be greatly appreciated.

PETER VIDAL
MAPICS IT TECHNICAL SUPPORT TEAM / SR SYSTEM ANALYST
10540 Ridge Rd., Suite 203, New Port Richey, FL 34654-5111
Tel:727-849-9999, x2414 /// Fax:727-815-3120
WWW.PALL.COM

"Hope opens doors where despair closes them."
Anonymous

------------------------------------------------------------------------
--------

Attention:

This communication may contain information that is confidential,
privileged and/or exempt from disclosure under applicable law.
If you are not the intended recipient, please notify the sender
immediately and delete the original, all attachments, and all
copies of this communication.


------------------------------------------------------------------------
--------