User Guide > Objects > Alphabetical Listing > SQL

SQL

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

Keep in mind that :PUT_ATT may be used to set a databaseA database is an organized collection of data including relevant data structures. 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 Tab

Field	Attribute	Value	Access Via:
Job report - Database	JOBREPORT_DB	"Y" - yes, "N" - no	GET_ATT :PUT_ATT (Pre-Process, Process)
Job report - 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 - file name	DATA_SOURCE	User-defined, maximum 255 characters	GET_ATT :PUT_ATT (Pre-Process, Process) Change Program, predefined variable
Connection - server	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
Settings - Show headlines in tables	SQL_CAPTIONS	"Y" - yes, "N" - no	GET_ATT :PUT_ATT (Pre-Process, Process)
Settings - Column separator	SQL_COLUMN_SEPERATOR	User-defined, maximum 1 character	GET_ATT :PUT_ATT (Pre-Process, Process)
Settings - Substitute character	SQL_SUBST_CHARACTER	User-defined, maximum 1 character	GET_ATT :PUT_ATT (Pre-Process, Process)
Settings - show NULL as empty string	SQL_SHOW_NULL	"Y" - yes, "N" - no	GET_ATT :PUT_ATT (Pre-Process, Process)
Settings - Maximum number of rows for tables	SQL_MAX_ROWS	User-defined, value between "1" and "9999"	GET_ATT :PUT_ATT (Pre-Process, Process)
Settings - Remove line breaks	SQL_REMOVE_CRLF	"Y" - yes, "N" - no	GET_ATT :PUT_ATT (Pre-Process, Process)
Settings - Maximum number of characters in a column	SQL_MAX_CHARACTERS	User-defined, value between "1" and "9999"	GET_ATT :PUT_ATT (Pre-Process, Process)