Nonstop Database, HiRDB Version 9 UAP Development Guide
![[Contents]](FIGURE/CONTENT.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
Index
[Symbols]
[A][B][C][D][E][F][G][H][I][J][K][L][M][N][O][P][Q][R][S][T][U][V][W][X]
- (Symbols)
- ? parameter, specifying value using repetition column as
- (A)
- abbreviations for products
- abstract data type, manipulating data in table with
- access path information
- access privilege
- granting
- revoking
- ADO.NET-compatible application program, HiRDB access from
- ALLOCATE CONNECTION HANDLE
- ALLOCATE CURSOR statement
- ALTER PROCEDURE
- ALTER ROUTINE
- ALTER TABLE
- ALTER TRIGGER
- AND
- AND multiple index usage [SQL optimization]
- AND multiple indexes, suppressing use of [SQL optimization option]
- AND PLURAL INDEXES SCAN [SQL optimization]
- arithmetic operations on numeric data
- array
- DELETE facility using
- facilities using
- FETCH facility using
- INSERT facility using
- UPDATE facility using
- Array class [Type2 JDBC driver]
- Array class [Type2 JDBC driver]
- ASSIGN LIST statement
- assignment statement
- audit event
- defining
- deleting
- auditor's password, changing
- automatic reconnect facility
- AVG
- (B)
- base table
- defining
- base table search process information
- batch acquisition from functions provided by plug-ins, facility for [SQL optimization option]
- batch updating
- JDBC2.0 basic facility
- JDBC2.1 Core API
- BEGIN DECLARE SECTION
- BETWEEN predicate
- data search using
- BINARY data
- addition update of
- partial extraction of
- Blob class [Type2 JDBC driver]
- BLOB data
- addition update of
- file output facility for
- partial extraction of
- Blob interface [JDBC1.2 core API]
- BLOB type, notes on using [Type2 JDBC driver]
- block mode
- block transfer facility
- Boolean predicate, searching for data using
- (C)
- C data description
- CALL statement
- CallableStatement class
- JDBC1.0 facility
- Type2 JDBC driver
- cataloged text, copying
- character code classification
- character code classification
- character code conversion facility [Type2 JDBC driver]
- character code type specification function
- character conversion facility [Type4 JDBC driver]
- character string, outputting to file
- check pending status
- check pending status
- Class file, creating
- client environment definition
- client environment definition
- supported [Type4 JDBC driver]
- client environment setup
- CLOSE statement
- COBOL data description
- coding example
- C language
- C language
- C language
- COBOL
- COBOL
- coding rule
- C++
- COBOL
- column
- name
- Column Name Descriptor Area
- contents of
- expanding
- organization of
- COMMAND EXECUTE
- command trace facility
- command trace file, backing up
- command trace information
- how to obtain
- interpreting
- commands, executing from UAP
- COMMENT
- comment, adding
- COMMIT statement
- COMMIT_BEHAVIOR, notes on
- comparison condition
- comparison predicate
- data search using
- compiling
- using multi-connection facility
- component specification
- compound statement
- CONNECT privilege
- granting
- revoking
- CONNECT statement
- Connection class
- JDBC1.0 facility
- Type2 JDBC driver
- connection handle
- allocating
- freeing
- getting
- to be used, cancelling all
- to be used, declaring
- connection information priorities [Type4 JDBC driver]
- Connection interface [JDBC1.2 core API]
- connection pooling [JDBC2.0 Optional Package]
- connection security facility
- defining
- deleting
- ConnectionPoolDataSource interface [JDBC2.0 Optional Package]
- conventions
- abbreviations for products
- diagrams
- fonts and symbols
- KB, MB, GB and TB
- version numbers
- COPY
- COUNT
- CREATE AUDIT
- CREATE CONNECTION SECURITY
- CREATE FUNCTION
- CREATE INDEX
- CREATE PROCEDURE
- CREATE SCHEMA
- CREATE TABLE
- CREATE TRIGGER
- CREATE TYPE
- CREATE VIEW
- CROSS JOIN [SQL optimization]
- cursor
- allocating
- closing
- closure of
- declaration and lock
- declaring
- declaring
- declaring
- definition of
- deletion using
- examples of using
- opening
- opening
- receiving retrieval information for
- retrieval using
- retrieval without using
- table operations using
- updating row retrieved, using
- updating using
- usage of
- use of
- using multiple cursors simultaneously
- cursor library, setting
- cursor updatability
- (D)
- data
- deletion of
- deletion of, with condition specified
- duplicated, eliminating
- extraction of
- fetching
- grouping
- inserting
- operation
- processing
- retrieval of
- satisfying multiple conditions, searching for
- sorted
- sorting
- specific data search
- that uses preprocessable cursor, updating
- updating
- updating
- updating with condition specified
- data collecting servers, separating
- SQL optimization
- SQL optimization option
- data dictionary table
- details of
- examples of SQL statement retrieving
- list of
- retrieval of
- data guarantee level
- data guarantee level
- data guarantee level 0
- data guarantee level 1
- data guarantee level 2
- data type
- defining type
- Type2 JDBC driver
- Type4 JDBC driver
- user-defined type, deleting
- data type, added
- JDBC2.0 basic facility
- JDBC2.1 Core API
- database operation
- DatabaseMetaData class
- JDBC1.0 facility
- Type2 JDBC driver
- DatabaseMetaData interface [JDBC1.2 core API]
- DataSource interface [JDBC2.0 Optional Package]
- DataSource object and JNDI, database connection using [Type4 JDBC driver]
- date data operation
- DBA privilege
- granting
- revoking
- DbType property
- deadlock
- between servers
- causes of
- corrective measures for
- countermeasures for
- countermeasures for
- example of
- in logical file used by plug-in, avoiding
- preventing
- DEALLOCATE PREPARE statement
- DECIMAL signed normalized number, function for conversion to
- DECLARE CONNECTION HANDLE SET
- DECLARE CONNECTION HANDLE UNSET
- DECLARE CURSOR
- definition information for user-defined type, receiving
- DELETE statement
- WHERE clause of
- DESCRIBE CURSOR statement
- DESCRIBE statement
- DESCRIBE TYPE statement
- diagnostic information, getting
- diagram conventions
- DISCONNECT statement
- distributed transaction [JDBC2.0 Optional Package]
- Driver class [JDBC1.0 facility]
- Driver interface [JDBC1.2 core API]
- DriverManager class, database connection using [Type4 JDBC driver]
- DROP AUDIT
- DROP CONNECTION SECURITY
- DROP DATA TYPE
- DROP FUNCTION
- DROP INDEX
- DROP LIST statement
- DROP PROCEDURE
- DROP SCHEMA
- DROP TABLE
- DROP TRIGGER
- DROP VIEW
- dynamic SELECT statement
- dynamic SELECT statement
- dynamic SQL
- execution characteristics of
- notes on executing
- (E)
- embedded exception, declaring
- embedded SQL
- declaring beginning of
- declaring end of
- embedded SQL declare section
- dispensing with
- items that can be described within
- embedded SQL UAP, overview of
- embedded variable, declaration of
- empty set
- END DECLARE SECTION
- environment definition information
- environment setting
- Type2 JDBC driver
- Type4 JDBC driver
- environment variable
- access path display utility
- access path information file for HiRDB SQL Tuning Advisor
- BES connection holding facility
- block transfer facility
- client using X/Open-compliant API in OLTP environment
- command execution from UAP
- inner replica facility
- inter-process memory communication facility
- JDBC driver
- lock control
- ODBC function
- output unit of UAP statistical information
- plug-in
- referential or check constraint
- setting
- space conversion for data
- specifying pointer as
- SQL-related
- system configuration
- system monitoring
- trouble-shooting
- updatable online reorganization
- user execution environment
- XDM/RD E2 connection facility
- environment variable group
- registering
- environment variable specification
- using UAP under OpenTP1 as client
- using UAP under TP1/EE as client
- using UAP under TP1/LiNK as client
- using UAP under TPBroker for C++ as client
- using UAP under TUXEDO as client
- using UAP under WebLogic Server as client
- error
- automatic identification of
- corrective measures for detected
- identification of
- re-reporting
- reporting
- error-handling process specification
- EX
- Exception trace log
- methods acquired in
- notes
- output example and analysis method
- output format
- required memory size and file size
- setup for acquiring
- Type4 JDBC driver
- EXECUTE IMMEDIATE statement
- EXECUTE statement
- execution user, changing
- EXISTS predicate
- extended SQL error information, facility for output of
- (F)
- FALSE
- FETCH statement
- FETCH statement
- floatable server allocation
- optimization features related to
- optimization features related to number of candidates of
- SQL optimization
- floatable server candidates, increasing number of
- SQL optimization
- SQL optimization option
- floatable server, allocating [SQL optimization]
- font conventions
- FOR READ ONLY clause
- specifying
- FOR statement
- FOR UPDATE clause
- specifying
- forced nest-loop-join [SQL optimization option]
- FREE CONNECTION HANDLE
- FREE LOCATOR statement
- function
- defining
- deleting
- returning return value of
- rules for determining called function
- (G)
- GB meaning
- GET CONNECTION HANDLE
- GET DIAGNOSTICS
- getBlockUpdate [Type2 JDBC driver]
- getBlockUpdate [Type2 JDBC driver]
- getClear_Env [Type2 JDBC driver]
- getCommit_Behavior [Type2 JDBC driver]
- getDBHostName
- Type2 JDBC driver
- Type4 JDBC driver
- getDescription
- Type2 JDBC driver
- Type4 JDBC driver
- getEncodeLang
- Type2 JDBC driver
- Type4 JDBC driver
- getEnvironmentVariables [Type4 JDBC driver]
- getHiRDBCursorMode [Type4 JDBC driver]
- getJDBC_IF_TRC [Type4 JDBC driver]
- getLONGVARBINARY_Access
- Type2 JDBC driver
- Type4 JDBC driver
- getLONGVARBINARY_AccessSize [Type4 JDBC driver]
- getLONGVARBINARY_TruncError [Type4 JDBC driver]
- getMaxBinarySize [Type4 JDBC driver]
- getNotErrorOccurred [Type4 JDBC driver]
- getPassword
- Type2 JDBC driver
- Type4 JDBC driver
- getRMID [Type2 JDBC driver]
- getSQLInNum
- Type2 JDBC driver
- Type4 JDBC driver
- getSQLOutNum
- Type2 JDBC drover
- Type4 JDBC driver
- getSQLWarningLevel
- Type2 JDBC driver
- Type4 JDBC driver
- getStatementCommitBehavior [Type4 JDBC driver]
- getTRC_NO [Type4 JDBC driver]
- getUapName [Type4 JDBC driver]
- getUser
- Type2 JDBC driver
- Type4 JDBC driver
- getXACloseString
- Type2 JDBC driver
- Type4 JDBC driver
- getXALocalCommitMode [Type4 JDBC driver]
- getXAOpenString
- Type2 JDBC driver
- Type4 JDBC driver
- getXAThreadMode [Type2 JDBC driver]
- global deadlock
- example of
- GRANT access-privilege
- GRANT AUDIT
- GRANT CONNECT
- GRANT DBA
- GRANT RDAREA
- GRANT SCHEMA
- group
- average value of
- maximum value of
- minimum value of
- rows count of
- total value of
- group processing, ORDER BY processing, and DISTINCT set function processing at local back-end server
- SQL optimization
- SQL optimization option
- grouping processing method [SQL optimization]
- grouping processing, rapid
- SQL optimization
- SQL optimization option
- (H)
- hash execution [SQL optimization]
- hash execution [SQL optimization]
- hash function for table partitioning
- hash join
- preparing for application of
- SQL optimization
- subquery hash execution [SQL extension optimizing option]
- HASH JOIN [SQL optimization]
- hash join processing method
- batch hash join
- bucket partitioning hash join
- continuous hash join
- intermittent hash join
- HASH SUBQ [SQL optimization]
- HASH SUBQ [SQL optimization]
- hash table size
- hashing mode
- tuning
- high-speed search condition
- application scope of
- deriving
- deriving [SQL optimization option]
- deriving by CNF conversion
- deriving by condition shifting
- HiRDB
- data type of
- functions provided by
- HiRDB client
- installing
- no response status
- organization of directory for
- organization of file for
- types of
- HiRDB client environment variable, tool for registering
- HiRDB OLE DB provider
- HiRDB.NET Data Provider
- data types of
- example of UAP using
- installing
- interfaces of
- list of classes provided by
- list of members provided by
- notes about
- prerequisite programs for
- type conversion by
- HiRDB_PDHOST
- HiRDB_PDHOST
- HiRDB_PDNAMEPORT
- HiRDB_PDNAMEPORT
- HiRDB_PDTMID
- HiRDB_PDTMID
- HiRDB_PDXAMODE
- HiRDB_PDXAMODE
- HiRDB/Developer's Kit
- HiRDB/Run Time
- HiRDBCommand
- list of members
- HiRDBCommandBuilder
- list of members
- HiRDBConnection
- list of members
- HiRDBDataAdapter
- list of members
- HiRDBDataReader
- list of members
- HiRDBException
- list of members
- HiRDBParameter
- list of members
- HiRDBParameterCollection
- list of members
- HiRDBProviderFactory
- HiRDBRowUpdatedEventArgs
- list of members
- HiRDBRowUpdatingEventArgs
- list of members
- HiRDBTransaction
- list of members
- HiRDBType property
- holdable cursor
- example of using
- hosts file, setting
- (I)
- I/O information, receiving
- IF statement
- IN predicate
- data search using
- index
- benefits of using
- changing during retrieval
- defining
- deleting
- drawbacks of using
- priority
- processing time
- index key value
- creating locked resources for
- non-locking of
- INDEX SCAN [SQL optimization]
- index scan [SQL optimization]
- index use, suppressing [SQL optimization option]
- index-type plug-in-dependent function
- forcing use of multiple indexes
- indicator variable, declaration of
- INSERT statement
- INSERT statement
- specifying ROW in
- INSTALL JAR
- installing
- Type2 JDBC driver
- Type4 JDBC driver
- integrity constraint
- inter-process memory communication facility
- interface
- area
- area type of
- between UAP and HiRDB
- use of
- (J)
- JAR file
- creating
- deleting
- re-registering
- registering
- JAR file access facility [JDBC2.0 Optional Package]
- JAR format, archiving in
- Java file
- compiling
- creating
- Java program, coding
- Java stored function
- Java stored procedure
- JDBC driver
- functions provided by
- JDBC interface method trace
- setup for acquiring
- Type4 JDBC driver
- JDBC1.0 facility
- JDBC1.2 core API
- JDBC2.0 basic facility
- JDBC2.0 Optional Package [Type2 JDBC driver]
- JDBC2.0 Optional Package [Type2 JDBC driver]
- JDBC2.1 Core API
- join method [SQL optimization]
- join method types [SQL optimization]
- join process information
- (K)
- KB meaning
- key conditions including scalar operation, applying [SQL optimization option]
- KEY SCAN [SQL optimization]
- key scan [SQL optimization]
- KEY SCAN MERGE JOIN [SQL optimization]
- (L)
- L-KEY R-LIST MERGE JOIN [SQL optimization]
- L-KEY R-SORT MERGE JOIN [SQL optimization]
- L-LIST R-KEY MERGE JOIN [SQL optimization]
- L-LIST R-SORT MERGE JOIN [SQL optimization]
- L-SORT R-KEY MERGE JOIN [SQL optimization]
- L-SORT R-LIST MERGE JOIN [SQL optimization]
- labeling rule
- C language
- C++
- COBOL
- OOCOBOL
- LANG, character codes that can be specified for
- LEAVE statement
- LIKE predicate
- data search using
- linking
- using multi-connection facility
- list
- creating
- deleting
- LIST SCAN [SQL optimization]
- LIST SCAN MERGE JOIN [SQL optimization]
- locator facility
- locator, invalidating
- lock
- period
- referencing during
- releasing
- starting
- lock control on tables
- lock mode
- exclusive mode
- protected retrieve mode
- protected update mode
- shared retrieve mode
- shared update mode
- simultaneous execution by two users based on
- transition rule of
- typical combination of
- typical combination of
- typical combination of
- typical combination of
- typical combination of
- typical combination of
- typical combination of
- typical combination of
- LOCK statement
- locked resource
- inclusive relationships
- setting minimum unit of
- locking
- based on deadlock priority value
- page
- page
- row
- row
- row-level
- units of
- log collection mode
- long running SQL statements, interval monitoring of
- (M)
- mapping
- during retrieval data acquisition
- SQL data type
- when ? parameter is set
- MAX
- maximum-hash-table-row-length
- maximum-number-of-hash-joins-in-SELECT-statement
- MB meaning
- merge join [SQL optimization]
- MIN
- MULTI COLUMNS INDEX SCAN [SQL optimization]
- MULTI COLUMNS KEY SCAN [SQL optimization]
- multi-connection facility
- (N)
- narrowed search
- using inner replica facility
- Native Runtime
- nest-loop-join, prioritized [SQL optimization option]
- NESTED LOOPS JOIN [SQL optimization]
- nested loops row value execution [SQL optimization]
- NESTED LOOPS ROW VALUE SUBQ [SQL optimization]
- nested loops work table execution [SQL optimization]
- NESTED LOOPS WORK TABLE SUBQ [SQL optimization]
- nested-loops-join [SQL optimization]
- no-log mode
- non-locking of index key values
- non-locking of index key values
- non-NULL data, searching for
- nonblock mode
- NOT
- NOT NULL constraint
- NULL predicate
- with NOT, data search using
- (O)
- object relational database table
- ODBC 3.5 driver
- installing
- setting environment variable
- ODBC application program, HiRDB access from
- ODBC function
- data type of
- facility available to
- provided by HiRDB
- ODBC2.0 driver, installing
- OLE DB
- OLE DB application program, HiRDB access from
- OPEN statement
- operation code
- optimizing mode 2 based on cost, application of [SQL extension optimizing option]
- OR
- OR multiple index usage [SQL optimization]
- OR multiple index use, priority of [SQL optimization option]
- OR PLURAL INDEXES SCAN [SQL optimization]
- outer joining
- overflow handling
- (P)
- p_rdb_conv_space
- p_rdb_conv_space_utf8
- p_rdb_dbhash
- p_rdb_dec_sign_norm
- p_rdb_set_lang
- parameter trace output examples
- PATH
- PATH
- PDADDITIONALOPTLVL
- PDADDITIONALOPTLVL
- PDAGGR
- PDAGGR
- PDASTHOST
- PDASTHOST
- PDASTPORT
- PDASTPORT
- PDASTUSER
- PDASTUSER
- PDAUTOCONNECT
- PDAUTOCONNECT
- PDAUTORECONNECT
- PDAUTORECONNECT
- PDBESCONHOLD
- PDBESCONHOLD
- PDBESCONHTI
- PDBESCONHTI
- PDBINARYBLKF
- PDBINARYBLKF
- PDBLKBUFFSIZE
- PDBLKBUFFSIZE
- PDBLKF
- PDBLKF
- pdcbl
- PDCLTAPNAME
- PDCLTAPNAME
- PDCLTCNVMODE
- PDCLTCNVMODE
- PDCLTGAIJIDLL
- PDCLTGAIJIDLL
- PDCLTGAIJIFUNC
- PDCLTGAIJIFUNC
- PDCLTGRP
- PDCLTGRP
- PDCLTLANG
- PDCLTLANG
- PDCLTPATH
- PDCLTPATH
- PDCLTRCVADDR
- PDCLTRCVADDR
- PDCLTRCVPORT
- PDCLTRCVPORT
- PDCLTRDNODE
- PDCLTRDNODE
- PDCMDTRACE
- PDCMDTRACE
- PDCMDWAITTIME
- PDCMDWAITTIME
- PDCMMTBFDDL
- PDCMMTBFDDL
- PDCNCTHDL-type variable, declaration of
- PDCNSTRNTNAME
- PDCNSTRNTNAME
- PDCONNECTWAITTIME
- PDCONNECTWAITTIME
- pdcpp
- PDCURSORLVL
- PDCURSORLVL
- PDCWAITTIME
- PDCWAITTIME
- PDCWAITTIMEWRNPNT
- PDCWAITTIMEWRNPNT
- PDDBACCS
- PDDBACCS
- PDDBBUFLRU
- PDDBBUFLRU
- PDDBLOG
- PDDBLOG
- PDDBORGUAP
- PDDBORGUAP
- PDDDLDEAPRP
- PDDELRSVWDFILE
- PDDELRSVWDFILE
- PDDFLNVAL
- PDDFLNVAL
- PDDLKPLIO
- PDDLKPRIO
- PDERRSKIPCODE
- PDERRSKIPCODE
- PDEXWARN
- PDEXWARN
- PDFESGRP
- PDFESGRP
- PDFESHOST
- PDFESHOST
- PDFORUPDATEEXLOCK
- PDFORUPDATEEXLOCK
- PDGDATAOPT
- PDGDATAOPT
- PDHASHTBLSIZE
- PDHASHTBLSIZE
- PDHATRNQUEUING
- PDHATRNQUEUING
- PDHJHASHINGMODE
- PDHJHASHINGMODE
- PDHOST
- PDHOST
- PDIPC
- PDIPC
- PDISLLVL
- PDISLLVL
- PDJDBFILEDIR
- PDJDBFILEDIR
- PDJDBFILEOUTNUM
- PDJDBFILEOUTNUM
- PDJDBONMEMNUM
- PDJDBONMEMNUM
- PDJDBTRACELEVEL
- PDJDBTRACELEVEL
- PDJETCOMPATIBLE
- PDJETCOMPATIBLE
- PDKALVL
- PDKALVL
- PDKATIME
- PDKATIME
- PDLANG
- PDLANG
- PDLOCKLIMIT
- PDLOCKLIMIT
- PDLOCKSKIP
- PDLOCKSKIP
- PDNAMEPORT
- PDNAMEPORT
- PDNBLOCKWAITTIME
- PDNBLOCKWAITTIME
- PDNODELAYACK
- PDNODELAYACK
- pdocb
- pdocc
- PDODBCWRNSKIP
- PDODBCWRNSKIP
- PDODBESCAPE
- PDODBESCAPE
- PDODBLOCATOR
- PDODBLOCATOR
- PDODBSPLITSIZE
- PDODBSPLITSIZE
- PDODBSTATCACHE
- PDODBSTATCACHE
- PDPLGIXMK
- PDPLGIXMK
- PDPLGPFSZ
- PDPLGPFSZ
- PDPLGPFSZEXP
- PDPLGPFSZEXP
- PDPLUGINNSUB
- PDPLUGINNSUB2
- PDPRMTRC
- PDPRMTRC
- PDPRMTRCSIZE
- PDPRMTRCSIZE
- PDPRPCRCLS
- PDPRPCRCLS
- PDRCCOUNT
- PDRCCOUNT
- PDRCINTERVAL
- PDRCINTERVAL
- PDRCTRACE
- PDRCTRACE
- PDRDCLTCODE
- PDRDCLTCODE
- PDRECVMEMSIZE
- PDRECVMEMSIZE
- PDREPPATH
- PDREPPATH
- PDSENDMEMSIZE
- PDSENDMEMSIZE
- PDSERVICEGRP
- PDSERVICEGRP
- PDSERVICEPORT
- PDSERVICEPORT
- PDSPACELVL
- PDSPACELVL
- PDSQLEXECTIME
- PDSQLEXECTIME
- PDSQLOPTLVL
- PDSQLOPTLVL
- PDSQLTEXTSIZE
- PDSQLTEXTSIZE
- PDSQLTRACE
- PDSQLTRACE
- PDSQLTRCOPENMODE
- PDSQLTRCOPENMODE
- PDSRVTYPE
- PDSRVTYPE
- PDSTJTRNOUT
- PDSTJTRNOUT
- PDSUBSTRLEN
- PDSUBSTRLEN
- PDSWAITTIME
- PDSWAITTIME
- PDSWATCHTIME
- PDSWATCHTIME
- PDSYSTEMID
- PDSYSTEMID
- PDTAAPINFMODE
- PDTAAPINFMODE
- PDTAAPINFPATH
- PDTAAPINFPATH
- PDTAAPINFSIZE
- PDTAAPINFSIZE
- PDTCPCONOPT
- PDTCPCONOPT
- PDTIMEDOUTRETRY
- PDTIMEDOUTRETRY
- PDTMID
- PDTMID
- PDTP1SERVICE
- PDTP1SERVICE
- pdtrcmgr
- PDTRCMODE
- PDTRCMODE
- PDTRCPATH
- PDTRCPATH
- PDTXACANUM
- PDTXACANUM
- PDUAPENVFILE
- PDUAPENVFILE
- PDUAPERLOG
- PDUAPERLOG
- PDUAPEXERLOGPRMSZ
- PDUAPEXERLOGPRMSZ
- PDUAPEXERLOGUSE
- PDUAPEXERLOGUSE
- PDUAPREPLVL
- PDUAPREPLVL
- PDUSER
- PDUSER
- PDVWOPTMODE
- PDVWOPTMODE
- PDWRTLNCOMSZ
- PDWRTLNCOMSZ
- PDWRTLNFILSZ
- PDWRTLNFILSZ
- PDWRTLNPATH
- PDWRTLNPATH
- PDXAMODE
- PDXAMODE
- PDXARCVWTIME
- PDXARCVWTIME
- PDXATRCFILEMODE
- PDXATRCFILEMODE
- plug-in distribution function
- PLUGIN INDEX SCAN [SQL optimization]
- PLUGIN KEY SCAN [SQL optimization]
- pointer, specifying as environment variable
- PooledConnection interface [JDBC2.0 Optional Package]
- PR
- preparable dynamic DELETE statement: locating
- preparable dynamic UPDATE statement: locating
- PREPARE statement
- PreparedStatement class
- JDBC1.0 facility
- Type2 JDBC driver
- PreparedStatement interface [JDBC1.2 core API]
- preprocessing
- for C programs in UNIX environment
- for C programs in Windows environment
- for COBOL programs in UNIX environment
- for COBOL programs in Windows environment
- overview of
- preprocessor declaration statement, validating
- priority [SQL optimization]
- procedure
- calling
- defining
- deleting
- process, avoiding survival of
- process, avoiding survival of
- program example
- C language
- COBOL
- PU
- PURGE TABLE statement
- PURGE TABLE statement
- (Q)
- quantified predicate
- query process information
- query processing method in HiRDB [SQL optimization]
- (R)
- R-LIST NESTED LOOPS JOIN [SQL optimization]
- rapid grouping facility
- RDAREA usage privilege
- granting
- revoking
- reconnect trace facility
- relational database table
- REMOVE JAR
- REPLACE JAR
- RESIGNAL statement
- result set enhancement [JDBC2.0 basic facility]
- result set expansion [JDBC2.1 Core API]
- results-set return facility
- Java stored procedures only
- limited to SQL stored procedures
- ResultSet class
- JDBC1.0 facility
- Type2 JDBC driver
- ResultSet interface [JDBC1.2 core API]
- ResultSetMetaData class
- JDBC1.0 facility
- Type2 JDBC driver
- ResultSetMetaData interface [JDBC1.2 core API]
- retrieval information, receiving
- retrieve first n records facility
- return code, referencing
- RETURN statement
- REVOKE access-privilege
- REVOKE CONNECT
- REVOKE DBA
- REVOKE RDAREA
- REVOKE SCHEMA
- rollback
- setting
- ROLLBACK statement
- rollback, setting
- rollback, setting
- row
- deleting
- deleting all
- in table, deleting all
- inserting
- into table with repetition column, inserting
- on column basis, inserting
- on row basis, inserting
- on row basis, inserting (to table with FIX attribute)
- repeating execution of each
- retrieval on basis of
- retrieving one
- that uses preprocessable cursor, deleting
- updating on basis of
- row identifier, searching using [SQL optimization]
- row value execution [SQL optimization]
- ROW VALUE SUBQ [SQL optimization]
- ROWID FETCH [SQL optimization]
- (S)
- scalar function
- schema
- defining
- deleting
- schema definition privilege
- granting
- revoking
- search method [SQL optimization]
- SELECT statement
- FROM clause of
- selection clause of
- SELECT-APSL [SQL optimization]
- SELECT-APSL [SQL optimization]
- SELECT-APSL [SQL optimization]
- SELECT-APSL [SQL optimization]
- set operation process information
- SET SESSION AUTHORIZATION statement
- setBlockUpdate [Type2 JDBC driver]
- setBlockUpdate [Type2 JDBC driver]
- setClear_Env [Type2 JDBC driver]
- setCommit_Behavior [Type2 JDBC driver]
- setDBHostName
- Type2 JDBC driver
- Type4 JDBC driver
- setDescription
- Type2 JDBC driver
- Type4 JDBC driver
- setEncodeLang
- Type2 JDBC driver
- Type4 JDBC driver
- setEnvironmentVariables [Type4 JDBC driver]
- setHiRDBCursorMode [Type4 JDBC driver]
- setJDBC_IF_TRC [Type4 JDBC driver]
- setLONGVARBINARY_Access
- Type2 JDBC driver
- Type4 JDBC driver
- setLONGVARBINARY_AccessSize [Type4 JDBC driver]
- setLONGVARBINARY_TruncError [Type4 JDBC driver]
- setMaxBinarySize [Type4 JDBC driver]
- setNotErrorOccurred [Type4 JDBC driver]
- setPassword
- Type2 JDBC driver
- Type4 JDBC driver
- setRMID [Type2 JDBC driver]
- setSQLInNum
- Type2 JDBC driver
- Type4 JDBC driver
- setSQLOutNum
- Type2 JDBC driver
- Type4 JDBC driver
- setSQLWarningLevel
- Type2 JDBC driver
- Type4 JDBC driver
- setStatementCommitBehavior [Type4 JDBC driver]
- setTRC_NO [Type4 JDBC driver]
- setUapName [Type4 JDBC driver]
- setUser
- Type2 JDBC driver
- Type4 JDBC driver
- setXACloseString
- Type2 JDBC driver
- Type4 JDBC driver
- setXALocalCommitMode [Type4 JDBC driver]
- setXAOpenString
- Type2 JDBC driver
- Type4 JDBC driver
- setXAThreadMode [Type2 JDBC driver]
- SIGNAL statement
- single row retrieval
- single-row SELECT statement
- single-row SELECT statement
- SORT MERGE JOIN [SQL optimization]
- source program
- space conversion function
- specific character pattern, searching for
- SQL
- corrective measures for error of
- error identification of
- error identification of
- executing
- executing
- for retrieving data (execution statement)
- for updating data (execution statement)
- functional organization of
- information by
- preprocessing
- value provided at time of execution
- SQL coding rule
- C language
- C++
- COBOL
- OOCOBOL
- SQL Communications Area
- SQL Communications Area
- contents of
- expanding
- organization of
- SQL data type
- SQL data type
- SQL Descriptor Area
- contents of
- data code set in
- data length set in
- example of
- expanding
- operation macro for
- organization of
- procedure for expanding
- SQL extension optimizing option
- SQL extension optimizing option
- SQL object
- re-creating for function
- re-creating for procedure
- re-creating for procedure
- re-creating for trigger
- re-creating for trigger
- SQL objects, making multiple [SQL optimization option]
- SQL optimization
- method types of
- option
- specification
- specifying
- SQL optimizing mode
- optimizing mode 1 based on cost
- optimizing mode 2 based on cost
- SQL prefix
- SQL preprocessor
- activating
- activating
- activating
- activating
- return code of (for C programs in UNIX environment)
- return code of (for C programs in Windows environment)
- return code of (for COBOL programs in UNIX environment)
- return code of (for COBOL programs in Windows environment)
- standard input and output of (for C programs in UNIX environment)
- standard input and output of (for C programs in Windows environment)
- standard input and output of (for COBOL programs in UNIX environment)
- standard input and output of (for COBOL programs in Windows environment)
- SQL runtime interim results
- SQL statement
- description locations of
- divisions in COBOL for describing
- executing by conditional branching
- executing multiple
- for retrieval, examples of
- list of (control SQL)
- list of (data manipulation SQL)
- list of (definition SQL)
- list of (embedded language)
- list of (routine control SQL)
- list of (usable in HiRDB)
- preprocessed and executed by EXECUTE IMMEDIATE statement
- preprocessed by PREPARE statement
- preprocessed, releasing
- preprocessing
- repeating
- SQL stored function
- defining
- executing
- SQL stored procedure
- debugging
- defining
- executing
- SQL terminator
- SQL trace dynamic acquisition facility
- SQL trace file
- making backup of
- SQL trace information
- collecting
- examining
- SQL tracing
- SQL_AUDITS table
- SQL_CHECK_COLUMNS table
- SQL_CHECKS table
- SQL_COLUMN_STATISTICS table
- SQL_COLUMNS table
- SQL_DATATYPE_DESCRIPTORS table
- SQL_DATATYPES table
- SQL_DIV_COLUMN table
- SQL_DIV_INDEX table
- SQL_DIV_TABLE table
- SQL_DIV_TYPE table
- SQL_EXCEPT table
- SQL_INDEX_COLINF table
- SQL_INDEX_DATATYPE table
- SQL_INDEX_FUNCTION table
- SQL_INDEX_RESOURCES table
- SQL_INDEX_STATISTICS table
- SQL_INDEX_TYPE_FUNCTION table
- SQL_INDEX_TYPES table
- SQL_INDEXES table
- SQL_IOS_GENERATIONS table
- SQL_KEYCOLUMN_USAGE table
- SQL_PARTKEY table
- SQL_PARTKEY_DIVISION table
- SQL_PHYSICAL_FILES table
- SQL_PLUGIN_ROUTINE_PARAMS table
- SQL_PLUGIN_ROUTINES table
- SQL_PLUGINS table
- SQL_RDAREA_PRIVILEGES table
- SQL_RDAREAS table
- SQL_REFERENTIAL_CONSTRAINTS table
- SQL_ROUTINE_PARAMS table
- SQL_ROUTINE_RESOURCES table
- SQL_ROUTINES table
- SQL_SYSPARAMS table
- SQL_TABLE_CONSTRAINTS table
- SQL_TABLE_PRIVILEGES table
- SQL_TABLE_RESOURCES table
- SQL_TABLE_STATISTICS table
- SQL_TABLES table
- SQL_TRIGGER_COLUMNS table
- SQL_TRIGGER_DEF_SOURCE table
- SQL_TRIGGER_USAGE table
- SQL_TRIGGERS table
- SQL_TYPE_RESOURCES table
- SQL_USERS table
- SQL_VIEW_TABLE_USAGE table
- SQL_VIEWS table
- SQL-optimization-option
- SQLCODE variable
- SQLException interface [JDBC1.2 core API]
- SQLJ
- SQLJ Runtime Library
- SQLJ Translator
- SQLJ Translator
- SQLSTATE variable
- SQLWarning class [JDBC1.0 facility]
- SQLWarning interface [JDBC2.1 core API]
- SR
- Statement class
- JDBC1.0 facility
- Type2 JDBC driver
- Statement interface [JDBC1.2 core API]
- statement, leaving
- static SQL
- execution characteristics of
- stored function
- defining
- stored procedure
- stored procedure
- structure, referencing
- structured repetition predicate, searching for data using
- SU
- subqueries with external references, execution of [SQL optimization]
- subqueries with no external references, execution of [SQL optimization]
- subquery
- searching for data using
- using EXISTS predicate
- using quantified predicate
- subquery hash execution, preparing for application of
- SUM
- symbol conventions
- synchronization point, setting
- synchronization point, setting
- synchronization point, setting
- system property, setting [Type2 JDBC driver]
- (T)
- table
- basic configuration of
- deleting
- outer joining of
- procedure for deleting
- procedure for updating
- retrieval from multiple tables
- retrieval from single table
- retrieval from two tables
- using repetition columns
- with FIX attribute, retrieval of
- with FIX attribute, updating
- with repetition columns, updating
- table data, retrieving dynamically
- table definition, altering
- TABLE SCAN [SQL optimization]
- table scan [SQL optimization]
- table with abstract data type
- deleting rows from
- inserting row into
- retrieving data from
- updating
- target floatable server
- increasing (back-end servers for fetching data) [SQL optimization option]
- increasing (back-end servers for fetching data) [SQL optimization]
- limiting (back-end servers for fetching data) [SQL optimization option]
- limiting (back-end servers for fetching data) [SQL optimization]
- TB meaning
- time data operation
- time data operation
- TIME, DATE, and TIMESTAMP columns, data conversion of
- total number of hits, facility for returning
- trace acquisition command
- transaction
- cancelling
- control
- invalidation of
- moving
- startup of
- startup of
- startup of
- terminating normally
- termination of
- validation of
- trigger
- defining
- deleting
- trigger operation search conditions
- trigger SQL statement
- trigger-activating SQL statement
- TRUE
- Type Name Descriptor Area
- contents of
- expanding
- organization of
- Type2 JDBC driver
- Array class
- Type4 JDBC driver
- (U)
- UAP
- basic configuration of
- basic SQL configuration in
- characteristics of
- command execution from
- configuration element of
- connecting to HiRDB
- connection to HiRDB system
- connection with HiRDB
- created with XDM/RD or UNIFY2000, converting
- creating
- data type and accessory used by
- descriptive language of
- design for improving handling
- design for improving performance
- designing
- disconnecting from HiRDB
- disconnection from HiRDB
- disconnection from HiRDB system
- embedded format of
- embedded format of
- error recovery
- execution procedure for
- extracting retrieved contents and storing them in
- format of
- in C, writing
- in C++, writing
- in OOCOBOL, writing
- notes on execution of
- operation environment of
- overview of
- preparation for execution of
- troubleshooting of
- using X/Open-based API (TX_function), executing
- written in C, executing
- written in COBOL, executing
- UAP statistical report
- how to obtain
- interpreting
- UAP statistical report facility
- uniqueness constraint
- UNKNOWN
- unlocked conditional search
- unsupported interfaces
- JDBC1.2 core API
- JDBC2.0 Optional Package
- JDBC2.1 Core API
- UPDATE statement
- SET clause of
- WHERE clause
- update-SQL work table, suppressing creation of [SQL optimization option]
- (V)
- value
- assigning
- set in variables and SQL statement execution status
- version number conventions
- view table
- defining
- defining
- defining
- deleting
- manipulating
- manipulating
- (W)
- WHENEVER
- WHILE statement
- window function
- work table ATS execution [SQL optimization]
- WORK TABLE ATS SUBQ [SQL optimization]
- work table buffer size
- work table execution [SQL optimization]
- WORK TABLE SUBQ [SQL optimization]
- work table, searching internally created [SQL optimization]
- WRITE LINE statement
- (X)
- XAConnection interface [JDBC2.0 Optional Package]
- XADataSource interface [JDBC2.0 Optional Package]
- XAException interface [JDBC2.0 Optional Package]
- XAResource interface [JDBC2.0 Optional Package]
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.