Informix

Expand all | Collapse all

New utils2_ak features!

  • 1.  New utils2_ak features!

    Posted Thu May 06, 2021 08:04 AM
    Folks, I have uploaded an update to utils2_ak that includes new features in myschema to support new myexport features similar to recent improvements to dbexport. I will shortly release an update to the myexport package that includes direct support for these. In the meantime, you could manually modify the myexport script to add the desired options to the myschema command line in there:

    --no-export-triggers Disables select triggers in the external table  export scripts.

    For both of the following options, DDL for the tables are generated and they are
    created on the target but no data is exported. They behave the same as the
    corresponding dbexport options:

    --no-data-tables - Do not produce export scripts for listed tables. If the option
     is passed but no tables are listed the tsinstancetable table is auto-included. The
    optional argument is a comma separated list of table names. Use with export scripts
    options: --myexport-scripts, --myexport-express, & --export-scripts.

    --no-data-access-method - Do not produce export scripts for tables created with the
    listed access method names. If the option is passed but no access methods are
    listed the ts_rtl_vtam and ts_vtam access methods are auto-included. The optional
    argument is a comma separated list of access method names.
     Use with export scripts
    options: --myexport-scripts, --myexport-express, & --export-scripts.



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------


  • 2.  RE: New utils2_ak features!

    Posted Thu May 06, 2021 09:02 AM
    Art, where are your latest utils (not just this, but all)? There are multiple versions all over the Internet :)
    Ty
    Hrvoje

    ------------------------------
    Hrvoje Zokovic
    ------------------------------



  • 3.  RE: New utils2_ak features!

    Posted Thu May 06, 2021 10:28 AM
    Hrvoje:

    The latest versions of my utils2_ak, myexport, and ratios.shr_ak packages are always on my web site at:

    askdbmgt.com/my-utilities

    All of the packages that have not been updated in a while still have the latest versions on the new IIUG SOftware Repository on SourceForge and GitHub: www.iiug.org/software

    When I update some package I'll install the latest on my web site. The versions of utils2_ak, myexport, and ratios.shr_ak packages on the IIUG site are older. I intended to maintain them there as well just one release behind, but honestly, I'm just too busy to update that site which takes more effort than maintaining it on my site. 

    Art


    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 4.  RE: New utils2_ak features!

    Posted Thu May 06, 2021 01:22 PM
    Thank you Art
    Hrvoje

    ------------------------------
    Hrvoje Zokovic
    ------------------------------