Search found 65 matches

by Rob4732
Wed Aug 25, 2010 9:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sql server extract - corrupt data when using an odbc stage
Replies: 4
Views: 3064

I changed the LAST_NAME column from nvarchar 50 to varchar 100 and re ran. Same bad data.

When I change my database stage from ODBC to DRS and run same extract(using nvarchar 50) my data looks good.

ID LAST_NM
345Kraska
by Rob4732
Tue Aug 24, 2010 5:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sql server extract - corrupt data when using an odbc stage
Replies: 4
Views: 3064

sql server extract - corrupt data when using an odbc stage

Hello Everyone, We are connecting to a sql server database with datastage for the first time. The odbc configuration is complete and we are communicating with the database from parallel jobs. When extracting data from a sql server table(via an odbc stage), we noticed that some of the data in nvarcha...
by Rob4732
Wed Jun 30, 2010 9:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Benefits of using a server job
Replies: 3
Views: 1261

Excellent Info.

Thanks
by Rob4732
Wed Jun 30, 2010 8:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Benefits of using a server job
Replies: 3
Views: 1261

Benefits of using a server job

I apologize if this question has been asked on the forum previously. My search results for 'server job' are too numerous to go thru. My question is: When would you want to use a server job(vs. a parallel) job? Is there a benefit to using a server job(vs. a parallel job)? I have heard that the startu...
by Rob4732
Tue Sep 01, 2009 4:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: process control in sequencers
Replies: 1
Views: 904

process control in sequencers

Hello Everyone, I have a master sequencer that calls a child sequencer: Master Seq -> Activity1 -> Child Seq -> Activity2 -> Activity3 In my child sequencer I am checking a condition and if true I branch to an Email stage and no other activities run in the child sequencer. However control returns to...