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
Search found 65 matches
- 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
- 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...
- 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
- 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...
- 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...