To write the DW into SQL database hint: in the READ COMMITTED and REPEATABLE READ isolation level ca-CodePudding

//Profile SQL
The SQLCA. DBMS="OLE DB"
The SQLCA. LogPass=& lt; * * * * * * * & gt;
The SQLCA. LogId="sa"
The SQLCA. The AutoCommit=False
='SQLOLEDB' SQLCA. DBParm="PROVIDER and DATASOURCE='127.0.0.1, 9989', PROVIDERSTRING='database=table"

//will write after dw SQL
W_main. Dw_temp. Setrow (1)
W_main. Dw_temp. RowsCopy (w_main. Dw_temp. GetRow (), w_main. Dw_temp. RowCount (), Primary! , w_main. Dw_input, 1, Primary!
W_main. Dw_input. SetTransObject (SQLCA_SQL)
RTN=w_main. Dw_input. The Update ()
IF RTN=1 THEN
COMMIT the USING SQLCA_SQL;
Ls_return="success"
//w_main. Dw_input. Retrieve ()

The ELSE
The ROLLBACK USING SQLCA_SQL;
Ls_return="modified failure"
END the IF

Write the SQL prompt
SQLSTATE=42000,
The Microsoft OLE DB Provider for SQL Server
In the READ COMMITTED and REPEATABLE READ isolation level can only specify READPAST locks,
Sql2000 sql2008 has this problem
To SNC SQL Native Client links do not have this problem, but using the environment not to install the SNC SQL Native Client, or use the OLE DB
Asking how code needs to modify,