Re: Get Record Creation Date

I think will do the trigger process combined with the RRN.

I'd not use the RRN but the unique key fields.
If the physical file is reorganized, the relative record no will/may be
changed.

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: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
Im
Auftrag von William Salim
Gesendet: Sunday, 05.1 2014 17:17
An: RPG programming on the IBM i (AS/400 and iSeries)
Betreff: Re: Get Record Creation Date

Thanks Dieter,

I think i have that things, that from the main file I made another file
that
contains year.
The program is in batch, runs at 00.30 am. Problem happened when new year
comes, reading from the main file that sort by the month+day (no other
keys).
When new year comes and program executed, it will be many transactions
duplicated the key month+day it could be from 5 years or more.

I think will do the trigger process combined with the RRN.

Thanks



On Sun, Jan 5, 2014 at 10: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%20se
arches%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

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