Search found 6797 matches
- Wed May 16, 2007 8:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Removing Duplicates using stage variables in parallel job
- Replies: 5
- Views: 1961
Only the fairy god mother can tell why its not working. We can only guess, which is not good. JoshGeorge gave you a nice explanation. thompsonp added to it. We can only do so much sitting on this side of the screen. A better way to do this is using the sort stage. Search the forum on the 'How to' pa...
- Wed May 16, 2007 8:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC driver error
- Replies: 7
- Views: 2099
- Wed May 16, 2007 8:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job Failure Code
- Replies: 7
- Views: 3004
- Wed May 16, 2007 8:08 am
- Forum: General
- Topic: Processing files in a directory
- Replies: 44
- Views: 12719
You need quotes. Your param should look like
Code: Select all
dsjob -run -param 'FILENAME=/path/of/3 February 2006.csv'
- Wed May 16, 2007 8:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: fixed width file
- Replies: 8
- Views: 2741
- Wed May 16, 2007 8:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Creating Hashed File
- Replies: 4
- Views: 1322
- Wed May 16, 2007 8:00 am
- Forum: General
- Topic: Processing files in a directory
- Replies: 44
- Views: 12719
So you have a file with the name '3 February 2006.csv' ? How are you opening this file in your script? First of all you have spaces in the name of your file, not a good practice, for files on unix. You will need to enclose the name in quotes to perform any operation on it, or else it will not find t...
- Wed May 16, 2007 7:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DS Job Type Identification - Server or PX in Unix
- Replies: 7
- Views: 1688
The JOBTYPEIND in DS_JOBS repository table will identify parallel jobs from server jobs.
Here are the indicators:
Server Jobs - 0
Parallel Jobs - 3
Job Sequences - 2
A simple uv query would be
where n is one of the indicators listed above.
Here are the indicators:
Server Jobs - 0
Parallel Jobs - 3
Job Sequences - 2
A simple uv query would be
Code: Select all
SELECT NAME FROM DS_JOBS WHERE JOBTYPEIND = 'n';
- Wed May 16, 2007 7:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing parameter values from One Job to Next
- Replies: 2
- Views: 1079
- Wed May 16, 2007 7:21 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Writing in to a sequential file trhru routine
- Replies: 22
- Views: 8125
If, all you are doing, is to write to a variable to a flat file then try going via the route of OS commands using DSExecute(). Would'nt that be feasible. I think Craig hit the bulls eye, by pointing out, that the error might lie in the fact that you are using DOS line terminator on a unix platform. ...
- Wed May 16, 2007 7:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance
- Replies: 6
- Views: 1638
- Tue May 15, 2007 2:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: time stamp conversion
- Replies: 19
- Views: 7432
- Tue May 15, 2007 12:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: time stamp conversion
- Replies: 19
- Views: 7432
- Tue May 15, 2007 10:39 am
- Forum: General
- Topic: Processing files in a directory
- Replies: 44
- Views: 12719
- Tue May 15, 2007 10:17 am
- Forum: General
- Topic: Processing files in a directory
- Replies: 44
- Views: 12719