DSXchange

Hi Ray, Thank you. I added the header file and then changed the j to J it got compliled sucessfully. My first Routine is sucessfull. Thank you once again. Regards, Rajeev Prabhu Your original problem was casing. Function names are case sensitive. The function name you wanted was DSAttachJob. The fun...

Hi, Thank you. We will modify and execute it. Regards, Rajeev Prabhu You might want to have a look at the following code. Originally this design came to me on a Datastage BASIC course that Ray Wurlod took (Thanks Ray :lol: ): ************************************** * Run Job: PocketSportsMasterContro...

Hi, I am new to Routines in DS, i am trying to write a routine which will reset a job and will make it available to run. The routine that i have made is as follows: h$V0S0 = DSAttachjob(Arg1,DSJ.ERRNONE) If (h$V0S0) Then hErrcode = DSRunJob(h$V0S0 , DSJ.RUNRESET ) End I am getting error as follows: ...

Hi,

I am calling UtilityRun Job from a transformer, which should execute the jobs one by one. But i want to reset the job first and then run the job, can you give me a solution.

Note: I cannot reset the job mannually.

Regards,
Rajeev Prabhu

Hi, We have developed some jobs in oracle 9i, but later on we developed the jobs in deelopment server which had 8i. When we run the same job in this machine we are getting the error as follows: ds_loadlibrary: error in dlopen - Dynamic Error ORACLE8_LOAD_ACCOUNT..Sequential_File_4.IDENT1: DSD.StageR...

Hi, I am having 32 jobs, in which i will be generating the Dsjobreport into a folder, i am having another job wich takes data from the folder which contains the DsjobReport and will take into our format. My doubt is that in Job Sequencer, cani call the second job after completion of each job 32 time...

Hi, I have created a job which takes data from a file which gives you job name, started and ended time of job etc. I want this to be used by multiple text files. The job is like this, source file (SEQ.) will contain the output of DSjobReport for a job, and from that i will be taking only the needed ...

Hi Ray, I have done as you have told, but i had missed out the constraint, but now i am not at all getting the output in the target sequential file. But when i remove the constraint, it is comming the col_1. Rest of the columns are comming blank. I have taken a print screen of the same, i would like...

Hi Ray, Yes there is a firewall, i think we will have to enable that port in the firewall. Thank you. Regards, Rajeev Prabhu Is there perhaps a firewall? The DataStage RPC servicce listens on port number 31538 and the DataStage telnet service listens on port number 23; you may need to open these. Is...

Hi Ray, I did as you told i am getting the out put as follows: " ************************************************** STATUS REPORT FOR JOB: ODBC_SEQ_LOAD Generated: 2004-12-03 11:50:25 Job start time=2004-12-03 11:50:23 Job end time=2004-12-03 11:50:25 Job elapsed time=00:00:02 Job status=2 (Fin...

Hi Ray, It is showing the following error when i try to select the project name after specifying the host id, "FAILED to connect to host :172.27.194.32,porject:UV (The host name specified is not valid,or the host is not responding). Yes i tried to ping it is pinging sucessfully. When i try to c...

Hi, I am having a job which calls the DSJobReport, it gives us a text file and it contains the status of the job, and when i view the data i get it in a single format, like as follows: ************************************************** STATUS REPORT FOR JOB: ODBC_SEQ_LOAD Generated: 2004-12-03 11:50...

Hi Kim, I got all the jobs that you have given in the link, but can you explain how i can start working on this. And how can i go forward in comiling this. Regards, Rajeev Prabhu You could download EtlStats.zip from ADN or my tips page. It posts all the row counts to tables in the warehouse but you ...

Hi Ray,

Yes i have put all the users to a group.

Regards,
Rajeev Prabhu

ray.wurlod wrote:Have you put the user(s) into the group?

Hi Kenneth Bland, What you specified is correct, but we don't get Parallel jobs during creation of ne jobs. That means we are creating server jobs only. Regards, Rajeev Prabhu Okay, so you took your Unix license and used it on a Windoze platform? That enables Parallel as a job type when creating a n...