Re: Get Record Creation Date

Hi,
What about adding a trigger and that trigger can record your triggered DB
suits.
Chamara.

From: William Salim
Sent: Sunday, 5 January 2014 19:28
To: RPG programming on the IBM i (AS/400 and iSeries)
Reply To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: Get Record Creation Date

First of all, there are no journals and files cannot added new fields..
Files used by many old programs that strictly cannot changed and do those
two things (journal and add field).
Bad design but need alternative solutions..

Thanks
On Jan 5, 2014 8:48 PM, "Henrik Rützou" <hr@xxxxxxxxxxxx> wrote:

> As suggested - add a creation data field to the record
>
> or ...
>
> journal the file
>
> or
>
> add a trigger program that records when records are added
>
>
> On Sun, Jan 5, 2014 at 2:31 PM, Bill Wragg <bill_wragg@xxxxxxxx> wrote:
>
> > Only solution is to add a date field to the record and when it is
created
> > populate it with the date.
> >
> > Good Luck
> >
> > -----Original Message-----
> > From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:
> rpg400-l-bounces@xxxxxxxxxxxx]
> > On Behalf Of William Salim
> > Sent: January-05-14 7:17 AM
> > To: rpg400-l@xxxxxxxxxxxx
> > Subject: Get Record Creation Date
> >
> > Hi Everyone..
> >
> > I look something that RPG or Any other language can have the
capability
> to
> > get the creation date for the record that has been created in files
> > (PF/LF).
> >
> > i have try to do the exploration using the QDBRTVFD but still no
result,
> > the
> > API only gave the last updated files not record.
> >
> > is there any solutions for this?, i really appreciate whether it will
do
> > another language or process in I series
> >
> >
> > Thanks
> >
> > --
> > Regards,
> >
> > William Salim
> > --
> > This is the RPG programming on the IBM i (AS/400 and iSeries)
(RPG400-L)
> > mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To
> subscribe,
> > unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives at
> > http://archive.midrange.com/rpg400-l.
> >
> > --
> > This is the RPG programming on the IBM i (AS/400 and iSeries)
(RPG400-L)
> > mailing list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
> >
> >
>
>
> --
> Regards,
> Henrik Rützou
>
> http://powerEXT.com <http://powerext.com/>
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.