does ODBCOutPut( ) wait for sql to finish
Posted: Thu May 25, 2017 1:29 am
It might be an obvious thing but I'm not sure right now, if odbc function is run in prolog and not the data source tab - and say the sql takes 3 minutes to run; does it wait before going onto the next statement in prolog or just keep going?
Code: Select all
pProcess = GetProcessName( );
dsnSQL = 'TM1_Finance';
ODBCOpen(dsnSQL, 'tm1admin', 'password');
vSQL = 'Exec usp_joinSomeTables';
ODBCOutPut(dsnSQL, vSQL);
ODBCClose(dsnSQL);
...
run some more prolog functions dependent on prev query result