|To search on a
specific topics use the search feature within your browser -
ctrl+f and type in the subject you are looking for.
is a Subset?
What is a Data Group?
is Extra Logic?
defining one-to-many relationships in my retrieval map, just how
many is many?
happens when the report finds more records than the Subset
is the significance of Subset groups with regard to performance?
7. What is
"node" logic and does it affect performance?
8. In my
Subset, I need one field from a file which has 30 fields. If I
link this file to my Subset, there will be 29 fields there that I
don't want. What should I do?
How do I remove a field from the data dictionary?
Can I delete unwanted database fields from the dictionary?
Where two similar fields exist in the Subset, does the choice of
which field to use have any effect on performance?
What aspects of the definition of one-to-one relationships in a
Subset have an effect on performance?
In what order should I define my files on the retrieval map?
When deciding what the based-on file should be, normally a
non-keyed physical file is specified. We have had the situation
where a customer has decided to use a keyed logical file instead,
are there any performance implications with this?
How many Subsets do I need?
Why can I only have 50 unique files in my Subset?
How do I change the index key structures in my Subset?
How do I access the last record of a group of related records on
the target file?
When adding a file to a Subset, one of the key fields on the
source file was eight bytes long, but its equivalent element on
the target file was ten bytes long. OPEN/DB did not seem to check
this, but the link seems to work ok. Why is this?
A twelve character database field actually comprises three
sub-fields. The first four characters are a "Cost
Center" code, the next two are an "Activity" code
and the last six are nominal. Can sorting be done on the
"Activity" sub-field only?
When and how does OPEN/DB use the OPNQRYF command?
Can you schedule a report to be run at certain times?
What should I be aware of when upgrading the iSeries to V6R1?