Alters data source logon parameters prior to logon. Can be used to override default connection logon parameters.
ALTER-CONNECTION NAME=connection_name [DSN={uq_txt_lit|_var}] [USER={uq_txt_lit|_var}] [PASSWORD={uq_txt_lit|_var}] [PARAMETERS=keyword_str=attr_str; [, keyword_str=attr_str;...]] [NO-DUPLICATE=TRUE|FALSE] SET-GENERATIONS=([{dimension1, hierarchy1} [,dimensioni, hierarchyi] ...]) SET-LEVELS=([{dimension1, level1} [,dimensioni, leveli] ...]) SET-MEMBERS=([{dimension1, level1} [,dimensioni, leveli] ...])
User-defined name for describing a data source connection.
Logical data source name recorded in Registry.properties.
Traditional logon semantics.
Keyword-attribute pairs required by data source drivers for logon. Syntax restrictions include delimiting semi-colons (;) and equal signs (=). Keywords must match logon property names for data sources in property files.
NO-DUPLICATE=TRUE|FALSE (default is FALSE)
(Optional) Prevents Production Reporting from creating additional logins to data sources handling previous queries. Creating a new login is the default behavior, allowing a single CONNECTION declaration in a subquery. This behavior, while allowing dynamic logins as needed, causes difficulties when doing DDL (BEGIN-SQL) and DML (BEGIN-SELECT) against temporary tables in some data sources. In such cases, you must fetch from the temporary table using the same login in which it was created. Here, you should code CONNECTION as NO-DUPLICATE=TRUE, and then use that connection in both the table creation logic of BEGIN-SQL and the row fetching logic of BEGIN‑SELECT.
SET-GENERATIONS
Dimension hierarchy for the previously-declared dimension. In the following example:
set-generations=('product',5,'time',1 )Returns the members in the ‘product’ dimension at the 5th generation in the hierarchy.
For example, returns all ‘Brand Name’ members (Generation Level 5) under the product hierarchy of ‘all products.drink.alcoholic beverages.beer and wine’. This increases the result set to a list of beers and wines.
Returns the members in the ‘time’ dimension at the 1st generation in the hierarchy.
For example, returns all ‘Year’ members (Generation Level 1) under the time hierarchy of ‘1997.Q.2.’ This reduces the result set to ‘1997’.
To clear values defined with SET-GENERATIONS, use:
set-generations=()
SET-LEVELS
Extends dimension hierarchies for previously-declared dimensions. Dimensions and hierarchies defined with SET-LEVELS can be literal values only. In the following example:
set-levels=('product',2 )SET-LEVELS used with the previous SET-MEMBERS returns all members under the product hierarchy and the next two generations (Product SubCategory and Brand Name) for the product hierarchy of ‘all products.drink.alcoholic beverages.beer and wine’.
SET-LEVELS used with the previous SET-MEMBERS and SET‑GENERATIONS returns all members for generation levels 5 through 7 under the product hierarchy of ‘all products.drink.alcoholic beverages.beer and wine.’
To clear values defined with SET-LEVELS, use:
set-levels=()
SET-MEMBERS
Returns the members in a dimension, level, or hierarchy whose name is specified by a string. Dimensions and hierarchies defined with SET‑MEMBERS can be literal values only. In the following example:
set-members=('product','all products.drink.alcoholic beverages.beer and wine','time','1997.Q1.2' )SET-MEMBERS:
Returns the members in the ‘product’ dimension, at the ‘all products’ hierarchy, at the ‘drink’, ‘alcoholic beverages’, and ‘beer and wine’ levels.
Returns the members in the ‘time’ dimension, at the ‘1997’ hierarchy, at the ‘Q1’ and ‘2’ levels.
To clear values defined with SET-MEMBERS, use:
set-members=()
alter-connection name=SAPR3-1 password=psswd parameters=logon.client=600;logon.ashost=starfish;logon.sysnr= 00;logon.language=EN;
Do not wrap the lines in the 'parameters=' line. Space restrictions dictate the wrapped line in the preceding example.