By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,237 Members | 1,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,237 IT Pros & Developers. It's quick & easy.

DWB and Views

P: n/a
Hi.

How to add views from database explorer to data project explorer?
the only options I can see at data project explorer:
- sql scripts
- stored procedures
- user-defined functions

None of those 3 folders accept views..
are those folders fixed or can be expanded to accept adding Views?

Thanks
FS

Sep 8 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
fayez wrote:
Hi.

How to add views from database explorer to data project explorer?
the only options I can see at data project explorer:
- sql scripts
- stored procedures
- user-defined functions

None of those 3 folders accept views..
are those folders fixed or can be expanded to accept adding Views?
Drill down to the schema where you want to add the view.
The schema has a VIEWS folder. Right click, NEW->With SQL Editor.
It generates a template for you:
CREATE VIEW SRIELAU.view1
AS SELECT col1, col2
FROM SRIELAU.table1
WHERE col2 = 99;

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 8 '06 #2

P: n/a
sorry Serge, may be I did not explain what I need in a right way..
I have the views created at database under schema..
I want to copy (move) this view under Data Project Explorer so I can
modify, add to my Clearcase vob .. etc

Thanks for your help.

FS

Serge Rielau wrote:
fayez wrote:
Hi.

How to add views from database explorer to data project explorer?
the only options I can see at data project explorer:
- sql scripts
- stored procedures
- user-defined functions

None of those 3 folders accept views..
are those folders fixed or can be expanded to accept adding Views?
Drill down to the schema where you want to add the view.
The schema has a VIEWS folder. Right click, NEW->With SQL Editor.
It generates a template for you:
CREATE VIEW SRIELAU.view1
AS SELECT col1, col2
FROM SRIELAU.table1
WHERE col2 = 99;

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 8 '06 #3

P: n/a
fayez wrote:
sorry Serge, may be I did not explain what I need in a right way..
I have the views created at database under schema..
I want to copy (move) this view under Data Project Explorer so I can
modify, add to my Clearcase vob .. etc
Ah.. now that I do not know about. I will try(!) to inquire.

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 8 '06 #4

P: n/a
ok, thanks for help..

Serge Rielau wrote:
fayez wrote:
sorry Serge, may be I did not explain what I need in a right way..
I have the views created at database under schema..
I want to copy (move) this view under Data Project Explorer so I can
modify, add to my Clearcase vob .. etc
Ah.. now that I do not know about. I will try(!) to inquire.

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 12 '06 #5

P: n/a
fayez wrote:
ok, thanks for help..

Serge Rielau wrote:
>fayez wrote:
>>sorry Serge, may be I did not explain what I need in a right way..
I have the views created at database under schema..
I want to copy (move) this view under Data Project Explorer so I can
modify, add to my Clearcase vob .. etc
Ah.. now that I do not know about. I will try(!) to inquire.
I passed your inquiry along, but haven't gotten a response.
If you really are interested you'll need to work through the official
channel (PMR)

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 12 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.