Unanswered: Db2 remote connect to Windows LUW from cobol program
I am trying to bind my whole application to Windows LUW database from cobol program using DRDA.
I am using 'EXEC SQL CONNECT TO remoteLocation END-EXEC' in every module so that it can bind to the remote database.
I have a transaction that executes four programs. Do i need to use 'Connect to remotelocation ' statement in every program or is there a way i can issue a Connect to statement in first program and rest would be connected to remote database.
Reason i am asking is because , i read it in one of blogs which state that using multiple COnnect to statement in programs is CPU Intensive.