| Author |
Message |
|
Topic: Aggregator output nullability |
dashpriya
Replies: 7
Views: 5180
|
 Forum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Posted: Wed Nov 25, 2009 4:19 am Subject: Re: Aggregator output nullability |
|
We also faced same issue, but we are also not able to remove those warnings.
|
|
Topic: handle null in modify stage |
dashpriya
Replies: 2
Views: 5912
|
Forum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Posted: Tue Jan 27, 2009 5:34 am Subject: Specification=Col_name= Handle_Null (Col_name,Default valu ) |
Please use below code to resolve your query :
Specification=Col_name= Handle_Null (Col_name,Default value )
|
|
Topic: deadlock detected while updating oracle table |
dashpriya
Replies: 11
Views: 4396
|
Forum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Posted: Tue Sep 09, 2008 10:29 pm Subject: deadlock detected while updating oracle table |
|
Please check if you are using same table for fetching the records and same table to update or insert the records in same job.This situation also can create deadlock.
|
|
Topic: Char to Decimal conversion. |
dashpriya
Replies: 2
Views: 876
|
Forum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Posted: Wed Jul 30, 2008 7:18 am Subject: Char to Decimal conversion. |
Thanks a lot for pointing me to the site.
Thanks
Dash
|
|
Topic: Char to Decimal conversion. |
dashpriya
Replies: 2
Views: 876
|
Forum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Posted: Wed Jul 30, 2008 2:51 am Subject: Char to Decimal conversion. |
DataStage® Release: 7x
Job Type: Parallel
OS: Windows
Hi All,
My Datatstage job consist of a DB2 stage then a Transformer then again a DB2 stage.In transformer stage I am using a Isvalid function to convert the char filed to decimal field.Can anyone s ...
|
|
Topic: DB2 UDB stage |
dashpriya
Replies: 0
Views: 502
|
Forum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Posted: Wed Apr 02, 2008 3:16 am Subject: DB2 UDB stage |
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Hi, Can any one let me know...
While using DB2 stage as output, I want to use the option "open command".There I need to use a db2 utlity command import from.......
This command is not a db2 que ...
|
|
Topic: Job is getting Hanged |
dashpriya
Replies: 3
Views: 1020
|
Forum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Posted: Thu Dec 13, 2007 11:26 pm Subject: Job is getting Hanged |
DataStage® Release: 7x
Job Type: Parallel
OS: Windows
Hi All,
Actullay I am fetching data from table XYZ and updating the same table XYZ after some transformation. Hence Job is getting Hanged.
please help me.
The solution can be create one mo ...
|
|
Topic: sum of column decimal(26,3) |
dashpriya
Replies: 1
Views: 1263
|
Forum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Posted: Fri Nov 02, 2007 2:13 am Subject: sum of column decimal(26,3) |
DataStage® Release: 7x
Job Type: Parallel
OS: Windows
Additional info: sum of column decimal(26,3)
I am calculating sum of column Col1 having datatype decimal(26,3) in db2 stage and After calulating SUM the datatype for output column is Double (31,3). Later I want to populate this double(31,3) ...
|
|
Topic: Decimal to Integer |
dashpriya
Replies: 4
Views: 1714
|
Forum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Posted: Fri Nov 02, 2007 2:12 am Subject: Re: Decimal to Integer |
|
I need a type conversion.So for one field I donot want to use ant stage.Can i use any logic like if the source vaue is of some particular range(as per decimal range) then how can I map it to target wh ...
|
|
Topic: Decimal to Integer |
dashpriya
Replies: 4
Views: 1714
|
Forum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Posted: Fri Nov 02, 2007 1:20 am Subject: Decimal to Integer |
DataStage® Release: 7x
Job Type: Parallel
OS: Windows
Hi,
Any one can plz help me to do a filed conversion.
My source is EEDBPE (Decimal(15)).I want it to map to the filed TRAN_AWRD_CNT (Integer(10)).
Can any one give me any sujjestion wether I ...
|
|
Topic: DB2/UDB API Stage Vs DB2/UDB Enterprise |
dashpriya
Replies: 5
Views: 1538
|
Forum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Posted: Thu Aug 09, 2007 10:50 pm Subject: DB2/UDB API Stage Vs DB2/UDB Enterprise |
Thanks a lot for all you answers.
Thanks
Dash
|
|
Topic: DB2/UDB API Stage Vs DB2/UDB Enterprise |
dashpriya
Replies: 5
Views: 1538
|
Forum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Posted: Thu Aug 09, 2007 3:01 am Subject: DB2/UDB API Stage Vs DB2/UDB Enterprise |
DataStage® Release: 7x
Job Type: Parallel
OS: Windows
Hi
Can any one tell me
what is the difference between DB2/UDB API Stage and DB2/UDB Enterprise?
In my project DB2/UDB API stage is used to populate i-series.Why not DB2/UDB Enterprise?
Please h ...
|
|
Topic: Datatype error |
dashpriya
Replies: 1
Views: 746
|
Forum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Posted: Thu Jul 12, 2007 12:26 am Subject: Datatype error |
DataStage® Release: 7x
Job Type: Parallel
OS: Windows
Hi
In my job I am having DB2 and Sequential file as my source file.When I am removing 4 columns from both the source(as using funnel as next stage) i am getting some error in my transformer.The erro ...
|
|
Topic: Switch case |
dashpriya
Replies: 7
Views: 1105
|
Forum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Posted: Fri Jun 15, 2007 4:37 am Subject: Re: Switch case |
|
Thanks a lot for guiding me..
|
|
Topic: Switch case |
dashpriya
Replies: 7
Views: 1105
|
Forum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Posted: Fri Jun 15, 2007 4:07 am Subject: Switch Case |
|
I am new to PX
|
| |
