Stored Procedure Definitions

admin on June 10th, 2010

To specify parameters for the stored procedure definition, click the Parameters tab in the Table Definition dialog box. The Parameters page appears at the front of the Table Definition dialog box. Parameter definitions are entered directly in the Parameters grid. To add a new parameter definition, you must edit the empty row  in the Parameters […]

Continue reading about Stored Procedure Specifying Parameters in datastage

admin on June 10th, 2010

The Columns page contains a grid displaying the column definition for each column in the table definition. You can add new column definitions, delete column definitions, or edit existing ones. The following columns appear if you selected Meta data supports Multi-valued fields on the General page: Association. The name of the association (if any) that […]

Continue reading about Table Definition Dialog Box – Columns Page

admin on June 10th, 2010

To create a stored procedure definition: In the DataStage Manager, select the Table Definitions branch and do one of the following:   Choose File > New Table Definition… . Choose New Table Definition… from the shortcut menu. Click the New button on the toolbar. In the DataStage Designer, select the Table Definitions branch in the […]

Continue reading about Creating a Stored Procedure Definition in datastage

The easiest way to specify a definition for a stored procedure is to import it directly from the stored procedure on the source or target ODBC database. A new definition for the stored procedure is created and stored in the Repository. To import a definition for a stored procedure via an ODBC connection: Choose Import […]

Continue reading about Importing a Stored Procedure Definition in datastage

admin on June 10th, 2010

You can access data in a database using a stored procedure, if required. To do so, you use an ODBC stage in a server job, or the STP plugin stage in a server or parallel job (the plugin stage has its own documentation, which is available when you install the plugin). A stored procedure can: […]

Continue reading about Stored Procedure Definitions in datastage