<div>
No way I know of to do it via DDS, but it is easy with SQL:<br />
<br />
- Gary Patterson<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />

<pre><code id="code-330404">CREATE VIEW MyTableLast30 AS
   SELECT * from MyTable WHERE somedate &gt;= current_date - 30 days 
</code></pre>
</div>


No way I know of to do it via DDS, but it is easy with SQL:

- Gary Patterson









CREATE VIEW MyTableLast30 AS
   SELECT * from MyTable WHERE somedate >= current_date - 30 days 


<div>
Would the view need to be dropped and created each day?
</div>


Would the view need to be dropped and created each day?

<div>
Thank you Gary that will get me started, if have other questions I will do another post.<br />
<br />
Thanks again<br />
Carl
</div>


Thank you Gary that will get me started, if have other questions I will do another post.

Thanks again
Carl

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

</div>


<div>
<div class="content wysiwyg-content">
I have a request to create a logical file that include records with a transaction date within the last 30 days and omits all others. The the only way I know how to do this would be to auto run a SQLRPGLE job every AM to reset the date and recreate the logical file. Is there any way to do this via DDS?<br />
<br />

</div>
</div>


I have a request to create a logical file that include records with a transaction date within the last 30 days and omits all others. The the only way I know how to do this would be to auto run a SQLRPGLE job every AM to reset the date and recreate the logical file. Is there any way to do this via DDS?



Using DATE in AS400 DDS

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.