Supplies information about a table's columns.
SQL_GET_COLUMNS TABLE=...
Syntax |
Description/Format |
---|---|
TABLE= |
Name of the table. |
The agentA program that enables the de-centralized execution of processes (such as deployments) on target systems (computers or business solutions) or a service that provides connectivity to a target system (such as for databases or middleware). An agent is also an object type in the Automation Engine. [Formerly called "Executor."] See also: host writes the result to a reportA report provides more detailed information about a task's execution or a component.. Exactly one line is output per column with the individual values being separated by semicolons.
Structure of the information given in a column:
Foreign key;primary key;column name;(data type)
Value |
Description |
---|---|
Foreign key |
Indicator for the key. Allowed values: 0 and 1 |
Primary key |
Indicator for the key. Allowed values: 0 and 1 |
Column name |
Name of the column. |
Data type |
This is a combination of the vendor's data type and the information whether or not this field permits value NULL. For character types, the length is shown enclosed in parentheses after the data type. |
A COMMIT is automatically made before this scriptA particular Automation Engine object type. functionPre-defined run book template in the Automation Engine. One single step only, e.g. Start Windows Service, Copy file,… is processed.
The following call retrieves column information of the Products table.
SQL_GET_COLUMNS TABLE="Products";
Result in the report:
0;1;ProductID;(int identity, not null)
0;0;ProductName;(nvarchar(40), not null)
1;0;SupplierID;(int, null)
1;0;CategoryID;(int, null)
0;0;QuantityPerUnit;(nvarchar(20), null)
0;0;UnitPrice;(money, null)
0;0;UnitsInStock;(smallint, null)
0;0;UnitsOnOrder;(smallint, null)
0;0;ReorderLevel;(smallint, null)
0;0;Discontinued;(bit, not null)
See also:
Automic Documentation - Tutorials - Automic Blog - Resources - Training & Services - Automic YouTube Channel - Download Center - Support |
Copyright © 2016 Automic Software GmbH |