RE: include current date in logical file

Ok, trivial example #2:

First, create a view of the employee table

create view corpdata/employee_v as
select empno,firstnme,midinit,lastname
from corpdata/employee
where hiredate < current_date


Second, query the view just created

select * from corpdata/employee_v


Sample output from the select query:

....+....1....+....2....+....3....+....4....+.
EMPNO FIRSTNME MIDINIT LASTNAME
000010 CHRISTINE I HAAS
000020 MICHAEL L THOMPSON
000030 SALLY A KWAN
000050 JOHN B GEYER
000060 IRVING F STERN
000070 EVA D PULASKI
000090 EILEEN W HENDERSON





-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Hoteltravelfundotcom
Sent: Tuesday, May 21, 2013 6:40 AM
To: Midrange Systems Technical Discussion
Subject: Re: include current date in logical file

I have no idea where to begin with the DDL or any of the elegant ideas given me here.
What are the steps needed to create this view ? I too want to stop using DDS. It is all I remember from AS/400 haven;'t been using for 5 years and back then the last shop was green screen strictly, this is a great way to modernize for us but how.


On Tue, May 21, 2013 at 8:31 AM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>wrote:

... and an SQL index cannot be accessed directly within an SQL
statement, but an SQL index can be used with native I/O like any keyed
logical file, i.e. in RPG it can be specified within the F-Specs, Read
with CHAIN, READ etc. OpCodes and updated or written with the
appropriate UPDATE and WRITE OpCodes.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars."
(Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training
them and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von rob@xxxxxxxxx
Gesendet: Tuesday, 21.5 2013 13:43
An: Midrange Systems Technical Discussion
Betreff: Re: include current date in logical file

With the index doing only ordering then you will have no problem
adapting to this new request.

There is some rudimentary selection capability in an index. It was
really only added there to allow DDL to replace about 90% of all DDS
logical files.
90% of DDS logical files are R IIML01R
...
S ActRec comp('A')
K ItemNumber



Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600
Mail
to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Booth Martin <booth@xxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
Date: 05/20/2013 06:31 PM
Subject: Re: MIDRANGE-L Digest, Vol 12, Issue 1084
Sent by: midrange-l-bounces@xxxxxxxxxxxx




Not possible, so far as I know.

As an aside, I would mention this: In my experience, if you do
succeed with your goal, and you provide a fantastic report of today's
orders, surer than the ocean reaching the shore someone will marvel at
it and say "Now just add in a date selector so we can find orders for any day.
That shouldn't take long."


On 5/20/2013 5:22 PM, Crystal Reports wrote:

How do you refer to current date in DDS logical file?

--
Booth Martin
802-461-5349
http://www.martinvt.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.