RE: SQL

As a test try qualifying the library and see if it works.

Update library.filea
Set fielda = 'xx'  where fieldb ='yy'


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

If it was that, would it let me do it interactively? 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Chris Payne
Sent: Thursday, January 18, 2007 4:13 PM
To: Midrange Systems Technical Discussion
Subject: RE: SQL

Could it be a library list issue?

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

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