Data nav Join Question

4.59K viewsDataNav

I have used data nave to connect to a oracle database. There are multiple tables I want to use.
General ledge with periodkey, versionkey, accountkey, deptkey, and companykey.
I need to join a table for each key to get a name/description. I want to create a custom fields that make the table readable. an example is as follows:
acctkey + ‘-‘ + acctdesc as account
Since acct key is in the main table and sub table I am linked to it will not accept the field. I need to do something like the following
[accountmaster].[acctkey] + ‘-‘ + [accountmaster].[acctdesc] as account
unfortunately data nave does not like this syntax. ANY SOLUTIONS?


Oracle organizes data using schemas and SQL uses databases. Data Nav can only uses join fields within the same schema/database (I Think). Crossing to another schema is my issue. Data link can do it using SQL but I haven’t found a way using data nav.

You are viewing 1 out of 2 answers, click here to view all answers.

Latest Questions

Qloud Losing Formatting 4 Answers | 0 Votes
Meditation on timelines 3 Answers | 0 Votes