Hi Everyone,
I have a small issue. There is one simple job, which
takes data from an oracle
table and writes the data into a sequential file.
There is one transformer stage
between this 2 stage.
The problem is that we are selecting records from
oracle table based on some
condition. And it's quite possible that because of
that condition the OCI stage
might not return any row, in that case nothing gets
written on the output sequential
file. My requirement is that even if no records is
coming from the OCI stage,
I have to write a dummy records in the sequential
file.
Please let me know how I can achieve this.
Thanks & Regards,
Bipul
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
Writing records into outout stage, even if no records comes
Writing records into outout stage, even if no records comes
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Writing records into outout stage, even if no records comes
Thanks Tony. It worked.
Regards,
Bipul
--- Tony Curcio wrote:
> I would add into your oracle stage a "union all" to
> a query that will create a dummy record (make it
> sort last). In your transformer stage, set a flag
> to identify if you get any more rows. Then when you
> get up to the dummy row, check the flag and see
> whether or not it needs to be written.
>
> ---Tony
> bipul sarkar wrote:
> Hi Everyone,
>
> I have a small issue. There is one simple job, which
> takes data from an oracle
> table and writes the data into a sequential file.
> There is one transformer stage
> between this 2 stage.
>
> The problem is that we are selecting records from
> oracle table based on some
> condition. And it's quite possible that because of
> that condition the OCI stage
> might not return any row, in that case nothing gets
> written on the output sequential
> file. My requirement is that even if no records is
> coming from the OCI stage,
> I have to write a dummy records in the sequential
> file.
>
> Please let me know how I can achieve this.
>
> Thanks & Regards,
>
> Bipul
>
>
>
> __________________________________
> Do you Yahoo!?
> Free Pop-Up Blocker - Get it now
> http://companion.yahoo.com/
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
Regards,
Bipul
--- Tony Curcio wrote:
> I would add into your oracle stage a "union all" to
> a query that will create a dummy record (make it
> sort last). In your transformer stage, set a flag
> to identify if you get any more rows. Then when you
> get up to the dummy row, check the flag and see
> whether or not it needs to be written.
>
> ---Tony
> bipul sarkar wrote:
> Hi Everyone,
>
> I have a small issue. There is one simple job, which
> takes data from an oracle
> table and writes the data into a sequential file.
> There is one transformer stage
> between this 2 stage.
>
> The problem is that we are selecting records from
> oracle table based on some
> condition. And it's quite possible that because of
> that condition the OCI stage
> might not return any row, in that case nothing gets
> written on the output sequential
> file. My requirement is that even if no records is
> coming from the OCI stage,
> I have to write a dummy records in the sequential
> file.
>
> Please let me know how I can achieve this.
>
> Thanks & Regards,
>
> Bipul
>
>
>
> __________________________________
> Do you Yahoo!?
> Free Pop-Up Blocker - Get it now
> http://companion.yahoo.com/
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.