Hi Hagen,
the SQL syntax "SELECT FIRST ..." is no longer supported by the database
kernel since kernel version 7.4.3. So I would like to recommend to use a
cursor:
Short version with an implicit empty cursor name:
EXEC SQL SELECT 'ONE' FROM DUAL;
EXEC SQL FETCH INTO :col1;
Long version with an explicit cursor name:
EXEC SQL PREPARE STMT_1 FROM SELECT 'ONE' FROM DUAL;
EXEC SQL DECLARE CUR_1 CURSOR FOR STMT_1;
EXEC SQL OPEN CUR_1;
EXEC SQL FETCH CUR_1 INTO :col1;
Regards,
Marco
> -----Original Message-----
> From: Guhr, Hagen [mailto:[EMAIL PROTECTED]
> Sent: Dienstag, 10. Mai 2005 16:37
> To: [email protected]
> Subject: EXEC SQL SELECT FIRST (C++)
>
> Hello
>
> I'm using currently MaxDB 7.5.0 and I want to use old ADBAS D
> Precompiler
> syntax in C/C++.
> The ADABAS D SQL statement is "EXEC SQL SELECT FIRST ...",
> but SELECT FIRST
> doesn't exists anymore. So I tried "EXEC SQL SELECT ... ORDER BY ...",
> without any results. It seems that the MaxDB Precompiler
> dosn't know the
> order clause.
>
> How can I use the old Precompiler syntax or create an equivalent SQL
> statement?
>
> Thanks, Hagen
>
>
>
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
