Example 2: creating an Oracle table

To create a table, specify a write mode of either create or replace. The next figure is a conceptual diagram of the create operation.

Shows an odbcwrite operator creating an Oracle table and writing to it

Here is the osh syntax for this operator:


$ osh "... orawrite -table table_2 
                   -mode create 
                  -dboptions {'user = user101, password =
                                userPword'} ..."

The orawrite operator creates the table, giving the Oracle columns the same names as the fields of the input InfoSphere® DataStage® data set and converting the InfoSphere DataStage data types to Oracle data types. See "Data Type Conversion" for a list of InfoSphere DataStage-to-Oracle conversions.