DSXchange

Not so sure; I have not tested it myself, but...

A quick 11.3.1 Knowledge Center search on BLOB indicates that the Oracle Connector, Teradata Connector, DB2 / DRS all support BLOB, but not ODBC. They suggest to use the DataStage data type of LongVarBinary.

If the day number is always fixed at '01' then you could still use Iconv() to convert to an internal number and add 31. The result would always be the next month. Use Oconv() to convert the result back to an external date format, and then discard the day number and concat day number 01. Iterate unti...

Welcome to DSXchange. That is just a license warning that you should safely be able to ignore; the ODBC drivers do not expect that anyone would ever want to test a new connection from the command line, hence the warning. :lol: I always test new ODBC connections from the command line first before tes...

Is your soapUI testing run on a Windows client or on your UNIX DataStage server? Testing this type of problem needs to be done from the server. Usually timeouts indicate firewall blockages. If you are certain you have the firewall open, and you've tested the IP and port using telnet from the UNIX se...

Now there are two topics about the APT_IMPORT_HANDLE_SHORT environment variable. :) That's great news about the sort optimizations. Also on the topic of 11.3.x surprises (possibly 9.x too): If you go with the IBM XLC C/C++ compiler (at least this is true on AIX), beware of installing the compiler ve...

Use the dsjob command with a primary command of -run along with the -queue <queue_name> option.

You can view all the command options by executing dsjob by itself.

You can view all the primary command options by executing dsjob -run by itself.

Yes, due to the timing, the simplest way to have all existing jobs pick up the project level auto-purge setting change would be to export and re-import everything. There are several posts on this topic.

You're welcome. Come back from the "dark side" already...

The 7.5 docs are getting scarce. I am wondering if the SoundexName function is home-grown, unique to your shop, or if it was built in. There are no matching search results on the ibm.com site.

If it is the 8.5 Client tier only, then you can install that onto Windows 7 Professional, Windows 7 Enterprise, or Windows 7 Ultimate. Not Home Edition.

System Requirements link:
http://www-01.ibm.com/support/docview.w ... wg27018823

Ditto on using the workload management feature. Create a queue with a job limit of 15. :D

Good find.

Just be aware that changes to shared containers do not affect the jobs that reference them, until after you recompile such jobs.

Yes, you're missing the path to the dsrecords executable. Prefix the program with its full path.

There is more than one way to do it. What have you tried so far, and which part do you need some help with? Please be specific.

I would assume that you would not need an isadm user on the engine tier, and it should run fine that way. There was probably a dsadm user created on the engine tier. By default, the isadm user is created internally, in the internal user registry, and not on the operating system. In the web console, ...