Highlighted
Honored Contributor.. Honored Contributor..
Honored Contributor..
468 views

use view instead table

Jump to solution

Hi expert

 

can i create in dbdict a file  that point to view and not a table in the same database ? or let say can i use a predefined database  views  within SM ?

 

thanks

 

0 Likes
1 Solution

Accepted Solutions
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: use view instead table

Jump to solution

We didn't have to do #4. 

We just created the dbdict with the same field names as the view. After SM created the table in the database, we went back into the dbdict record and modified SQL Tables section to point to the view name instead of the m1 table name and then just clicked OK or Save. 

View solution in original post

3 Replies
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: use view instead table

Jump to solution

Yes, it's possible. You have to create the dbdict and then go back in and modify the SQL table name to point to the actual view.

0 Likes
Highlighted
Honored Contributor.. Honored Contributor..
Honored Contributor..

Re: use view instead table

Jump to solution

Hi Tom

 

thanks for your support,

please confirm steps to do this

1- create a view in oracle

2- create a new table  using dbdict in SM

3- in the table windows, write the name of the view  (alias is not mandatory)

4- click on "import new coluon from databse"

5- save

 

0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: use view instead table

Jump to solution

We didn't have to do #4. 

We just created the dbdict with the same field names as the view. After SM created the table in the database, we went back into the dbdict record and modified SQL Tables section to point to the view name instead of the m1 table name and then just clicked OK or Save. 

View solution in original post

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.