Explain The Different Types Of Embedded Sql That Can Be Used In Pb Sc

1.	Explain The Different Types Of Embedded Sql That Can Be Used In Pb Scripting?
Answer» Given below are the SQL statements in scripts that are possible with Sybase ASE: Transaction Management statements – CONNECT, COMMIT, ROLLBACK and DISCONNECT are used to manage transactions in ASE. If a trigger fails, then a RAISEERROR should be issued in the trigger and not ROLLBACK. PB has got a DBMS SPECIFIC return code (SQLDBCode = -1) WITHIN the transaction object which can be used to throw messages to the user. Non-cursor statements – INSERT/UPDATE/DELETE/SELECT. Cursor statements – the user can retrieve ( declare, open, fetch & close cursors) and issue update( update & delete cursors). DB Stored Procedures – they can be used for retrieve, update or both. To execute DDL statements the AutoCommit must be SET to TRUE (1), but if it is TRUE, ROLLBACK cannot be issued, hence after completion of the DDL operation it must be set back to FALSE. Given below are the SQL statements in scripts that are possible with Sybase ASE:

Explain The Different Types Of Embedded Sql That Can Be Used In Pb Scripting?

Answer»

Given below are the SQL statements in scripts that are possible with Sybase ASE:

Transaction Management statements – CONNECT, COMMIT, ROLLBACK and DISCONNECT are used to manage transactions in ASE. If a trigger fails, then a RAISEERROR should be issued in the trigger and not ROLLBACK. PB has got a DBMS SPECIFIC return code (SQLDBCode = -1) WITHIN the transaction object which can be used to throw messages to the user.
Non-cursor statements – INSERT/UPDATE/DELETE/SELECT.
Cursor statements – the user can retrieve ( declare, open, fetch & close cursors) and issue update( update & delete cursors).
DB Stored Procedures – they can be used for retrieve, update or both. To execute DDL statements the AutoCommit must be SET to TRUE (1), but if it is TRUE, ROLLBACK cannot be issued, hence after completion of the DDL operation it must be set back to FALSE.

Given below are the SQL statements in scripts that are possible with Sybase ASE: