Search found 42189 matches

by chulett
Wed Dec 18, 2013 9:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Hanging while updating sql server table
Replies: 10
Views: 3368

Where are the locks coming from? If it is from the job itself, have you tried running on a single node as previously noted? That would eliminate the target as the source of the locks but would still lock if they are being generated on the source side.
by chulett
Wed Dec 18, 2013 9:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Implementing Transpose functionality in Datastage 8.5
Replies: 2
Views: 1639

... column names you would have to manually hard-code and add to the flow before pivoting.
by chulett
Wed Dec 18, 2013 8:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with Post SQL execution in OCI
Replies: 7
Views: 2127

What happens if you change it to two anonymous blocks one after the other rather than embedding them like that? Or run both scripts inside one anonymous block?
by chulett
Tue Dec 17, 2013 7:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Input stage
Replies: 16
Views: 4745

suryadev wrote:please suggest how to retrieve the whole tags?
eostic wrote:When it ends in a slash, you get the whole tag.
by chulett
Tue Dec 17, 2013 5:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Find the highest value in a group
Replies: 8
Views: 2959

So your desired output would be... Empl_rec, Daily_Change_Ver_Num, Changed Data 03456, 3, "Empl_Status, Leave_of_Absone_Date, New_Salary" 45633, 2, "New_Address, Empl_Status" Correct? And your changed data field, is it in fact one field containing a comma delimited list of the ch...
by chulett
Tue Dec 17, 2013 4:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Find the highest value in a group
Replies: 8
Views: 2959

You'd have to clarify what "Col_3 is different across the records in the group" means. Can you supply examples with real data, input and output?
by chulett
Tue Dec 17, 2013 3:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Find the highest value in a group
Replies: 8
Views: 2959

You don't really need to Sort or leverage a Key Change column, just run the data through an Aggregator. Group by Col_1, max(Col_2) and do whatever is appropriate for Col_3... depending on what "Data" means.
by chulett
Tue Dec 17, 2013 9:20 am
Forum: General
Topic: Controller problem: Unhandled failure (255) encountered exec
Replies: 1
Views: 1636

Welcome.

Do an exact search here for "Controller problem: Unhandled failure" and you find 50 other discussions on this subject.
by chulett
Tue Dec 17, 2013 8:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Hanging while updating sql server table
Replies: 10
Views: 3368

Well... classic first question would be, if you run this on a single node does the problem go away? Secondly, have you had your DBA monitor the session when it is hung?
by chulett
Tue Dec 17, 2013 8:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with Post SQL execution in OCI
Replies: 7
Views: 2127

Can we get a clue as to what the after SQL actually is? I'd also be curious what makes you think it is being skipped.
by chulett
Tue Dec 17, 2013 8:29 am
Forum: General
Topic: Deploying the code from SVN
Replies: 1
Views: 829

Just an FYI, you asked this in three posts - one is just fine. I removed the other two posts.
by chulett
Mon Dec 16, 2013 6:14 pm
Forum: General
Topic: How to Output Multiple Job Logs
Replies: 4
Views: 811

FYI - You are able to go back and edit your original post to correct the Job Type...
by chulett
Mon Dec 16, 2013 1:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Hanging while updating sql server table
Replies: 10
Views: 3368

And so off we go!

Can you specify what kind of locks you are seeing? Posting the actual error messages should help, I would think.
by chulett
Mon Dec 16, 2013 1:45 pm
Forum: General
Topic: How to Output Multiple Job Logs
Replies: 4
Views: 811

I'm not sure I'd be relying on the logs for information like this. Is this something you could specifically store outside the logs so you have more control of how it is stored and how long it is retained?
by chulett
Mon Dec 16, 2013 11:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Hanging while updating sql server table
Replies: 10
Views: 3368

Is this a parallel job? I only asked because you posted in the Server forum.