SQL

The following overview includes the attributes of a SQL Job object and describes their functions, allowed values and ways of modification.

Warning! Keep in mind that :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.

Predefined variables may be used in scripts, and script variables may be set to attributes retrieved via predefined variables.

SQL Page

Field	Attribute	Value	Access Via:
Job Report - Store to - Database	JOBREPORT_DB	"Y" - yes, "N" - no	GET_ATT :PUT_ATT (Pre-Process, Process)
Job Report - Store to - File	JOBREPORT_FILE	"Y" - yes, "N" - no	GET_ATT :PUT_ATT (Pre-Process, Process)
Job Report - Generate - On error only	JOBREPORT_ERROR_ONLY	"Y" - Job report only saved if error occurs "N" - Job report always saved	GET_ATT :PUT_ATT (Pre-Process, Process)
Optional reports - Agent log	SQL_AGENTLOG	"Y" - yes, "N" - no	GET_ATT :PUT_ATT (Pre-Process, Process)
Connection - Connection Object	CONNECTION	User-defined, maximum 200 characters	GET_ATT :PUT_ATT (Pre-Process, Process) Change Program, predefined variable
Connection - Server Port	SERVER_NAME	User-defined, maximum 100 characters	GET_ATT :PUT_ATT (Pre-Process, Process) Change Program, predefined variable
Connection - Database	DATABASE_NAME	User-defined, maximum 100 characters	GET_ATT :PUT_ATT (Pre-Process, Process) Change Program, predefined variable
Result Table Settings - Show - Headline in table	SQL_CAPTIONS	"Y" - yes, "N" - no	GET_ATT :PUT_ATT (Pre-Process, Process)
Result Table Settings - Show - NULL for empty strings	SQL_SHOW_NULL	"Y" - yes, "N" - no	GET_ATT :PUT_ATT (Pre-Process, Process)
Result Table Settings - Remove - Line breaks	SQL_REMOVE_CRLF	"Y" - yes, "N" - no	GET_ATT :PUT_ATT (Pre-Process, Process)
Result Table Settings - Column Separator	SQL_COLUMN_SEPERATOR	User-defined, maximum 1 character	GET_ATT :PUT_ATT (Pre-Process, Process)
Result Table Settings - Substitute Character	SQL_SUBST_CHARACTER	User-defined, maximum 1 character	GET_ATT :PUT_ATT (Pre-Process, Process)
Result Table Settings - Maximum table rows	SQL_MAX_ROWS	User-defined, value between "1" and "9999"	GET_ATT :PUT_ATT (Pre-Process, Process)
Result Table Settings - Maximum characters in column	SQL_MAX_CHARACTERS	User-defined, value between "1" and "9999"	GET_ATT :PUT_ATT (Pre-Process, Process)