SQL - declare ... Cursor command in qdesign

[Joe Boyle]

I have the note below but can't recall where it came from originally,


By specifying RDB/VMS versus RDB as the relational type, you specify how the
database is accessed and what PowerHouse capabilities are available. Using
RDB/VMS, the database is accessed via the native API, while RDB specifies an
SQL interface using the PowerHouse data access layer. RDB/VMS is essentially
the same interface and feature set as in PowerHouse 7.10. Using RDB allows
you to use SQL statements and SQL-related syntax such as the DECLARE CURSOR
and CURSOR statements and the SQL-related verbs. Since the two interfaces
are quite different, there will likely be performance differences, however
which will be faster is situation dependant.



-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Johnson, Harold A EDUC:EX
Sent: 30 November 2006 17:57
To: powerh-l at lists.sowder.com
Subject: SQL - declare ... Cursor command in qdesign

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

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: &quot;subscribe&quot; in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the list
archive at Google.