DSXchange

ray.wurlod

Start by disabling operator combination so you can learn which stage (operator) is actually throwing the error.

ray.wurlod

I don't have one. That's why I told you to search DSXchange.

ray.wurlod

How about DataStage SQL?

Code: Select all

DELETE FROM DS_JOBS WHERE NAME = '\\\\Jobs\03 DATAMART\16 LCD\Sequencer';

Part of the problem is that the backslash character can also be treated as a quote character.

ray.wurlod

Not true, because Cognos is not part of the Information Server suite. You have to manually import Cognos reports, queries, BI models and physical models using a bridge.

ray.wurlod

Not true, because Cognos is not part of the Information Server suite. You have to manually import Cognos reports, queries, BI models and physical models using a bridge.

ray.wurlod

Use Metadata Asset Manager (version 8.7) or istool (earlier versions) and one of the IBM Cognos BI Content Manager bridges. There are three, one for all components, one for models only, one for reports only.

ray.wurlod

You missed the quotes.

Code: Select all

DELETE DS_JOBS '\\\\Jobs\03 DATAMART\16 LCD\Sequencer'

You can also use a Select List

Code: Select all

SELECT DS_JOBS WITH NAME LIKE "...16 LCD..."
DELETE DS_JOBS REQUIRE.SELECT

ray.wurlod

How was the hashed file created?

What does its VOC entry look like? To find out:

Code: Select all

LIST.ITEM VOC 'hashedfilename'

ray.wurlod

Duplicate link names are permitted provided they don't connect to the same stage.

ray.wurlod

Note that, in the first syntax (overwrite the multivalued field completely), the angle brackets and commas are part of the syntax.

As with any ANSI-standard SQL, non-numeric values need to be surrounded by single-quote characters.

ray.wurlod

Yes, I do, and I daresay Ernie does too. The Query functionality is very clearly explained in the online help, in the Information Center, and in the Metadata Workbench User manual.

ray.wurlod

There are two syntaxes - one that completely overwrites the multi-valued field and one that inserts a new value into the multi-valued field. The first is INSERT INTO tablename (@ID, mvfieldname) VALUES (keyvalue, <mv1,mv2,mv3>); The second uses dynamic normalization INSERT INTO tablename_association...

ray.wurlod

Auto-purge is not triggered if the job fails. Auto-purge is only triggered if the job status is "Finished" or "Finished (see log)".

If you're an Administrator you could temporarily unprotect the project.

ray.wurlod

Please mark the thread as Resolved using the green button at the top of the screen.

ray.wurlod

Some UNIXes allow a positive argument to the head command, for example head +5 filename (this would be your filter if you have that capability).

Search found 53125 matches