binary load

[manoranjan_d]

In Binary load user can use Where Clause, Group By clause and other SQL-like syntax?

[avinashelite]

Directly no where clause , Group By clause and other SQL-like syntax

but you could do a resident load the then use the where clause , Group By clause etc

[manoranjan_d]

so  u r saying

it is applicable to resident load,

it is not applicable to binary load

am i correct

[awhitfield]

Binary

The binary statement is used for loading the data from another QlikView document, including section access data. It does not load the layout information or variables.

Only one binary statement is allowed in the script and it must be the first statement of the script, even before the SET statements usually located at the beginning of the script.

Syntax:

binary [path] filename

HTH Andy

[avinashelite]

yes, your rite

[manoranjan_d]

hi whitfiled,

so binary load will load the script portion of the  document?

[avinashelite]

It loads all the script tables and model of the binary load file except the UI objects and Variables

[awhitfield]

Yep!

[avinashelite]

If you have got the answers mark the correct and helpful answers and close this thread