Search found 281 matches
- Wed Aug 19, 2009 3:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Strange hashed file behaviour
- Replies: 2
- Views: 1375
Strange hashed file behaviour
Hi , everybody !!! I have a hashed file tha contains 1000 rows. Each run of some jobs insert into the file 10 rows and the option "Clear before writing" is unchecked. I need to update each time these 10 rows . The problem is all rows (each time therwea can be 90 that are different) get NUL...
- Sun Jun 21, 2009 8:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job stops Immediately with no reason
- Replies: 5
- Views: 2658
- Sun Jun 21, 2009 3:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job stops Immediately with no reason
- Replies: 5
- Views: 2658
Job stops Immediately with no reason
Hi , everybody !!! I hae a job run by Job Sequence . Immediately after the job is finishing (It transfer all rows) and I get message : "Job <My Job Name > has finished, status = 97 (Stopped by operator)" . Because of it the whole my sequence failed. I have tried to change job's name and re...
- Wed May 20, 2009 3:32 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Order of rows in hashed file
- Replies: 3
- Views: 2414
Order of rows in hashed file
Hi !!!
If anyway to preserve order of rows in hashed file according the order they enter the hashed file ?
May be to use different type of hashed file ?
Thanks
If anyway to preserve order of rows in hashed file according the order they enter the hashed file ?
May be to use different type of hashed file ?
Thanks
- Sun May 17, 2009 2:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Suppressing NLS warnings
- Replies: 3
- Views: 1976
Suppressing NLS warnings
Hi , everybody !!! I have a question regarding NLS . I have a job that each run have about NLS 2000 warnings since DS failed to map some values are come from Database. My job fails after 50 warnings . I increase it to 2500 in Director but each time the job is run by job sequence and the job failed a...
- Wed May 06, 2009 10:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Cross join
- Replies: 5
- Views: 3795
- Mon May 04, 2009 6:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Cross join
- Replies: 5
- Views: 3795
Cross join
hi !!!
I need to perform the following task :
A B 2
A C 3
A B 4
A C 1
I need to get all combinations of two first fields with a third field :
A B 1
A B 2
A B 3
A B 4
A C 1
A C 2
A C 3
A C 4
If any easy way to get it in DS ?
I need to perform the following task :
A B 2
A C 3
A B 4
A C 1
I need to get all combinations of two first fields with a third field :
A B 1
A B 2
A B 3
A B 4
A C 1
A C 2
A C 3
A C 4
If any easy way to get it in DS ?
- Mon Mar 23, 2009 6:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Link Collector
- Replies: 1
- Views: 1463
Link Collector
Hi , everybody !!! Sometime the job containign Link Collector failed with messages tht relates to its temporal files (ds_ipcopen() - Error in open /tmp/ade...) and Link initialization. We have given a answer that it is because of lack of resources on Datastage server. If any problem to this issue in...
- Mon Jan 26, 2009 3:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Run UNIX script through FTP
- Replies: 4
- Views: 3930
- Mon Jan 26, 2009 1:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Run UNIX script through FTP
- Replies: 4
- Views: 3930
Run UNIX script through FTP
Hi !!!
If any way to run UNIX script hrouth FTP ? THis script will run the Ds Job.
Thanks,
Nissim
If any way to run UNIX script hrouth FTP ? THis script will run the Ds Job.
Thanks,
Nissim
- Mon Jan 19, 2009 5:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Write speed to seq file
- Replies: 7
- Views: 3512
- Mon Jan 19, 2009 4:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Write speed to seq file
- Replies: 7
- Views: 3512
Write speed to seq file
Hi , everybody .
How I can speed up the writing to seq file . I am sure that botlneck in writing to seq file . I am get about 3500 rows/sec.
Some programming tricks ?
How I can speed up the writing to seq file . I am sure that botlneck in writing to seq file . I am get about 3500 rows/sec.
Some programming tricks ?
- Tue Dec 30, 2008 9:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date and Time of Last Successful Job Run
- Replies: 7
- Views: 3256
- Tue Dec 30, 2008 5:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date and Time of Last Successful Job Run
- Replies: 7
- Views: 3256
Date and Time of Last Successful Job Run
Hi !!!
I need to know when last time the JOB finished with status Ok ( =1)
Can I know it with DS Functions without to scan Log of Job ?
Thank you
I need to know when last time the JOB finished with status Ok ( =1)
Can I know it with DS Functions without to scan Log of Job ?
Thank you
- Tue Nov 25, 2008 11:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Conditioning for Before SQL Statement
- Replies: 1
- Views: 1342
Conditioning for Before SQL Statement
Hi !!!
If any way to do befor SQL statement in DB depending on value of Job Parameter ?
If any way to do befor SQL statement in DB depending on value of Job Parameter ?