DSXchange

Craig

I got it to work. I doubt if sequences will import because they changed them in almost every release of Ds7.x.

This is one of the routines on my tips page. It has been posted before. * ----------------------------------------------------------------- * GetJobCategory(JobName) * Decription: Returns Job Category. * Written by: Kim Duke * Notes: * --------------------------------------------------------...

The quickest way is to run this SQL. Change SEQFILENAME to whatever you are looking for in uppercase. SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY, DS_JOBOBJECTS.NAME AS OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),'SEQFILENAME',1) > 0 th...

Ray

This is a job except the whole SQL statement is sent to the next job. I was trying to explain it so JobNo, StartId and EndId are the parameters.

Sorry.

Use a filter stage. You could also pass in shell variables as parameters. You could also use pipes.

My tool is stand alone to do what would take the Director and VPN to do otherwise.

I not sure exactly what you are looking for but DsWebMon will start and stop any job from the web. You can view logs and monitor or anything you want. You can get a free 30 day evaluation by going to m You can view the manual or downlaod it at: m m m One DsWebMon can control multiple DataStage serve...

The '//JOB.STARTED.NO' record stores a multivalued list of runs. The first one is the last run StartId = RtLogStartRec<1,1>. The end record is based on the last record in the file which is stored in '//SEQUENCE.NO'. You need to subtract one from this. I did not want to email more than 100 records. S...

Here is the core of it: open "DS_JOBS" to DsJobs else stop read JobRec from DsJobs, JobNameToLog else Call DSLogWarn(JobNameToLog:" not in DS_JOBS.", "JobControl") goto TheEnd end JobNo = JobRec<5> JobCategory = JobRec<3> FileName = JobNameToLog:'_Log' * -------...

Just in case you needed it.

Setup the tutorial and walk through it. Might help.

Oracle REPLACE is similar to EREPLACE and CHANGE in Universe BASIC.

Yes!

You should be able to use a UV stage and write a job to extract from the RT_LOGnnn file to update Oracle. You need a batch job to feed the job number nnn to the UV stage. select * from RT_LOG#JobNo#; You need to trick DataStage to get the metadata. You need to create a q-pointer. It should not impor...

Edit the routines which come with DataStage. Try to figure them out. Ask when you do not understand something.