DSXchange

Any chance the formatting of the postings could be preserved instead of stripped off?

Thanks!

Here is some code that would be in your Job1 job: hJob1 = DSAttachJob("LoadJob", DSJ.ERRFATAL) ErrCode = DSSetParam(hJob1, "TimeAfter", TimeAfter) The first argument to DSSetParam is the handle of the job. The second argument is the parameter in the LoadJob job. The third argumen...

I agree with Craig, but would add: convert the non-packed fields using the ASCII() routine all together as opposed to individually. It will be much faster. Separate the layout by packed and non-packed fields and for each non-packed group of fields that are together in the layout use ASCII() on the w...

The error message "Object variable or With block variable not set" is from Visual BASIC. I suspect a DLL conflict on the server. They are hard to track down. You might check with Ascential, but it probably isn't their fault. Other ideas: 1. has the server been rebooted since the install? Y...

The first thing I would check is that all of the parameters sent to the PROCESS_DATA routine are assigned to variables within the routine. The variables should be worked on, not the parameters.

John

We had something similar happen here although we are using version 4.2.1r8 on W2K. We fixed it by using the Administrator and testing the username and password on the Schedule tab of the project. It seems DataStage 'saves' this name and uses it when the scheduled job runs. You might give it a try. J...

1. VOC is short for vocabulary. It is a repository of 'things' the underlying database engine knows about (jobs, routines, etc.). There is one for each project. 2. You use the same jobname in DSAttachJob as you see in Designer. If you have released jobs (ie. [jobname]%rel[release number]) in a proje...

Correction to previous reply -

the key should be build like: key1 : @TM : key2

John

I have not done exactly what you are trying, but I know the keys of a compound key hash file are separated by a text mark (@TM). You might try building the key like: key1 : @TM key2

John