DSXchange

Hi I have a job in which a transformer accepts records having 84 fields in each.There are 8 constraints to be handled with the output records also having 84 fields each. Since one transformer cannot handle so many columns,the input has been provided to 2 transformers.However,a run time error occurs ...

Hi Rajeev,


thats is not a problem. any no if configure file you can create. only problem is during runtime u need to select which one is correct version.

Please write Job routine.

Hi Sreenivasulu, DB2 API stage is not a native stage. [b]please see the following information[/b] Native Parallel vs. Plug-In Database Stage Usage Starting with release 7, DataStage EE offers database connectivity through native parallel and plugin stage types. For some databases (DB2, Informix, Ora...

Hi, We are using DB2 enterprise stage for source I have used a user defined query in that stage. I want to execute this query in parallel mode. The query is like. Select a.c1, a.c2, b.c3,b.c4 from table1 a, table2 b Where a.c3= b.c3 I want to execute this query in parallel execution mode If i use, u...

Hi

We are using same DB2 UDB Enterprise stage with following properties but we can able to insert.

Write method: upsert
upsert mode: Auto-generated Update & Insert.
Check your $APT_configure file for DB2 setup or set DB2 partitioning.

Please try this.

yes PowerDesigner 10 supports the Red Brick.

Please use TimeDate( ) function...

yes