I have created a unicode-enabled database by set the parameter _UNICODE to YES and the parameter DEFAULT_CODE to UNICODE.
Then,I input some data from sqlserver2000 to the database successful.
when I try to run some query statement,the error occur:
The most anoying limit in SAPDB is the row-length limit. That means a row of a table may not contain more data than 8KB which is 4000 chars if you use UNICODE.
I tested several times,I found that if the statement include 3 tables it will run fine,more than 3 tables it will generate the General error;-2009 POS(1) Join columns too long.
You seem to experience another limit that forces the columns in a JOIN to not exceed a certain number of bytes. That's on reason why it is a bad idea in general to use string-columns for joins.
Besides,I sometimes fall across the General error;-904 POS(1) Space for result tables exhausted,when I execute sql statement both at sql studio and according JDBC driver.
Well, i have no idea what that is.
I have read the document carefully,but still confused.
At last,I also setup a non unicode-enabled database and try the same example,and it's run fine.
Is this a sapdb BUG?
There a table where all limits are listet: http://www.sapdb.org/7.4/sap_db_features.htm
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
