DSXchange

Do you have any long-running after-stage or after-job subroutines? These, too, can lead to a long time between stage finish and job finish.

DelCnt is a variable set earlier in your code. The Oconv is specifying that the first (DelCnt - 1) "/" characters should be skipped then one pipe-delimited field returned. An equivalent expression is: Field(SrchRslts, "/", DelCnt, 1) Looks like the original developer grew up with P...

Derivations of Fundname1 and Fundname2 would be useful in providing a more exact diagnosis, as well as any other stage variables upon which they in turn depend.

You don't need hashed file cache sharing unless both users are using cache. It is sufficient that both users refer to the hashed file in the same way - that is, same location (whether account or pathname) and same name (correctly spelled and cased). And, as others pointed out, all writes to hashed f...

You can do anything for which there exists a command line in DataStage, either through ExecSH/ExecDOS or through DSExecute (or through Perform or Execute in DataStage BASIC). Whether it makes sense to do so is an entirely different question. For example, you could invoke a script to perform the FTP ...

There's a logical inconsistency in your statement "Job is running fine, but the output file is not getting generated.". That aside, you need to do some detective work to determine exactly where the file may be being written (did you provide a pathname?). Perhaps initiate a search for that file name....

The DataStage Repository is ALL GOING TO CHANGE in the very near future! That's the main reason I'm backing off from advising people how to hack. There is a secondary reason related to the fundamental interconnectedness of all things (in the DataStage Repository) - for example, to change a category ...

The precompiler should pick it up.

Report bug through your support provider.

Entire is "idiot proof" in that all rows of the lookup appear on every processing node. As Arnd suggests, if your source data are key partitioned on the lookup key and your lookup data are partitioned on the lookup key, then only the relevant lookup rows will occur on each partitioning node. But you...

I was unaware that the invocation ID becomes part of the named pipe file. Given that it is, I retract my previous guess and leave you to research what O/S error code 1 means and what might have happened to prevent the file from being created.

Siva's advice relates to server jobs. The way you handle zero-length strings in parallel jobs is different; but the representation of null property in the Sequential File stage is one of them. Once you can get "" into your job, you then have to monitor it right through the job design and either conv...

INTEGRITY, the product that Ascential purchased with Vality and re-named QualityStage, began life on mainframes. This is the reason for the eight-character limit on file names and preference for fixed-width format (just in case you ever want to run your design on a mainframe, it won't need any work)...

I am guessing that this line is the problem. file /appl/dsadm/Projects/CASHDB/QS/Controls/COUNTRY.UCL not found! You've declared a user classification override in the xxAREA rule (or is it xxADDR rule? it's not clear), but somehow managed not to provide the override definition (the file called COUNT...

Project definition is stored in a password-protected MDB file. Did you export (as IMF file) from the one QS project and import into the other?

Telling us it's Number or Decimal alone does not help. You need to tell us the whole story. What are the precision and scale values (a) when you do a DESCRIBE and (b) after importing into DataStage?