Re: Get Record Creation Date

@William



I think that triggers are the way around – the sample code I gave you are
actually a stripped down trigger from one upcoming product of mine
<vendor>powerEXT Monitor that does what you want – monitors and records
events on specific changes to the DB and in the same time provides a
graphical UI and messaging system</vendor>


On Sun, Jan 5, 2014 at 4:24 PM, William Salim <william.salim@xxxxxxxxx

wrote:

@Henrik & Vernon,

I am open to any process, this things is a very awful design that i

cannot

changed the files and process.
I am not working in the IT company, it is owned by "someone" that cannot

be

touch, even by the boss.
So, no Journal, no change fields allowed. (impact for that i know it is
huge, the DR process will have failed)

Just need another way around to solve this...

Thanks


On Sun, Jan 5, 2014 at 10:13 PM, Vernon Hamberg <

vhamberg@xxxxxxxxxxxxxxx

wrote:

As to reading from journals - there is now a user-defined table

function

that can do that -DISPLAY_JOURNAL -

Information can be found at

http://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/DISPLAY_JOURNAL%20%28easier%20searches%20of%20Audit%20Journal%29

I agree with Henrik that journals are a pretty heavy hammer - that is
why I suggested in another reply that some purging might be needed -

but

I think only a before image is needed, since the OP wants create date,
not change info

The trigger approach would be best to use a CREATE trigger, too, so

long

as only create date is needed - now change date? That's another story.

I don't think an UPDATE trigger is called on a CREATE of a new record -
but I'm easily corrected - just haven't looked at that in a while.

HTH
Vern

On 1/5/2014 8:52 AM, Henrik Rützou wrote:

William

these master files - who owns them?

If they are part of a standard system please ask your ISV before you

go

down the path
Dieter suggests.

I do standard systems and nobody are allowed to change the PF layer -

if

they do any
changes are overwritten by my change management when new version are
installed.

Journalling and triggers are allowed since they don't change the PF

layer.

Journals are heavy, general and nonactive, triggers can record

specific

changes and
even trigger some BL to run.


On Sun, Jan 5, 2014 at 3:39 PM, William Salim <

william.salim@xxxxxxxxx

wrote:

Dieter.. interesting, but i got no clue for that. is there any

samples?

Thanks



On Sun, Jan 5, 2014 at 9:32 PM, Henrik Rützou <hr@xxxxxxxxxxxx>

wrote:

Dieter

are you suggesting to change the original file from probably DDS

defined

to

SQL defined
and then add a logical file the correspond to the originally file

on

top

?

On Sun, Jan 5, 2014 at 3:29 PM, William Salim <

william.salim@xxxxxxxxx

wrote:
Wow ok then. I will try for this.

Thank you very much all :)
On Jan 5, 2014 9:24 PM, "Henrik Rützou" <hr@xxxxxxxxxxxx>

wrote:

Triggers dosn't change the file in any way the only thing is

happening

is

that
the trigger program is called when any update of the file is done




On Sun, Jan 5, 2014 at 3:22 PM, William Salim <

william.salim@xxxxxxxxx

wrote:
Thanks guys,
Perhaps i will try do the trigger and have analysys on that.
The rule is files cannot be changed. Hopefully trigger will not

change

the

level check of the main files.

Thanks
On Jan 5, 2014 9:08 PM, "Henrik Rützou" <hr@xxxxxxxxxxxx>

wrote:

Then you should write a trigger program that records changes to

the

file.

On Sun, Jan 5, 2014 at 2:57 PM, William Salim <

william.salim@xxxxxxxxx

wrote:
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@midrange.comTo

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.

--
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.

--
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.

--
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.

--
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,

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.

--
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.