× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. January 2014

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



As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.