These activities have their own role in the database transactions:
The JDBC call procedure activity calls the stored procedures of the database.
In order to establish JDBC connection for some activities like java code activity, we use JDBC Get Connection activity.
The JDBC Query activity is used to perform SQL SELECT statement in the database.
The other SQL statements like INSERT, UPDATE and DELETE are performed using JDBC Update activity.
The dynamically built SQL statements or the custom built statements are performed using SQL Direct activity.In other words,the SQL statements which are not supported by the other activities are executed by the SQL Direct activity.
For training on TIBCO BusinessWorks mail us at virtualnuggets@gmail.com