DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 27 matches
Author Message
Resolved
 Topic: Aggregator output nullability
dashpriya

Replies: 7
Views: 5186

PostForum: 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: 5928

PostForum: 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: 4410

PostForum: 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

PostForum: 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

PostForum: 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: 503

PostForum: 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: 1021

PostForum: 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: 1264

PostForum: 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

PostForum: 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

PostForum: 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: 1539

PostForum: 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: 1539

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 15, 2007 4:07 am   Subject: Switch Case
I am new to PX
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours