DSXchange

Profile Stage? No, that's a completely separate (and different) product. For processing files with the same structure, there are at least a couple of different options: 1) Concatenate them all together 'before job' and process them all at once. 2) If you have the 7.5.x version of DataStage, leverag...

Yah... wasn't that one of their older albums - "Selling Man Paste by the Pound"?

Yes, there is a DSJobStartTimestamp macro: "date and time when the job started on the server in the form YYYY-MM-DD HH:MM:SS".

The date and time the job started doesn't change, so use the Initial Value of the stage variable to capture it once instead of on each row. The blank derivation of the stage variable means it retains its value over the course of the job. Then you just simply reference this value for each row going i...

Create a Stage Variable.
Put Macro(s) in the Initial Value field.
Leave the Derivation of the Stage Variable blank.
Use in your output link.

I saw that! :D

Anyone know how to see who makes up the team?

Actually, "too busy" would send a different error, a -14.

Best to post the entire message. More than likely it's as Arnd noted.

Before a job runs, is it that the ds system will check if the hash file resource is there in the given directory? Then only it runs the job. Since the hash files are created during the job run and that I have emptied the hash directory prior to run, could this cause the error? Depending on your exa...

Also, if this is coming from a Link Collector which it looks like it might, then double-check that all links into the stage provide the exact same metadata.

It's more a test of your patience right now.

Saying that 'performance is slow' with your delete query is pretty much meaningless without alot more information. You can have the 'fastest' delete query in the world that uses PK fields, but if there are many indexes on the table and/or RI to other tables, than deletes can still be slow... but wil...

Yes, as Arnd notes you'll need to use a datatype of LongVarChar (and a large size) in order to stand a chance of making this work. Make sure you keep the array size at 1 or at least raise it at your own risk. The other 'trick', if you know the data in the CLOB that you are selecting will fit in a Va...

Mmmmm.... man paste.

ASAP help would best be found by using the Search functionality of the forum.

DataStage server jobs work in a typeless environment using DataStage BASIC as a programming language. There is no direct mechanism for accessing C or Java. Actually, there is... for Java. It's a separate purchase, but you can buy the Java Pack which will allow you that 'direct mechanism for accessi...