DSXchange

hi,

How are you scheduling your jobs? Is it through command line program or directly on to Datastage director?

Thanks & regards
Sudhindra P S

hi,

Thanks for responding to the query I had posted earlier. It will be nice if you could share your resolution with us.
Am yet to resolve this issue, if I could find anything I would let you know on the same.

Thanks & regards
Sudhindra P S

hi Ray/Chulett, We have IBM Information Server using which we would be exposing Datastage jobs as WebServices. I have few PL/SQL stored procedures which I need to invoke during each stage from Job initialization to job completion phase to update Scheduler database. The flow of components invoking me...

hi Chulett, We are using Organization wide built in Scheduler to schedule ETL jobs as WebServices. This scheduler application is built upon .Net and Oracle applications. I need to update this Scheduler Oracle database "before","during" and "after execution" completion o...

hi Ray, I have undergone training under you sometime back. That was really an excellent one I would say. I had designed an similar strategy before where in I could make use of Shell Script to do the activity of invoking PL/SQL stored procedure using Execute command stage or by using Shell script as ...

hi All, 1) Can anybody please tell me which technology would be the best one to use as wrapper for ETL jobs exposed as webservices? 2) Does core Java programming language provide better performance when used as Wrapper for ETL jobs which are exposed as webservices? 3) And lastly can anybody please t...

hi All, I have a requirement where in I need to invoke PL/SQL stored procedure 3 times. i.e. I need to invoke a stored procedure before I kickstart a job(Sequence), during sequence execution (thatz when control passes from one ETL job to another ETL job within the sequence) and lastly after the comp...

hi,

We are basically setting up connectivity between Server and client machines for which we require configuring ports for easy network traffic. Can anybody help in identifying which all ports I need to select.

Thanks & regards
Sudhindra P S

hi, I just need to configure ports between Datastage Server and client tools. Can anybody suggest me on to how can I choose ports for effective network traffic between Datastage server and client machine. Here are few ports which are listed below. Can anybody suggest me which all ports I need to con...

hi Edward, I would suggest you to write a shell script to carry out this activity. Do the following steps using shell script 1) make use of "awk" functionality so that you can break file name in to different pieces based on "_" as the delimiter. 2) Then make use of "mv"...

hi DSExperts, Many thanks for all of you in providing me tips in such a nice way to achieve desired results. Atlast am able to achieve output the way I required. Chulett, I just had to call $QRY in double codes--->"$QRY" and it worked fine. Kduke, Please find query modified as below to han...

hi Chulett, Thanks for the info you have provided. Am able to execute query but, it is throwing some syntax error as mentioned below. Could you please help me out in trouble shooting this error. --------- Command Executed--------------------- /apps/Ascential/DataStage/DSEngine/bin/dssh SELECT NAME||...

hi Kduke, Thanks for providing before hand caution on double quotes in the query. When I execute Query using either 'uvsh or dvsh' it is not getting through. It says "uvsh:is not found" and "dssh:not found". Could you please suggest what else should I take care in my shell script...

hi Arndw, Many Thanks!!!! The link which you provided is very helpfull in achieving list of job names by executing below mentioned SQL command through Datastage Administrator. [b][color=brown]Could you please further guide me on to how I can fire this query from my shell script and take its output i...

hi All,

Am running Sequnce from a Unix Shell Script. [b]I need to generate list of job names belonging to an sequnce dynamically in a shell script[/b].
Can any DSExperts, please help me in how to obtain jobname list?

Thanks & regards
Sudhindra P S