When you install SAP Sybase IQ, several directories
may be created. This section describes the directory structure.
The directories created depend on which options you choose
during installation and which directories already exist in your
Sybase directory (the directory defined by $SYBASE on
UNIX or %SYBASE% on Windows).
By default, SAP Sybase IQ software is installed in a unique
subdirectory under the Sybase directory. This subdirectory is called the installation
directory. Other tools provided with SAP Sybase IQ have unique
subdirectories under the Sybase directory. This section describes only the subdirectory
structure for SAP Sybase IQ.
By default, the SAP Sybase IQ directory is
IQ-16_0. The location of
IQ-16_0 varies, depending on where
you install SAP Sybase IQ. The
IQ-16_0 directory is also referred
to by the environment variable $IQDIR16 on UNIX
or %IQDIR16% on Windows.
The SAP Sybase IQ directory holds a number of directories
and files:
- Demo directory (%ALLUSERSPROFILE%/SybaseIQ/demo) – Holds the tools required to build the iqdemo database. The iqdemo database files
are iqdemo.db,
iqdemo.iq, iqdemo.iqmsg, and
iqdemo.iqtmp. The demo database itself is not
shipped with SAP Sybase IQ.
- The subdirectory /demo/adata – Holds 16.x data to allow the creation of the 16.x iqdemo database. The
subdirectory /demo/demodata holds
SAP Sybase IQ 12.7 data to allow the creation of
an iqdemo database that has the same schema layout and data as the IQ 12.7
asiqdemo database. Use /demo/mkiqdemo.bat on Windows
and demo/mkiqdemo.sh on UNIX to create the 16.x iqdemo
database. The iqdemo database can be used to demonstrate problems to
Technical Support.
- Scripts directory (IQ-16_0/scripts) – Holds
some scripts used in examples and when creating catalog objects
like stored procedures. Do not edit these scripts.
If you edit, delete, or move these scripts, the server will not
operate properly.
- Samples directories – The samples directory contains SQL samples and user-defined
function (UDF) samples.
%ALLUSERSPROFILE%/SybaseIQ/samples/sqlanywhere
contains directories of SQL samples. The sqlanywhere/c directory
holds C++ examples that illustrate using ESQL (embedded SQL) and
C with SAP® Sybase SQL Anywhere. Because
SAP SQL Anywhere and
SAP Sybase IQ share common code, you can modify
these examples for use with SAP Sybase IQ. The
%ALLUSERSPROFILES%/SybaseIQ/samples/udf directory
holds sample C++ scalar and aggregate UDFs.
- Executable directories – Hold executables, libraries, help files, and so on. On UNIX, executable
subdirectories include IQ-16_0
subdirectories /bin64, /lib64,
/logfiles, /res, and
/tix. On Windows, these include
IQ-16_0 subdirectories
\h, \install,
\java, and \bin32.