DSXchange

That new Repository Management functionality in the Web Console for Information Server that Ernie mentioned has specific function for identifying and removing duplicate table definitions from the repository.

string[20] is Char(20) - DataStage will right pad. If you use string[max=20] (which is VarChar(20)) the trailing pad characters will not be applied. You will always get leading and trailing non-significant zeroes that indicate the full precision and scale of the decimal number - you can remove these...

At least one file per resource disk mentioned in the node pool that the Data Set stage is using from the configuration file. More than one file if the operating system limits file size (for example to 2GB). More than one file (potentially) if you append to the Data Set.

Please explain more fully, with examples, what "does not work" means in this context.

you can find the configuration file in the following path "opt\IBM\InformationServer\Server\Configurations" This is not correct on two counts. First, UNIX interprets the backslash character as escaping the next character, so opt\IBM\InformationServer\Server\Configurations would become opt...

What ever happened to the requirement for RANK?

Can you make sure that the routine is compiled?

I'm not sure that that's possible. Look at the Data Elements associated with MQ Series. I suspect what you'll have to do is to read the entire message, identify and discard the header and keep the payload. But you will also need to make sure that the message is of the appropriate type.

The only limitation of which I am aware is that the target column must be VarChar data type.

Cue "Twilight Zone" theme... An IPC stage (theoretically at least) is no more than a visual manifestation of inter-process row buffering - it's only there to allow you to use buffer sizes and timeouts different from the job default. So why one of your jobs works and the other doesn't is a ...

Some column names and other properties have changed in the database tables. Attempting to re-import the table definitions does not appear to pick up the changes. Is there a way to pick up the changes without deleting the existing table definitions in XMETA? We have a lot of FastTrack mappings and In...

Andy, that's the Information Server administrator.

Changing DataStage administrator is simply a matter of giving the suite component role "DataStage and QualityStage Administrator" to the new user (and maybe revoking it from the old).

Only if you combine the triplets of columns into single columns (then back again into separate columns after pivoting if needed).

This parameter does not affect server jobs.

Sainath.Srinivasan wrote:If you are only interested on the .ds file, you can rename it in Unix itself.

That is ill-advised, because the segment files' names on the resource disk include the descriptor file name.