6.9.1.4.9.1 Additional Options for PGQL Statement Execution

Several options are available to influence PGQL statement execution. The following are the main ways to set query options:

• Through flags in the modify options string argument of execute
• Through Java JVM arguments.

The following table summarizes the main options for modifying PGQL statement execution.

Table 6-7 PGQL Statement Modification Options

Option	Default	Options Flag	JVM Argument
Auto commit	true if JDBC auto commit is off, false if JDBC auto commit is on	AUTO_COMMIT=F	-Doracle.pg.rdbms.pgql.autoCommit=false
Delete cascade	true	DELETE_CASCADE=F	-Doracle.pg.rdbms.pgql.deleteCascade=false

• Turning Off PGQL Auto Commit
  
• Turning Off Cascading Deletion