how do I escape ' in isql literal?

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.

isql syntax

asked 23 Apr '15, 11:52

gg99
227●29●30●38
accept rate: 10%

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?)

(23 Apr '15, 12:05) Volker Barth

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.

(26 Apr '15, 01:57) gg99

flat view

One Answer:

active answers oldest answers newest answers popular answers

2	Use '' e.g. Using 'Driver...dbkey=''whatever''' permanent link answered 24 Apr '15, 10:32 Martin 9.0k●130●169●257 accept rate: 14% edited 24 Apr '15, 10:34 flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

isql ×46
syntax ×36

question asked: 23 Apr '15, 11:52

question was seen: 2,145 times

last updated: 26 Apr '15, 01:57

SAP SQL Anywhere

how do I escape ' in isql literal?

Follow this question

Related questions