SQL scripts in CODE/400 (was RE: PNLGRP's in CODE/400)

["Phil" <sublime78ska@xxxxxxxxx>]

Fantastic!!

I added PNLGRP, and I also added .sql while I was at it.

Because I just found out something new (to me - may be old news to others!)

I placed my sql scripts for creating a table, and adding labels to the
table, into a .sql file.  I did this for documentation only.  Then I double
clicked on it to make a change to it, and ISQL in Ops Nav opened up.  Cool,
I made my changes and then clicked the "Run All" icon and ISQL ran all of my
scripts in this file.  This is just beautiful.  (Oh, I did have to manually
connect to host first).

Now, if there were a tool in Ops Nav or Code/400 to graphically view the
data model (an ERD tool) my excitement would reach all-time levels. ;)

Thanks Violaine,

Phil

> -----Original Message-----
> From: owner-code400-l@midrange.com
> [mailto:owner-code400-l@midrange.com]On Behalf Of batthish@ca.ibm.com
> Sent: Wednesday, July 11, 2001 3:56 PM
> To: CODE400-L@midrange.com
> Subject: Re: PNLGRP's in CODE/400
>
>
> Hi Phil,
>
> if you look at the "Put to host" action (using the Action window and
> editing the local file action), you will see that the action is
> defined for
> all local files that are of type <SRC> .  If you press the edit
> button, you
> will be able to see what extension define the type <SRC>.
> I don't know what extension you are using, but you basically have 2
> options:
> 1) Add the extension you are using for PNLGRP to the type <SRC> or
> 2) Change the action to apply to <ALL> types (then you'll never have to
> worry about it).
>
> Hope this helps!
>
> Violaine Batthish
> CODE/400 Project Lead
> batthish@ca.ibm.com          IBMCA(BATTHISH)
>
> CODE/400 page:  http://www.ibm.com/software/ad/varpg
> WDT/400 Support :
> http://www.ibm.com/software/ad/wdt400/update_downloads.html
>
>
>
>
>
>                     "Phil"
>
>                     <sublime78ska@yaho       To:
> <CODE400-L@midrange.com>
>                     o.com>                   cc:
>
>                     Sent by:                 Subject:
> PNLGRP's in CODE/400
>                     owner-code400-l@mi
>
>                     drange.com
>
>
>
>
>
>                     07/05/2001 11:04
>
>                     PM
>
>                     Please respond to
>
>                     CODE400-L
>
>
>
>
>
>
>
>
> In the Code Project Organizer, I wanted to "Put to Host" a pnlgrp member.
> But I don't have that option.
>
> Should I have that option, or is this not supported?
>
> Thanks,
>
> Phil
>
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> +---
> | This is the CODE/400 Mailing List!
> | To submit a new message, send your mail to CODE400-L@midrange.com.
> | To subscribe to this list send email to CODE400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> CODE400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: larry@paque.net
> +---
>
>
>
> +---
> | This is the CODE/400 Mailing List!
> | To submit a new message, send your mail to CODE400-L@midrange.com.
> | To subscribe to this list send email to CODE400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> CODE400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: larry@paque.net
> +---
>


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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