Re: DataStage ETL question

I won't bother to ask why, since DS Designer can include sql statements as before or after stage actions, you are using a sequential file to 'feed ' the OCI stage, or why you do not just write a shell script to do the Sql .. Please indicate how you pass the variables to the sequential file ... I am not sure that the method you describe is a supported technique, but, without more info, I can't be sure..

BTW. have you contacted Ascential's excellent support folks?  

jshinwar_at_yahoo.com (shinwar) wrote:

>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

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Mon Oct 07 2002 - 10:02:39 CDT