1. Implementing Siebel Business Applications on DB2 for z/OS
  2. Siebel Scripting Considerations

Siebel Scripting Considerations

This section outlines best practices for managing cursor modes in Siebel scripts when querying DB2 on z/OS and OS/390.

Follow these best practices for scripted queries when the underlying database is DB2 on z/OS and OS/390:

  • Use the ForwardBackward Cursor Mode when your business component query is expected to return only a single record for example, when querying pick lists or searching a business component by its Id field set the cursor mode to ForwardBackward.

  • Use the ForwardOnly Cursor Mode when the query result set is expected to return multiple records, use ForwardOnly cursor mode. In these cases, always traverse to the end of the result set using the NextRecord method to ensure the cursor is properly closed.