Launch sql script within powerbuilder

[Alex Bibiano González]

Powerbuilder 10.5.1 and MS SqlServer 2005.

When my application first starts, I connect to the sql server with "sa"
credentials.

What I want to do is launch a sqlscript that I have in a text file (sql
sentences) to create a new database and his tables.

Any suggestions?

A lot of thanks,

Alex B.

[André Tobiassen]

Check out using Dynamic Sql:

Execute Immediate s_SQLString Using transactionobject;

Read the file into a string (do any parsing necessary) and execute your
statement(s).

Regards
André

På Thu, 13 Sep 2007 09:31:56 +0200, skrev Alex Bibiano González
<abib...@nikel.es>:

[Remigiusz Cieślak (EMATIQUE)]

Hi Alex,

The easiset way (perhaps not so sofisticated) is to iterate the commands
(after reading them from the file) and post them to the db via "execute
immediate".

http://www.rgagnon.com/pbdetails/pb-0024.html

Kind regards
recies

Użytkownik "Alex Bibiano González" <abib...@nikel.es> napisał w wiadomości
news:46e8e76c$1@forums-1-dub...

[mason]

Run("sqlcmd.exe -S... -U... -P... -d... -b -imyscript.sql")

As others suggested, putting these DDLs in your PB codes is a better
approach. At least nobody can alter your myscript.sql to damage your
database.

"Alex Bibiano González" <abib...@nikel.es> wrote in message
news:46e8e76c$1@forums-1-dub...