SQL
The following overview includes the attributes of SQL Job objects and describes their functions, allowed values and ways of modification.
Notes:
- Predefined variables may be used in scripts, and script variables may be set to attributes retrieved via predefined variables.
- :PUT_ATT may be used to set a database plus server (DATABASE_NAME, SERVER_NAME) or a Microsoft Access database. It is not possible to assign values to all three attributes because the access to the database would not be unique.
Connection: Connection Object
CONNECTION
Value: User-defined
Length: Max. 200 characters
Access through: GET_ATT, :PUT_ATT (Pre-Process, Process), Change Program, predefined variable
Connection: Server Port
SERVER_NAME
Value: User-defined
Length: Max. 100 characters
Access through: GET_ATT, :PUT_ATT (Pre-Process, Process), Change Program, predefined variable
Connection: Database
DATABASE_NAME
Value: User-defined
Length: Max. 100 characters
Access through: GET_ATT, :PUT_ATT (Pre-Process, Process), Change Program, predefined variable
DATA_SOURCE
Connection file name
Value: User-defined
Length: 255 characters
Access through: GET_ATT, :PUT_ATT (Pre-Process, Process), Change Program, predefined variable
Result Table Settings: Show Headline in Table
SQL_CAPTIONS
Value: Y / N
Access through: GET_ATT, :PUT_ATT (Pre-Process, Process)
Result Table Settings: Show NULL for Empty Strings
SQL_SHOW_NULL
Value: Y / N
Access through: GET_ATT, :PUT_ATT (Pre-Process, Process)
Result Table Settings: Remove Line Breaks
SQL_REMOVE_CRLF
Value: Y / N
Access through: GET_ATT, :PUT_ATT (Pre-Process, Process)
Result Table Settings: Column Separator
SQL_COLUMN_SEPERATOR
Value: User-defined
Length: Max. 1 character
Access through: GET_ATT, :PUT_ATT (Pre-Process, Process)
Result Table Settings: Substitute Character
SQL_SUBST_CHARACTER
Value: User-defined
Length: Max. 1 character
Access through: GET_ATT, :PUT_ATT (Pre-Process, Process)
Result Table Settings: Maximum Table Rows
SQL_MAX_ROWS
Value: User-defined
Length: A value between 1 and 9999
Access through: GET_ATT, :PUT_ATT (Pre-Process, Process)
Result Table Settings: Maximum Characters in Column
SQL_MAX_CHARACTERS
Value: User defined
Length: A value between 1 and 9999
Access through: GET_ATT, :PUT_ATT (Pre-Process, Process)
Job Report: Store to Database
JOBREPORT_DB
Value: Y / N
Access through: GET_ATT, :PUT_ATT (Pre-Process, Process)
Job Report: Store to File
JOBREPORT_FILE
Value: Y / N
Access through: GET_ATT, :PUT_ATT (Pre-Process, Process)
Job Report: Generate on error only
JOBREPORT_ERROR_ONLY
Value: Y (Job report only saved if error occurs) / N (Job report always saved)
Access through: GET_ATT, :PUT_ATT (Pre-Process, Process)
Job Report: Add Agent log
SQL_AGENTLOG
Value: Y / N
Access through: GET_ATT, :PUT_ATT (Pre-Process, Process)
See also: