RE: QAQQINI -- MIDRANGE-L

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/createqaqqini.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