Using Dynamic ESQL

If you are using dynamic ESQL, add the SQL keyword to the DESCRIBE statement. Thus, this Version 6 statement:

EXEC SQL DESCRIBE DEMOSTMT USING DESCRIPTOR psqlda; 

becomes this Version 9 statement:

EXEC SQL DESCRIBE DEMOSTMT USING SQL DESCRIPTOR psqlda; 

Change the USING clause in the FETCH statement to INTO SQL. Thus, this Version 6 statement:

EXEC SQL FETCH C1 USING DESCRIPTOR psqlda; 

becomes this Version 9 statement:

EXEC SQL FETCH C1 INTO SQL DESCRIPTOR psqlda; 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095