Using ODBCLink/SE With ODBC Applications | ODBCLink/SE Reference Manual |
Joins
ODBCLink/SE supports two kinds of joins: inner joins, sometimes called natural joins, and Left Outer joins. An inner join will return no records if any of the secondary records are not found; a left outer joins will still return the primary
record and give nulls (or zeros) on the secondary table. To add or modify a join definition, select Catalog, Joins. The following figure illustrates this process by creating a Left Outer join from table MEMBERSHIP to table ACCT-
HISTORY.
Note: To do left outer joins on the host (as opposed to Impromptu downloading both tables and doing the joins locally) you must modify file COGDMOD.INI in directory \COGNOS\COGAPPS as follows:
[Exception tables] Joined=T
Impromptu has been known to generate incorrect SQL when joining three tables or more using a left outer join. To correct, modify the SQL that is generated and
Changing the display format
Impromptu has a limited number of display formats available. To change the display format, highlight the column and select Format Data. You cannot specify edit masks, however you have a choice of numeric display formats. To add dashes or other constants to your output, you must build an expression with SUBSTRING functions. To add a decimal point to a number that is not defined as a decimal, you must create a calculated field by dividing the number by 100.
| ODBCLink/SE |
40 | ©M.B. Foster Associates Limited |