DSXchange

I have scenarion, where I have to join 6 different tables as the source. The joining condtion includes several outer joins and self joins. I am planning to write whole SQL in an ODBC stage which will be the source. Is that the best option in DataStage? Is there much we can do from DataStage? Regards

Any update on this?

let me re-frame my question.

If a job aborts, and then it is re-set, sometimes it shows the reason for error and sometimes it does not .
why is this so?

what are the probable reasons for a abnormal termination apart from some kind of resource constraints in server?

Thanks

Hi If there is an abnormal termination fo a job, after re-setting sometimes it displays the reason for abnormal termination, but sometimes it does not so . Is it like for cases where it dispalys the information on re-setting that for some reason DS could not update the log ,but shows the information...

Hi
Is there anyway to have a user-defined SQL in DataStage without wirting
the select inside a batch i.e. only by using some stage in a sever job.
For instance I want to do a look up based on on a complex SQL involving
joining 3/4 tables , outer join on one and having a decode clause . etc.

Thanks

Hi all

Frankly speaking I have not gone into the details available at this site.
However I have a very basic question , with the introduction of Hawk, will it be essential for DataStage developers to learn Web-Sphere.

Thanks.

Hi

I want to take export of DataStage jobs from command line, but at a Category level.
I could not find an option of passing category in dscmdexport .

Thanks

Another round about solution would be to use an ODBC stage.
In that case you can trap the exact error.
However this is not the exact soultion to your problem.

Thanks Again.

Another quick related question.

If I want to know the full category information i.e main catergory/sub-category etc. for a job which is under 2/3 layers , will I have use the logic find caegory's category OR
there is any direct method or table where this information is stored?

Thanks Arnd

If that is the only option, I need some help as I am not familiar with Selects on UDB. Can you pls provide some more details as how it shud be implemented? Or can you send me document on this..

Thanks a lot

Hi everybody

Is there any function/macro available to get the category name of the job after supplying the jobname.

For Ex. we can get various information about a job by using DSGetJobInfo.
However DSGetJobInfo does not return category information..

Thanks in advance....

I want to read an excel file as source. I have created a DSN for the excel file and created an odbc stage to read that file using the DSN. However this seems not to be working.....

arindami wrote:How can I read a hash file using universe stage?

Thanks to all in advance.

THANKS A LOT , RAY.

However I have done this but in a different way.
What I have done this I have passed this command in the pre-command section of the datastage.
But doing it in that way is not working.....

How can I read a hash file using universe stage?

Thanks to all in advance.