RE: Replacing objects if they exist: Another SQL-newbie UDF question

["Richard Casey" <casey_r@xxxxxxxxxxxxxxxx>]

Phillip,

Does V4R5 not allow the DROP commands?

For example:

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

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

Have fun!

Richard

-----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
question

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.