Thanks, that worked! /Simon
On Mon, Apr 30, 2012 at 6:15 PM, Jeremy Evans <[email protected]>wrote: > On Sunday, April 29, 2012 11:54:07 PM UTC-7, Simon Dahlbacka wrote: >> >> 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 >> > > DB[:myschema__tzerrm].where(:ezcono=>100, :ezorno=>'0000101049', > :ezponr=>3, :ezposx=>0).update(:ezstat=>'XX') > > > Jeremy > > -- > You received this message because you are subscribed to the Google Groups > "sequel-talk" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/sequel-talk/-/fBNLsZ8fOUUJ. > > 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. > -- 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.
