XML schema of all tables

[lmonincx]

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!

[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

[rbecher]

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

[rwunderlich]

There are also a number of Qvd*() functions that can be used to get information about the contents of QVDS. They functions are listed in the "System Functions" section of the Ref Guide.

-Rob