sunil@beach.cis.ufl.edu (Sunil Murthy) (10/09/90)
Could someone give me the syntax for the dynamic SQL statements PREPARE, EXECUTE, and DESCRIBE in Ingres Version 6.0. We have a 5.0 Version running and it does not support dynamic SQL. I need this information for a reference and Ingres tech. support need a contact i.d before they talk to you... Thanks --Sunil -- | ______ | (__ _ . | | 273-11 Schucht Village Gainesville FL 32603 (h) | ____)|_|| || |_ | Ph: (904) 334 5629 (h) (904) 392 2694 || 2583 (o) | m u r t h y | E-470 CSE, U. of Florida Gainesville FL 32611 (o)
bg0l+@andrew.cmu.edu (Bruce E. Golightly) (10/09/90)
The general syntax is really pretty simple - EXEC SQL PREPARE statement_name FROM string_variable | string_literal; EXEC SQL EXECUTE statement_name [USING variable [,variable...]]; EXEC SQL DESCRIBE statement_name INTO descriptor_name; A useful variation is: EXEC SQL IMMEDIATE string_variable | string_literal; Please bear in mind that dynamic SQL becomes available in 6.x. Version 5 releases do not support dynamic SQL.