Search found 4 matches

by Bhavesh.Shah
Thu Jan 03, 2008 12:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Failure During Execution of Operator Logic
Replies: 29
Views: 20796

If you are using the DB2 API stage, there is patch available for this bug. Ask Ascential Support for the Patch.
by Bhavesh.Shah
Fri Aug 03, 2007 10:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to get the correct "CENTURY" if from 2-digit Y
Replies: 6
Views: 4498

If you can afford a Basic Transformer in your Parallel Job then a combination of Iconv & Oconv can get you the desired results.
by Bhavesh.Shah
Wed Jul 25, 2007 10:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Display stages in tabular form
Replies: 5
Views: 2284

D,

You can use the Generate Report feature present on the toolbar to generate a report on the Job. The report contains the summary of the entire job and its a good way to have a look at the columns (tabular format) going in and coming out of each stage/ link.

Thanks,
Bhavesh
by Bhavesh.Shah
Wed Jul 25, 2007 9:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC Vs DataSet - Performance Suggestions
Replies: 1
Views: 1197

ODBC Vs DataSet - Performance Suggestions

Hi, We have an ETL process that produces a Daily File in the form of a DataSet containing around 2 million records on an average. After the Daily File is generated I need to load the data into a DB2 table through an ODBC stage for some auditing (Done in Cobol). Now I have the same data residing in a...