List of stored qvd's

[hopkinsc]

Hi All,

I want to include a list of all the QVD's stored on the front page of a transformation qvw so the users can easily see what QVD's that particular qvw created.

Is there an easy way of doing that without manually listing them?

[nilesh_gangurde]

Hi,

Store Qvd Name into Variable.

And then use that variable whenever required.

-Nilesh

[Gysbert_Wassenaar]

You could create a sub routine that stores as table into a qvd and also adds the table name or qvd name to a table so you can list the names of the created qvds.

QvdList:
Load '' as QvdName AutoGenerate(0);

Sub StoreAndList(TableName)

    Store $(TableName) into $(TableName).qvd ;
    Concatenate ( QvdList )
    Load '$(TableName)' as QvdName autogenerate(1);

End Sub

TableA:
load * from somewhere;

StoreAndList('TableA');

If you want to give the qvd's names different from the tables you could add another parameter to the sub and use the second parameter for the qvd name..