DataStage ETL question

From: shinwar <jshinwar_at_yahoo.com>
Date: 3 Oct 2002 13:49:07 -0700
Message-ID: <77e5857.0210031249.1656d1a3@posting.google.com>

Hoping anyone might be helpful to answer my DataStage(DS) ETL question. Sorry for posting this in Oracle site. Because I do not know if there is any site focus on DataStage discussion. My question is:
I have a sequential file with simple SQL statements. Inside DS designer, I put a Sequential stage to read this sequential file. And, this stage is link to another OCI stage which is for Oracle.

SEQstage --------------> OCIstage

So, OCIstage supposed to execute any SQL coming on from SEQstage. Somehow, I could not succeed in doing so. I do not know what is the problem. I tried OCI with fixed SQL before. It was all fine. Now, I do not know how OCI should handle variable SQL statements. Please advise me. Thank you.

Shinway Received on Thu Oct 03 2002 - 15:49:07 CDT