3 Replies Latest reply: Apr 23, 2009 9:56 PM by Rob Wunderlich RSS

    XML schema of all tables

    Linda Monincx

      Hi,

       

      Can someone tell me if it's possible for a system to create an xml file which contains all the tables possible to deliver?

      customer is now delivering many files each time containing sometimes different combinations of data tables, i am looking for a complete overview of all possible tables.

       

      Thanks!

       

        • XML schema of all tables
          Oleg Troyansky

          What "system" do you mean in your question - QlikView or the source database ?

          If you are using a standard ODBC connection, you should be able to use SQL functions:

           

          SQLTABLES;

          SQLCOLUMNS;

           

          and get a complete list of your tables.

          not sure if this is what you are looking for...

          Oleg

          • XML schema of all tables
            Ralf Becher

            Hi,

            you can read header informations from QVD files into QV like this:

            QvdFieldHeader:
            LOAD Left(FileName(), len(FileName())-4) as QVDName, *;
            LOAD FieldName,
            BitOffset,
            BitWidth,
            Bias,
            NoOfSymbols,
            Offset as HeaderOffset,
            Length as HeaderLength,
            [NumberFormat/Type] as Type,
            [NumberFormat/nDec] as nDec,
            [NumberFormat/UseThou] as UseThou,
            [NumberFormat/Fmt] as Fmt,
            [NumberFormat/Dec] as Dec
            FROM $(qvdFile)(XmlSimple, Table is [QvdTableHeader/Fields/QvdFieldHeader]);

            QvdTableHeader:
            LOAD Left(FileName(), len(FileName())-4) as QVDName, *;
            LOAD QvBuildNo,
            CreateUtcTime,
            SourceFileSize,
            TableName,
            RecordByteSize,
            NoOfRecords,
            Offset,
            Length
            FROM $(qvdFile)(XmlSimple, Table is [QvdTableHeader]);

            You could also reuse this xml part of the QVD file w/o reloading it.

            Maybe this helps.

            Ralf