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