DSXchange

Have you added the DSN to the uvodbc.config file in the project directory?

Perhaps your derivation can include an If..Then..Else test looking for the E and using a different format string for StringToDecimal() function.

What if you close and re-open Designer? It may be that all that is needed is to refresh the client's view of the Repository.

You can look in the Job Properties of the sequence. Any dependent jobs should be listed on the Dependencies tab.

In Engine credentials under Domain management.
Select user in left hand pane, fill in user name and password in right hand pane and click the Apply (?) button.

You can also set up a default mapping for users who don't have a specific mapping.

In Engine credentials you MUST map Information Server user to an operating system user who has needed access to DataStage file system objects.

Welcome aboard. Given that integration with source code control systems is implemented through Information Server Manager I don't see how you can cause a trigger to fire. There's nothing in version 8.7 for achieving what you seek, though the READONLY attribute in the project repository is still hono...

I guess you could define an "external table" in the Oracle database, that refers to the sequential file, and perform the join on that basis.

Other than that, not really.

Your DBA will almost certainly feel angst at transactions of this size. The usual technique is to include column(s) in the target tables that indicate a unique id of the run that loaded them, or of the most recent update, and possibly a timestamp "last updated". Using these columns you can...

Generally speaking Data Set descriptor files have ".ds" as the suffix on their file names. So I'd be building a list that bore that fact in mind. Further, your script implies, but does not show, the for loop that processes $filelist element by element. Finally, you should execute the dsenv...

You probably meant "system variables", in particular @NUMPARTITIONS, @PARTITIONNUM and @INROWNUM.

Follow Kryt0n's advice; it's about the best you can do.

You might like to collect performance statistics and analyse them using the Performance Analysis tool in the Designer client, before and after implementing the "no inserted sort" provision.

Try making the source data type VarChar or Char, rather than float. Floating point numbers can not be fully accurately represented in digital computers; you can read about the IEEE 754 standard to understand why this is. Conversion from string to decimal is far more likely to preserve the actual dig...

This is an example of a case where you may benefit from slightly increasing the buffer timeout value.

It's still related to total load on the machine, but if you can allow the IPC buffers a bit more grace time, you *should* get fewer timeouts.