The session table controls the parameters that onpload uses to invoke a load or unload job.
| Column | Type | Description | ||
|---|---|---|---|---|
| sessiontype | CHAR(1) | Describes the type of load or unload session: | ||
|
U N S |
= = = |
Job is driven by the user interface. Job expects a socket interface and is removed when the job is finished. Job is run from the command line. |
||
| automate | CHAR(1) | Flag for automatically creating maps and formats at runtime: | ||
|
Y blank |
= = |
Create automatically. Do not create. |
||
| lockflag | CHAR(1) | Flag for locking mechanism that ipload uses | ||
| sessionid | SERIAL | Session identifier (primary key) | ||
| name | CHAR(130) | Name of the load or unload job. This name appears in the command line displayed in the Load Job Select or Unload Job Select window. | ||
| status | CHAR(1) | Job status: | ||
|
R C S blank |
= = = = |
running connecting starting Job is complete. |
||
| server | CHAR(40) | Override default server to load and unload | ||
| map | CHAR(18) | Name of the map that controls the load (foreign key to the name column of the maps table; the maps table specifies the format and, for unload jobs, the query) | ||
| infile | CHAR(160) | Name of the device array (foreign key to the name column of the device table) | ||
| hostname | CHAR(40) | Name of the computer on which the onpload utility is running | ||
| dbname | CHAR(30) | Name of database to be loaded or unloaded | ||
| filter | CHAR(128) | Filter for screening import data (foreign key to the name column of the filters table) | ||
| recordfilter | CHAR(384) | File in which to store filtered records | ||
| suspensefile | CHAR(384) | File in which to store records that do not pass conversion | ||
| rejectfile | CHAR(384) | File in which to place records that the database server rejected | ||
| logfile | CHAR(384) | File in which to place session status messages | ||
| projectid | INTEGER | Project for maps and formats (foreign key to the project table) | ||
| headersize | INTEGER | Size in bytes of header information to strip from input | ||
| quiet | INTEGER | If true, suppresses status message output | ||
| tracelevel | INTEGER | Higher values result in more status messages | ||
| sourcetrace | INTEGER | If true, source and module line numbers are placed in status message outputs | ||
| multicthread | INTEGER | Sets the maximum number of conversion threads that you can invoke on a device | ||
| blocksize | INTEGER | I/O blocksize for accessing device | ||
| filetype | INTEGER | Specifies the type of file: tape, array, pipe (UNIX only) | ||
| number_records | INTEGER | Specifies the number of records to load | ||
| start_record | INTEGER | Specifies the number of the record at which to start loading | ||
| maxerrors | INTEGER | Maximum number of errors to allow before aborting the load or unload | ||
| swapbytes | INTEGER | Specifies the number of bytes to swap (If swapbytes is 4, the first 4 bytes are swapped with the next 4 bytes. If blank, bytes are not swapped.) | ||
| runmode | INTEGER |
2 7 129 130 386 2 129 130 131 132 |
= = = = = = = = = = |
Express-mode load, no conversion Deluxe-mode load, without replication Deluxe-mode load, with conversion Express-mode load, with conversion Express-mode load, with conversion and do not generate violations table Unload, no conversion Unload, with conversion, dirty read isolation level Unload, with conversion, committed read isolation level Unload, with conversion, cursor stability isolation level Unload, with conversion, repeatable read isolation level |
| loadmode | INTEGER | Type of job: | ||
| 1
2 |
=
= |
load
unload |
||
| caseconvert | INTEGER | Case conversion type. Convert to: | ||
| U or u
L or l P or p |
=
= = |
uppercase
lowercase propernames |
||
| commitinterval | INTEGER | Commit interval for committing a load transaction. (The value is specified in the Load Options window, page Figure 111. The commit interval applies only to deluxe mode.) | ||
| socketport | INTEGER | Set by onpload to specify the port number of the connection | ||
| numtapes | INTEGER | Number of tapes to load | ||