Search found 5168 matches

by kumar_s
Fri Sep 08, 2006 9:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: conerting a decimal(12,3) to decimal (9,2)
Replies: 4
Views: 1924

DecimalToDecimal should work. you have some option in Modify stage as well. I dont have access to DS right now to get you the right info. But you can optionally convert it to char and trim the 0's it if required and convert it back to decimal.
by kumar_s
Fri Sep 08, 2006 9:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage EE 7.5x2
Replies: 8
Views: 1571

Give another chance thorugh safe mode.
by kumar_s
Fri Sep 08, 2006 9:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Concatenate issue
Replies: 9
Views: 2144

Hope you are not getting confused with the new line character seen through a special text editior.
by kumar_s
Fri Sep 08, 2006 9:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UserDefined Query Delete statement
Replies: 11
Views: 2950

You can also map it in series, tranformer-->DB-Delete-->transformer-->DB-Insert.
by kumar_s
Fri Sep 08, 2006 8:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Record level properties
Replies: 5
Views: 1026

If it is fixed width, whats the point having delimiter, or the vise versa?
Can you give some example.
by kumar_s
Fri Sep 08, 2006 8:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Persist Generated File Infile..Row_Generator
Replies: 12
Views: 4105

Alright, I was carried away with "sqlldr failure".
by kumar_s
Fri Sep 08, 2006 8:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem while using parameter in the exe command activity
Replies: 4
Views: 1328

It is something like a path for the shell to be called, you can use it in command field as well. But you can always check with the echo #parameter# in the command field.
And look at the director log to ensure the parameter value is getting utilized.
by kumar_s
Fri Sep 08, 2006 8:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RowCount from the DSGetLinkInfo always return zero
Replies: 20
Views: 6587

This is to Monitor your row count. To turn it on, you have the variables in Datastage Admisntrator client.
Something like, DISABLE_JOBMON under monitor. Set it to true. Some other relevent parameters are APT_MONITOR_TIME and APT_MONITOR_SIZE.
by kumar_s
Fri Sep 08, 2006 8:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Persist Generated File Infile..Row_Generator
Replies: 12
Views: 4105

Pls dont hijack the thread, Create a new post for this purpose.
by kumar_s
Fri Sep 08, 2006 8:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage cross references
Replies: 5
Views: 1462

Each job will create its own BASIC code, but still you have set of hashed files, where it acts as a common repository for the metadata of datastage. Where the guys who answere above in your post were very much expert in extracting the required data from it. Generally it is not suggested.
by kumar_s
Fri Sep 08, 2006 8:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lookup Question
Replies: 15
Views: 3163

Sort-Merge-Transformer combination will also work.
by kumar_s
Fri Sep 08, 2006 8:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lookup Question
Replies: 15
Views: 3163

So Sort based on "Key" as well as "date2", but "date2" in reverse order.
by kumar_s
Fri Sep 08, 2006 8:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage EE 7.5x2
Replies: 8
Views: 1571

If you are using the same, it shouldnt be a problem unless some of link is been accessed some where. First make sure the Datastage services are not running. Then try to uninstall from control pannel.
Also give a search for 'Ascential' or 'Datgastage' in Registry and clean it up if required.
by kumar_s
Fri Sep 08, 2006 8:21 am
Forum: IBM QualityStage
Topic: Imcomplete Record Read from File
Replies: 6
Views: 2141

Were you able to view the data?
by kumar_s
Fri Sep 08, 2006 8:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Rejected row
Replies: 6
Views: 1363

Is this the only warning?