RE: QAQQINI -- MIDRANGE-L

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.