if I add this code which use dblink in my pc file,then the program run "EXEC SQL COMMIT WORK RELEASE" will spend more than 30 second, if I take off the dblink sql, the "EXEC SQL COMMIT WORK RELEASE" just cost less than 1 second, why? somebody meet this question??? should I and some option in my pc file??,thans
EXEC SQL select prod_id, acc_nbr into :g_acServTypeID , :g_acAccNbr from ibss.tb_cm_serv @ibss where serv_nbr = :g_acServIDIBSS ;
EXEC SQL select prod_id, acc_nbr into :g_acServTypeID , :g_acAccNbr from ibss.tb_cm_serv @ibss where serv_nbr = :g_acServIDIBSS ;