cancel
Showing results for 
Search instead for 
Did you mean: 

how do I escape ' in isql literal?

g_g_99
Participant
0 Kudos
2,376

I need to include ' inside a string literal in isql. for example, CREATE SERVER remote_db2 CLASS 'saodbc' USING 'DRIVER=SQL Anywhere 11;DBN=remote_db2;INT=Yes;dbfile=d:\\db2;dbkey=whateverwith ending in single quote'

I know I can use '' in other string literal but ''' in above

confuses isql in the use with dbkey.

VolkerBarth
Contributor
0 Kudos

Possibly Nick's answer may be of help:

Trouble connecting to dbisql with special characters

(FWIW, I won't comment on the secrecy of a DBKEY in a USING clause... - so you need to autostart the second database from the current one?)

g_g_99
Participant
0 Kudos

thx no I don't have to start the 2nd database but some reason(probably my mistake somewhere along) I failed to connect to started db w/o the dbkey.

Accepted Solutions (0)

Answers (1)

Answers (1)

MCMartin
Participant

Use ''
e.g. Using 'Driver...dbkey=''whatever'''