RE: A problem in embedded SQL

[DEnglander@xxxxxxxxxxxxxxx]

Marvin,

I think I have had this same issue in the past. If it is as I recall, it 
has to do with the SQL Preprocessor. The way I got around it was to make 
the statement dynamically prepared. I made a SQL statement with all of the 
selection criteria and the quotes with the LIKEs. I seem to recall that 
was the issue. I think the issue had to do with the quotes not being 
interpreted as you think they are being interpreted.

I remember removing the LIKEs in the RPG program, and data was returned. 
It was awhile ago, but I think that is how I got around this.

Hope this helps.

Douglas Englander


"CONFIDENTIALITY NOTICE:  This e-mail transmission (and/or the attachments accompanying it) contain confidential information belonging to the sender.  The information is intended only for the use of the intended recipient.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on the contents of the information is strictly prohibited.  Any unauthorized interception of this transmission is illegal under the law.  If you have received this transmission in error, please promptly notify the sender by reply e-mail, and then destroy all copies of the transmission."