Copyright 1989-1999 by Sybase, Inc. All rights reserved. Sybase, the Sybase logo, Data Workbench, InfoMaker, PowerBuilder, Powersoft, SQL Advantage,
Data definition Adaptive Server IQ 12.4.010 Release Bulletin for Digital UNIX 7.1 Data definitionThis section reports pr
Adaptive Server IQ 12.4.0 Large IN subqueriesRelease Bulletin for Digital UNIX 11•= ALL•!
User-defined variable issue Adaptive Server IQ 12.4.012 Release Bulletin for Digital UNIXTo avoid truncated output, incr
Adaptive Server IQ 12.4.0 Sybase CentralRelease Bulletin for Digital UNIX 13 7.4 Sybase C
Data Type column in Table Editor retains focus Adaptive Server IQ 12.4.014 Release Bulletin for Digital UNIXWhen you use
Adaptive Server IQ 12.4.0 Additions to the start_asiq or asiqsrv12 command-line optionsRelease Bulletin for Digital UNIX
-gm command line option Adaptive Server IQ 12.4.016 Release Bulletin for Digital UNIXThe -iqmt switch is not set by star
Adaptive Server IQ 12.4.0 Confirming connectionsRelease Bulletin for Digital UNIX 17The f
Using a .odbc.ini file Adaptive Server IQ 12.4.018 Release Bulletin for Digital UNIXIf Adaptive Server IQ does not detec
Adaptive Server IQ 12.4.0 Addition to STOP DATABASE statementRelease Bulletin for Digital UNIX
Required Operating System Patches Adaptive Server IQ 12.4.02 Release Bulletin for Digital UNIX• Digital Unix V4.0fNote
Error in DBSTOP example Adaptive Server IQ 12.4.020 Release Bulletin for Digital UNIXThe following information should be
Adaptive Server IQ 12.4.0 -Z switch must be uppercaseRelease Bulletin for Digital UNIX 21
MESSAGE PATH Adaptive Server IQ 12.4.022 Release Bulletin for Digital UNIX 9.2.2 MESSAGE PATHIn the MESSAGE PATH clause
Adaptive Server IQ 12.4.0 Error documenting IQ PATHRelease Bulletin for Digital UNIX 23•
SIZE clause of CREATE DBSPACE Adaptive Server IQ 12.4.024 Release Bulletin for Digital UNIXin database /tech1/iq/cdrdb.d
Adaptive Server IQ 12.4.0 Recommended index typesRelease Bulletin for Digital UNIX 25 9.2
Changes to “Using join indexes” Adaptive Server IQ 12.4.026 Release Bulletin for Digital UNIXIf the join column is made
Adaptive Server IQ 12.4.0 Changes to “Using join indexes”Release Bulletin for Digital UNIX
Error in DISK_STRIPING default Adaptive Server IQ 12.4.028 Release Bulletin for Digital UNIX 9.3 Error in DISK_STRIPING
Adaptive Server IQ 12.4.0 DefaultRelease Bulletin for Digital UNIX 29DefaultONDescription
Adaptive Server IQ 12.4.0 Converting 12.0.x databases to 12.4.0Release Bulletin for Digital UNIX
New and changed general database options Adaptive Server IQ 12.4.030 Release Bulletin for Digital UNIX• In order to join
Adaptive Server IQ 12.4.0 DescriptionRelease Bulletin for Digital UNIX 31DescriptionThis
Description Adaptive Server IQ 12.4.032 Release Bulletin for Digital UNIXDescriptionFor joins within a query, the IQ opt
Adaptive Server IQ 12.4.0 String function REPEAT is supportedRelease Bulletin for Digital UNIX
Using ISNULL() and COALESCE() Adaptive Server IQ 12.4.034 Release Bulletin for Digital UNIXThe NUMBER(*) function is not
Adaptive Server IQ 12.4.0 DefaultRelease Bulletin for Digital UNIX 35Default1DescriptionT
Effect of checkpoints Adaptive Server IQ 12.4.036 Release Bulletin for Digital UNIXTemporary IQ Blocks Used:,163 of 6144
37• Incremental backups are disabled After the database is opened in forced recovery mode, incremental backups are disabled. The next backup must be a
38 To verify that the data is not corrupt and set the database storage to its actual value, you start the server with the -iqdroplks switch and connec
39Running sp_iqcheckdbIn order to recover leaked storage within a database, first start the server with the -iqdroplks switch in the asiqsrv12 command
Insert into table from remote SQL database not supported Adaptive Server IQ 12.4.04 Release Bulletin for Digital UNIXYou
40 The dbcc_option settings of 0 and 3, when combined with the server option -iqdroplks, update the free list if no errors are detected. In order to p
41ExampleAssume that the DBA cannot successfully open and connect to database foo, because of reported IQ errors during database open and recovery. To
42 9.5.6 SP_IQSTATUS now displays IQ Page SizeThe sp_iqstatus stored procedure now displays the IQ page size in addition to the block size. For examp
43When you use the RESTORE statement to move and/or rename a database, you can rename all of the files except the transaction log. Transactions contin
44 Set the name of the transaction log file (-t ) This option sets a filename, including an optional directory path, for a new transaction log. If the
45The same command can also be used to add a new user. For this reason, if you inadvertently enter the user ID of an existing user when you mean to ad
46 9.5.14 Changes to BACKUP statementIn the Adaptive Server IQ Reference, the SIZE and STACKER option descriptions in the BACKUP statement should re
47ipcrm -m mid1 -m mid2 ... -s sid1 -s sid2 ...For example:% ipcrm -m 40965 -s 5130 -s36682 9.5.16 Monitoring server activityIt may be helpful, especi
48 9.6 Client applications 9.6.1 ODBC AutoPreCommit omittedThe ODBC AutoPreCommit option was omitted from the Adaptive Server IQ Reference. Turning t
49 9.7.1 Adaptive Server IQ plug-in help reflects Multiplex supportAdaptive Server IQ Multiplex 12.4.0 is a separate product from Adaptive Server IQ 1
Adaptive Server IQ 12.4.0 Setting the LD_LIBRARY_PATH Environment VariableRelease Bulletin for Digital UNIX
50 • Output from sp_iqstatus procedureYou may find additional help from the Sybase online support database, MySupport. MySupport lets you search throu
51techinfo.sybase.com2 In the Browse section, click on the What’s Hot entry.3 Explore your area of interest: Hot Docs covering various topics, or Hot
Accessing Current Release Bulletin Information Adaptive Server IQ 12.4.06 Release Bulletin for Digital UNIXDepending on
Adaptive Server IQ 12.4.0 Changed functionality in Adaptive Server IQ 12.4.0Release Bulletin for Digital UNIX
Improved stored procedure output Adaptive Server IQ 12.4.08 Release Bulletin for Digital UNIX• Improved stored procedure
Adaptive Server IQ 12.4.0 stop_asiq utilityRelease Bulletin for Digital UNIX 9•-iqmc sets
Commentaires sur ces manuels