DSXchange

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

Yes, did the same.

It is again most likely due to the version of compiler mismatch.

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.

If you were give the cobol layout, use Complex Flat File. It is worth to build a Cobol layout if not given.

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.

Add a userdefined variable PWD in DS Administrator which points to your project folder.

Yup, thanks. Server edition should also need all datastageenvironments to be set. Sorry i was carried away with something else.

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.

Do you initially have any partiton and sort on the key on which the aggregation is done?

BTW do we have dsenv in Server edition?

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.

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.

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

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

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