Tag: technology

CONNECT

CONTROL

SYSMAINT

EXECUTE

Uncommitted Read

Cursor Stability

Read Stability

Repeatable Read

The cursor is moved to another row

The row the cursor is on is deleted by the application

The row the cursor is on is deleted by another application

The row the cursor is on needs to be updated by another application

It has to be in a CURSOR

cannot be used in Embedded SQL

No restrictions

None of the above

Uncommitted Read

Cursor Stability

Read Stability

Repeatable Read

Backup purposes

Storing intermediate results

Staging area for load operations

Sharing result data sets between applications

SELECT COUNT *

SELECT COUNT(*)

SELECT COUNT[*]

SELECT COUNT(ALL)

Uncommitted Read

Cursor Stability

Read Stability

Repeatable Read

Business Dynamic Content

Business Driven Catalog

Business Data Content

Business Data Catalog

-ssl

-force

-globalinstall

-delete