Re: Associating .sql files with IBM i Access Client Solutions or command line option for Run SQL Scripts

[Paul Therrien <paultherrien@xxxxxxxxxxxxxxxxxx>]

THIS ADDRESSES HOW ONE MAY EXCLUDE PLUGINS FROM SOMEONE'S INSTALLATION.
YOU'LL NOTE THE RSS IS ONE OF THOSE THAT CAN BE EXCLUDED.

9.5 CUSTOMIZED PACKAGES

IBM i Access Client Solutions provides system administrators the ability
to restrict the usage of specific functions by setting the following
property in the AcsConfig.properties file:

    com.ibm.iaccess.ExcludeComps=<function, function,...>

The function keywords which may be specified are:

   Function           Description
    cfg             System Configurations
    sm              5250 Session Manager
    5250            5250 Emulator
    vcp             Virtual Control Panel
    console         5250 Console
    consoleprobe    Search the local network for console configurations
    hmcprobe        Search an HMC for partitions
    hmi1            Hardware Management Interface 1
    hmi2            Hardware Management Interface 2
    keyman          SSL/TLS certificate management
    dtgui           Data Transfer graphical user interface
    upload          Data Transfer batch uploads
    download        Data Transfer batch downloads
    cldownload      Data Transfer batch downloads
    l1c             IBM Navigator for i (Level 1 Console)
    rmtcmd          Remote command (available from the command-line)
    splf            Printer Output (spool files)
    rss             Run SQL Scripts
    db2tools        SQL Performance Center
    sysdbg          IBM i System Debugger

---
Paul Therrien Andeco Software, LLC 

paultherrien@xxxxxxxxxxxxxxxxxx 

225-229-2491 

On 2016-09-06 13:26, Rob Berendt wrote:

> Do you have any documentation which mentions
> /PLUGIN=rss
>
> Rob Berendt
> -- 
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
> Garrett, IN 46738
> Ship to:  Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
> From:   Paul Therrien <paultherrien@xxxxxxxxxxxxxxxxxx>
> To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Cc:     Rob Berendt <rob@xxxxxxxxx>
> Date:   09/06/2016 11:42 AM
> Subject:        Re: Associating .sql files with IBM i Access Client 
> Solutions or    command line option for Run SQL Scripts
> Sent by:        "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
>
> acslaunch_win-32.exe /PLUGIN=rss /SYSTEM=mysystem
>
> ---
> Paul 
>
> On 2016-09-06 11:32, Rob Berendt wrote:
>
> > I know the documentation
> ftp://ftp.software.ibm.com/as400/products/clientaccess/solutions/GettingStarted_en.html#9.1
>
> > does not mention that you can associate .sql file extensions with the
> new 
>
> > IBM i Access Client Solutions but I wasn't ready to give up yet.
> >
> > I was wondering if there is a command line option (see section 9.1 of
> the 
>
> > above link) to start "Run SQL Scripts".
> >
> > Rob Berendt
> > -- 
> > IBM Certified System Administrator - IBM i 6.1
> > Group Dekko
> > Dept 1600
> > Mail to:  2505 Dekko Drive
> > Garrett, IN 46738
> > Ship to:  Dock 108
> > 6928N 400E
> > Kendallville, IN 46755
> > http://www.dekko.com
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related 
> questions.