STORED PROCEDURE or SQL Script

STORED PROCEDURE or SQL Script

 

  

Hi all,

Am fairly new to DB2, 2 days and a couple of hours maybe. I need some help if
someone is able and willing to.

I want to create a set of schema or tables and I want to be able to create a
script that I can used to check if a schema exist, if it does, drop it first
and then re-create it otherwise just create it. The script may have been a
generic one that you can use for checking stored procedures, tables, index
script.

A simple example or template may suffice and I'll probably be able to just take
it from there. More often, it is the syntax that is different and I can't work
out the proper syntaxes in DB2 ....

Any help will be very much appreciated ... Thanks in advance ...



DB2 & UDB email list listserv db2-l LazyDBA home page