Indicator Variables

关注

原创最新推荐文章于 2026-09-02 19:08:47 发布 2.2k 阅读 AI 写同款· GEO 优化 ›

Windows 本地 PostgreSQL 忘记 postgres 密码后，如何重置密码并给 root 用户最高权限 <think>我们只需要根据内容生成摘要，不超过150字。摘要应该简明扼要概括主要问题和解决步骤。注意是中文摘要。</think>在Windows本地开发中，因root数据库账号无CREATEDB权限且忘记postgres超级管理员密码，通过临时修改pg_hba.conf为trust认证重置密码，并重启PostgreSQL服务进行登录，最后授予root用户SUPERUSER等权限，完成数据库创建。阅读详情

Indicator Variables

1. Function: Processing NULL Data

2. The value of Indicator Variable (SMALLINT)

l >=0 (usually 0), indicate that the column is not NULL

l <0 (usually -1), indicate that the column is NULL

l -2, indicate that the column value can’t be stored in host variable for the reason that numeric conversion could not be performed or arithmetic expression error occurred

l -3, indicate that a hole was detected for the row on a multiple row FETCH, and values were not returned for the row. SQLCODE +222, is also returned for that row.

3. Indicator Variable Usage

l When using SELECT or FETCH statement in SQL, indicator variables are set by DB2 according to the property of the relevant column(NULL or NOT NULL)

l When using UPDATE or INSERT statement in SQL, the programmer need to set the value of indicator variables to tell DB2 that the relevant column is NULL or NOT NULL

收录于