RE: SQL

["John Candidi" <jacandidi@xxxxxxxxxxxxxxxxxxxx>]

It's simple statement 
Update filea
Set fielda = 'xx'  where fieldb ='yy'

When I run this interactively, it runs fine.I created the source file and
enter these commands into it then do a RUNSQLSTM using the source file x in
lib y using member z, it errors out

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Elvis Budimlic
Sent: Thursday, January 18, 2007 1:17 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: SQL

RUNSQLSTM is your friend.
Separate multiple SQL statements (i.e. UPDATE,CREATE,DELETE,INSERT) in a
source member with semicolons (;).

Elvis

Celebrating 10-Years of SQL Performance Excellence

-----Original Message-----
Subject: SQL

Excuse the idiocy in this question. We don't do a whole lot of SQL, usually
very small updates that I do interactively but I have a large update to do
and I would like to submit it to batch. How do I go about doing that?

John A Candidi