Well, I'll try writting to a file first. If I still have problems, I'll ask our administator about the DB2 stage.
Thank you for your help!
Search found 4 matches
- Thu Feb 05, 2004 3:37 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problems using Link Collector
- Replies: 6
- Views: 1304
- Thu Feb 05, 2004 3:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problems using Link Collector
- Replies: 6
- Views: 1304
Re: Problems using Link Collector
OOPS you hae already mentioned the target. Sorry ! When writing into Sequential file and then to DB2 in which stage are you having the error. I would suggest for that job, break it into 2 jobs. First write into Sequential file in Link Partitioner job and then use this file to write into DB2 with th...
- Thu Feb 05, 2004 3:05 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problems using Link Collector
- Replies: 6
- Views: 1304
Re: Problems using Link Collector
What is your target Database in the job and what is the stage you are using to write into ? The target database is mainframe DB2 (stage is DSDB2) and the stage writing to it is the Link Collector. I have tried having the Link Collector write to a sequential file first then writing to the database, ...
- Thu Feb 05, 2004 2:34 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problems using Link Collector
- Replies: 6
- Views: 1304
Problems using Link Collector
I am writing a job with a link collector. It is accepting 2 inputs of the same format from 2 different transformers. Then the output is to a DB2 plugin. The job executes without error when selecting - "Clear table and insert rows". The job needs to be changed to Update then Insert new rows...