Search found 3 matches
- Tue Nov 15, 2011 11:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error in using ORCHESTRATE.col in Before Job SQL in ODBC Con
- Replies: 1
- Views: 2045
Error in using ORCHESTRATE.col in Before Job SQL in ODBC Con
Hi, We have developed a job, in which we need to delete some records on some crteria from the target before loading data into target table(DB2). We are using ODBC Connector stage to connect to DB2. Query provided in Before Job SQL: DELETE FROM RDMCLUB.UNIQUE_ASSORTMENT_CLUB B WHERE B.POG_SUBCAT_ID I...
- Thu Jun 30, 2011 9:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help in reading source file and loading data into DB
- Replies: 3
- Views: 1428
- Thu Jun 30, 2011 9:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help in reading source file and loading data into DB
- Replies: 3
- Views: 1428
Need help in reading source file and loading data into DB
Hi, I have a requirement as below: My source file is an excel sheet having data in below format: 1 Age: 27 Sex: Male NVR0035733 Elector's Name: Father's Name: House No: K SATYA NARAYANA SURYA NARAYANA 01/01/2027 2 Age: 38 Sex: Male NVR0035634 Elector's Name: Father's Name: House No: SAYED HABIBOOR S...