RE: SQL problem

James,

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

Paul Morgan

Principal Programmer Analyst
IT Supply Chain/Replenishment

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of James Lampert
Sent: Monday, July 09, 2012 11:33 AM
To: Midrange Systems Technical Discussion
Subject: SQL problem

One of our off-site developers is trying to do some work through SQL:

I realized that there is another way to create this database on DB2
on i if I can create the empty table structure on “Venus” and then I
can use Rollbase to re-initialize the seed data. Then we can get the
database ready on DB2 on i. so I managed to extract all the table DDL
from my DB2 on LUW version instance, and made some changes to make it
DB2 on i compatible and try to create all objects in the “Venus”
server. I created a schema “RB_DBO” and created all tables
successfully, but when I try to create Primary Key constraints on
these table, I got a SQL exception “ErrorCode: -5051”, some thing
like :

Error: [SQL5051] Qualifier LEON not same as RB_DBO.
SQLState: 42875
ErrorCode: -5051
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.
SQLState: 42875
ErrorCode: -5051

I did some research on this error, and I believe the reason is that
the “leon” account didn’t have “Alter table” privilege on tables in
schema “RB_DBO”.

He seems to have complete authority over the RB_DBO library, and
everything in it, so I have no idea what the problem is.

--
JHHL