DSXchange

How many fields are actually returned in the dynamic array? DCount(Result,@FM) What's happening in the eighth field? You talk about the first seven, then the ninth? I'm wondering why. What is the source of the column definitions on this link? Hashed file or some other source that uses positional add...

How, precisely, is this an Information Analyzer problem?

They have provided no means to delete these jobs. They do not exist because there is no design. Therefore the DataStage deleter program can't find them, because this is what it seeks first. Push IBM. It can be done manually, but I prefer that they tell you how; that way you can't sue me if something...

DSJobName in the job sequence would be the name of the calling sequence. You ought to be able to select this macro in the expression editor when building the parameter-defining expression in the job activity that invokes the other job sequence or job.

Windows XP is not a supported platform. The licensing documentation you received when you purchased the software should have mentioned this. One can get DataStage Enterprise Edition to work on Windows XP but one would never get support for it. Parallelism is about processes. You can even run small e...

I was reading some administration documentation this week. A particular backup script designated a .out file to log the output from the process. I assume this was a typographical error, as it named the file, bacfkup.out (sic, hopefully). I suppose if things do not go well, it might be an apt moniker...

The answer is, indeed, no but meaningfully named stage variables can make this much more maintainable. For example instead of C1 use IsNullFoo, etc; so that your final test expression has the form IsNullFoo : IsNullBar : IsNullBlah Remove the final semi-colon using an appropriate substring. In anoth...

Stream input from table A into Transformer stage, reference inputs from table B and table C. Construct your output column derivation expression according to your logic, remembering to take into account that the "not found" condition will return NULL.

What happens if you specify null field value property as 000 ?

There are four different ways rounding can be done. These are all supported by the r_type option to decimal-handling functions. Study the section of the manual that describes r_type, then find an appropriate conversion function, maybe DecimalToDecimal().

IA analyses require huge amounts of scratch space. My guess - and I don't know for sure - is that viewing logs or monitoring jobs exacerbates the total demand for disk space on the server to a point where it fills the disk. This would especially be true if you used the default configuration file sup...

I don't have a version 7 system at the moment. Can you try these commands? LIST.ITEM UV_SCHEMA WITH SCHEMA_NAME = '<<Project name>>'; LIST.ITEM UV.ACCOUNT WITH @ID = '<<Project name>>'; You could, of course, look at the date/time created of the project directory or of the VOC file within it.

The information is in UV_SCHEMA. But the SQL identifiers (such as table name) are case sensitive. Make sure UV_SCHEMA is in upper case.

sqlldr is non-transactional. Therefore commit is irrelevant.

All Information Analyzer tasks are run as DataStage jobs (the osh is generated directly by IA, there is no graphical job design generated) in the ANALYZERPROJECT project.