DSXchange

Other environments ... but from time to time we get back to good old DataStage :D

No... no way that I know of.

hjob=DSAttachJob("demojob",DSJ.ERRWARN) status=DSRunJob(hjob,DSJ.RUNNORMAL) Unixcmd="/fdev/users/11001/Proc.shl" CALL DSExecute("UNIX",Unixcmd,ScrOutput,RetCode) ErrCode=DSSetParam(hjob,"ScrOutput",ScrOutput) You first run demojob and then you still want to p...

Your mail has some "holes" in it... but let's try. You need to populate a table with fields from a source, the updates have the same primary key but the logic for the calculation is different. And you can't do it in a single SQL, e.g. your groupings are different. 2 SQLs as input one table...

Try the following, should be pretty close to what you want:
Ogmios

One of the reasons I never use ftp stage but always shell out to get the file via an OS script. What you want to do is not in the ftp file stage.

Ogmios

If you look at the DB2 error codes it's an arithmetic overflow.

Ogmios

Not the expert on XMLInput but if I remember correctly you don't read an XML input file with a Sequential Stage :D . You use a FolderStage to point to the XML file and connect that to XMLInput. "There is one crucial design requirement of XML Input - you need to pass it an input link contain a U...

Nothing out of the box exists like that. As of v7.5 you can make a report for a single job from designer (clicking on the button looking like internet explorer on the toolbar). But if you're a bit skilled in any quick and dirty language: perl, python, .... you can easily generate such a list from ds...

I suggested to first check with Ascential/IBM for a patch. For some things they have patches and doing an upgrade from 7.5 to 7.5.1.a seems a bit overkill. Don't know whether a patch really exists. Most of my installations are currently 7.5.1.a and the Oracle stage seems to work correctly in there. ...

The Oracle stage is known to work... not work... work... not work ... on and off since version 4. Best is also to log a case with Ascential/IBM... sometimes they have workarounds/patches available. For the upgrade if you really want to go ahead: - DataStage always has an installation guide. - Going ...

A version that returns less clutter is: SELECT INSTANCE, MODIFIER, DTM, REASON FROM UNNEST DS_AUDIT ON MODS A WHERE CLASS = '2' AND DTM > '2006-04-10 00:00:00' AND DTM = (SELECT MAX(DTM) FROM UNNEST DS_AUDIT ON MODS B WHERE CLASS = '2' AND A.INSTANCE = B.INSTANCE) ORDER BY DTM Fill in the date after...

You can use the following to see changes after a certain date:
I also have some queries to unnest the data in DS_AUDIT, but have to search for them a bit.

Ogmios

For the original question on making it faster. I suppose you're using the ODBC stage (seeing the error messages)... switch to the oracle stage or the DRS one to see a significant speed increase. For DB2 the speed difference between ODBC and the DB2 stage is usually not that big... Between ODBC and O...

djdinjan wrote:Hi all, I had run the command and it said "No such file or Directory".

Any suggestions on how to fix this file.

Thanks,
Dinesh

Run it in the project where the file resides

Ogmios