根据X/Open和SQL Access Group SQL CAE规范(1992)所进行的定义,SQLERROR返回SQLSTATE值。SQLSTATE值是包含五个字符的字符串,由2个字符的SQL错误类和3个字符的子类构成。五个字符包含数值或者大写字母, 代表各种错误或者警告条件的代码。成功的状态是由00000标识的。SQLSTATE代码大多数情况
SQL20430N 無法在這個環境定義中設定或參照廣域變數 variable-name。 解說 在部分環境定義中,無法設定廣域變數,且無法在其他環境定義中參照它。可在下列情況中傳回此訊息: 陳述式已嘗試在下列其中一個環境定義中設定具名廣域變數: 複合SQL(行內)陳述式 主體不是複合 SQL(已編譯)陳述式的函數 方法 主體不是...
STATE_STORE_NULL_TYPE_ORDERING_COLS_NOT_SUPPORTED、STATE_STORE_UNSUPPORTED_OPERATION_ON_MISSING_COLUMN_FAMILY、STATE_STORE_VARIABLE_SIZE_ORDERING_COLS_NOT_SUPPORTED、UDTF_ALIAS_NUMBER_MISMATCH、UDTF_INVALID_ALIAS_IN_REQUESTED_ORDERING_STRING_FROM_ANALYZE_METHOD、UDTF_INVALID_REQUESTED_SELECTED_EXPRESSION_FRO...
this is a buffer allocated for each client, so you should not set the global variable to a large value. Instead, change the session variable only from within those clients that
0xC001F001-1073614847 DTS_E_FAILEDSYSTEMVARIABLEREMOVE 无法删除系统变量。 删除必需变量时会出现此错误。 必需变量是由运行库创建的变量,用于在任务和运行库之间进行通信。 0xC001F002-1073614846 DTS_E_CHANGESYSTEMVARIABLEREADONLYFAILED 更改变量属性失败,因为该变量为系统变量。 系统变量是只读的...
IncomingRowChangeType整數一個值,指定所有傳入資料列是否都是新的資料列,或轉換是否應該偵測變更的類型。 InferredMemberIndicatorString推斷的成員的資料行名稱。 SqlCommandString用來建立結構描述資料列集的 SQL 陳述式。 UpdateChangingAttributeHistoryBoolean一個值,指出歷程記錄屬性更新是否...
Change the invocation of the function to remove the invalid string length unit or change it to a unit valid for the data type and values being processed. sqlcode: -20289 sqlstate: 428GC SQL20290NThe SQL statement references routineroutine-name(specific namespecific-name) which cannot be run ...
You can change the SQL mode at runtime by using aSET [GLOBAL|SESSION] sql_mode='modes'statement to set thesql_modesystem value. Setting theGLOBALvariable requires theSUPERprivilege and affects the operation of all clients that connect from that time on. Setting theSESSIONvariable affects only ...
Action: Check the variable type before re-typing the command. SP2-0253 Data item line_number (data_item_name) will not fit on line Cause: The current line size setting is too small to fit the specified data item on a line. Action: Increase the line size so that the item can be disp...
Create the variable in the scope of the package or a package object such as a task. Specify the value and data type of the variable. The only configurable option on system variables is specifying whether they raise an event when they change value. ...