4 Replies Latest reply: Jan 19, 2015 4:38 AM by Felipe Carrera RSS

    QDF / Store $(vL.TableName) into... not recognized "unknown statement"

    Felipe Carrera

      hi community

      I am using for first time the QDF. In the tranform Container, under Application i am loading tables from the extract Container and storing them as QVDs, according to the QDF, ie. using the Standard variables

      ll tables load well except for a table, which is not recognized. any idea why is this Happening? thanks!

       

       

      recognized.  .  QDF_StoreVar.pngScriptError.png

      //the Script Structure is like this:

       

      // ----------------------------------------
      // Load TABLE QVD
      // ----------------------------------------

      LET vL.TableName='table';
      LET vL.before=now();


      table_tmp:
      LOAD field1,
      field2,
      ...............
        fieldn   
      FROM $(vG.Folder_ExtractQVDPath)v_table.qvd(qvd);

       

      Concatenate(table_tmp)
      LOAD field11,
      field21,
      .............
      fieldn1
      FROM $(vG.Folder_ExtractQVDPath)v_table1.qvd(utf8,qvd);

       

      NoConcatenate
      [$(vL.TableName)]:
      LOAD field1,
          field2,
        field11,
      ..........
      fieldn
      Resident table_tmp;

       

      drop table table_tmp;

       

      // ----------------------------------------
      // Write out the QVD to the defined path
      // ----------------------------------------

       

      STORE $(vL.TableName) INTO $(vL.QVDPath)\$(vL.TableName).qvd;                                                                                                                                                                                 

       

      // ----------------------------------------
      // Create statistical data
      // ----------------------------------------
      LET vL.after=now();
      LET vL.TableNumber=$(vL.TableNumber)+1;
      let vL.TableName_$(vL.TableNumber) ='$(vL.TableName)';
      let vL.NoOfRows_$(vL.TableNumber) = NoOfRows('$(vL.TableName)');
      let vL.NoOfFields_$(vL.TableNumber) = NoOfFields('$(vL.TableName)');
      let vL.TableTime_$(vL.TableNumber) =time(Timestamp('$(vL.after)') - timestamp('$(vL.before)'),'hh:mm:ss');

      // *****************************************;
      // Drop table;
      //*****************************************;
      DROP Table $(vL.TableName);

      trace 'Dropped Table $(vL.TableName)';