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. |
Use '' |
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?)
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.