database insert question

[Former Member]

hi

once i insert records from PI into a databse table, on a database level how can the database team know that PI has completed its insertion of records , can they do something on their end to check it ?

Please suggest.

Thnx

[Former Member · Accepted solution]

Hi,

By default there is no indicators/notifications available for specifying the operation completed..

if needed either they can write a trigger at the database table level or if needed you can send email notification to them that operation of insertion is completed(for this need to create one more receiver addition to the jdbc where the mail receiver adapter can be used for sending the notification...but need to use EOIO ...to ensure mail triggers only after insertion completes...)

HTH

Rajesh

[Former Member · Accepted solution]

Suggestions from Rajesh is good but I won't recommend to implement this in PI. The complexity and the performance might suffer, so better to implement some kind of notification at the DB side. Check with the DBA what flexibility they can provide to you

[Former Member · Accepted solution]

was just wondering how can DB team build a notification , how will they know if all records have been inserted.

suppose multiple records have to be inserted, and there is some network delay and some records come in after some time in the table, how can DB team know : inserts have finished from PI ?

Please suggest

[rodrigoalejandro_pertierr · Accepted solution]

asume you send 10000 record from pi, those records are delivered in one shipping, there is no way that somefield reach and some not. thus if you need to parse those 10000 records in 2 delivers. 5000 records will reach and later the others 5000. and DB teams will know cheking if the table is bloked if new records are being saved.

[Former Member · Accepted solution]

was just wondering how can DB team build a notification , how will they know if all records have been inserted.

Check with a DBA, I am sure there is a way of doing it in DB.

suppose multiple records have to be inserted, and there is some network delay and some records come in after some time in the table, how can DB team know : inserts have finished from PI ? 

Either PI will insert all the records or none, which means either the process will be completed or will be terminated.

[rodrigoalejandro_pertierr]

you can configure your SP to trigger an alert when the insert is completed., another posibility is the use of the structure INSERT_UPDATE wich respnse back the number of record inserted or update once the statements finished, by this way you know when the all the data is conpleted loaded into table.

now if they need to execute another query onvce the data is fully loaded, the can create an SP that validate if the table is loked, if not run the query

Edited by: Rodrigo Alejandro Pertierra on Sep 23, 2010 12:56 PM

Edited by: Rodrigo Alejandro Pertierra on Sep 23, 2010 12:59 PM