DSXchange

Do you have a valid license file?

IBM have a product called DataStage (mainframe edition) that can generate good quality COBOL as well as the JCL to compile and run it.

With only 10 rows in the reference data set, this is a perfect fit to use a Lookup stage (unless the rows are each 1M in size!)

Don't have any benchmarks but my experience suggests that well-written COBOL would probably beat DataStage fairly easily. So the question boils down to just how good these COBOL programmers are, particularly with respect to accessing (remote?) DB2 databases.

Can you lie and specify Long VarChar (1024) data type in your job?

It's still a requirement that the reference data set can fit in memory. Does your 10 million+ row reference data set fit in memory?

Can you push the join back into the database, with a BETWEEN condition in the join specification?

No. The leading zeroes are added when the value is displayed or converted to string to show that precision and scale are being handled correctly. The value is correct.

Try running the update installer in console mode. Also make sure that you are using the correct version of the update installer (approx. 176 for Fix Pack 1 - the latest version of the update installed does not work with FP1).

You can't open it with just the URL any more. You need the pathname of the start page. For example www.machine.com:9080/index/login.asp (this might not be correct; I've done it from memory).

Don't have the file open in any other application.

The IBM support portal can usually be found at www.ibm.com/support/xx/yy where xx is your country and yy your language, for example www.ibm.com/support/au/en for Australia/English.

Yes it's possible. Communication is via TCP/IP port number 31538.

Life gets a lot more complex once you upgrade to version 8.

There is not.

Get rid of the database stage to do your test. You will be amazed at what you see.