DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 817 matches
Author Message
 Topic: Sequence status is 99
us1aslam1us

Replies: 18
Views: 5148

PostForum: General   Posted: Wed Aug 05, 2015 5:56 pm   Subject: Sequence status is 99
This is the suggestion i got from IBM:

InfoSphere DataStage: Problems when running multiple instances of a job from a job sequence, or from a script using dsjob


Environment variable: DSWaitRes ...
 Topic: Update is not working correctly in Oracle stage
us1aslam1us

Replies: 9
Views: 2865

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 28, 2012 11:27 am   Subject: Update is not working correctly in Oracle stage
Check the data type for the ZIP column in the target table. Also verify what data you are feeding into this column? Is it integer, text, text with white spaces?

sAM
Resolved
 Topic: ORA-01722: invalid number
us1aslam1us

Replies: 20
Views: 11520

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Jun 06, 2012 3:31 pm   Subject: ORA-01722: invalid number
Andrea,

Where do we need to change these options? Can you be little more specific about this.

Sorry Craig.... Just going through the same issue.

Thanks
sAM
Resolved
 Topic: New row in source is not loaded into target table
us1aslam1us

Replies: 4
Views: 1614

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Apr 25, 2012 12:07 pm   Subject: New row in source is not loaded into target table
NOTFOUND works fine when performing lookup on Hashed Files but for the Table lookup it is always better to use the null check.

sAM
Resolved
 Topic: Need Help to Implement Logic
us1aslam1us

Replies: 14
Views: 4496

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 25, 2012 11:56 am   Subject: Need Help to Implement Logic
Vineet,

It can all be done by using a stage variable to store the previous value and populate this vale in the current Column.

But why would anyone like to modify the Amounts associated with Pr ...
Resolved
 Topic: Logic for implementation of the req
us1aslam1us

Replies: 4
Views: 1377

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 04, 2011 3:22 pm   Subject: Logic for implementation of the req
It is quite hard to understand your requirement. Share some information on how your input data looks and what exactly are you expecting in your output.

Sample Data??

sAM
 Topic: how to pad zero to a string with out using transformer stage
us1aslam1us

Replies: 2
Views: 1495

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 30, 2011 1:59 pm   Subject: how to pad zero to a string with out using transformer stage
Why not transformer stage???

What is your source? In case if you are pulling the data from some database then you can perform this operation in your source SQL statement itself.

sAM
 Topic: error with DRS stage
us1aslam1us

Replies: 3
Views: 1841

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Oct 22, 2009 3:27 pm   Subject: error with DRS stage
Hello Abha,

We went through the same Issue couple of days ago and found that there is bug fix (patch) available for this. Talk to you Serive Provider.

sAM
 Topic: Error in timestamp_from_string function in Modify stage
us1aslam1us

Replies: 1
Views: 1263

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri May 29, 2009 3:52 pm   Subject: Error in timestamp_from_string function in Modify stage
Nothing wrong here but change [%yyyy-%mm-%dd hh:nn:ss] to [%yyyy-%mm-%dd %hh:%nn:%ss] and try it.
Resolved
 Topic: get Current TimeStamp-(MINUS) 1 Day
us1aslam1us

Replies: 5
Views: 5342

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Mar 17, 2009 1:46 pm   Subject: get Current TimeStamp-(MINUS) 1 Day
Have you checked the function TimestampFromSecondsSince()???
 Topic: remove leading zeros in decimal field in sequential file
us1aslam1us

Replies: 26
Views: 62197

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Mar 17, 2009 1:43 pm   Subject: remove leading zeros in decimal field in sequential file
I hope this will solve your issue..


Trim(DecimalTostring(In.Col),'0','L')


sAM
 Topic: Target table has more data than Source View
us1aslam1us

Replies: 2
Views: 1072

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Nov 25, 2008 2:49 am   Subject: Target table has more data than Source View
There might be two seperate issues you are facing.

''OCI has fetched truncated data''
There might be some column in the source which is having column length greater than the one in the target.
...
 Topic: Increment sequence
us1aslam1us

Replies: 2
Views: 1240

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 25, 2008 2:37 am   Subject: Increment sequence
Simple solution will be to use stage variables. Try something like this....
Sort the data on your three columns.
Initialize sVValue as 1

sVCurrent = COLA:COLB:COLC
sVValue = If sVCurren ...
 Topic: problem with paralle direct load
us1aslam1us

Replies: 1
Views: 730

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 25, 2008 2:25 am   Subject: problem with paralle direct load
Did you try using peek or flat file as output to test? I really doubt that there might be some tranformations which is causing this issue. Share you Job Design...
 Topic: Adding the amount column value from Sequencial file.
us1aslam1us

Replies: 4
Views: 908

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 25, 2008 2:20 am   Subject: Adding the amount column value from Sequencial file.
If your source already have it as decimal then what is stopping you to use aggregator for Summing those values??
 

 Jump to:   



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