Data nav Join Question

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
2.84K viewsDataNav
0
0 Comments

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?

Edited question

2 Answers

0
163 0 Comments

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.

0
709 0 Comments

Hi – I don’t have an Oracle installation handy from where I am at the moment – but just curious if you found a solution? Wonder if the oracle SQL version of a Concatenate function would work?

1019 Questions total questions asked
83 Solved total solved questions
2553 Answers total answer posted
14477 Total users total community members