How are dL4 date fields defined?
Are dL4 date fields supported by IQ?
Which file types are supported by IQ?
Why does my IQ for Unix license file get invalidated on a regular basis?
How do I compute a percentage subtotal in IQ?
How do I define a MRT record which contains multiple possible values?
How can I detect if IQ is performing a fast key search?
How can I detect if IQ is performing a smart sort?
What is "ODBC error: Microsoft (ODBC SQL driver) (SQL server incorrect syntax near DBO)"?
How do I recover from "ODBC error: Microsoft (ODBC SQL driver) (SQL server incorrect syntax near DBO)"?
Why do I get the word "reserved" in the upper left corner of the screen on starting IQ 3.1?
Which printer configuration file does IQ for UNIX uses for background print?
Why do I get "ODBC ERROR MESSAGE: ODBC is not installed on this machine."?
How can I have IQ skip deleted records in a FoxPro file?
Where are IQ error codes documented?
What does the message, "Code 1:x, Code 2:y" mean?
How do I recover from Code 1:25, Code 2:-4?
Can I use an IQ2 iqcap terminal file with IQ4?
How do I prevent my IQ process from running after disconnecting from my telnet or dialup session?
Is IQ year 2000 compliant?
Is IQ supported in a network environment?
Can I use Samba with IQ?
What are Universal Data files?
What product versions support Universal Data files?
Can earlier releases access Universal Data files?
How are Universal Data files defined in the IQ data dictionary?

How are dL4 date fields defined?

dL4 date fields are defined as field type 176. For "Field Size", use 2, 4 or 6 for 1%, 2%, and 3% date fields respectively. In addition, use Y0M0D9 for "Date Layout", 10 for "Output Size of Field", and use MM/DD/YYYY for "Output Format".
Back to IQ FAQ's

Are dL4 date fields supported by IQ?

IQ versions 4 and 5 support dL4 date fields.
Back to IQ FAQ's

Which file types are supported by IQ?

IQ release 3, 4, and 5 support files types 0, 1, 3, 44, 261, 262, 263 (version 4 only), and 999. All other file types are NOT supported.
Back to IQ FAQ's

Why does my IQ for Unix license file get invalidated on a regular basis?

On most Unix systems, using the "-a" option with cpio alters the "change time" on a file in UNIX on output. Do not use the "-a" option when backing up files in the /etc/DCI directory or skip the /etc/DCI directory when performing backups.

This problem can be avoided by using a hardware passport device.
Back to IQ FAQ's

How do I compute a percentage subtotal in IQ?

The IQ User's Guide states "to create a subtotal that is a percentage in IQ for UNIX or Windows, you must multiply by 100 before dividing. For instance, to create a tuition percentage column rather than a tuition ratio column, perform the calculations in this order:

1. Multiply TUITION by 100 to get TEMP.

2. Divide TEMP by ORIG-TOTAL-DUE to get TUITION-PCT.

The proper order of the commands within your procedure would be:

MULTIPLY TUITION TIMES 100 GIVING TEMP.
DIVIDE TEMP BY ORIG-TOTAL-DUE GIVING TUITION-PCT."
Back to IQ FAQ's

How do I define a MRT record which contains multiple possible values?

If a MRT record does not contain unique record identification, then it is defined as a default record type. A default record type must be the very last record type defined. In addition, it should be defined as a recurring record. The Record ID Code Type, Location, Sub-field Offset, and Storage Size must be set to zero (0), one (1), zero (0), and zero (0) respectively. Furthermore, the Record ID Code must also be set to zero (0).

Please refer to "IQ Data Dictionary Reference" manual for a detailed description.
Back to IQ FAQ's

How can I detect if IQ is performing a fast key search?

IQ performs a fast key search only on primary files. This process can be identified when the number of records processed is equal to the number of records found.
Back to IQ FAQ's

How can I detect if IQ is performing a smart sort?

IQ performs a smart sort when the field being sorted is in the index of primary files. This process can be identified if the initial sort is completed in a single pass.
Back to IQ FAQ's

What is "ODBC error: Microsoft (ODBC SQL driver) (SQL server incorrect syntax near DBO)"?

IQ has detected a 32-bit ODBC driver, instead of Microsoft?s 16-bit ODBC driver.
Back to IQ FAQ's

How do I recover from "ODBC error: Microsoft (ODBC SQL driver) (SQL server incorrect syntax near DBO"?

IQ for Windows uses the 16-bit ODBC driver, instead of the 32-bit ODBC. Installing the 16-bit ODBC resolves this problem.
Back to IQ FAQ's

Why do I get the word "reserved" in the upper left corner of the screen on starting IQ 3.1?

IQ3 will not run with an IQ2 SSN and IQ3 reports ?reserved? mistakenly. A later version of IQ3 correctly reports a security violation.
Back to IQ FAQ's

Which printer configuration file does IQ for UNIX uses for background print?

IQ for UNIX uses iqprtcfg.dat as the configuration file for background print.
Back to IQ FAQ's

Why do I get "ODBC ERROR MESSAGE: ODBC is not installed on this machine."?

