Search found 6797 matches

by DSguru2B
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...
by DSguru2B
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

Is that all there is to the error? Do you have any other error messages? Need more info then that.
by DSguru2B
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

Segmentation fault usually means its running out of memory. If the data size in your lookup table is large then use the join stage instead of the lookup stage.
I forgot to ask, whats your job design?
by DSguru2B
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' 
by DSguru2B
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

This has been discussed before. Please do a search on "Error when checking operator: "record_length=fixed" (no length given) and record field format is variable-length".
by DSguru2B
Wed May 16, 2007 8:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating Hashed File
Replies: 4
Views: 1322

Also research about CREATE.FILE .
by DSguru2B
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...
by DSguru2B
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

Code: Select all

SELECT NAME FROM DS_JOBS WHERE JOBTYPEIND = 'n';
where n is one of the indicators listed above.
by DSguru2B
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

May we know why do you want to avoid landing the values to a flat file?
Also, how are you controlling the process, is it via a script or via job sequences?
Also, you have parameters for each job, can these parameters be repeated in different jobs?
by DSguru2B
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. ...
by DSguru2B
Wed May 16, 2007 7:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance
Replies: 6
Views: 1638

WHat is the array size you are using? If its 1 then try to increase that. Sometimes a simple change in array size can make all the difference.
by DSguru2B
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

I dont think you will get that. It will only add zeros.
by DSguru2B
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

Where are you changing the format? The StringToTimestamp() changes the string into a timestamp. The format of the timestamp will depend upon the default that is set in your target stage. I hope you are giving the .3 in the default timestamp of the target stage.
by DSguru2B
Tue May 15, 2007 10:39 am
Forum: General
Topic: Processing files in a directory
Replies: 44
Views: 12719

Look in the first entry of the log and see if all the parameters are being passed properly, if any.
by DSguru2B
Tue May 15, 2007 10:17 am
Forum: General
Topic: Processing files in a directory
Replies: 44
Views: 12719

Compile the job. DSJE_BADSTATE is indicating that the job is not in a runnable state.