DSXchange

Hi Eric, Thankyou for the response, yes we are suing HP-UX. As you told i checked the path of both DS and that in environment. The path details is as follows: DS PATH: /usr/bin:/usr/local/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/aCC/bin:. Envorinment PATH: /var/opt/ascential/scripts:/sbin:/usr/sbi...

Hi, Through Datastage, the shell script having Oracle Connection is throwing one error. The same shell script is working fine directly through Unix. Although, independantly the Oracle is working fine throuth datastage, yet the shell script with the Oracle is not working. The shell script is working ...

Hi, Thank you. Regards, Rajeev Prabhu Start with learning the Sequencer. There's a tutorial on the CD, as well as ample documentation. Start but creating a Sequencer job and adding a job activity stage. You'll quickly grasp how the Sequencer can run a job, as well as reset it if necessary. You'll be...

Hi, Thankyou for the reply. Can you guide me how we can use a Sequencer or Batch job do the controlling of the job. In advance thanks. Regards, Rajeev Prabhu No, it is not fine. A job cannot use job control APIs on itself, you need to either use a Sequencer or a Batch job to do the controlling.

Hi,

Thanks to all your reply, as Chullet and other told it was error in the Shell Script, we were using KSH command which was not required, i removed that and it worked fine, Thank you.

Regards,
Rajeev Prabhu

chulett wrote:Consider your nit picked.

Hi, I have a major doubt regarding Job sequencer in Parallel Extender, but currently i am developing jobs in server mode and later planing to migrate to Parallel mode (when the environment is ready), and this sequencer is working fine for server mode. I have a doubt that does Parallel Extender suppo...

Hi, I have a job which calls a shell script "del_indicator.sh " in the after job subroutine, the job is getting executed with Warning error and the error is as follows: ODH_INDICATOR_FILE_JOB..AfterJob (ExecSH): Error when executing command: /opt/dsadm/del_indicator.sh /opt/ascential/DataS...

Hi K C Bland, Sorry, for puting the requirment as immediate. Thankyou for the reply also. No it is not after job routine that calls the reset job but after completion of the job once again we are checking the status and reseting the job through the Routine and running the job once again. Hope this i...

Hi, See we have to query on a table that has be executed every 2 minutes and check the jobs which has taken more time than usual and if the the time taken is more than the usual time we have to send a mail to the enduser saying that this job has taken more time than usual. It is not necesary that it...

Hi,

I have a job which has to be scheluded every day and which should run every 2 minutes, is this possible. According to my conclusion is that this is not possible. Is there anyother way that i can implement this requirment.

Regards,
Rajeev Prabhu

Hi, I have a doubt regarding DS routines, i have created 2 routines (one is to get the log details of the job and second is to reset the job) in server job environment, can the same routine be reused in 7x Parallel Extender, i came to hear that we cannot use the same in PX, is this correct, please g...

T42 wrote:Do it within a SQL statement.

Do you mean to say by giving Begin and end statement, i tried this also that is also not working.

Regards,
Rajeev Prabhu

Hi, I want to call an stored procedure from Oracle 8 OCI stage, i called the procedure in the Before SQL as follows: call TEST_SAN2(); But it showed me the following error SAMPLE_ORACLE_CALL_PROC..Oracle_OCI_8_0: ORA-06576: not a valid function or procedure name I tried executing the procedure from ...

Hi, Can you tell me how did you call Procdure in Oracle OCI stage. Regards, Rajeev Prabhu You might want to consider using an OCI stage, or better yet (if on 7.5) the Stored Procedure stage. I tried OCI stage, and it works. But is there any disadvantage if I use OCI stage instead of odbc stage?

Hi Ray, In the adminstrator settings i have not set any value of Inactivity Timeout for seconds, and i have checked the checkbox for Do Not timeout. This imply's that it should not timeout at anytime, am i correct or this is the reverse way. Please clarify my doubt. Regarding the Firewall, does it c...