I have a existing connection handle created in application init

nConnHandle = sqlstringconnect( "DRIVER= .... )

I use this for SPT queries.

I want to create remote cursor initialli with no data and use requery() to get data into it.
In my knowledge, SPT cursors does not allow this.
So I need to create remote view. I want to utilize the exisitng connection handle for this remote view.

I tried the code above but got error "not a character expresion".

How to create SPT cursor which does initially not contain data and can be filled with data using requery() ?

or How to create remote view based on specific connection handle?

nConnHandle = sqlstringconnect( "DRIVER=PostgreSQL;" + ;
     "DATABASE=template1;SERVER=localhost;" + ;
     "PORT=5432;UID=postgres;PWD=masterkey;B9=0" )

CREATE DATABASE temp
CREATE SQL VIEW myview REMOTE CONNECTION (nConnHandle) AS SELECT * FROM pg_namespace