RE: QAQQINI

["Bruce Collins" <bruce.collins@xxxxxxxxxxxxx>]

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.