DSXchange

Try "echo %DATE% %TIME% > filename.dat"

Umberto,

just as with date /t you can use the time /t command to get the current time output in dos.

If you used the metadata for the table "pippo" in your job design, you can go to the Manager and right-click on the table definition and do a usage analysis to get the list of jobs that have used that object.

Vincent - the poster is pointing DataStage at the .c source file, not the library object.

It was just a "fyi" about a capability in the DS product overall, that a memory cache lookup does exist. In this case I'm really not sure how so address the requirements and this grouping into units of 4 coupled with a PX process is confusing me a bit as well.

sendmk,

If "IsDuplicate" and "LastKey" are stage variables and are declared in that order with IsDuplicate coming first then the output won't always be 1. But the output will be 1 if the order is reversed.

Balki,

fyi - the dynamic lookup cache option you mentioned has a counterpart in DataStage server hashed files with the system level caching mechanism and hashed file creation and lookup options. But I don't think that this feature is a the core of the thread here.

Gokul, this is a bug that should be reported to your support provider. Most likely the solution is going to be that this functionality is going to be explicitly disallowed, since it will be a lot of work to duplicate the distributed memory mechanism in a memory file. I would not hold my breath waiti...

Of course you can do this. Add the column in a transform stage and fill it with values according to your logic. It isn't declared in the source (since it doesn't exist there) but created as part of your job design.

You can pass it any string value you want; including "0".

32Bit means exceeding a 2Gb limitation on file sizes; this applies to your Hashed file. I would have expected DS to abort with a write error, but it could also cause the job to abort in the background but still show a status of "running". Have you been able to see if the job "hangs" after loading th...

Does the job actually terminate if you send it a STOP request from the Director? If that works then you could write another job that waits (n) minutes, checks to see if the status of the other job is still RUNNING and issues a STOP request to it. If a STOP doesn't work then it becomes more complicat...

dj, please re-read your post and mine. You are getting the error message because the column doesn't exist - my response was intentionally facetious in that it only solved the symptom and not your problem and I did not intend you to follow it. Creating an unused column doesn't fix anything - you need...

hello dj352001,

There is very high likelihood that the error message and your missing column are related. You can get rid of your error message in DataStage by going to your database and entering "ALTER TABLE {tablename} ADD COLUMN {the invalid columname} VARCHAR(32);"

Create an empty directory in that location pointed to by the UV.ACCOUNT, then execute a 'dssh' and create an empty account using ideal compatibility.