請問一下有人知道「STATUS = -206」這個錯誤訊息代表什麼意思嗎 ?
我確定我的l_tc_ima01,l_tc_cus_no1都是有值
目前分別將值塞至兩個不同table,只是一個會成功,另一個會失敗
INSERT INTO tmp_cbmi730(tc_ima01,tc_cus_no1) VALUES(l_tc_ima01,l_tc_cus_no1)
LET m = STATUS -->STATUS = -206
INSERT INTO log_file(tab,key1,key2 ) VALUES('cbmi730',l_tc_ima01,l_tc_cus_no1)
LET n = STATUS-->STATUS = 0
到這個網址將ERROR CODE 輸入即可看到錯誤訊息的說明.(TIPTO工程師專用)
-206:
-206 The specified table is not in the database.
The database server cannot find a table or view specified in the statement. The table or view might have been renamed or dropped from the database.
You might also get this message if you omit the keyword "TYPE" when you are trying to grant USAGE privileges on a user-defined type. For example, the following GRANT statement is correct:
GRANT USAGE ON TYPE person_row_type TO usr2;
The following GRANT statement, however, generates error -206:
GRANT USAGE ON person_row_type TO usr2;
Check the names of tables and views in the statement or check for omission of the keyword "TYPE" in a GRANT statement. If the names are spelled as you intended and "TYPE" is not missing, check that you are using the database you want. To find the names of all tables in the database, query the systables table. To find the names of all views, query the sysviews table.
你這個錯誤訊息可能是你套件本身的錯誤訊息。
這個很難了解這是什麼意思。
如果擔心是資料庫的問題。可以試試將同一段的sql碼喂給gui工具處理。
(因為我不知道你用哪個sql,只能跟你說用相對應的工具)
來取得實際的錯誤為何