Re: SQL problem

"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.

James,

That is exactly the point. As the constraint name wasn't qualified, SQL
inserted the user name as a default qualifier (ie., schema) name. So, when
your developer wrote:

ALTER TABLE "RB_DBO"."RB_ACTION" ADD CONSTRAINT "PK_RB_ACTION" PRIMARY KEY
("ACTION_ID");
The system changed it to:

ALTER TABLE "RB_DBO"."RB_ACTION" ADD CONSTRAINT "LEON"."PK_RB_ACTION"
PRIMARY KEY
("ACTION_ID");
Just use the same qualifier in the constraint name:

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

Best Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries