Search found 5168 matches

by kumar_s
Tue Aug 08, 2006 9:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Excecute command activity
Replies: 15
Views: 5250

ray.wurlod wrote:Put echo in the command field and #TextToEcho# in the parameter field.

Yes, did the same. :cry:
by kumar_s
Tue Aug 08, 2006 8:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compile error in Transformer
Replies: 9
Views: 3548

It is again most likely due to the version of compiler mismatch.
by kumar_s
Tue Aug 08, 2006 7:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to get number of working days in a month in SQL
Replies: 12
Views: 4485

You have WeekdayFromDate() available in Datastage. Returns the day numberof the week from the given date. You can use this to identify the whether the given date is week day or week end.
by kumar_s
Tue Aug 08, 2006 3:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Neeed help in converting Packed decimals
Replies: 7
Views: 925

If you were give the cobol layout, use Complex Flat File. It is worth to build a Cobol layout if not given.
by kumar_s
Tue Aug 08, 2006 3:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Excecute command activity
Replies: 15
Views: 5250

Passing parameter in the parameter field also faild in my case with simple echo statement.

echo "DataStage" gives the output, not if "Datastage" is passed as parameter. :shock:
by kumar_s
Tue Aug 08, 2006 3:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compile error in Transformer
Replies: 9
Views: 3548

Add a userdefined variable PWD in DS Administrator which points to your project folder.
by kumar_s
Tue Aug 08, 2006 2:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dsjob executable
Replies: 8
Views: 5403

Yup, thanks. Server edition should also need all datastageenvironments to be set. Sorry i was carried away with something else.
by kumar_s
Tue Aug 08, 2006 2:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in PivotPX Stage
Replies: 1
Views: 934

If this is only with the pivot stage, check the permissions. Try with dsadm.
make sure teh files pivotenu.so and pivot.so under $DSEngine/lib have necessary permissions like -r-xr-xr-x as minimum to the group of dstage.
by kumar_s
Tue Aug 08, 2006 2:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Agg,1: Hash table has grown to 16384 entries.
Replies: 9
Views: 25291

Do you initially have any partiton and sort on the key on which the aggregation is done?
by kumar_s
Tue Aug 08, 2006 2:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dsjob executable
Replies: 8
Views: 5403

BTW do we have dsenv in Server edition?
by kumar_s
Tue Aug 08, 2006 2:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DATSTAGE EE 7.5.1.A and oracle timestamp format
Replies: 1
Views: 770

I tried to do it with varchar format
You need to convert it before loading into the table. Either through to_date() function available in oracle, or the inbuild funcions available in datastage.
by kumar_s
Mon Aug 07, 2006 8:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Excecute command activity
Replies: 15
Views: 5250

I did another test for passing parameters for Executecommand activity in Version 7.0 Server edition, as once said by Craig, the value is been passed correctly without any warning or error, but the command is not executed correctly.
But the hardcoded value gives the desired output.
by kumar_s
Mon Aug 07, 2006 5:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lookup in server job
Replies: 2
Views: 1093

At this stage, we all will suggest you to take up any training in Datastage. And go through the documents given as pdf in the client machine. You can find that under, Start-->All Program--->Ascential DataStage--->Online Manuals. Just to aid you, the second link added as the input to a transformer in...
by kumar_s
Mon Aug 07, 2006 5:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: could not able to do in flat file
Replies: 6
Views: 1422

Aha... When we delete the a post created by us, it really doesnt reflect in home page. The count remain the same. But gets reflected in this page. At times i ll find, a post with an answere from some one else, before mine in just a mater of seconds or minutes. So I use to delete those post, but not ...
by kumar_s
Mon Aug 07, 2006 4:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Excecute command activity
Replies: 15
Views: 5250

Yes you can parameterize the path in Executecommand Activity stage.
And what is the compilation error. Post the error.