Search found 5168 matches

by kumar_s
Thu Jun 22, 2006 7:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to increment surrogate key
Replies: 9
Views: 3845

You can use userStatus option to pass on value form the previous stage in JobSequnce.
Or you can define your own surrogate key. You can have the max of the field as an additional column in user defined query, and use it the transformer to frame your logic to add 1 with the help of Stage variable.
by kumar_s
Thu Jun 22, 2006 7:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Control fatal error (-14)
Replies: 25
Views: 13418

May I know how may number of jobs been called parallely by the batch job?
Is it possible for you to serialize it?
by kumar_s
Thu Jun 22, 2006 7:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Same job with different functions
Replies: 5
Views: 969

Use Execute command activity to clear the file at first. Later call the job using job activity with update action inthe job for 5 times.
by kumar_s
Thu Jun 22, 2006 7:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Filter Stage is Slow
Replies: 4
Views: 888

This might be not true for all cases.
May I know, how you compare the performance? The load consistency of the server?
But still there may be some case where transformer might have eaten up large resource, but have performed well.
by kumar_s
Thu Jun 22, 2006 7:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to export DS Project
Replies: 6
Views: 1883

Proceed with the suggestions given by Arnd, And if you manage to import the exported dsx sucessfully into another project, try to do REINDEX for DS_JOBS of the current project. This might also help.
by kumar_s
Thu Jun 22, 2006 7:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with APT_STRING_PADCHAR
Replies: 9
Views: 4731

And more over, this variable is not required to be inserted into the any job or sequence, unless it is required to be changed. Is there any specific reason that, the use of variable in the sequence?
by kumar_s
Thu Jun 22, 2006 7:19 am
Forum: Site/Forum
Topic: ToolXchange?
Replies: 4
Views: 2203

If you pocket is too heavy with many tools, and have urge to upload, I am ready to give my id to receive all your innovative tools.
:wink: Hope not RMM stages :wink:
by kumar_s
Thu Jun 22, 2006 7:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Generate a Sequential file with a header and footer??
Replies: 14
Views: 3418

Or before job subroutine to create a file with header. And append the file in the job with detail. And later cat with the trailer in after job subroutine.
by kumar_s
Thu Jun 22, 2006 2:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to pass NULL to a function in testing phase
Replies: 2
Views: 682

Have you tried @NULL?
by kumar_s
Thu Jun 22, 2006 2:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Append to DataSet - expecting 3 segments, read 4 segments
Replies: 11
Views: 3370

Are all of the sources compatiable with the given layout?
by kumar_s
Thu Jun 22, 2006 2:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IPC stage
Replies: 4
Views: 914

If two active stage are connected to gether, the process are clubbed together. If an IPC is used in mid of it, the both process are mutually exclusive. If you need parallalism, you can use Link partitionor. If you have 64links out of it, you input record set will be processed parallely in all the 64...
by kumar_s
Thu Jun 22, 2006 2:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with APT_STRING_PADCHAR
Replies: 9
Views: 4731

IF you tend to change the default value of the variable after assigning in the sequence, yes it will affect.
by kumar_s
Thu Jun 22, 2006 2:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Filter Stage is Slow
Replies: 4
Views: 888

What filter condition you use?
by kumar_s
Thu Jun 22, 2006 2:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ASCII format showing some low characters
Replies: 22
Views: 5709

Sam - Check the option available in the edition. And try to turn of the "Show space and tabs" option. If enabled will show you spaces, new line character, tabs... It is an additional feature available in the editior. So there is nothing to do with your job. Veiw the same file in unix, with vi option...
by kumar_s
Thu Jun 22, 2006 2:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: phantom
Replies: 3
Views: 844

If this error re occurs for every time, check you transformations and for datatype mismatch if any.
"from previous run...".
This is for PX and not for this edition.