Count of Inserted rows

[Anonymous]

Hi All,
I have a job which reads more than 5000 records daily. I want to create a log table which captures job status ( OK/FAILED) , No of Rows Inserted , No of Rows Updated , No of Rows Deleted.
So I can be able to identify the no of rows inserted daily.
Kindly assist how to do this.

Thanks,
Saty.

[Anonymous]

There is no global variable like (Integer)globalMap.get("tMysqlOutput_1_NB_LINE_UPDATED") available if you use tMysqlRow to execute the statements, if you want to count the number of rows are deleted or updated, you have to use tMysqlOutput to do it.

Thanks Shong.Your reply is very helpful. I've understood the usage of these variables.

[_AnonymousUser]

hi,
is it possible to use function inet_aton before inserting data into a mysql database on a col ,if possible can anyone show how to use it and the component used.................

[Anonymous]

Hi banu,

is it possible to use function inet_aton before inserting data into a mysql database on a col ,if possible can anyone show how to use it and the component used.................

Could you please elaborate your case with an example with input and expected output values, which helps us to understand your requirement much better.
Best regards
Sabrina

[_AnonymousUser]

Hi ,
the data file contains ip address like 10.58.25.26 in a column ,in the table for this column i have given the data type as integer . The inet_aton function normally converts ip address to integer value based on some logic .
Since i want the address to be converted into integer i want to know which component can be used to perform this operation while inserting into database table... is it possible

[Anonymous]

hi,
is it possible to use function inet_aton before inserting data into a mysql database on a col ,if possible can anyone show how to use it and the component used.................

Hi
inet_aton is a function of Mysql database, you can't call a SQL function in a Java expression, as a workaround, use a tMysqlRow to execute a query for inserting like this:

"insert into person values ("+row1.id+", INET_ATON('"+row1.ip+"'))"

Shong

[_AnonymousUser]

Hi,

Thank u ... and il check on user routines ....

[Anonymous]

Hi id4dsc,
Thank you for ur post.
i got my query resolved with the help of ur post.
Thanks and Regards,
Anand Yadav