hello one and all, i would like to write a stored procedure which looks something like:
CREATE PROCEDURE IC_INITIATE(d CHAR(3), CN CHAR(20)) RETURNS (IC CHAR(22)) AS BEGIN SELECT "CN" FROM TABLE WHERE (DIV = :d) INTO :IC; ...MAYBE OTHER STUFF to IC... UPDATE TABLE SET "CN" = :IC WHERE (DIV = :d); SUSPEND; END so CN is in quotes because i don't know how to pass a field/column name as the CN parameter and then use that CN as an actual field in a table. how can i do that? thanx in advance and merry christmas. lucas