How do I perform updates that include parameters against a DB2 database, using raw sql I'd run a query similar to
UPDATE MYSCHEMA.TZERRM SET EZSTAT=’XX’ WHERE EZCONO=100 AND EZORNO='0000101049' AND EZPONR=3 AND EZPOSX=0 Where the values in the where clause should be parametrised. using the db << ... syntax works if i use a hardcoded sql string, but then I'd have to do the parameter replacement myself and be aware of sql injections and what not so I'd rather avoid that if at all possible. So, how should I be doing this? -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
