DSXchange

My understanding is that you would have to install 9.x onto a server and go with default port numbers in that installation.

It is probably possible. Contact Support to request a procedure.

My understanding is that you can avoid specifying the port number only if you installed using the default port number.

You mentioned you had installed a Hana client on your AIX server. Have you tried connecting from the AIX command line, via that client, with the same ID and password, with success? The ODBC error you got looks pretty generic, so it could be caused by any number of things.

That sounds like really bad performance. I would be curious if you tried any of the above suggestions and what you found out from those.

There is no RLVIEWS in my 11.3.1 XMETA database (yet?)... My repository uses the bundled DB2. I also did not find any such references in any *.sql file from the install media. There are, however, plenty of SQL comments "-- DataStage operations database: create reference/lookup tables & view...

Try a test where you do all processing possible in job1 and write the output to a data set. In job2, read the data set from job1 and truncate and load into DB2.

Sometimes less is more.

Thanks for clarifying!!

Great suggestion! Thank you.

This will not directly answer your question, however...

Are you aware of the derivation substitution feature? You can, for instance, select multiple columns (dozens or hundreds), right-click, and apply the same derivation to all selected columns in a single step.

Is it possible to perform two-source probabilistic matching in real time with: - data source: real-time request, one record at a time, via web service call to a job we deploy as an ISD application - reference source: Oracle (akin to an Oracle sparse lookup, knowing that the reference records can be ...

Try the following:

1. Output from command "uname -n"

2. The config file fastname, for each node, should match the above output

3. The /etc/hosts file should contain one or more hostnames (short and/or long versions) that match the above output and resolve to the same IP address

abc123: The 2nd format tag is more accepting than the first... Please read my answer a few more times, test it yourself, and compare the results you see with the documentation about the format tags.

1. Does the downloaded driver file name actually contain an extra "a" that is not in the example from the instructions? 2. Are there any differences in file sizes, owners, groups, or permissions, as far as the mysql driver file(s) go? 3. Does your .odbc.ini header section have a line for t...