DSXchange

Ray, I went through the forum this ..solution posted by Kenneth. I tried out that. But Cmd = "cat /clocal/ivp/dvlp/tmp/Param.txt":"|cut -c2-5" Call DSExecute("UNIX", Cmd, Output, SystemReturnCode) Ans = Output * Setup Test7Job, run it, wait for it to finish, and test fo...

Ray,

Then how do I accomplish this :

I have a sequencer. It loads a Seq file. I use the data in the file as Parameter in next Job in sequencer.

I thought before Job Sub routine should be good .

Thanks
Sumeet

Hi, I have routine where I open a seq file..read the content and pass it as a parameter to the job. So basically this is the Before Job Sub Routine. I have couple of questions : 1> it gives an error during compilation-- 0046 ^ End of File unexpected, Was expecting: Array Name, Variable name, New var...

Thanks Ray for letting me know.

I had the same idea but the manual misguided me a bit.
So I am going for Before Job Subroutine.

Thanks
Sumeet

Ray,

I thought so but , still its not picking the param, even when I remove the space.

SHould I try doing it from a Before sub routine.

Thanks
Sumeet

Hi, I am trying to pass a parameter to the job through Job control. But its not taking the parameter. ErrorCode = 0 ParamName = 'PHID' * ParamValue = PH02 JobHandle = DSJ.ME JobName = DSGetJobInfo(JobHandle,DSJ.JOBNAME) ErrCode = DSSetParam (JobHandle,ParamName, PH02) Call DSLogInfo('SetParam ErrCod...

hi gateleys , There is a problem with this design. I had done the same thing but if we dont make date1, date2 as keys then the hash file will give out just one record. Infact when we are populating the hash file , only one record gets populated with just the DUMMY field as key. This is a common thin...

Hi , I went ahead with mentioned in previous post. I tried both the ways ..with UV stage and with regular hash file. But the YR_MONTH which I am getting is same for all the records. I know why this is happening. I have created a dummy key in hash file using @outrownum/KeyMgtGetNextValue(). But I am ...

Hi , I had to do a range lookup ,so I followed what has been mentioned in other posts i.e. use UV stage and I ran into the following problem. Source has column : Src_Date Hash File--> UV stage has : date1 , date2, Yr_Month My objective is: if Src_date is between date1 and date2 pull the Yr_month . N...

gateleys , I tried it just now, and it worked . What I did was I made col1,col2,col3,col4 as key in the Hash file, where its getting populated. then when I viewed the data in UV stage with none of the col marked key , the data seemed to be perfect. I tried with keys in UV stage and they worked fine ...

Hi gateleys, I load the hash File from Seq File. And that is what I did..I saved the metadata in Hash file and loaded it in UV stage. Still it was giving the metadata mismatch. ANd that is where the problem comes the positions of columns ,when vied from UV stage, seems to have changed. Thanks Sumeet

HI , I populated a hash file in job1. I tried to open that hash file through UV stage but when I try to view the data it gives MetaData mismatch. And some columns are missing and some columns have shifted. Data veiwed from Hash File col1 col2 col3 col4 col5 M 198905 1989-05-01 1985-05-31 26 M 198910...

HI , I populated a hash file in job1. I tried to open that hash file through UV stage but when I try to view the data it gives MetaData mismatch. And some columns are missing and some columns have shifted. Data veiwed from Hash File col1 col2 col3 col4 col5 M 198905 1989-05-01 1985-05-31 26 M 198910...

Hi, We have jobs which has environment variable file -- "dsenv". Now we want to run the same set of jobs with different environment variable file -- "dsenv1". The jobs are called from parent sequencers which are in turn kicked off by a shell script(command line). Is there any way...

Hi ,

In Server Jobs if we dont clear Hash file. what happens to it during the next run to the file.

Is the Data in Hash file from previous run purged or it keeps on appending the data to previous file.

Thanks
Sumeet