Upgrade (to IDS9.2) problem
Posted in 2000
Hi, all
Your help will be greatly appreciated.
I am doing the upgrading test from IDS7.31 to IDS9.2.
Our applications are written in C++, RougeWave DBTools++
(ver 3.0) and ESQL/C (ver9.14) . In one of the application,
we send a SQL statement to IDS via DBTools++ class.
The SQL statement is exactly the following:
"create index xostmp on ostate_tmptbl (os_netentityid);
update statistics low for table ostate_tmptbl (os_netentityid); "
This works well on IDS7.31. But on IDS9.2, I got -252 and -770
error. I have a work round for this problem. I can divide the above
statement into 2 statement and send them to IDS by calling the same
DBTools++ function twice. But this way, I must modify all of our
application source, so I want to know why it does not work in IDS9.2
and if there are other solutions.
Thanks for any idea.
Harry