Comment 7 for bug 1282307

I tried as your suggestion, but i still cannot reproduce it. the detailed steps as follows.

1). set conf/server to 1 and restart dcs.

[jiegao@g4t3018 /opt/home/jiegao/project/core/sqf/sql/scripts]$ sqcheck
Checking if processes are up.
Checking attempt: 1; user specified max: 2. Execution time in seconds: 0.

The SQ environment is up!

Process Configured Actual Down
------- ---------- ------ ----
DTM 2 2
RMS 4 4
MXOSRVR 0 1 -1

2). on windows side, use windows odbc connection string to call the back end server.
i use the following sql:
 SQLCHAR sql[40]="insert into checkone1 values('bbb')";
 SQLCHAR sql1[40]="set schema aa";
 SQLCHAR sql2[40]="insert into checkone values('bbb')";
suppose we have schema aa and table checkone and checkone1.

3) check the result by trafci.

SQL>show schema;

SCHEMA SEABASE

--> result shows that the schema hasn't retained.