I would like to select a record containing a single quote via the OPNQRYF command in a CL program. How can I specify...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
in a QRYSLT parameter? You can do this either by looking for the HEX value of the quote character:
OPNQRYF FILE((TNAMES)) QRYSLT('ZZFILE *CT X"C1"') …
or by surrounding the quote character with other quotes that signal to the QRYSLT parameter that you want to look for a single quote:
OPNQRYF FILE((TNAMES)) QRYSLT('ZZtext *CT " ' ' " ')
NOTE: I have spread out the quotes with spaces to show them more clearly; don't include the spaces in your code!
MORE INFORMATION ON THIS TOPIC
The Best Web Links: tips, tutorials and more.
Ask your programming questions--or help out your peers by answering them--in our live discussion forums.
Ask the Experts yourself: Our application development gurus are waiting to answer your programming questions.
Dig Deeper on RPG iSeries programming
Related Q&A from John Blenkinsop
When an error occurs on an IBM command, the diagnostic messages are sent first, then an escape message, which you can monitor. On AS/400 you see the ...continue reading
Learn how to 'append data to the file' with the FTP DIR command, and eliminate the hassle of having to end the FTP session and restart to view ...continue reading
RPGIV will 'think of' incoming integer fields as binary, and then will redefine them in the program structures as PACKED. So, when you chain a record...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.