Gordon I got some ddl working with the %ResultSet to chage the password by ddl
kill set %msql="_SYSTEM" set sql="alter user pfc identified by abc" set rs=##class(%ResultSet).%New() write rs.Prepare(sql) 1 w rs.Execute() 1 just change the sql to be your own ddl HTH Peter On Mon, 16 Jun 2003 09:16:28 -0400, "Gordon Twaddell" <[EMAIL PROTECTED]> wrote: >This is a follow-on question on building an InstallShield installer >for our application. The target platforms are Windows32 (NT/ W2K/ XP) >and Linux. > >Question #2: > >I have an upgrade requirement to update a previous version of our database >to the latest revision. For our other supported databases (Oracle / DB2) >this means executing ddl sql in a command to modify tables definitions >and data. Again because of InstallShield, I need these operations to run >without user interaction (e.g. shell commands for linux or CMD/BAT files >for W32). > >I've been trying to figure out how to use Cache's Terminal window >to accomplish my task, but I haven't seen anything that suggests that >I could execute SQL from a Terminal script. > >Does anyone have a suggestion? > > TIA, Gordon >
