Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search

Sybase IQ(TM)Language Reference [Table of Contents] Chapter 1: Introduction

Sybase IQ Language Reference

[-] About This Book

About This Book

Sybase IQ Language Reference is a reference guide that includes command syntax for commands that a System Administrator or application developer uses to create and maintain end-user environments.

Audience

This manual is intended for:

This manual assumes that you are already familiar with Sybase products and in particular Sybase(R) SQL Server(TM). This manual covers material that is specific to Sybase IQ(TM) administration. It provides basic syntax and usage information for every command, function, and system stored procedure that a System Administrator uses to create and maintain a successful Sybase IQ environment.

How to Use This Book

This manual consists of the following chapters:

Related Documents

Other manuals that you may find useful are:

Other Sources of Information

Use the SyBooks(TM) and SyBooks-on-the-Web online resources to learn more about your product:

Sybase Certifications on the Web

The Technical Support information on the Sybase Web site is updated frequently.

For the latest information on product certifications and/or the EBF Rollups:

  1. Point your Web browser to the Technical Information Library at the following URL:

    http://techinfo.sybase.com

  2. In the Browse section, click on the Hot entry.

  3. Explore your area of interest: Hot Docs covering various topics, or Hot Links to Technical News, Certification Reports, Partner Certifications, and so on.

If you are a registered SupportPlus user:

  1. Point your Web browser to the Technical Information Library at the following URL.

    http://techinfo.sybase.com

  2. In the Browse section, click on the Hot entry.

  3. Click on the EBF Rollups entry.

    You can research EBFs using the Technical Information Library, and you can download EBFs using Electronic Software Distribution (ESD).

  4. Follow the instructions associated with the SupportPlusSM Online Services entries.

If you are not a registered SupportPlus user and want to become one:

You can register by following the instructions on the Web.

To use SupportPlus, you need:

Whether or not you are a registered SupportPlus user:

You may use Sybase's Technical Information Library. Certification Reports are among the features documented at this site.

  1. Point your Web browser to the Technical Information Library at the following URL:

    http://techinfo.sybase.com

  2. In the Browse section, click on the Hot entry.

  3. Click on the topic that interests you.

Conventions

Formatting SQL Statements

SQL is a free-form language: there are no rules about the number of words you can put on a line or where you must break a line. However, for readability, all examples and syntax statements in this manual are formatted so that each clause of a statement begins on a new line. Clauses that have more than one part extend to additional lines, which are indented.

SQL Syntax Conventions

The conventions for syntax statements in this manual are as follows:

Table 1: Syntax statement conventions

Key

Definition

COMMAND

or

command

Command keywords, stored procedures, and function names are in Bold Courier in syntax statements and Bold Helvetica in text. Sybase IQ commands and functions are in UPPERCASE, and SQL Sever commands and functions are in lowercase, although Sybase IQ and SQL Server allow all keywords to be in mixed case.

DATATYPE

or

datatype

Datatypes and system tables are in Bold Courier in syntax statements and in italics in text. Sybase IQ datatypes are in UPPERCASE, and SQL Server datatypes are in lowercase.

variable

Variables, or words that stand for names, numbers, or phrases that you fill in, are in italics.

{}

Curly braces designate options or groups of options that are repeated. Do not include braces in your option.

[]

Brackets mean the enclosed options are optional. Do not include brackets in your option.

()

Parentheses are to be typed as part of the command.

|

The vertical bar means you may select only one of the options shown.

...

Ellipses indicate you can repeat the previous argument.

,

Comma means you may choose more than one option, separating your choices with commas.

___

Underlined words in syntax represent the default value.

/* */ or --

Comment delimeters in examples.

Syntax statements (displaying the syntax and all options for a command) are printed like this:

SELECT column_name 
FROM table_name
WHERE search_conditions

In syntax statements, keywords (commands) are in normal font and identifiers are in lowercase: italics for user-supplied words.

Case

You can disregard case when you type Sybase IQ keywords:

SELECT is the same as Select is the same as select.

However, this manual distinguishes keywords that Sybase IQ handles by making them uppercase as opposed to keywords handled by SQL Server, which are in lowercase.

Obligatory Options {You Must Choose At Least One}

Optional Options [You Don't Have to Choose Any]

Ellipsis: Do It Again (and Again)...

An ellipsis (...) means that you can repeat the last unit as many times as you like. In this syntax statement, buy is a required keyword:

buy thing = price [cash | check | credit] 
[, thing = price [cash | check | credit] ]...

You must buy at least one thing and give its price. You may choose a method of payment: one of the items enclosed in square brackets. You may also choose to buy additional things: as many of them as you like. For each thing you buy, give its name, its price, and (optionally) a method of payment.

Expressions

Several different types of expressions are used in Sybase IQ syntax statements.

Table 2: Types of expressions used in syntax statements

Usage

Definition

expression

Can include constants, literals, functions, column identifiers, variables or parameters

logical expression

An expression that returns TRUE, FALSE, or UNKNOWN

constant expression

An expression that always returns same value, such as 5+3 or "ABCDE"

float_expr

Any floating-point expression or expression that implicitly converts to a floating value

integer_expr

Any integer expression, or an expression that implicitly converts to an integer value

numeric_expr

Any numeric expression that returns a single value

char_expr

Any expression that returns a single character-type value

binary_expression

An expression that returns a single binary or varbinary value

Pathname Differences Between Windows NT and UNIX

UNIX pathnames use the slash (/) character as the directory name separator, while Windows NT pathnames use the backslash (\) character. In addition, a fully qualified Windows NT pathname includes a device indicator (such as C:). Certain Sybase IQ commands (such as IQ CREATE INDEXSPACE) require a pathname parameter, which you should fully qualify.

The following is an example of a fully qualified Windows NT pathname:

C:\SYBASE\TEST.DB

This next example is a fully qualified UNIX pathname:

/s1/usr/sybase/TEST.DB

If a relative pathname is specified in either example (such as just TEST.DB), then the absolute path is relative to the working directory where Sybase IQ Open Server was started. See your Installation and Configuration Guide for more information.

In the examples of this book, a distinction is made between the pathnames specified for UNIX and Windows NT. However, text references to pathnames (such as $SYBASE/bin) use only the slash (/) character to distinguish directories. For Windows NT, you should substitute the backslash (\) in these references unless indicated otherwise.

If You Need Help

Help with your Sybase software is available in the form of SyBooks(TM) and AnswerBase(TM) CDs, and Sybase Technical Support.

Each Sybase installation that has purchased a support contract has one or more designated people who are authorized to contact Sybase Technical Support. If you cannot resolve a problem using the manuals or online help, please have the designated person contact Sybase Technical Support or the Sybase subsidiary in your area.


Sybase IQ(TM)Language Reference [Table of Contents] Chapter 1: Introduction