NICE
Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
‘If you're going through hell, keep going.’
Winston Churchill
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Thursday, July 27, 2017 11:55 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: Determining if a file is DDS described or DDL described
delete rows in a physical?
Sure! SYSPARTITIONSTAT. Search the knowledge center for that.
Partition = Member
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From: Alan Shore <ashore@xxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 07/27/2017 11:51 AM
Subject: RE: Determining if a file is DDS described or DDL
described
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
Hi
I have been using the object statistics view quite a lot since we upgraded
to V7r1
There are quite a few other views that are also available
Look here
http://ibm.biz/DB2foriServices
I was wondering if there are any views that shows the number of deleted
records in a physical file
Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
‘If you're going through hell, keep going.’
Winston Churchill
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
MichaelQuigley@xxxxxxxxxx
Sent: Thursday, July 27, 2017 11:35 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Determining if a file is DDS described or DDL described
"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 07/27/2017
07:55:06 AM:
----- Message from "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx> on Thu,
27 Jul 2017 08:15:16 +0200 -----
To:
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
Subject:
RE: Determining if a file is DDS described or DDL described
The catalog view SYSTABLES will return these information Column
TABLE_TYP:
P=Physical File, T=SQL Table, L=Logical File, V=SQL View, A=Alias,
M=MQT
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!"
„Train people well enough so they can leave, treat them well enough so
they
don't want to.“ (Richard Branson)
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Matt
Olson
Sent: Mittwoch, 26. Juli 2017 21:58
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Determining if a file is DDS described or DDL described
I think I have asked this before, but what is the system view that
shows
if
a file is DDS versus DDL described?
I searched the archives but couldn't find the info.
There's also the object statistics view
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzajq/rzajqudfobjectstat.htm
The above link is to 7.2 documentation, but I'm using it on 7.1.
Michael Quigley
Computer Services
The Way International
www.TheWay.org
--
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.
Please contact support@xxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link:
http://amzn.to/2dEadiD
midrange.com
