Does V4R5 not allow the DROP commands?

For example:

DROP VIEW mylib/myview;
CREATE VIEW mylib/myview AS
FROM xxxx
WHERE xxxx;

If you use RUNSQLSTM to run the above source with ERRLVL(20), it should work

Have fun!


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of phil.seay@xxxxxxx
Sent: Friday, April 29, 2011 6:03 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Replacing objects if they exist: Another SQL-newbie UDF

Hi James,

I execute a DLTF command (and ignore the possible error message) in the CL
program before executing the RUNSQLSTM command. My software has to run on a
V4R5 machine.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].