Re: [MI400] Field list in Query object

[Bobby.Hicks@xxxxxxxxxxxxxxxx]

One more question.  After dumping the query object, I noticed that not all 
the fields are listed from both the input files.  All fields from the 
first file are listed,  but only a subset are listed from the second file. 
 Any ideas?  Is it that only so many fields can be selected in a query and 
if you don't specifically select those fields, the default number is 
selected.


Bobby.

Robert Hicks
Combinatorics Consulting Company
Tel.: (248) 347 - 7222, ext. 222
Fax: (248) 347 - 7227
Email:  Robert.Hicks@xxxxxxxxxxxxxxxx






"Carsten Flensburg" <flensburg@xxxxxxxxxx>
Sent by: mi400-bounces@xxxxxxxxxxxx
07/17/2003 08:29 AM
Please respond to MI Programming on the AS400 / iSeries

 
        To:     "MI Programming on the AS400 / iSeries" <mi400@xxxxxxxxxxxx>
        cc: 
        Subject:        Re: [MI400] Field list in Query object


Hello Bobby,

I think you're on the right track - but the header is only 16 bytes: The 2
bytes preceeding the field name is the file id. The field name is followed
by a 2 byte select sequence number, again followed by a 2 byte sort 
priority
number.

The select field template size found in the header includes the 16 byte
header - so to calculate the number of fields you'd say (template size - 
16)
/ 32

Best regards,
Carsten Flensburg

----- Original Message ----- 
From: <Bobby.Hicks@xxxxxxxxxxxxxxxx>
To: <mi400@xxxxxxxxxxxx>
Sent: Thursday, July 17, 2003 12:45 PM
Subject: [MI400] Field list in Query object


> Can anyone tell me if I am missing something.
>
> I want to retrieve a list of fields from a file used in a query.  I 
found
> that the offset to the field list is at 7C.  Then the space at  the 
offset
> found at 7c as the following format:    18 char header (the first 4 
bytes
> are the size of the space) then each field occupies a 32 byte space.  Is
> there something that would tell you how many fields, etc are in the list
> or do you have to calculate the number of fields by space size by 32?


_______________________________________________
This is the MI Programming on the AS400 / iSeries (MI400) mailing list
To post a message email: MI400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mi400
or email: MI400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mi400.