RE: QADBIFLD

I will look at the file when I get logged in to see if it has DDS or was
created with a record length. I'm already about 90% sure it was the record
length because I remember there was only one field in it.

Another reason to add to your list is an interface file that is dropped as a
DB2 file instead of being dropped in the IFS.

As for SYSCOLUMNS, I found the fields in "indexes" are not included in it.
I forget the field but when I looked at the view, it explicitly has "field
<> 'IX'". I originally switched one of the logicals over it but then found
other missing items so I switched to the physical figuring you can't exclude
from it like you can with a view or logical. When I found it was also
missing the fields, I was really confused.

Thanks for the info Rob. I would not have thought to look for that.


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob
Berendt
Sent: Wednesday, December 23, 2020 7:45 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: QADBIFLD

About the only "new" files created this way are people who still do
techniques like the following:
CRTPF FILE(ROB/SPOOL) RCDLEN(150)
CPYSPLF FILE(QSYSPRT) TOFILE(ROB/SPOOL) ...

This is done normally for just a few reasons.
1: Not willing to find an sql service or api to replace doing a system
command to a spool file which does not have an output file option.
2: Not willing to change to generating PDF's instead of spool files
3: Requested by IBM to send in printouts and not willing to use iACS to
download spool files to text files.

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail
to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob
Berendt
Sent: Wednesday, December 23, 2020 7:21 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: QADBIFLD

DDS or SQL doesn't matter. What won't show is this:
CRTPF FILE(ROB/DELME) RCDLEN(10)

Syscolumns is not the cure all
SELECT * FROM qsys2.syscolumns
WHERE system_table_schema='ROB' and
system_table_name='DELME'
gets a blank on that also

Rob Berendt