Hi
I am trying to parameterize shema name:

CREATE PROCEDURE Test1"
(IN "SCH_NM" VARCHAR(20)
)

BEGIN
insert into SCH_NM."test" (x)
values(234555,)
END;

But I get an error:
[IBM][CLI Driver][DB2/LINUXX8664] SQL0204N "SCH_NM.test" is an undefined name. LINE NUMBER=... SQLSTATE=42704

Please help

You will have to do it as dynamic SQL not static.

Andy

the problem in this case is not only you'll have to create the schema but you'll have to create the table inside that schema as well. Absence of any one of those will always result in an error.

IBM Information Center states
So dynamic SQL is the way out for you.

for further reference
http://publib.boulder.ibm.com/infoce...n/r0000925.htm

Schema creation doesn't have anything to do with the problem.

Schemas are created implicitly when you create a table and have the necessary privileges (e.g. IMPLICIT_SCHEMA if I'm not mistaken).

point noted and thanks for updating me on the same.