DSXchange

ray.wurlod

There's no public domain documentation. These tables were originally built using the UniVerse RDBMS (the original engine for DataStage). When IBM purchased UniVerse but had not yet purchased DataStage, the two engines shared the same code base, and have diverged only a little since. UniVerse RDBMS i...

ray.wurlod

I'm surprised by your assertion. Both ExecuteCommand and DSExecute() are synchronous operations, so should wait. Is the batch file one that starts, fires off some background processes, and returns quickly?

ray.wurlod

Every node you add increases spot processing load (number of processes). That's the main "parameter" you need to consider. Too many nodes can be counter productive. For a silly example, eight nodes to process one row equals seven idle nodes, but the processes all still need to be started. ...

ray.wurlod

Changes made in Administrator will only affect jobs created subsequently.

To change existing jobs, use Job > Clear Log in Director client.

ray.wurlod

I did the installation. They were supposed to change the Analysis Settings. Thanks for catching that - I'll follow up with them.

ray.wurlod

Asterisk works for me. How are you quoting the literal string?

ray.wurlod

Code: Select all

(Auto) ::=  Round Robin if sequential -> parallel
            Entire on reference input to Lookup stage
            DB2 on input link to DB2 stage of any kind (parallel execution)
            Same if parallel -> parallel

ray.wurlod

Welcome aboard.

What you seek to do is not possible in a server job.

ray.wurlod

Is there a vast number of table definitions, perhaps stored in a bazillion different folders in your repository? They are displayed in sorted order; sorting them may be taking much of this time.

ray.wurlod

I'm not sure. Create one and check. I'd imagine not.

ray.wurlod

That's a purely Cognos question. I don't know the answer. I'd imagine it's possible. But not using Information Server components.

ray.wurlod

0x20 is 32 in decimal. You should have used Char(32) rather than Char(20), but " " is actually more efficient. None of these will handle ASCII NUL, however, which is Char(0) - and is not the same as NULL (unknown value).

Code: Select all

Convert(" ", "", NullToEmpty(MyFieldValue))

ray.wurlod

That could be counter-productive, and probably as fraught as the Indian government's stated intention to block any internet web site that contains "inappropriate" content. This is clearly a movable feast; what's appropriate today, or to one political party, might not be tomorrow or to a di...

ray.wurlod

Maintain SEQNO in a stage variable. Use other stage variables to detect change in BUSS_UNIT. Increment SEQNO only if BUSS_UNIT changes.

ray.wurlod

You could try generating the entire SQL in a previous (server?) job and providing it to your loading job as a parameter value.

Search found 53125 matches