<div>
You use a view in a SELECT query just like you would use a table:<br />
&nbsp;<br />
strsql<br />
select * from yourviewnamegoeshere<br />
<br />
- Gary Patterson
</div>


You use a view in a SELECT query just like you would use a table:
 
strsql
select * from yourviewnamegoeshere

- Gary Patterson

<div>
Hey Gary,<br />
<br />
Thanks for the help yet again. &nbsp;How do I alter that view? &nbsp;I ask because when I run that command for my query, I get this error: &nbsp;Selection error involving field *N.<br />
<br />
I would assume it has something to do with my query criteria. &nbsp;
</div>


Hey Gary,

Thanks for the help yet again.  How do I alter that view?  I ask because when I run that command for my query, I get this error:  Selection error involving field *N.

I would assume it has something to do with my query criteria.  

<div>
Drop the view and re-create it.<br />
<br />
- Gary
</div>


<div>
Ahhh- thanks for the info Gary.<br />
<br />
Very handy.<br />
<br />
I appreciate it.<br />
<br />
-Anthony
</div>


Ahhh- thanks for the info Gary.

Very handy.

I appreciate it.

-Anthony

<div>
Happy to help.<br />
<br />
- Gary
</div>


<div>
<div class="content wysiwyg-content">
Hi everyone, I created an sql view on an iseries; however, I don't know how to view it and see the results.<br />
<br />
I created the sql using strsql and then going through the prompts. &nbsp;I know the view is there, because I can drop it- but I can't see it.<br />
<br />
Can someone help me, I've a 400 novice.
</div>
</div>


Hi everyone, I created an sql view on an iseries; however, I don't know how to view it and see the results.

I created the sql using strsql and then going through the prompts.  I know the view is there, because I can drop it- but I can't see it.

Can someone help me, I've a 400 novice.

How retrieve a view from an SQL query on iSeries?

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.