setting variables in binary load

[#1]

HI guys,

I am doing binary load of one QVW file into another one.

I need to set values of some variables like path of my QVD files in the first QVW file before Binary load statement executes in the second QVW file.

Any suggestions on how to do that?

Regards,

Saurabh

[Colin-Albert]

You could use an include file to hold the variable definitions and then call the include file in both QVWS.

Importing text files containing scripts?

[#3]

Hi Saurabh,

You can create your binary load statement in text file (.txt or .qvs) file and include in your main application.

/********* Main Application *******/

$(Must_Include=binary.txt);  // or include

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

// rest of script ...

Binary load statement script could be generated (manually or automatically) something like below:

/********* binary.txt  *******/

BINARY numbers_2.qvw;

It will have one statement, here source numbers_2.qvw can be changed manually or automatically. I think you will generate this binary.txt through some automation.

Does this help ?

Ersen