Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
chriys1337
Creator III
Creator III

Star is *; in Section Access

Hi, I am curious about the Star is *; Statement in Section Access, what is it doing? I am well aware of the fact, that a "*" in Section Access, does only mean that all values which are in this table available will be shown. Which is not the same as all values which are existing.

So anybody has an idea? There is also another thread, which did not answer the exact question what this statement is doing.

Section Access;

[QV Auth]:
NoConcatenate LOAD * Resident QV_Auth_Pre;

Section Application;
Star is *; // Required If Wildcard Characters Are Used in SA
SA_REDUCTION:
LOAD * INLINE [ ...];

1 Solution

Accepted Solutions
awhitfield
Partner - Champion
Partner - Champion

Hi christian,

here you go:

Star

The string used for representing the set of all the values of a field in the database can be set through the star statement. It affects the subsequent LOAD and SELECT statements.

Syntax:

Star is[ string ]

Arguments:

ArgumentDescription
string

An arbitrary text. Note that the string must be enclosed by quotation marks if it contains blanks.

If nothing is specified, star is; is assumed, i.e. there is no star symbol available unless explicitly specified. This definition is valid until a new star statement is made.

View solution in original post

1 Reply
awhitfield
Partner - Champion
Partner - Champion

Hi christian,

here you go:

Star

The string used for representing the set of all the values of a field in the database can be set through the star statement. It affects the subsequent LOAD and SELECT statements.

Syntax:

Star is[ string ]

Arguments:

ArgumentDescription
string

An arbitrary text. Note that the string must be enclosed by quotation marks if it contains blanks.

If nothing is specified, star is; is assumed, i.e. there is no star symbol available unless explicitly specified. This definition is valid until a new star statement is made.