Receiver jdbc design
I did around fifteen intewrfaces and all have receiver jdbc communication channel.
we are using same receiver jdbc com channel for all interfaces, is it fine? all are working fnee as of now
again, I am doing insert operation in all intrerfaces.
So the client said they need some interfaces to be updated with data. I am using update_insert in those but then I need a key field right?
The client is saying they can't give ey fields in some tables. I think it's not possible to do update_insert in tables without key field right?
ithe metadata of able shows primarykey=false, so is it possible to update those tables by any way?
some tables like salary_details need multiple records for each employee, so I can use only insert operation here, right? if I use update_insert, it will save only last data, right?
when should i use UPDATE alone? how its different from UPDATE_INSERT?
can i use UPDATE in tables without primary key using stored procedures or any work around?