|
when you exit SQL you are presented with a little menu which allows to save the session to an source member. If you do so, you can easily add/mod those command lines and run the entire member with CL command RUNSQLSTM. It even runs in batch and creates a detailed report of its acitivites. (Great for month end routines...) Axel Niederquell Selkirk GmbH -------- Original Message -------- Subject: RE: SQL and MAPICS (22-Feb-2002 23:31) From: WIEDLJ@timesaversinc.com To: niederquell@selkirk.de > I also have been playing around with SQL. If you try your F1 key it should > show you the valid commands like SELECT you can F4 on the line and it will > prompt you for your fields, etc. It is fast. When working with updating > be careful. > > Does anyone know how to put an SQL statement in a CL. I have tried with no > luck. > > > > *********************************************************** > This email has been scanned for viruses. > *********************************************************** > > _______________________________________________ > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list > To post a message email: MAPICS-L@midrange.com > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l > or email: MAPICS-L-request@midrange.com > Before posting, please take a moment to review the archives > at http://archive.midrange.com/mapics-l. >
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.