DSXchange

Ok.added the column to the table. Made more progress but stuck at this point. I ran the prrequisite for DsJobreportdriver . ExtractJobStatusSeq - creates ./Staging/JobStatusStg.txt ->worked b. BuildJobStatusHash - used as lookup in this job ->worked as well. I tried to run DsJobreportdriver .This ra...

interesting.... In my Job I found the sql as INSERT INTO ETL_LINK(PROJECT_NAME, JOB_NAME, LINK_NAME, LINK_TYPE, SOURCE_IND, JOB_CATEGORY, AVERAGE_ROW_LENGTH) VALUES (?,?,?,?,?,?,?); where as in the oracle etl link table has only these columns SELECT a.project_name, a.job_name, a.link_name, a.link_ty...

I have progressed further and this is what I got. LoadEtlJoblink failed with the following error. LoadEtlJobLink..TransDsJobLinks: |LoadEtlJobLink..ETL_LINK.ETL_LINK: DSD.BCIOpenW call to SQLPrepare failed. SELECT PROJECT_NAME,JOB_NAME,LINK_NAME,LINK_TYPE,SOURCE_IND,JOB_CATEGORY,AVERAGE_ROW_LENGTH F...

ok i have made some progress but far from making it to work. When I run Seqjobstatus it finished. Now when i try to run the sequence Seqprepare etl stats it failed .The job BuildHashParam in the folder ETL_Job_Params has aborted with this message DSD.SEQOpen Failed to open DwMaster.ini in directory ...

No, Iam looking to create a routine which I will be calling in the end of a sequence. So in that case the server routine can take multiple parameters correct?

I am trying to create a routine which will take arguments as job name, start timestamp,end timestamp and will write the log to a file whose name will be jobname_starttimestamp_endtimestamp.
Thanks for your time and guidance.

heres my another try DEFFUN OpenSequentialFile(filename, openmode, writemode, logevents) CALLING "DSU.OpenSequentialFile" $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF Ans = 0 hJob = DSAttachJob(JobName, DSJ.ERRNONE) RealJobName = DSGetJobInfo(hJob, DSJ.JOBNAME) If RealJobNam...

my subroutine just assigns return code and logs.
I guess I am messing up the gile closing and end else...i cannot figure it out.
any help is appreciated.

<modified>

I am writing this routine to write job log to a file.The routine was working when tryin to display on screen.when i changed ot rite to a file it is giving me compilation error.Any pointers appreciated. 0027 On Error ^ End of Line unexpected, Was expecting: '!', '=', "AND", "OR", ...

Thanks for your quick response. I followed the video steps .
I compiled all the routines.2 routines failed.they are KgdArchiveLog and KgdTestSendMail.
But I am stuck here.

I am on ds 7.5.1A.I am having issues getting etlstats to work. Thease are the steps I followed. 1.I downloaded ETLStats. 2.Ran the sqlscripts on oracle db. 3.Imported dsx files. 4.edited the email scripts to remove kdukes adrs. 5.compiled all jobs. 6.After compilation I get these errors -Compiling: ...

sprase look up worked as sugested

Yes, it is a server routine.I wrote a server job to call this routine.Thanks for all your help.

Thanks girija very much for your response.
I did both changing datatype to bigint and put quote = none.
now the job works.

appreiate your help.