「STATUS = -206」這個錯誤訊息代表什麼意思

#4gl #tiptop

ru0217 2020-09-18 11:40:09 ‧ 1966 瀏覽

分享至

請問一下有人知道「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

WQ iT邦新手 2 級 ‧ 2020-09-18 12:02:26 檢舉

tmp_cbmi730 <--一般在TIPTOP系統的程式裡這是寫暫存的TABLE，跟LOG_FILE是不一樣的。請確認下列步驟。
1.確認TEMP_TABLE有建立
2.TABLE欄位型態與塞入的值型態及長度是否符合

而印象中-206。指定的表table-name不在數據庫中。

ru0217 iT邦新手 5 級 ‧ 2020-09-18 13:54:29 檢舉

這個我確認過了，原本 tc_ima_cus_file內這兩個欄位都是 VARCHAR(40)

CREATE TEMP TABLE tmp_cbmi730(
TC_IMA01 VARCHAR(40),
TC_CUS_NO1 VARCHAR(40)
)

tc_ima01 LIKE tc_ima_cus_file.tc_ima01,
tc_cus_no1 LIKE tc_ima_cus_file.tc_cus_no1

ru0217 iT邦新手 5 級 ‧ 2020-09-18 14:50:03 檢舉

我知道問題點，也處理好了，感謝你的提醒，謝謝 !!

登入發表討論

直播研討會

{{ item.channelVendor }} {{ item.webinarstarted }} |

直播中

2 個回答

做工仔人!

iT邦大師 1 級 ‧ 2020-09-18 17:07:25

最佳解答

到這個網址將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.