Tuesday, September 23, 2008

Controle de Transação para BSFN

Controle de Transação para Business Function

Auto - Commit
=================================

JDBReturn = JDB_InitBhvr ( lpBhvrCom, &hUser, (char*) Null, JDEDB_COMMIT_AUTO);
JDBReturn = JDB_OpenTable( hUser, NID_Fxxxxx , ID_Fxxxxx _yyyyy , NULL , (ushort) 0, (char * ) NULL , &hRequestFxxxxx );
JDBReturn = JDB_UpdateTable( hRequestFxxxxx, NID_Fxxxxx , (ID) NULL , ID_Fxxxxx_yyyyy , (void*) &dsFxxxxxKey , nNumKeys, (void*) &dsColFxxxxx);

JDBreturn = JDB_CloseTable (hRequestFxxxxx);
JDBreturn = JDB_FreeBhvr (hRequestFxxxxx);


Manual - Commit
=================================

JDBReturn = JDB_InitBhvr ( lpBhvrCom, &hUser, (char*) Null, JDEDB_COMMIT_MANUAL);
JDBReturn = JDB_OpenTable( hUser, NID_Fxxxxx , ID_Fxxxxx _yyyyy , NULL , (ushort) 0, (char * ) NULL , &hRequestFxxxxx );
JDBReturn = JDB_UpdateTable( hRequestFxxxxx, NID_Fxxxxx , (ID) NULL , ID_Fxxxxx_yyyyy , (void*) &dsFxxxxxKey , nNumKeys, (void*) &dsColFxxxxx);

if (JDBReturn == PASSED) {
JDB_CommitUser (&hUser);
} else (
JDB_RollbackUser (&hUser);
}

JDBreturn = JDB_CloseTable (hRequestFxxxxx);
JDBreturn = JDB_FreeBhvr (hRequestFxxxxx);

No comments:

Post a Comment

Thanks for your comment!

Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
JDEFusion is not affiliated with Oracle Corporation. Contents of this site are not endorsed nor approved by Oracle.
JDEFusion is part of Oracle official OTN blogs listing for Latin America under category JD Edwards and Fusion Middleware.