I want to make sure people understand you can use these queries in a job. You need to use a UV stage instead of a hash file. You may need to put the SQL all on one line. I noticed I could not execute a multiple line SQL statement in BASIC. Try it and let us know.
I would love it if someone would take array size and EtlStats and show a comparison to rows/sec and array size and transaction size. You could automate extracting this data and storing it in a table. We as a group need to know the optimal array size and transaction size. I think there are a lot of other factor which may impact these like database and network traffic. Row size should also effect rows/sec. It would really be cool to get mb/sec. I posted a routine to calculate row size from the metadata. So it is possible.
DataStage Engine commands?
Moderators: chulett, rschirm, roy