1 Reply Latest reply: Oct 3, 2013 2:05 PM by Gysbert Wassenaar RSS

    Create Load Statement from SQL Schema Definition

    Jerry Helms

      I have a large number of tables that I want to generate  Load script for as opposed to manually writing the script for each table.  I have retrieved the table names and column names from SQL as illustrated below:

       

      schema.png

      I would like to generate a script file that looks like:

      AccountCombos:

         Load PK,

           ... REMAINING COLUMNS ...  ;

        SELECT SQL

           ...  COLUMN LIST ;

        From AccountCombos;

        Store AccountCombos into ../qvd/AccountCombox.qvd(qvd);

        drop table accountCombos;