Re: SQL problem

Regarding:

Error occurred in:
ALTER TABLE "RB_DBO"."RB_ACTION" ADD CONSTRAINT "PK_RB_ACTION" PRIMARY KEY ("ACTION_ID")
Error: [SQL5051] Qualifier LEON not same as RB_DBO.

Morgan, Paul wrote:

Is there a LEON library? Is there an RB_ACTION table in that library?

More information:

This seems to be happening in some sort of generated or canned script. LEON is the user name, and there is no LEON library. And the script shows the correct library (RB_DBO). From the script itself:

CREATE SCHEMA "RB_DBO";

CREATE TABLE "RB_DBO"."RB_ACTION" (
"CUST_ID" BIGINT NOT NULL, "ACTION_ID" BIGINT NOT NULL, "ORIGINAL_ID" BIGINT NOT NULL, "OBJ_DEF_ID" BIGINT NOT NULL, "ORDER_NO" INTEGER, "ACTION_NAME" VARCHAR(50) NOT NULL, "ACTION_TYPE" VARCHAR(5), "NEW_STATUS_ID" BIGINT, "IS_GROUP" CHAR(1), "PROPERTIES" CLOB(1048576) , "COND_EXPR" CLOB(1048576) , "PAGE_ID" BIGINT NOT NULL, "CREATED_BY" BIGINT NOT NULL, "CREATED_AT" TIMESTAMP NOT NULL, "UPDATED_BY" BIGINT NOT NULL, "UPDATED_AT" TIMESTAMP NOT NULL
)
DATA CAPTURE NONE COMPRESS NO;

. . .

CREATE UNIQUE INDEX "RB_DBO"."UQ9_RB_RSS_SESSION"
ON "RB_DBO"."RB_RSS_SESSION"
("CUST_ID" ASC, "LIST_DEF_ID" ASC, "USER_ID" ASC)
MINPCTUSED 0
ALLOW REVERSE SCANS
PAGE SPLIT SYMMETRIC
COLLECT STATISTICS
COMPRESS NO;

ALTER TABLE "RB_DBO"."RB_ACTION" ADD CONSTRAINT "PK_RB_ACTION" PRIMARY KEY
("ACTION_ID");

. . .

"LEON" never appears in the script, so I have no idea where SQL is getting it, other than it being the user profile under which the script is being run.

--
JHHL