User`s guide

v
5.2.2.2 User-Specific Configuration Files............................................................................... 5-4
5.2.2.3 Input, Output, and List-files ....................................................................................... 5-4
5.2.3 Additional Remarks ............................................................................................................ 5-5
5.3 Pro*C/C++................................................................................................................................... 5-5
5.3.1 Starting Pro*C....................................................................................................................... 5-5
5.3.2 Pro*C Include, System Configuration and Demo Files.................................................. 5-5
5.3.3 SQLLIB Calls ........................................................................................................................ 5-6
5.3.4 Linking Pro*C....................................................................................................................... 5-6
5.3.5 The Pro*C SQLCPR.H Header File ................................................................................... 5-6
5.3.6 UTM Applications ............................................................................................................... 5-6
5.4 Pro*COBOL.................................................................................................................................. 5-6
5.4.1 Starting Pro*COBOL............................................................................................................ 5-7
5.4.2 Pro*COBOL Include, System Configuration, and Demo Files...................................... 5-8
5.4.3 SQLLIB Calls ........................................................................................................................ 5-8
5.4.4 Linking Pro*COBOL............................................................................................................ 5-8
5.4.5 openUTM Applications ...................................................................................................... 5-8
5.5 The Oracle Call Interface............................................................................................................ 5-8
5.5.1 Linking OCI.......................................................................................................................... 5-9
5.5.2 Optional Parameters............................................................................................................ 5-9
5.6 The Object Type Translator .................................................................................................... 5-10
5.6.1 Starting Ott......................................................................................................................... 5-10
5.6.2 Ott System Configuration File ........................................................................................ 5-10
6 Using the Oracle Database Under openUTM
6.1 SQL Operations........................................................................................................................... 6-1
6.1.1 CONNECT............................................................................................................................ 6-1
6.1.2 COMMIT............................................................................................................................... 6-1
6.1.3 ROLLBACK .......................................................................................................................... 6-1
6.1.4 SAVEPOINT......................................................................................................................... 6-1
6.1.5 Cursor Operations ............................................................................................................... 6-1
6.1.6 Dynamic SQL ....................................................................................................................... 6-2
6.1.7 PL/SQL ................................................................................................................................. 6-2
6.1.8 Autocommit.......................................................................................................................... 6-2
6.2 UTM Operations ......................................................................................................................... 6-2
6.2.1 RSET and PEND RS............................................................................................................. 6-2
6.2.2 PEND ER and PEND FR..................................................................................................... 6-2
6.2.3 PEND KP, PEND PR, and PEND PA................................................................................ 6-2
6.2.4 PEND RE, PEND FI, PEND SP, and PEND FC............................................................... 6-2
7 Globalization Support
7.1 Specifying a Language, Territory, and Character Set............................................................ 7-1
7.1.1 Oracle Database ................................................................................................................... 7-1
7.1.2 Other Oracle Database Products ....................................................................................... 7-2
7.2 Supported Language Conventions........................................................................................... 7-2
7.3 Supported Territories ................................................................................................................. 7-2
7.4 Supported Character Sets .......................................................................................................... 7-3