Sybase Complete Guide to IQ Load Table Operations

Page 29

Adaptive Server IQ 12.4.0

Default

Default

Description

ON

This option reports a syntax error for those queries containing outer joins that have ambiguous syntax due to the presence of duplicate correlation names on a null-supplying table.

The following join clause illustrates the kind of query that is reported.

( R left outer join T , T join S on ( C1 ) )

where C1 is a condition. If the option is set to ON, this query is interpreted as follows.

( R left outer join T on ( C1 ) ) join S on ( C2 )

where C1 and C2 are conditions.

9.4.5 Support for joins between stores or databases

This section clarifies current support for joins between stores or between databases.

Any joins within a given IQ database are supported. This means that you can join any system or user tables in the Catalog Store with any tables in the IQ Store, in any order.

Joins of IQ tables with tables in an Adaptive Server Enterprise database are supported under the following conditions:

•On UNIX platforms, the IQ database must be the remote database, and the Adaptive Server Enterprise database must be the local database. In other words, on ASE you must add the IQ server a remote server, and define the IQ tables as proxy tables.

•On Windows NT, the IQ database can be either the local database or the remote database.

Release Bulletin for Digital UNIX

29

Image 29

Contents Product summary Release Bulletin Adaptive Server IQ For Digital UnixRequired Operating System Patches Adaptive Server IQ Required Operating System PatchesRelease Bulletin for Digital Unix RestrictionsAdaptive Server IQ Converting 12.0.x databases to Following outer join format is supported Documentation for this version Installation InstructionsSetting the Ldlibrarypath Environment Variable Special migration instructions Accessing Current Release Bulletin InformationObtaining query plans Go to support.sybase.comChanged functionality in Adaptive Server IQ Changed functionality in this versionImproved stored procedure output Adaptive Server IQ Adaptive Server IQ Stopasiq utility Known problemsData definition Temporary tables in proceduresAdaptive Server IQ Queries 1 ANY, SOME, and ALL subquery supportLarge in subqueries Adaptive Server IQ OperationsOutput to file in Dbisql Changing length of Dbisql column valuesDbspawn Error when starting a server User-defined variable issueUnsupported terminal types cause Dbisql error User-defined variable issue Adaptive Server IQDSE not installed on Windows client systems Problems with Add User-defined Data Type wizardAdd Service utility installed only with Server Components Notification message setting omitted from Index PropertiesProduct compatibilities Documentation updates and clarificationsStartup, shutdown, and connection Data Type column in Table Editor retains focusSpecifying server switches Additions to the startasiq or asiqsrv12 command-line optionsGn command-line option Gm command line optionUsing -v switch on 64-bit platforms Gm command line option Adaptive Server IQAdaptive Server IQ Confirming connections Using Odbc connectivity with UnixConfirming connections Stopasiq utility Using a .odbc.ini fileUsing a .odbc.ini file Adaptive Server IQ Adaptive Server IQ Addition to Stop Database statement Addition to Stop Database statementConfiguration files do not accept quotes Error in Dbstop exampleError in Dbstop example Adaptive Server IQ Disconnect details omittedAdaptive Server IQ Switch must be uppercase Switch must be uppercaseData definition DDL Change to Create Database statementColumn Limit Correction LowDisk functions as HighGroupJoint Virtual Table JVT definition IQ database file paths must be uniqueError in raw partition limit Error documenting IQ PathError on Create Dbspace Adaptive Server IQ Error documenting IQ PathSize clause of Create Dbspace Adaptive Server IQ Size clause of Create DbspaceAddition to Drop Database statement Adaptive Server IQ Recommended index types Changes to Using join indexesRecommended index types Id custid idlname Changes to Using join indexes Adaptive Server IQAdaptive Server IQ Changes to Using join indexes Data manipulation DML Error in Diskstriping defaultSupport for joins between stores or databases Adaptive Server IQ DefaultNew and changed general database options Adaptive Server IQ New and changed general database optionsInsertnumberrowsperrawiobuffer Adaptive Server IQ DescriptionDescription Adaptive Server IQ Corrections to Insert LocationCorrection to Char function String function Repeat is supportedNumber* function not supported Adaptive Server IQ String function Repeat is supportedUsing Isnull and Coalesce Backup and system administrationUsing Isnull and Coalesce Adaptive Server IQ New options for reserving spaceInsufficient disk space Change to error messageEffect of checkpoints Adaptive Server IQ Forced recovery and leaked space recoveryStorage within the database as in use Dbccoption option Spiqcheckdb Set dbccoption to 2, as a temporary option New Stored Procedure Columns Improved output in stored proceduresTransaction Log utility Minpasswordlength optionSpiqstatus now displays IQ Page Size Maintaining a transaction log or mirror Grant Connect for existing user ID Error message for buffer cache settingsSetting PrefetchBufferLimit option Dropping users may delete tables Documentation on Data Backup and RecoveryCleaning up after abnormal exit Changes to Backup statementMonitoring server activity Creating attribute tables for PowerBuilder Using PC client applicationsClient applications Help filesAdaptive Server IQ plug-in help reflects Multiplex support Technical SupportSybase Certifications on the Web Other sources of informationTechinfo.sybase.com