Hello all,

I have to transform this static statement:

EXEC SQL INSERT into lib.file values ('001', db2xml.xmlclobfromfile ('/user/web.xml')) end-exec

in a dynamic statement as follows :

EXEC SQL prepare S1 from :sql_statement end-exec
EXEC SQL EXECUTE S1 end-exec

My problem is to know how to define the content of
:sql_statement
because I receive from the external side the path where the message is stored

Could somebody help me ?

Thanks