What is "Use NB_LINE_" drop down for on TOracleRow

Anonymous — Tue, 25 Sep 2012 11:42:04 GMT

This option is missing from the TOracleRow documentation (up to 5.1). What it appears to do is allow the global map variable for the component?
If it's useful why isn't it on other TdatabaseRow components?

Re: What is "Use NB_LINE_" drop down for on TOracleRow

Anonymous — Wed, 26 Sep 2012 04:42:50 GMT

Hi, g.e.davies
Sorry, this option is not documented yet, well, I think it will be done soon in next releases
1. toracleRow is used to execute a query, for exmaple: "delete from person"
2. Use Nb_LINE is used to count the total number of records have been proceed.
3. When this option is set to NONE, there is no a global variable for counting the total number of records have been inserted, updated, or deleted.
4, when inserted item is choosen, there will be a global variale such as ((Integer)globalMap.get("tOracleRow_1_NB_LINE_INSERTED")) will be avaible, which counts the total number of records have been inserted into database.
5. the same to updated, deleted items
let me explain it more detaily, if you are execute a query "delete from person", and this option is set to deleted, a global variable ((Integer)globalMap.get("tOracleRow_1_NB_LINE_DELETED")), will counts the total number of records have been deleted.
Many components have global variable, such as tFilelist, tFileOutputDelimited, tMysqlOutput
Best Regards
Sabrina

topic Re: What is "Use NB_LINE_" drop down for on TOracleRow in Talend Studio

What is "Use NB_LINE_" drop down for on TOracleRow

Re: What is "Use NB_LINE_" drop down for on TOracleRow