Re: DDS Support (Re: NT web server access to AS400)

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

-----Original Message-----
From: Jerry_C._Phillips@pstechno.com <Jerry_C._Phillips@pstechno.com>
To: MIDRANGE-L@midrange.com <MIDRANGE-L@midrange.com>
Date: Thursday, June 29, 2000 3:13 PM
Subject: Re: DDS Support (Re: NT web server access to AS400)


>Bruce,
>
>You wrote..
>
>"BUT... there aren't any REAL tools for manipulating the DDS sources.  I
can
>take ERWin, and in moments, change the database and generate the SQL script
to
>change the database from the old and the new models (and I mean Database,
not
>just one file, but maybe dozens) then run the SQL script thru OpsNav or
send it
>to the 400 with FTP and execute it there."
>
>I too use Erwin to generate DDL.  I just Forward Engineer to the 400 via
odbc.
>How do you 'execute it there' after you ftp?
>


Put it in a source file member and RUNSQLSTM.

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified AS/400 Professional System Administrator
 -- IBM Certified AS/400 Professional Network Administrator
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"If all you have is RPG, then everything looks like a 400!"



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---