Q

Selecting a record containing a single quote

I would like to select a record containing a single quote via the OPNQRYF command in a CL program. How can I specify 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.


This was first published in October 2004

Dig deeper on RPG iSeries programming

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close