DSXchange

Welcome aboard! :D Don't have the problem here; running DataStage and QualityStage but not (yet) MetaStage. I wonder if that makes a difference? Also, we're on an AIX server, not a Windows server. Sorry I can't be more help than that. Are you on SP2, and are you aware that there are known issues ass...

Preserve the data file, and be absolutely certain that -850.00 is generated by DataStage. This allows you to isolate the culprit. Make sure that the figure is in exactly the position specified in the control file.

Can YOU answer the OP's question 13?

(Arguably Q13 is the stunned silence from the interviewer resulting from the candidate's answers to the previous 12.)

You can write the routine, the essenceof which is Loop While ReadSeq Line1 From File1 ReadSeq Line2 From File2 ReadSeq Line3 From File3 ReadSeq Line4 From File4 * Adjust the next statement to handle intervening delimiter character NewLine = Line1 : Line2 : Line3 : Line4 WriteSeq NewLine To File5 Rep...

The job you have to export is the one currently numbered 740, not "another job". Then import that one.

My point was that the export does not use RT_CONFIGnnn, rather than suggesting that you should export a different job. Sorry about the confusion.

No. Columns containing spaces will be read as spaces. Can you grab the SQL from the DataStage job and execute in a different DB2 client, to determine what DB2 thinks of the SQL? Maybe use EXPLAIN or any other available profiling tools. The best place to grab the SELECT statement is from the job log....

Beware that variable names are case sensitive. The name of this input link variable is NOTFOUND (not NotFound).

Even I have not been able to figure out the answer to Q13. Maybe there's a case for providing partial answers, and alerting interviewers (via a premium service?) of some standard questions that can be asked, the standard partial answer that is published here, and some follow-up question to test the ...

Are you telling us that there are millions of rows of data to be processed, or millions of rows in the hashed files? If the latter, some gains may be able to be had by tuning the hashed files.

This is a highly skilled task, and I would recommend hiring a competent consultant to undertake it.

Welcome aboard! :D

Learn to use the Search facility here, it can get you answers faster than posting. When you have an error code, as you do here, a search on the error code is likely to prove productive.

Yes, RT_CONFIG740 is so badly damaged - it was probably being written to when the disk full condition occurred - that even CLEAR.FILE won't work. This suggests that it's header block has become corrupted. Export the job (which doesn't use RT_CONFIG740) and import it (which will generate a new set of...

It appears that DataStage is not handling BigInt, and treating the value as Integer (signed 32-bit integer). Check whether this is the case by asking your support provider; the real question is "is BigInt" a supported data type. It wasn't in early versions of DataStage, I haven't checked for some ti...

First off, 30 does fall into the "small and manageable" category. I'd be happy to have a Transformer stage with 30 outputs, given that only one of them is triggered for any input row. WriteNFiles would be called in an output column derivation expression. Argument Line is the line to be written to th...

Great answer, and surprisingly brief. There's so much more that could have been said, but Ken has captured the essence of it. I'd just add one more thing - a decision support system is more than just the collection of data; it's also the corporate knowledge of that data and of how it is used, and it...

Reindexing will not help if one of the hashed files has become corrupted. Indeed, the reindexing will fail to complete successfully in this case. That said, RT_CONFIGnnn is one of the least likely (smallest) hashed files in the repostory to become corrupted. It's only updated at compile time. More t...