Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Scripts...
Wed, Nov 3 2010 1:29 PMPermanent Link

Stefano Monterisi

Hi Tim,
always EDB Smile
I want to create and manage structure (create, alter, update tables) of a
database all in scripts; Is possible this?
IS possible to insert several script into one file? Is possible to call a
script from another script?
If yes, an example is welcome!!
Smile
Thanks in advance!!

Stefano Monterisi

Thu, Nov 4 2010 4:06 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Stefano,

<< I want to create and manage structure (create, alter, update tables) of a
database all in scripts; Is possible this? >>

Sure, although scripts in ElevateDB are quite a bit different than the
semicolon-delimited scripts in DBISAM.  Check out this section of the SQL
manual on the syntax:

http://www.elevatesoft.com/manual?action=topics&id=edb2sql&section=sql_psm_statements

Basically, scripts look like this:

SCRIPT(<Parameters>)
BEGIN
  <SQL/PSM Statements)
END

<< IS possible to insert several script into one file? Is possible to call a
script from another script? >>

No, and no.  You can call stored procedures and functions from scripts, but
not other scripts.

--
Tim Young
Elevate Software
www.elevatesoft.com


Image