× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.