Hi,
I created a tdbinput
then a tPerlRow
then a tdbOutput
the 3 objects are linked via main link input->perlrow->output
in the tperlrow i calculate the values for the output
il all works fine
But somethimes i would like to say to tdboutput not to write anything
to perform this i wrote the tperlrow so that it gives to the tdboutput the () value ( @tPerlRow_1=() )
i would like to let dbinput not to insert anything if the row in input is ()...
is it possible for me to modify the automatic code generated adding a if (@tDBOutput_1) before the push?
Or there is some other way?
thank u
You can't know in the tPerlRow if it's the last iteration. But you can do it another way: instead of trying to know if it's the last iteration to perform a specific action, use a tPerl with a "trigger, run after" link, as illustrated by the screenshot.
Hi,
I would like to be able to run the following oracle commands within Talend. Is there a way?
drop table contr_catalog_newcols;
create table contr_catalog_newcols as select * from contr_catalog
where M_PRICE <> '-10.00%';
--add columns
alter table contr_catalog_newcols add
(mb_client_product_id varchar(100), mb_online_customer_price char(14));
commit;
--for product
--find m_clientproductid
update contr_catalog_newcols set mb_client_product_id=trim(substr(m_product_id, 1, instr(m_product_id, ':',1,1)-1));
commit;
update contr_catalog_newcols set mb_client_product_id=trim(m_product_id) where mb_client_product_id is null;
commit;
and then I can do my regular mapping
thanks,
bob
I was able to solve my own problem by trial and error. I eventually tried enough combinations and came up with an oracle error of ora-01003 which let me to use a tJava with several tOrarows and that did the trick for me