DSXchange

Hi All I have a job with two reference input links to one transformer. The first reference input link takes its key value from the stream input. The second reference input link takes its key value from the first input reference link. The UI didn't allow me to drag and drop this arrangement, and now ...

Thanks for the input guys.

This isn't a user-written function, it's a supplied function I found in the documentation, but which apparently doesn't exist (thanks Ray for confirming that).

FYI The documentation I found it in is online help on DataStage 5.2.2.

Thanks

Dave

Doh! Sorry...... abstracted it a bit and managed to put another bug in. The real error is this..... 0611 ReturnValue = DSWaitForJobList("Add", singleStreamJob, 1) ^ ',' unexpected, Was expecting: '!', ')', '=', "AND", "OR", "LT", "LE", "GT"...

Hi Everyone I've been having some trouble trying to get the DSWaitForJobList function working, which results in the following error: 0610 Return Value = DSWaitForJobList("Add", singleStreamJob, 1); ^ Variable Name (UNDEFINED) unexpected, Was expecting: ';', End of Line The documentation su...

The job inserts rows, it doesn't update any. It inserts one row into a number of tables for each one input row.

The destination database tables each contain the correct amount of rows and the correct data. However, the log reports that _less_ rows have been written than is actually the case.

Stage variables work great inside the transformer. However, I also use DSGetLinkInfo in the controlling job to find out how many rows are written to the database, and update my keys and config file appropriately. The value I get returned here is sometimes correct, and sometimes not. On the occasions...

Yep, that worked well. I still don't really understand why the DSGetLinkInfo function wasn't returning me the values I was expecting, but the job now works fine.

Thanks

Dave

Yes, the idea is to have a single common variable and increment it across all of the links.

Thanks for the tip re: performance, I'll put everything into stage variables. I'll still need to use the DSGetLinkInfo function though within the stage variable?

The problem with @OUTROWNUM is that it returns the number of rows going out of that specific link. I have 4 links, one of which has less rows going out of it than the other 3. So @OUTROWNUM will not return me the correct value for this link.

Hi all I have a transformer which uses the following code to increment a key for each row processed through several of the output links: CMStart+DSGetLinkInfo (DSJ.ME,"Transform","boCM",DSJ.LINKROWCOUNT) "Transform" is the name of the tranformer; "boCM" is the...

Hi Optico

Thanks very much for your post, that answers me perfectly.

I will probably follow your advice and use an additional job to read and process the file.

Thanks again

Hi I'm looking at recovery techniques for cases such as DB failure, a DS crash and so on. I intend to write an informational message to the log file intermittently to reflect the progress which a job has made. Can anybody tell me if I can then access the log file outside of Director (ie. is it writt...