DSXchange

So if you can read from the Excel ODBC then the connection and sheet format is correct. Is your write SQL automatically generated or user-defined?

No worries, but I had to state it, since if IntSvar = 3 then evaluates to true when the integer is converted to a string and get the value "3"

Amey - if you use a stage variable that is integer and involves and implicit conversion, then you need to compare to the constant 10, not "10" ; for that reason I kept the substring and compared to a string constant of "10" to avoid unnecessary datatype conversions.

If you can't get it working in Oracle using an Oracle SQL tool then chances are very high that you won't get it functioning in DS, either.

What is the query you are using and what goes wrong with it?

I think you can use "sysctl" in RedHat but an not sure.

Your user process can only open 1024 files at a time; I'm not sure if the error message is the same, though. Your user stack is pretty small as well.

Simpler since both input and output are strings.

No, the Job Control is only executed 1 time regardless of the APT_CONFIG number of concurrent nodes. Also, you need a "body" in PX jobs (although a dummy row generator to a copy stage is sufficient)

Now I need to use the adage Ray always does : "Define Performance". In order to optimally start setting up a machine you need to know the type of box (CPUs, Memory, IO Ports, Disks, etc.) as well as have an inkling of what sort of ETL load is going to be used. Is the DB2 database on the same machine...

Can you read from it using COL1 and COL2 in a test job?

what does "ulimit -a" for your datastage user show? And what setting for NFILES in your sysconfig?

No, the Job Control is only executed one time before the body of the job is run, so there is no need for any parallelism.

This system limit needs to be reconfigured if too restrictive. What UNIX do you have?

Nivas - a .csv file is not the same as a .xls file; the OP is using ODBC to populate the Excel sheet directly.

No, deletion of jobs and categories can only be done through the clients.