Imagine the following file content:
TABLE_NAME;COLUMN;VALUE
PRODUCT;'PRODUCT_COD';'999'
PRODUCT;'PRODUCT_NAME'; 'ANY NAME'
PRODUCT;'QUANTITY';10
PRODUCT;'INPUT_DATE';'2012-01-01'
ADDRESS;'STREET_NAME';'ANY NAME'
ADDRESS;'ZIPCODE';'999999999'
DataStage must to generate the following INSERT Statements from this file:
INSERT INTO PRODUCT (PRODUCT_COD, PRODUCT_NAME, QUANTITY, INPUT_DATE) VALUES ('999','ANY NAME',10,'2012-01-01')
INSERT INTO ADDRESS (STREET_NAME, ZIPCODE) VALUES ('ANY_NAME','999999999')
It's possible to appear at the next day, for example, a content like:
TABLE_NAME;COLUMN;VALUE
PRODUCT;'PRODUCT_COD';'999'
PRODUCT;'PRODUCT_NAME'; 'ANY NAME'
PRODUCT;'QUANTITY';10
PRODUCT;'INPUT_DATE';'2012-01-01'
ADDRESS;'STREET_NAME';'ANY NAME'
ADDRESS;'ZIPCODE';'999999999'
CUSTOMER;'CUSTOMER_NAME';'JOHN'
And we also have to insert into a third table with a different structure. In this case, it has only one column as follow:
INSERT INTO CUSTOMER (CUSTOMER_NAME) VALUES ('JOHN')
IN SHORT: Can DataStage create dynamic SQL Statements for each record based on a file content like this above?
Create the SQL Statement and execute it, of course.
![Razz :-P](./images/smilies/icon_razz.gif)
Waiting different tables with different number of columns.
Thanks for your help, my friends.
Best Regards,