DSXchange

Check both spelling and casing of the parameter names you use.

Use the expression editor or parameter helper to select them, rather than typing parameter names. Typing is the principal source of typing mistakes.

Hi Ray, I can use Wait for File Activity.But my problem is that the file name is not fixed.E.g. the Control File names can be 'GL_CONTROL_FILE_EGF.txt','GL_CONTROL_FILE_XYZ.txt','GL_CONTROL_FILE_PQR.txt' etc. And there is no fixed sequence in which the files would come.sometimes 'GL_CONTROL_FILE_EG...

It's possibly even better than being local; DataStage hashed files can be cached in memory, so that the fast key-based access (via the hashing algorithm) is at least three orders of magnitude faster than disk-based access.

In DataStage the term is "hashed" file, not "hash" file.

I have never used a naming standard file. MetaStage can successfully import from an ER1 or XML file produced by ERwin; so maybe this is a path you might travel?

You can only specify sort on the input link(s) to a stage. On-link sorting and Sort stage perform exactly the same sort function, using a tsort operator. However an explicit Sort stage gives you better control over the amount of memory allocated for sorting, and to specify that the data are already ...

Depends when you ask. Versions for AIX and Linux have been released, I believe we're still waiting for the other platforms. The delay is primarily one of logistics - getting enough media created for each platform, and keeping them separate to reduce the chances of the wrong media being sent to anyone.

For only a few cents per day you can purchase a premium membership that allows you to see the premium posts in full, and helps to fund the bandwidth required to sustain DSXchange. Maybe your employer would buy it for you. There is a link on the home page to a page on which corporate discounts can b...

All versions up to and including 5.2 use UniVerse.

Version 6.0 of DataStage was the first not to use UniVerse as its engine.

Good. Now please tell us which stage type you are using for DB2.

If it is the DB2 Enterprise stage, please advise the values of the Write Mode and Write Method properties. If you are using SQL, please also post the SQL query and identify which columns in it are Date data type.

Not the job that does the lookup; the job that populates the hashed file. Is there a Transformer stage between the OCI stage and the hashed file stage in the part that populates the hashed file? If not, put one in. The most probable cause for not populating the hashed file intermittently is that no ...

Please post the entries for "castle" from .odbc.ini and from uvodbc.config file.

Did you restart DataStage after editingthe .odbc.ini file?

Why not just use a Wait For File activity to do the waiting, then a simple expression to extract the substring wherever it is that you're going to use it. Are you on 7.5 or an earlier version? If earlier, then maybe you need a Routine to do the substring. As to why the difference in wait time, that'...

Welcome aboard. :D (The term is "hashed" file, not "hash" file.) When the hashed file is not populated, what row count is reported through the job? Is there a Transformer stage in the job? If not, put one in, even though it does nothing. Then you will be able to isolate the problem to "0 rows select...

You must read every byte in a sequential file to get to the next byte. Therefore you must read every field. But, if you look carefully, you will find that each column as a "Drop On Import" property - you could set this property for all except the two fields you want to read.

Did you try to use the StringToDate() function in the SQL, or upstream in the DataStage job in a Transformer stage?