User Guide > Objects > Alphabetical Listing > Database

Database

The following tables list the attributes that apply to Database event objects and describes their functions, allowed values and ways of modification. Fields in tables are ordered as they are displayed in the UserInterface.

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

Database Tab

Field	Attribute	Value	Access Via:
Value 1 - Source	OPERAND1_SOURCE	"SQL" - SQL query "STATIC" - Statistical value "VARA" - Variable object	GET_ATT, :PUT_ATT
Value 1 - SQL	OPERAND1_SQL_QUERY	SQL statement, limited to 255 characters.	GET_ATT, :PUT_ATT
Value 1 - Server	OPERAND1_SQL_SERVER_NAME	The name of the databaseA database is an organized collection of data including relevant data structures. computer, limited to 30 characters.	GET_ATT, :PUT_ATT
Value 1 - Host	OPERAND1_SQL_AGENT	The name of a database agent, limited to 32 characters.	GET_ATT, :PUT_ATT
Value 1 - Database	OPERAND1_SQL_DATABASE_NAME	The database name, limited to 30 characters.	GET_ATT, :PUT_ATT
Value 1 - Login	OPERAND1_SQL_LOGIN	The name of a Login object, limited to 200 characters.	GET_ATT, :PUT_ATT
Value 1 - MS Access only: File name	OPERAND1_MSACCESS_FILE	The path and file name of the MS Access database, limited to 255 characters.	GET_ATT, :PUT_ATT
Value 1 - Static value	OPERAND1_STATIC_VALUE	Static value, limited to 40 characters.	GET_ATT, :PUT_ATT
Value 1 - Variable object	OPERAND1_VARA_NAME	The name of a Variable object, limited to 200 characters.	GET_ATT, :PUT_ATT
Value 1 - Key	OPERAND1_VARA_KEYWORD	The name of a key, limited to 200 characters.	GET_ATT, :PUT_ATT
Operator	OPERATOR	">" - Greater than "<" - Less than "=" - Equal to "<>" Not equal to ">=" Greater than or equal to "<=" Less than or equal to "CONTAINS" - Contains	GET_ATT, :PUT_ATT
Value 2 - Source	OPERAND2_SOURCE	"SQL" - SQL query "STATIC" - Statistical value "VARA" - Variable object	GET_ATT, :PUT_ATT
Value 2 - SQL	OPERAND2_SQL_QUERY	SQL statement, limited to 255 characters.	GET_ATT, :PUT_ATT
Value 2 - Server	OPERAND2_SQL_SERVER_NAME	The name of the database computer, limited to 30 characters.	GET_ATT, :PUT_ATT
Value 2 - Host	OPERAND2_SQL_AGENT	The name of a database agent, limited to 32 characters	GET_ATT, :PUT_ATT
Value 2 - Database	OPERAND2_SQL_DATABASE_NAME	Database name, limited to 30 characters.	GET_ATT, :PUT_ATT
Value 2 - Login	OPERAND2_SQL_LOGIN	The name of a Login object, limited to 200 characters.	GET_ATT, :PUT_ATT
Value 2 - MS Access only: File name	OPERAND2_MSACCESS_FILE	The path and file name of the MS Access database, limited to 255 characters.	GET_ATT, :PUT_ATT
Value 2 - Static value	OPERAND2_STATIC_VALUE	Static value, limited to 40 characters.	GET_ATT, :PUT_ATT
Value 2 - Variable object	OPERAND2_VARA_NAME	The name of a Variable object, limited to 200 characters.	GET_ATT, :PUT_ATT
Value 2 - Key	OPERAND2_VARA_KEYWORD	The name of a key, limited to 200 characters.	GET_ATT, :PUT_ATT

Event Tab

Field	Attribute	Value	Access Via:
Check	EVENT_REPEAT	"R" - Repeatedly "S" - Single run "F" - Until the first hit is found.	GET_ATT, :PUT_ATT
Timer control	EVENT_TIME	MMMM - Minutes in interval HHMM - Start time	GET_ATT, :PUT_ATT
First check	EVENT_FIRST_EXEC	"N" - After the time has expired "S" - Immediately	GET_ATT, :PUT_ATT
Start after check time	EVENT_START_AFTER_SCH	"N" - Do not run "Y" - Run	GET_ATT, :PUT_ATT