× 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

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





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.