SQL - declare ... Cursor command in qdesign

Johnson, Harold A EDUC:EX Harold.A.Johnson at gov.bc.ca
Thu Nov 30 11:57:04 CST 2006


Hi all.  We are operating on Alpha servers with OpenVMS, v8.2, PH
v840d1, using PH Web as an interface.    We encountered an error when
attempting to use the SQL - declare cursor command:

Ie:  sql in <database> declare <name> cursor for select * from
<table>....
*E* The database 'SFAS_DATABASE' is the wrong type.

Our database type is "RDB/VMS", which is the preferred type as I
understood.  However, when I changed the type back to just plain old
"RDB", the error went away.  
Is this on purpose, or is the "RDB/VMS" type just missing from the error
check?

Cheers



More information about the powerh-l mailing list