DSXchange

Hi Ray, Thanks you Ray, that is really great. I got the log summary log but as you told from the huge data that it gives i want only the part of the text data that describes wether the jobs is "sucessful" or "aborted" or "sucessful with warning" and if so aborted/Warnin...

Hi Ray, I am attaching the code for your perusal. $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF ErrorCode = 0;* set this to non-zero to stop the stage/job ReportType = 0 LogEntries = 0 DirName = InputArg Suffix = ".txt" JobHandle = DSJ.ME JobName = DSGetJobInfo(JobHandle,DSJ....

Hi Ray, Thanks you. See yesterday i had created an routing which gives the details fo the job (Job name, start time, end time, elapsed time, rows read, rows written, the status of the job) and along with that i have created a array variable to collect the DSLogSummary data in the routine but it is g...

Hi Ray, What are the basic requirments that you need to acess the table through UV db, i am tried careating the metada of the same that you had given but i was not able to get the select work sucessfully, it was showing error saying the LOG_RT26 (this is a log table for a paraticular job) is not ava...

Hi, Thank you, what you told is correct but I have a doubt in this, if you give it in the after stage routine will it execute for reach row ?. Regards, Rajeev Prabhu If there is a transformer stage before this ODBC stage, then you could wrap up this update SQL in a shell script and call it as an aft...

Hi,

See i want to get the log of each job and that can be taken form RT_Log table, first how will i be able to get acess to this table and what are the settings that are to be done to get this details.

Regards,
Rajeev Prabhu

Hi Kim, I am using the routine code that you had given in your site to generate the short desc of the log and Last warning of the job, how do we get the data or where do you write this data to, so that i can take it and use it. Are you writing the data to a file to some other table. Regards, Rajeev ...

Hi Ray, If am using the DSGetLogSummary, to get the log details how do i get the details, should i write a routine ?. Regards, Rajeev Prabhu You can create a DataStage job that retrieves the log information using the metadata I supplied to retrieve using either a UV stage or a hashed file stage. If ...

Hi,

I want to write an update command on a table in before job routine in ODBC Stage, is this possible. Like in Oracle Enterperise stage there is Before and after SQL queries.

Regards,
Rajeev Prabhu

Hi Ray,

What type of C++ compiler ?.

Regards,
Rajeev Prabhu

ray.wurlod wrote:You will also require an appropriate C++ compiler on the UNIX machine. Do you have this?

Hi, Suppose, we have unix server (Solaris) and DS license for unix. How do you compile and run the jobs ?. [Till now we have not got the DS License but Unix server is ready, we are wating for the same]. Also we have another senario, i.e till now we were working on Server jobs, now since we can do th...

Hi,

I have developed a job in Parallel and i want to compile and run it, how can i do it, i understand that Parallel jobs can be compiled and run only by unix so how can i do it.

Regards,
Rajeev Prabhu

Hi Ray, Yes my development envioronment has been setup in Unix platform, and i am using Oracle 9i stage. Where do we find the dsevnorinment variables in ds. Regards, Rajeev Prabhu So, your 'OS' is really UNIX with error messages like that, yes? :? Also, what Oracle stages are you using in your jobs?...

Hi, I am having a simple job which takes data from Ms Acess using ODBc and puts it into a sequential file, when i run the job i am geting the folloing Warining, Job_ERROR_RUN..Sequential_File_4.DSLink5: nls_map_buffer_out() - NLS mapping error, row 1 (approx), row = ""ODBC_SEQ_LOAD=1"...

Hi Mandyli,

I got it done. Thank you.

Regards,
Rajeev Prabhu

mandyli wrote:Hi Rajeev,

use the following code in your routine. it will reset the job & run.

AuditHandle = DSAttachJob(" your Job name " ,DSJ.ERRNONE)
RunErr = DSRunJob(AuditHandle, DSJ.DSJ.RUNRESET )



try this.


Thanks
Man