Search found 5168 matches

by kumar_s
Fri Dec 01, 2006 2:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error missing ORA.DLL
Replies: 6
Views: 1931

Welcome Aboard :D !!!

Was it a new server/ installaion? Where you able to see the stages in designer? If it was the existing and the same server where the code been developed, check if any change in permission one user id and the filesystem been changed.
by kumar_s
Fri Dec 01, 2006 2:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: unable tostart multiload process
Replies: 4
Views: 1514

Give us more inputs on which database, exact error message, job design etc.,
by kumar_s
Fri Dec 01, 2006 1:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Intact property in seqential file
Replies: 2
Views: 892

If you wish to use runtime column propagation to propagate those
columns you have not defined through the job, then you will also
have to define the full schema using the schema file property on
the input or output page of the stage.
by kumar_s
Fri Dec 01, 2006 1:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Target file layout - Dynamic change
Replies: 3
Views: 910

Read the file and pass it as a parameter to the next job based on the condition. I havent tested if Modify accepts paramter.
by kumar_s
Wed Nov 29, 2006 12:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Highest Key Generated
Replies: 11
Views: 3828

The key generated is based on the number of rows been passed. So either if you know the number of rows that will be process through the transformer, you can get it, else, capture it after job or by using some other stage like, sort to get the max of it.
by kumar_s
Mon Nov 20, 2006 7:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: schedule every last friday of the month
Replies: 4
Views: 1761

You can schedule the job for daily run or every friday, which actually check if the current day is the last friday of the month and execute the process.
Or get the list of last friday of the month for may be 2 ot 3years, and schedule it manually.
by kumar_s
Mon Nov 20, 2006 4:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: zipping
Replies: 14
Views: 2915

I did a quick test with gzip. I gave me individual zip file. May be you can tell us the issue exactly.
by kumar_s
Mon Nov 20, 2006 4:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Switch v/s filter stage
Replies: 8
Views: 3143

You shouuld be able to find a attrative button on the top of the page. Dont you?
by kumar_s
Mon Nov 20, 2006 12:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unsupport v1.1 Type Error
Replies: 3
Views: 1118

Hi leeten ,
Welcome Aboard :D !!!

What is your job design? Do you use any API?
Is it particular to that job or for all other jobs?
by kumar_s
Mon Nov 20, 2006 12:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: passing parameter to stored procedure stage
Replies: 2
Views: 3684

The number of column that available in the input link will be the input parameter to the Stored procedure stage. To have an column which will be the input for the SP stage, you can follow the Ray's method. Include a dummy transformer with the column populated by Job properties or the inbuilt Date fu...
by kumar_s
Wed Nov 15, 2006 4:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Format Delimiter ascii 168 (¿)
Replies: 11
Views: 5165

Where do you see the data "2006-11-15 ?999 ?aaabbb", is it in view data browser or at output file. That too makes some difference.
by kumar_s
Wed Nov 15, 2006 3:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to clear RT_LOG****
Replies: 6
Views: 10852

The Director client might go in Waist state till it gets deleted. Else you can use CLEAR.FILE with directly the filename, as mentioned. But this will again remove the Auto purge option to not work.
Or create a Copyof current job and delete the old job, and rename the Copy of job to the old job name.
by kumar_s
Wed Nov 15, 2006 2:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Maximum Size for job name?
Replies: 4
Views: 1197

259 chars. I dont guess Job description will be given as the job name. :wink:
by kumar_s
Wed Nov 15, 2006 2:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: lookup space problem
Replies: 14
Views: 5226

What is the job desing? Is it populating the lookupfile or looking up and existing file? If populating lookup file, what is the size of the file, is that huge to occupy the rest of the space when created?