IBM Support

user table with name beginning with underscore can be created but it cannot be accessed and cannot be dropped.

Troubleshooting


Problem

The customer reported that they can create a table with name beginning with underscore as below. $ nzsql -d test -c 'create table _BTS_111 ( A INTEGER );' CREATE TABLE $ nzsql -d test -c '\d' List of relations Schema | Name | Type | Owner --------+----------+-------+------- ADMIN | _BTS_111 | TABLE | ADMIN But they cannot read from the table as below. $ nzsql -d test -c 'select * from _BTS_111;' ERROR: relation does not exist TEST.ADMIN._BTS_111 They also cannot drop it as below. $ nzsql -d test -c 'drop table _BTS_111;' ERROR: relation does not exist TEST.ADMIN._BTS_111 In addition they cannot backup database due to it as below. $ nzbackup -db test -dir /nzscratch/Backup Error: DB SQL 'lock table ADMIN._BTS_111 in access share update mode;' failed - DB error - ERROR: relation does not exist TEST.ADMIN._BTS_111. Database User's Guide mentions below. ---------------------------------------------------------------------- Regular identifiers must begin with a letter; they cannot begin with a digit, underscore, or dollar sign. ----------------------------------------------------------------------

[{"Product":{"code":"SSUSQ8","label":"IBM Netezza Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
03 June 2022

UID

swg22004960