Re: Is there an API that can show me the last time a PF was reorg'ed?

Thanks, Rob. Yea, we use that, or we did prior to Turnover which
remembers for us now. I was being a little facetious with that remark
but it is good for the archive to have the "set option" post.

Kyle

On 2/21/06, rob@xxxxxxxxx <rob@xxxxxxxxx> wrote:
> by the way, regarding that commit(*none), if you're talking about a
> sqlrpgle program sql has their own version of the hspec in
> C/EXEC SQL
> C+ Set Option
> C+     Naming    = *Sys,
> C+     Commit    = *None,
> C+     UsrPrf    = *User,
> C+     DynUsrPrf = *User,
> C+     Datfmt    = *iso,
> C+     CloSqlCsr = *EndMod
> C/END-EXEC
>
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> "Kyle Collie" <kcollie@xxxxxxxxx>
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 02/21/2006 05:28 PM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
>
>
> To
> "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> cc
>
> Fax to
>
> Subject
> Re: Is there an API that can show me the last time a PF was reorg'ed?
>
>
>
>
>
>
> Yea, I get tired of typing commit(*none)...  8-)
>
> Kyle
>
> On 2/21/06, Jim Wiant <Jim.Wiant@xxxxxxxxxxxxxxxx> wrote:
> > No rollbacks or commits or any other transaction processing? No
> > Mirroring?
> >
> > Sorry ;-)
> >
> > JPW
> >
> >
> >
> >
> >
> > The bitterness of poor quality remains long after low pricing is
> > forgotten!
> >
> >
> >
> > Cautillo, Leon M.
> >
> >
> >
> > -----Original Message-----
> > From: midrange-l-bounces@xxxxxxxxxxxx
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Kyle Collie
> > Sent: Wednesday, 22 February 2006 11:06
> > To: Midrange Systems Technical Discussion
> > Subject: Re: Is there an API that can show me the last time a PF was
> > reorg'ed?
> >
> >
> > Journaled? That's a dirty word around here.
> >
> > Thanks
> > Kyle
> >
> > On 2/21/06, Graap, Ken <keg@xxxxxxxxxxxxx> wrote:
> > > If the file is being Journaled, a journal entry is deposited to the
> > journal whenever the file is reorganized...
> > >
> > >      Journal Codes - TAA   - Detail
> > >
> > >  Code  . . . . : F = Data Base mbr
> > >  Entry type  . : RG
> > >  Sub type  . . :
> > >
> > >  Code descrp . : Physical file mbr
> > >                   reorganized (RGZPFM)
> > >
> > > Kenneth
> > >
> > > -----Original Message-----
> > > From: midrange-l-bounces@xxxxxxxxxxxx
> > > [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Kyle Collie
> > > Sent: Tuesday, February 21, 2006 1:09 PM
> > > To: Midrange Systems Technical Discussion
> > > Subject: Is there an API that can show me the last time a PF was
> > > reorg'ed?
> > >
> > >
> > > Is there an API, or any other method such as a table entry or some
> > > flag, that can tell me the last time a file was reorg'ed?
> > >
> > > Kyle
> > >
> > > --
> > > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/midrange-l.
> > >
> > >
> > > --
> > > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/midrange-l.
> > >
> > >
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> >
> > ######################################################################
> > This message was scanned for compliance with Foodstuffs email policies
> > ######################################################################
> > This message has been sent from Foodstuffs (Auckland) Limited
> ("Foodstuffs").
> >
> > The information contained in this message and or attachments
> > is intended only for the person or entity to which it is
> > addressed and may contain confidential and/or privileged
> > material. Any review, retransmission, dissemination or other
> > use of, or taking of any action in reliance upon, this
> > information by persons or entities other than the intended
> > recipient is prohibited. If you received this in error,
> > please contact the sender and delete the material from any
> > system and destroy any copies.
> >
> > The views and opinions expressed in this message may be those
> > of the individual and not necessarily those of Foodstuffs,
> > and are not given or endorsed by it.
> >
> > Please note that this communication does not designate an
> > information system for the purposes of the Electronic
> > Transactions Act 2002.
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> >
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>