EasyManuals Logo

IBM DB2 User Manual

IBM DB2
585 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #371 background imageLoading...
Page #371 background image
setDB2ClientProgramId
Format:
public abstract void setDB2ClientProgramId(String program-ID)
throws java.sql.SQLException
Sets a user-defined program identifier for the connection, on DB2 for z/OS
servers. That program identifier is an 80-byte string that is used to identify the
caller. The DB2 for z/OS server places the string in IFCID 316 trace records
along with other statistics, so that you can identify which program is
associated with a particular SQL statement.
getIDSBigSerial
Format:
public int getIDSBigSerial()
throws java.sql.SQLException
Retrieves an automatically generated key from a BIGSERIAL column after the
automatically generated key was inserted by a previously executed INSERT
statement.
The following conditions must be true for getIDSBigSerial to execute
successfully:
v The INSERT statement is the last SQL statement that is executed before this
method is called.
v The table into which the row is inserted contains a BIGSERIAL column.
v The form of the JDBC Connection.prepareStatement method or
Statement.executeUpdate method that prepares or executes the INSERT
statement does not have parameters that request automatically generated
keys.
This method applies only to connections to IBM Informix Dynamic Server
(IDS) databases.
getIDSSerial
Format:
public int getIDSSerial()
throws java.sql.SQLException
Retrieves an automatically generated key from a SERIAL column after the
automatically generated key was inserted by a previously executed INSERT
statement.
The following conditions must be true for getIDSSerial to execute
successfully:
v The INSERT statement is the last SQL statement that is executed before this
method is called.
v The table into which the row is inserted contains a SERIAL column.
v The form of the JDBC Connection.prepareStatement method or
Statement.executeUpdate method that prepares or executes the INSERT
statement does not have parameters that request automatically generated
keys.
This method applies only to connections to IBM Informix Dynamic Server
(IDS) databases.
getIDSSerial8
Format:
Chapter 7. JDBC and SQLJ reference information 355
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the IBM DB2 and is the answer not in the manual?

IBM DB2 Specifications

General IconGeneral
DeveloperIBM
Initial Release1983
LicenseProprietary
Written inC, C++
CategoryDatabase Management System (RDBMS)
Operating SystemLinux, Windows
Programming LanguagesC, C++
Data ModelsRelational
EditionsCommunity, Standard, Advanced
Key Featureshigh availability, scalability