Search found 20 matches
- Fri Nov 04, 2005 1:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem adding jobs to schedule
- Replies: 15
- Views: 15557
- Fri Nov 04, 2005 12:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem adding jobs to schedule
- Replies: 15
- Views: 15557
problem adding jobs to schedule
I have a new install of DataStage. I can run jobs manually but when I try to schedule a job I get the following error message. I have been unable to schedule any jobs. Error adding to schedule: at: garbage after time specification (Command was: AT 14:00 /NEXT:5 vmdsr_sched.exe C:\Ascential\DataStage...
- Fri Nov 04, 2005 9:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: duplicate rows from oracle when running in parallel
- Replies: 5
- Views: 1527
- Fri Nov 04, 2005 8:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: duplicate rows from oracle when running in parallel
- Replies: 5
- Views: 1527
I have an Oracle stage going into a transformer stage which writes out to a flat file. In the oracle stage I have changed from the default of sequential to parallel partitioning. It does not give me any options to specify entire , round robin etc... In the transformer stage partitioning is set to th...
- Fri Nov 04, 2005 7:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: where are the log files for DS
- Replies: 12
- Views: 4220
where are the log files for DS
I know how to use Director to view job logs. I would like to view/use the job logs outside of the director.
Where does DS store job logs? Are they in a text file that can be edited?
Where does DS store job logs? Are they in a text file that can be edited?
- Fri Nov 04, 2005 7:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: duplicate rows from oracle when running in parallel
- Replies: 5
- Views: 1527
duplicate rows from oracle when running in parallel
My source is a table on Oracle 9i. In the Oracle 9i stage I have set it to work in parallel. When I run the job I am getting duplicate records from Oracle.
How can I set up the stage so that each partition gets a unique set of rows to process?
How can I set up the stage so that each partition gets a unique set of rows to process?
- Wed Nov 02, 2005 3:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: remove duplicate stage compared to sort stage
- Replies: 2
- Views: 1387
remove duplicate stage compared to sort stage
I want to remove duplicate records from a data set. I was going to use the remove duplicates stage. The documentation says the data must be sorted before removing duplicates. However the sorter stage also has the capability of removing duplicates. Why would I want to use the removed duplicate record...
- Tue Sep 20, 2005 8:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ds error messages
- Replies: 4
- Views: 1769
- Fri Sep 16, 2005 7:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ds error messages
- Replies: 4
- Views: 1769
ds error messages
I am getting error messages from the server such as
DBS000027
but I can not find a list of error messages in the documentation that I have.
Can someone tell me where to find a list of error messages and their descriptions?
DBS000027
but I can not find a list of error messages in the documentation that I have.
Can someone tell me where to find a list of error messages and their descriptions?
- Fri Sep 16, 2005 7:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: dsenginge won't start
- Replies: 5
- Views: 2207
- Thu Sep 15, 2005 6:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: dsenginge won't start
- Replies: 5
- Views: 2207
I had exported the job from server version 7.5 and imported it into the new 7.5x enterprise version both running on windows. We have been running version 7.5x for about a month but only with new jobs created on that server. I recompiled the job and then tried running the job. Could the problem be fr...
- Thu Sep 15, 2005 12:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: dsenginge won't start
- Replies: 5
- Views: 2207
dsenginge won't start
I am running on windows with 7.5x enterprise edition. My jobs are all server. I ran a job with an empty source file. After the job was running for several minutes I tried to stop the job from the director. I then got a popup window complaining about an internal error. I clicked okay and the popup di...
- Tue Sep 06, 2005 5:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: fixed width columns and the default null string
- Replies: 4
- Views: 1750
- Fri Sep 02, 2005 9:25 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: fixed width columns and the default null string
- Replies: 4
- Views: 1750
fixed width columns and the default null string
I am receiving fixed width files. I would like to determine when a column value is null. On the sequential file stage - outputs - format screen there is a field called "default null string". Can someone explain how this is supposed to be used? My assumption was that if I put a value there ...
- Sat Aug 13, 2005 5:29 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: check for a particular row existing in the incoming file
- Replies: 2
- Views: 1013
check for a particular row existing in the incoming file
The first 3 characters of each incoming record indicates the record type. Record type = '999' indicates that the record is the trailer record. At the end of each incoming file there should be a trailer record, which contains a count of the number of records in the file. I have a transformer stage in...