DSXchange

No, each line needs to be commented.

Please post PX questions in the PX forum.

If you have just the value in a file, I would prefer using "cat" in a sequence command stage to get the value into a variable, and then passing that value as a parameter to your PX job and using the parameter to seed the surrogate key stage.

Yes, the semicolon is used to put multiple commands on one physical line of source code. I use it all the time for commenting inline:

If the input argument is NULL then it is not equal to "".
But if it is "" then it will execute taht code and exit the routine. The RETURN statement should read RETURN({value}) to be correct, though

I don't know if I'd aspire to be Dumbledore -doesn't he get ETL'd and loaded to the big database in the sky?

The DSParams lookup will show the project level default settings, but jobs can override this at runtime so that value may be incorrect. The best way to check is to look at the second log entry as DSGuru2B has already stated.

Bertrand - in this case the ROOT refers to a .dsx DataStage object, i.e. the SUBRECORDs point to RECORD object as the root, and isn't referring to a UNIX "root" owned file. Here the parameters are being declared and point back to their job. Narsi1111 - Could you explain you solution? I'm afraid I ca...

Lol, now you've given away our location. Perhaps we can pretend that "Griffin House" is a code name

Actually, it does sound like a name that comes from a Harry Potter book.

I assume you mean BTrieve by Pervasive. The Windows product ships with an ODBC driver.

See This page on Pervasive's site

Martin, can you check to see which actions are performed on your PC at startup? One of the causes of these automation errors in Windows is if a DLL is overwritten. If you have some enterprise type of software control it might "detect" some DataStage library as being invalid or older and overwrite it...

I prefer it when a column is not nullable; if there is a choice then I always recommend not allowing null values. This simplifies database queries and storage. But as you have pointed out, there are many legitimate cases where a null value should be used. Trying to avoid a null in those columns is a...

None of those lines liste have invalid syntax. Is your error reproduceable and does it have the error on the same line each time?

swades - the APT_DISABLE_COMBINATION switch is used in this case to help locate the stage that is causing your problem. But there is no need to do so, since your original error is telling you that it occurs in the ODBC stage. Is this the source stage? What are your column definitions? At least one o...

Craig, I think the DSXchange frequent poster points system for you is as follows: 10K - Letter via 2nd class containing 1 (silver) lick-on sticky star that you can adhere to the top left corner of your monitor 15K - 2nd silver start, plus an e-mail from www.greetingcards.com that sings "Congratulati...

saur_classic. I'm amazed that you are amazed that nobody has answered your question. As volunteers the members here mainly suggest paths to try to analyze problems. In addition, your job as a developer also includes testing different settings to see if you can find the cause. It might be less amazin...