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.

Reply via email to