DSXchange

2.If we update the the source file of lookup (eg oracle table,or asequncial file )how it will visible at the lookup dynamically? DataStage does not update your lookup table automatically. If you are using a hashed file you have pre-populated this with an image from the target table. As the job runs...

<arcane stuff>That character is actually an Icelandic "thorn" character. It's used in some other languages, such as Old English and Old Norse.</arcane stuff> This character is how a field mark (@FM) is represented in some data viewers including, it seems, your DataStage data browser. Multi-line desc...

You can access Excel via an ODBC driver for Excel. However, such a driver does not ship with DataStage; you will need to source one from elsewhere.

Otherwise you can generate a text file in any format that Excel can open, such as a CSV file.

You can use message handlers to either suppress or demote warning messages to informational.

These are set up within the DataStage environment. The easiest way is to right mouse click on the warning itself, then choose to create a message handler from the pop-up menu.

Not if you had (bought) two licences.

... or DROP columns

Search the forum for UNLOCK

It's do-able with awk, but not in a single line - you'd need an awk script to loop through the arbitrary (or even fixed) number of sets of coordinates. So you may as well go with any kind of script.

DataStage does not impose any limit on record length in sequential files.

However, the underlying operating system may do so.

"Hire a competent consultant" is the fastest solution! :D "Get some training" is the next best, and better for longer term maintainability.

Virtual Data Sets only exist in parallel jobs. They do not exist in server jobs. The original post marked the job as a server job.

It's not an error message! It is technical metadata that indicates that the column is not indexed. It's in the description column so should not have any impact whatsoever on your job design. That there are mark characters in the description should be OK. I do not know why this error is appearing. Th...

The pid does exist - it's just that you're looking for the wrong thing. Each connected client establishes a dsapi_server as its agent process, and that may fork a dsapi_slave process. The problem with your job design, however, is more likely to be locks in the Repository database than processes. If ...

You'll always get the warning (since the Aggregator stage uses dfloat internally and you can't affect that), but you can create a message handler to demote it to an informational message. Or you can declare the output column to be a dfloat, and modify it back to integer somewhere downstream, as Kuma...

1. in real time senario lookupss are very large in size(GBs or TBs). I such a case how Datastage can manage the storage in main memory. No. The maximum size of a cached hashed file is 999MB. If you were to use DataStage Enterprise Edition, then you could use a virtual Data Set (or Lookup File Set) ...