Hi Marvin
This is the reason why I suggested that you cut and paste from the STRDBG of the program
What is being used may not be what you THINK is being used
Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of DEnglander@xxxxxxxxxxxxxxx
Sent: Wednesday, December 11, 2019 10:32 AM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: [EXTERNAL] RE: A problem in embedded SQL
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."
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
