Database components are generally used to read from/ write to different databse. The basic database components are “run sql” , “input table”, “output table”.
Input Table
Input Table unloads data records from a database into an Ab Initio graph, allowing you to specify as the source either a database table, or an SQL statement that selects data records from one or more tables.
In the source field (as marked yellow) if name button is clicked, the name of the table from which all the rows are to selected, should be mentioned. If Select Statement is clicked the path of the required sql file is to be mentioned or required sql statement should be embedded.
Output Table
Output Table loads data records from a graph into a database, letting you specify the records' destination either directly as a single database table, or through an SQL statement that inserts data records into one or more tables.
In the destination field, if name button is clicked, the name of the table in which all the rows are to inserted, should be mentioned. If Insert Statement is clicked the path of the required sql file is to be mentioned or required sql statement.
The parameters for this component are RDBMS( like Teradata, Oracle or SQL) dependent.
Run Sql
Run sql is a database component. It executes SQL statements in an Oracle or SQL Server database.
In the run sql component two parameter files are required to be mentioned (as they are marked yellow)
1) DBConfigFile: Name of the database table configuration which is required to be used has to be mentioned here.
2) SQL file : Name of the file containing SQL statements. The DBMS execution utility executes the SQL statements contained in the file specified in the SqlFile parameter. If the DBMS execution utility successfully executes the statements, it exits with status 0.
Input Table
Input Table unloads data records from a database into an Ab Initio graph, allowing you to specify as the source either a database table, or an SQL statement that selects data records from one or more tables.
In the source field (as marked yellow) if name button is clicked, the name of the table from which all the rows are to selected, should be mentioned. If Select Statement is clicked the path of the required sql file is to be mentioned or required sql statement should be embedded.
Output Table
Output Table loads data records from a graph into a database, letting you specify the records' destination either directly as a single database table, or through an SQL statement that inserts data records into one or more tables.
In the destination field, if name button is clicked, the name of the table in which all the rows are to inserted, should be mentioned. If Insert Statement is clicked the path of the required sql file is to be mentioned or required sql statement.
The parameters for this component are RDBMS( like Teradata, Oracle or SQL) dependent.
Run Sql
Run sql is a database component. It executes SQL statements in an Oracle or SQL Server database.
In the run sql component two parameter files are required to be mentioned (as they are marked yellow)
1) DBConfigFile: Name of the database table configuration which is required to be used has to be mentioned here.
2) SQL file : Name of the file containing SQL statements. The DBMS execution utility executes the SQL statements contained in the file specified in the SqlFile parameter. If the DBMS execution utility successfully executes the statements, it exits with status 0.