When IQ for Windows is started with an empty data dictionary, like the distributed ddmaster.dat, it attempts to use the 16-bit ODBC driver. The above message is then reported if the ODBC driver is not installed. Please install the Microsoft 16-bit ODBC driver to avoid the above warning.
Back to IQ FAQ's

How can I have IQ skip deleted records in a FoxPro file?

The "Show Deleted Rows" option may be turned off from the ODBC FoxPro Setup screen.
Back to IQ FAQ's

Where are IQ error codes documented?

These error numbers are documented in "Intelligent Query and IQ Access User's Guide for Windows and Motif" and "Intelligent Query and IQ Access User's Guide" appendix A.
Back to IQ FAQ's

What does the message, "Code 1:x, Code 2:y" mean?

These types of errors are fatal and "are caused by many reasons, including the inability to locate or open an IQ system file, improper or incorrect security permissions, data dictionary setup, and hardware constraints or failure" (Intelligent Query and IQ Access User's Guide, p. A-6). Error "Code 1:" and "Code 2:" are listed in columns one and two, respectively.

IQ fatal errors are listed in "Intelligent Query and IQ Access User's Guide", appendix A.
Back to IQ FAQ's

How do I recover from Code 1:25, Code 2:-4?

According to "Intelligent Query and IQ Access User's Guide", this error occurs when IQ could not open a supporting file, such as iqcap, iqconfig.dat, iqprtcfg.dat or the data dictionary file.

Please refer to "Intelligent Query and IQ Access User's Guide", appendix A for a detailed description.
Back to IQ FAQ's

Can I use an IQ2 iqcap terminal file with IQ4?

Yes, IQ2 iqcap files are fully compatible with IQ4.
Back to IQ FAQ's

How do I prevent my IQ process from running after disconnecting from my telnet or dialup session?

On a Unix system, orphaned processes may be avoided by adding a XS record and then setting its value to one in the iqconfig.dat file. These orphaned IQ processes may result in a slow system.
Back to IQ FAQ's

Is IQ year 2000 compliant?

IQ for Unix version 4 is certified to be Year 2000 compliant. IQ itself is a query and report generator and hence, was not designed to interpret users? data. However, since many users have 2 or 3 digit years stored in their data files, DCI enhanced IQ to handle year 2000 problems. Specifically, IQ for Unix version 4 has been enhanced to:

• Correct Year 2000 ascending and descending sort of 2 digit year date fields for UniBasic and dL4 files, including dL4 FoxPro Full-ISAM files. The sort will work correctly, even if a 2 digit year is stored as part of key data. For example, "010100" will appear before "010199" in a descending sort. Likewise, "010100" will appear after "010199" in an ascending sort.

• Correct time calculation of 2, 3, and 4 digit year data fields for UniBasic and dL4 files, including dL4 FoxPro Full-ISAM files.

• Correct leap year calculation for 2, 3 and 4 digit years for UniBasic and dL4 files, including dL4 FoxPro Full-ISAM files.

• IQ interprets dates as specified in the data dictionary date layout as follows:

a) 4 digit years (Y4) are taken "as is".
b) 3 digit years (Y3) are added to the DEFAULT century as configured in IQCONFIG.DAT item CD.
c) For UniBasic and dL4 files, 2 digit years (Y2) are converted to be in the nearest century based on a plus/minus 50 years rule. A two digit year is thus assumed to be within 50 years, plus or minus, of the current year as returned by the system. For example, if the system returns 1998 as the current year, then the year 47 will be interpreted as year 2047, and year 49 will be interpreted as year 1949.
• A new IQCONFIG.DAT item CD allows the user to override the default century (1900) for a three digit year.year.

A new IQCONFIG.DAT item CD allows the user to override the default century (1900) for a three digit year.
Back to IQ FAQ's

Is IQ supported in a network environment?

Although IQ is not specifically tested in a network environment, it should work in a properly configured NFS system which can properly handle record locking. The product itself does not use any system calls specific to networking.

IQ for Windows should work properly in a Microsoft network file system. It is, however, not tested for Novell networks.
Back to IQ FAQ's

Can I use Samba with IQ?

Yes, but if files on the Unix/Linux server are to be accessed concurrently by both Windows and Unix applications, it may be necessary to set Samba configuration options so that Window and Unix/Linux record locking are handled identically. Please check your Samba documentation for any references to record or file locking configuration.
Back to IQ FAQ's

What are Universal Data files?

Universal Data files are product and hardware independent data files that contain UniBasic BCD data. They may be shared or moved among different Unix platforms without conversion. In addition, they may be used concurrently with UniBasic, dL4 for Unix and Windows, and IQ for Unix and Windows.
Back to IQ FAQ' s

What product versions support Universal Data files?

The minimum revision level for Universal Data files are UniBasic 6, dL4 3, IQ for Unix version 4 and IQ for Windows version 5.
Back to IQ FAQ's

Can earlier releases access Universal Data files?

Universal Data files require minimum product revisions and cannot be accessed by older releases.
Back to IQ FAQ's

How are Universal Data files defined in the IQ data dictionary?

Universal Data files may be defined as UniBasic or dL4 file types 261 or 262, respectively.
Back to IQ FAQ's