|
midrange.com
Here's mine (V5R3):
-------------------------------------------
Display File Field Description
Input parameters
File . . . . . . . . . . . . . . . . . . . : QAQQINI
Library . . . . . . . . . . . . . . . . . : QSYS
File Information
File . . . . . . . . . . . . . . . . . . . : QAQQINI
Library . . . . . . . . . . . . . . . . . : QSYS
File location . . . . . . . . . . . . . . . : *LCL
Externally described . . . . . . . . . . . : Yes
Number of record formats . . . . . . . . . : 1
Type of file . . . . . . . . . . . . . . . : Physical
File creation date . . . . . . . . . . . . : 11/09/00
Text 'description'. . . . . . . . . . . . . : QUERY OPTIONS FILE
Record Format Information
Record format . . . . . . . . . . . . . . . : QAQQINI
Format level identifier . . . . . . . . . . : 336865A21EA65
Number of fields . . . . . . . . . . . . . : 3
Record length . . . . . . . . . . . . . . . : 2518
Format text . . . . . . . . . . . . . . . . : Query options file
Field Level Information
Data Field Buffer Buffer Field Column
Field Type Length Length Position Usage Heading
QQPARM CHAR 256 258 1 Both Parameter
Field text . . . . . . . . . . . . . . . : Query option parameter
Variable length field -- Allocated length : 10
Coded Character Set Identifier . . . . . : 37
QQVAL CHAR 256 258 259 Both Parameter Value
Field text . . . . . . . . . . . . . . . : Query option parameter value
Variable length field -- Allocated length : 10
Coded Character Set Identifier . . . . . : 37
QQTEXT GRAPHIC 1000 2002 517 Both Query Option
Text
Field text . . . . . . . . . . . . . . . : Query option text
Variable length field -- Allocated length : 100
Allows the null value
Default value . . . . . . . . . . . . . . :
*NULL
Coded Character Set Identifier . . . . . : 13488
UCS2 Conversion . . . . . . . . . . . . . : *CONVERT
----------------------------------------------------------------------------------
6/22/06 Display File Description
DSPFD Command Input
File . . . . . . . . . . . . . . . . . . . : FILE QAQQINI
Library . . . . . . . . . . . . . . . . . : *LIBL
Type of information . . . . . . . . . . . . : TYPE *ALL
File attributes . . . . . . . . . . . . . . : FILEATR *ALL
System . . . . . . . . . . . . . . . . . . : SYSTEM *LCL
File Description Header
File . . . . . . . . . . . . . . . . . . . : FILE QAQQINI
Library . . . . . . . . . . . . . . . . . . : QSYS
Type of file . . . . . . . . . . . . . . . : Physical
File type . . . . . . . . . . . . . . . . . : FILETYPE *DATA
Auxiliary storage pool ID . . . . . . . . . : 01
Data Base File Attributes
Externally described file . . . . . . . . . : Yes
File level identifier . . . . . . . . . . . : 1001109063428
Creation date . . . . . . . . . . . . . . . : 11/09/00
Text 'description' . . . . . . . . . . . . : TEXT QUERY OPTIONS FILE
Distributed file . . . . . . . . . . . . . : No
DBCS capable . . . . . . . . . . . . . . . : Yes
Maximum members . . . . . . . . . . . . . . : MAXMBRS 1
Number of constraints . . . . . . . . . . . : 0
Number of triggers . . . . . . . . . . . . : 6
Number of members . . . . . . . . . . . . . : 1
Access path maintenance . . . . . . . . . . : MAINT *IMMED
Access path recovery . . . . . . . . . . . : RECOVER *AFTIPL
Force keyed access path . . . . . . . . . . : FRCACCPTH *NO
Member size . . . . . . . . . . . . . . . . : SIZE *NOMAX
Allocate storage . . . . . . . . . . . . . : ALLOCATE *NO
Contiguous storage . . . . . . . . . . . . : CONTIG *NO
Preferred storage unit . . . . . . . . . . : UNIT *ANY
Records to force a write . . . . . . . . . : FRCRATIO *NONE
Maximum file wait time . . . . . . . . . . : WAITFILE *IMMED
Maximum record wait time . . . . . . . . . : WAITRCD 60
Max % deleted records allowed . . . . . . . : DLTPCT *NONE
Reuse deleted records . . . . . . . . . . . : REUSEDLT *YES
Coded character set identifier . . . . . . : CCSID See DSPFFD
Allow read operation . . . . . . . . . . . : Yes
Allow write operation . . . . . . . . . . . : Yes
Allow update operation . . . . . . . . . . : ALWUPD *YES
Allow delete operation . . . . . . . . . . : ALWDLT *YES
Record format level check . . . . . . . . . : LVLCHK *YES
Access path . . . . . . . . . . . . . . . . : Keyed
Access path size . . . . . . . . . . . . . : ACCPTHSIZ *MAX1TB
Maximum key length . . . . . . . . . . . . : 258
Maximum record length . . . . . . . . . . . : 2518
File is currently journaled . . . . . . . . : No
Access Path Description
Access path maintenance . . . . . . . . . . : MAINT *IMMED
Unique key values required . . . . . . . . : UNIQUE Yes
Access path journaled . . . . . . . . . . . : No
Access path . . . . . . . . . . . . . . . . : Keyed
Constraint Type . . . . . . . . . . . . . . : NONE
Number of key fields . . . . . . . . . . . : 1
Record format . . . . . . . . . . . . . . . : QAQQINI
Key field . . . . . . . . . . . . . . . . : QQPARM
Sequence . . . . . . . . . . . . . . . : Ascending
Sign specified . . . . . . . . . . . . : UNSIGNED
Zone/digit specified . . . . . . . . . : *NONE
Alternative collating sequence . . . . : No
Sort Sequence . . . . . . . . . . . . . . . : SRTSEQ *HEX
Language identifier . . . . . . . . . . . . : LANGID ENU
Trigger Description
Trigger name . . . . . . . . . . . . . . . : TRG Q__OSYS_QAQQINI_B
EFORE_INSERT_______
Trigger library . . . . . . . . . . . . . : QSYS
Trigger state . . . . . . . . . . . . . . : STATE *ENABLED
Trigger status . . . . . . . . . . . . . : *OPERATIVE
Trigger event . . . . . . . . . . . . . . : TRGEVENT *INSERT
Trigger time . . . . . . . . . . . . . . : TRGTIME *BEFORE
Allow repeated change . . . . . . . . . . : ALWREPCHG *YES
Program Name . . . . . . . . . . . . . . : PGM QQQTINI
Library . . . . . . . . . . . . . . . . : QSYS
Program is threadsafe . . . . . . . . . . : THDSAFE *UNKNOWN
Multithreaded job action . . . . . . . . : MLTTHDACN *SYSVAL
Trigger type . . . . . . . . . . . . . . : *SYS
Trigger orientation . . . . . . . . . . . : *ROW
Trigger creation date and time . . . . . : 11/09/00 06:34:31
Number of trigger update columns . . . . : 0
Trigger name . . . . . . . . . . . . . . . : TRG Q__OSYS_QAQQINI_A
FTER_INSERT________
Trigger library . . . . . . . . . . . . . : QSYS
Trigger state . . . . . . . . . . . . . . : STATE *ENABLED
Trigger status . . . . . . . . . . . . . : *OPERATIVE
Trigger event . . . . . . . . . . . . . . : TRGEVENT *INSERT
Trigger time . . . . . . . . . . . . . . : TRGTIME *AFTER
Allow repeated change . . . . . . . . . . : ALWREPCHG *NO
Program Name . . . . . . . . . . . . . . : PGM QQQTINI
Library . . . . . . . . . . . . . . . . : QSYS
Program is threadsafe . . . . . . . . . . : THDSAFE *UNKNOWN
Multithreaded job action . . . . . . . . : MLTTHDACN *SYSVAL
Trigger type . . . . . . . . . . . . . . : *SYS
Trigger orientation . . . . . . . . . . . : *ROW
Trigger creation date and time . . . . . : 11/09/00 06:34:32
Number of trigger update columns . . . . : 0
Trigger name . . . . . . . . . . . . . . . : TRG Q__OSYS_QAQQINI_B
EFORE_UPDATE_______
Trigger library . . . . . . . . . . . . . : QSYS
Trigger state . . . . . . . . . . . . . . : STATE *ENABLED
Trigger status . . . . . . . . . . . . . : *OPERATIVE
Trigger event . . . . . . . . . . . . . . : TRGEVENT *UPDATE
Trigger time . . . . . . . . . . . . . . : TRGTIME *BEFORE
Allow repeated change . . . . . . . . . . : ALWREPCHG *YES
Trigger update condition . . . . . . . . : TRGUPDCND *CHANGE
Program Name . . . . . . . . . . . . . . : PGM QQQTINI
Library . . . . . . . . . . . . . . . . : QSYS
Program is threadsafe . . . . . . . . . . : THDSAFE *UNKNOWN
Multithreaded job action . . . . . . . . : MLTTHDACN *SYSVAL
Trigger type . . . . . . . . . . . . . . : *SYS
Trigger orientation . . . . . . . . . . . : *ROW
Trigger creation date and time . . . . . : 11/09/00 06:34:31
Number of trigger update columns . . . . : 0
Trigger name . . . . . . . . . . . . . . . : TRG Q__OSYS_QAQQINI_A
FTER_UPDATE________
Trigger library . . . . . . . . . . . . . : QSYS
Trigger state . . . . . . . . . . . . . . : STATE *ENABLED
Trigger status . . . . . . . . . . . . . : *OPERATIVE
Trigger event . . . . . . . . . . . . . . : TRGEVENT *UPDATE
Trigger time . . . . . . . . . . . . . . : TRGTIME *AFTER
Allow repeated change . . . . . . . . . . : ALWREPCHG *NO
Trigger update condition . . . . . . . . : TRGUPDCND *ALWAYS
Program Name . . . . . . . . . . . . . . : PGM QQQTINI
Library . . . . . . . . . . . . . . . . : QSYS
Program is threadsafe . . . . . . . . . . : THDSAFE *UNKNOWN
Multithreaded job action . . . . . . . . : MLTTHDACN *SYSVAL
Trigger type . . . . . . . . . . . . . . : *SYS
Trigger orientation . . . . . . . . . . . : *ROW
Trigger creation date and time . . . . . : 11/09/00 06:34:32
Number of trigger update columns . . . . : 0
Trigger name . . . . . . . . . . . . . . . : TRG Q__OSYS_QAQQINI_B
EFORE_DELETE_______
Trigger library . . . . . . . . . . . . . : QSYS
Trigger state . . . . . . . . . . . . . . : STATE *ENABLED
Trigger status . . . . . . . . . . . . . : *OPERATIVE
Trigger event . . . . . . . . . . . . . . : TRGEVENT *DELETE
Trigger time . . . . . . . . . . . . . . : TRGTIME *BEFORE
Allow repeated change . . . . . . . . . . : ALWREPCHG *YES
Program Name . . . . . . . . . . . . . . : PGM QQQTINI
Library . . . . . . . . . . . . . . . . : QSYS
Program is threadsafe . . . . . . . . . . : THDSAFE *UNKNOWN
Multithreaded job action . . . . . . . . : MLTTHDACN *SYSVAL
Trigger type . . . . . . . . . . . . . . : *SYS
Trigger orientation . . . . . . . . . . . : *ROW
Trigger creation date and time . . . . . : 11/09/00 06:34:31
Number of trigger update columns . . . . : 0
Trigger name . . . . . . . . . . . . . . . : TRG Q__OSYS_QAQQINI_A
FTER_DELETE________
Trigger library . . . . . . . . . . . . . : QSYS
Trigger state . . . . . . . . . . . . . . : STATE *ENABLED
Trigger status . . . . . . . . . . . . . : *OPERATIVE
Trigger event . . . . . . . . . . . . . . : TRGEVENT *DELETE
Trigger time . . . . . . . . . . . . . . : TRGTIME *AFTER
Allow repeated change . . . . . . . . . . : ALWREPCHG *NO
Program Name . . . . . . . . . . . . . . : PGM QQQTINI
Library . . . . . . . . . . . . . . . . : QSYS
Program is threadsafe . . . . . . . . . . : THDSAFE *UNKNOWN
Multithreaded job action . . . . . . . . : MLTTHDACN *SYSVAL
Trigger type . . . . . . . . . . . . . . : *SYS
Trigger orientation . . . . . . . . . . . : *ROW
Trigger creation date and time . . . . . : 11/09/00 06:34:32
Number of trigger update columns . . . . : 0
Member Description
Member . . . . . . . . . . . . . . . . . . : MBR QAQQINI
Member level identifier . . . . . . . . . : 1001109063429
Member creation date . . . . . . . . . . : 11/09/00
Text 'description' . . . . . . . . . . . : TEXT QUERY OPTIONS FILE
Expiration date for member . . . . . . . : EXPDATE *NONE
Access path maintenance . . . . . . . . . : MAINT *IMMED
Access path recovery . . . . . . . . . . : RECOVER *AFTIPL
Member size . . . . . . . . . . . . . . . : SIZE *NOMAX
Current number of records . . . . . . . . : 13
Number of deleted records . . . . . . . . : 0
Allocate storage . . . . . . . . . . . . : ALLOCATE *NO
Contiguous storage . . . . . . . . . . . : CONTIG *NO
Preferred storage unit . . . . . . . . . : UNIT *ANY
Records to force a write . . . . . . . . : FRCRATIO *NONE
Share open data path . . . . . . . . . . : SHARE *NO
Max % deleted records allowed . . . . . . : DLTPCT *NONE
Number of member accesses . . . . . . . . : 206
Data Space Activity Statistics . . . . . :
Data space size in bytes . . . . . . . : 28672
Physical file open accesses . . . . . . :
Physical file close accesses . . . . . :
Write operations . . . . . . . . . . . :
Update operations . . . . . . . . . . . :
Delete operations . . . . . . . . . . . :
Logical Reads . . . . . . . . . . . . . :
Physical Reads . . . . . . . . . . . . :
Clear operations . . . . . . . . . . . :
Data space copy operations . . . . . . :
Reorganize operations . . . . . . . . . :
Access paths builds/rebuilds . . . . . :
Records rejected by key selection . . . :
Records rejected by non-key selection . :
Records rejected by group-by selection. :
Access Path Activity Statistics . . . . . :
Access path logical reads . . . . . . . :
Access path physical reads . . . . . . :
Access path size . . . . . . . . . . . : 24576
Number of access path entries . . . . . : 13
Access path valid . . . . . . . . . . . : Yes
Implicit access path sharing . . . . . : No
Access path journaled . . . . . . . . . : No
Last change date/time . . . . . . . . . . : 03/06/04 05:42:45
Extract date/time . . . . . . . . . . . . : 06/22/06 13:27:03
Last extract date/time . . . . . . . . . : 04/15/05 11:09:28
Last save date/time . . . . . . . . . . . : 12/19/00 16:11:09
Last restore date/time . . . . . . . . . : 03/06/04 05:40:48
Last used date . . . . . . . . . . . . . : 04/15/05
Days used count . . . . . . . . . . . . . : 3
Reset date . . . . . . . . . . . . . . :
Record Format List
Record Format Level
Format Fields Length Identifier
QAQQINI 3 2518 336865A21EA65
Text . . . . . . . . . . . . . . . . . . . : Query options file
Total number of formats . . . . . . . . . . : 1
Total number of fields . . . . . . . . . . . : 3
Total record length . . . . . . . . . . . . : 2518
Member List
Source Creation Last Change
Deleted
Member Size Type Date Date Time Records
Records
QAQQINI 53248 11/09/00 03/06/04 05:42:45 13
0
Text: QUERY OPTIONS FILE
Total number of members . . . . . . . . . : 1
Total number of members not available . . : 0
Total records . . . . . . . . . . . . . . : 13
Total deleted records . . . . . . . . . . : 0
Total of member sizes . . . . . . . . . . : 53248
Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-297-2863 or ext. 1863
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Bruce Collins
Sent: Thursday, June 22, 2006 9:21 AM
To: Midrange Systems Technical Discussion
Subject: RE: QAQQINI
V5R3
Bruce "Hoss" Collins
IBM Certified Specialist - eServer i5 iSeries System Administrator V5R3
Cisco Certified Network Associate
AAA Cooper Transportation
Dothan, AL 36303
(334)793-2284 x2434
-----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l- bounces@xxxxxxxxxxxx] On Behalf Of DeLong, Eric Sent: Wednesday, June 21, 2006 5:52 PM To: Midrange Systems Technical Discussion Subject: RE: QAQQINI What release? IBM will change this from time to time as they add functionality to the SQL engine. There have been many new features
added
to QAQQINI in the last few releases. IBM always recommends that you crtdupobj the QSYS/QAQQINI file that is restored from the install
media.
There are triggers on this that need to be retained on any copy of the QAQQINI file you create.
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/topic/rzajq/create qa
qqini.htm#createqaqqini Eric DeLong Sally Beauty Company MIS-Project Manager (BSG) 940-297-2863 or ext. 1863 -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Bruce Collins Sent: Wednesday, June 21, 2006 5:38 PM To: Midrange Systems Technical Discussion Subject: QAQQINI I have just noticed that in the QAQQINI the record length is different from the old system. I spoke to the systems guys but they have no clue. I went into single record mode using DBU and did a page down. On the
Old
System the records looked ok but on the new system it looks like It
has
trash in the last 2 places of the 2nd and 3rd fields. In fact the last byte of the 2nd field is the first letter of the 3rd field. Any thoughts? Bruce "Hoss" Collins IBM Certified Specialist - eServer i5 iSeries System Administrator
V5R3
Cisco Certified Network Associate
AAA Cooper Transportation
Dothan, AL 36303
(334)793-2284 x2434
OLD SYSTEM
DBU Field Selection
File . . . . : QAQQINI Text . . . . QAQQINI
Library . . : QTEMP Member . . : QAQQINI
Position to Record Format . . . . . . . . RQAQQINI Name, F4 for
list
Position to Field Name . . . . . . . . . Name*, *FIRST,
*LAST
Single Record Text/Field Name . . . . . . TXT TXT/FLD/BTH/ALS
Mult Record Text/Field/Column Heading . . FLD TXT/FLD/HDG/ALS
Select/Remove field Auto Dup . . . . . . RMV SEL/RMV
Display New New Auto Upper Allow Field
Seq# Select Only Line Page Dup Case Null Name Type Length
Dec Loc
10 Query option parameter K01 QQPARM A 256
1
20 Query option parameter va QQVAL A 256
259
30 Query option text QQTEXT A 1000
517
Record Length 1518 with 3 fields
------------------------------------------------------------------------
--------------------
NEW SYSTEM
DBU Field Selection
File . . . . : QAQQINI Text . . . . QUERY OPTIONS FILE
Library . . : QSYS Member . . : QAQQINI
Position to Record Format . . . . . . . . QAQQINI Name, F4 for
list
Position to Field Name . . . . . . . . .
NAME/*FIRST/*LAST/GEN.*
Single Record Text/Field Name . . . . . . BTH TXT/FLD/BTH/ALS
Mult Record Text/Field/Column Heading . . FLD TXT/FLD/HDG/ALS
Select/Remove field Auto Dup . . . . . . RMV SEL/RMV
Display New New Auto Upper Allow Field
Seq# Select Only Line Page Dup Case Null Name Type Length
Dec Loc
10 Query option parameter K01 QQPARM A 256
1
20 Query option parameter va QQVAL A 256
257
30 X Query option text QQTEXT A 1000
513
Record Length 1512 with 3 fields
--
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.
As an Amazon Associate we earn from qualifying purchases.
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.
