DSXchange

Hi Arnd, I exported as .dsx a simple job and looked at the underlying code. Now, if I were to parameterized just the database, user and password, I would be looking at the following section of the code- BEGIN DSRECORD Identifier "V0S42" OLEType "CCustomStage" Readonly "0&quo...

We have tons of old jobs where variables such as database, user, password, etc were hard-coded. We now need a mechanism to automate the process of parameterizing each of these jobs. One of the ways would be export all these jobs as XML and parse the files for the variable and replace them with the d...

Anyone!! to help me with the above error??

you should use "DSJ.PARAMLIST", as the documentation specifies. Hi Arnd, I did just that and I could test the function successfully. However, when I use the routine as RoutineActivity stage in a job sequence, and specify a jobname as one of the argument to the function, then it aborts wit...

Ray, I have supplied both the arguments to the DSGetJobInfo function- ParamNameList = DSGetJobInfo(JobHandle, DSJ.ParamNameList) and also- JobStatus = DSGetJobInfo(JobHandle, DSJ.JOBSTATUS) Is there a problem in DSJ.ParamNameList? Further, if you have a look at my code, it only has about 50 lines, s...

I think you need to add DSPrepareJob. Regarding including DSPrepareJob, it is part of the code you supplied. If you look at the code above, there is a line included- DsErrCode = DSPrepareJob(JobHandle) Now, when I test the this function, I get the following message: Program "DSGetJobInfo"...

You could replace every job activity with this as a routine activity. Hi Kim, I will try that. I dont have access to DS right now. While we are at this, I want to put another question across. Like I mentioned above, that the parameters in the sequential file were of the format- paramName=paramValue...

I have my parameters in a hashed file. The key is the paramName. In plaintext, it was in the format below- paramName1=paramValue1 paramName2=paramValue2 and so on.... I have tried to use Kim's routine to assign parameters to my job. Following is the code: * ------------------------------------------...

Thanks Chulett.
For some strange reason, it was not there in my client. However, I looked it up in another client and it was available. Will use that, else may have to reinstall my client.

gateleys

Can anyone provide me the UV code for the CRC32 function? We have DS7.0, and it doesn't seem to have the function. I would appreciate the help.
Thanks.
gateleys

Hi ! I think my example has misled you a little. I want to be able to select the First Rows only for a given Site.. Irrespective of the Date. ie., If the file is Site Date Qty ------------------------------------ A 2006-02-17 1300 A 2006-02-16 1500 A 2006-02-18 1200 Then the output should be Site D...

Naveen- Here you go... Source Record (File) -------------------- Source ID Gender State Cntry_Code ----------------------------------------------------------- SRC1 Male Nebraska United States RuleTable(DataBase) -------------------- Source ID Source Value Cleansed Value ----------------------------...

I have designed my job sequences as suggested 'somewhere' in this forum. In short, the failure of any job is handled by 'Otherwise' links to a Sequencer stage (set to ANY). Further, the failure is notified, and the RoutineActivity is called to force fail the sequence, with the name of the sequence p...

Thanks Arnd.

I have the same constraint for outlink1 and outlink2. Now, I have 2 simple ways of enforcing the constraint- 1. Specify the same in the constraint field of outlink1 and also in outlink2. 2. Or, I could declare a stage variable, svMyConstraint, whose derivation field contains the constraint. And, the...