1 Reply Latest reply: Sep 23, 2014 6:13 AM by Mark Manders RSS

    how get fields from two tables using Resident Load

      Hi Friends,

       

      I have two table

       

      Table 1  Table 2

      A            Z        

      B            X

      C            Y

       

      Now I have to create a new table taking values from Table1 and Table2

       

      Can I use Resident Load for this

       

      thanks

        • Re: how get fields from two tables using Resident Load
          Mark Manders

          You probably want to use a CONCATENATE or JOIN statement?

          When you have loaded tables 1 and 2  (using FROM statement), you can use RESIDENT after that, since they are present in memory.

           

          Might be something like this ....

           

          [Table 1]:

          LOAD * FROM [Table 1 ...];

           

          [Table 2]:

          LOAD * FROM [Table 2 ...];

           

          [Table 3]:

          NOCONCATENATE

          LOAD * RESIDENT [Table 1 ...];

          <CONCATENATE / JOIN>

          LOAD * RESIDENT [Table 2 ...];


          DROP TABLES [Table 1], [Table 2];

           

          Don't forget the NOCONCATENATE in the sample above, or else the data from Table 1 is loaded twice in Table 1. QV recognizes that Table 1 and the resident load from Table 1 have exactly the same build, so they will be concatenated automatically, unless you use the NOCONCATENATE statement first.