Statements that do not require a package

 

In some cases, you might try to create an SQL package, but the SQL package is not created and the program still runs. This situation occurs when the program contains only SQL statements that do not require an SQL package to run.

For example, a program that contains only the SQL statement DESCRIBE TABLE will generate message SQL5041 during SQL package creation. The SQL statements that do not require an SQL package are:

• COMMIT

• CONNECT

• DESCRIBE TABLE

• DISCONNECT

• RELEASE

• RELEASE SAVEPOINT

• ROLLBACK

• SAVEPOINT

• SET CONNECTION

 

Parent topic:

Considerations for creating an SQL package