Considerations for specifying parameters that contain single quotation
marks (apostrophes):
- implicit invocation - specify the exact string.
- explicit invocation - specify two apostrophes for each apostrophe
within the string. For example, to pass the string "It's" specify:
It''s
To
pass the three-parameter string
"It's 2 o'clock" specify:
It''s 2 o''clock
Considerations for specifying parameters that are quoted strings:
- implicit invocation:
- explicit invocation:
- p_value - specify two quotation marks for each enclosing
quote. For example, to pass the fully-qualified data set name 'USER33.MASTER.BACKUP' specify:
'''user33.master.backup'''
The
outermost set of quotation marks is required as part of the syntax.
- k_word('k_value') - to pass the
same fully-qualified data set name as shown in the previous example
as a k_value, specify
'dsn(''''''user33.master.backup'''''')'
The
number of enclosing quotation marks must be doubled because the entire
specification is itself a quoted string.