SQL Anywhere® Studio Help

317 Pages·2004·1.16 MB·English

SQL Anywhere® Studio
Help
Partnumber: DC38176-01-0902-01
Lastmodified: October2004
Copyright©1989–2004Sybase,Inc.Portionscopyright©2001–2004iAnywhereSolutions,Inc.Allrightsreserved.
Nopartofthispublicationmaybereproduced,transmitted,ortranslatedinanyformorbyanymeans,electronic,mechanical,manual,optical,or
otherwise,withoutthepriorwrittenpermissionofSybase,Inc.
Sybase,SYBASE(logo),AccelaTrade,ADAWorkbench,AdaptableWindowingEnvironment,AdaptiveComponentArchitecture,AdaptiveServer,
AdaptiveServerAnywhere,AdaptiveServerEnterprise,AdaptiveServerEnterpriseMonitor,AdaptiveServerEnterpriseReplication,Adaptive
ServerEverywhere,AdaptiveServerIQ,AdaptiveWarehouse,AnswerBase,AnywhereStudio,ApplicationManager,AppModeler,
APTWorkbench,APT-Build,APT-Edit,APT-Execute,APT-Library,APT-Translator,ASEP,AvantGo,AvantGoApplicationAlerts,AvantGo
MobileDelivery,AvantGoMobileDocumentViewer,AvantGoMobileInspection,AvantGoMobileMarketingChannel,AvantGoMobilePharma,
AvantGoMobileSales,AvantGoPylon,AvantGoPylonApplicationServer,AvantGoPylonConduit,AvantGoPylonPIMServer,AvantGo
PylonPro,BackupServer,BayCam,Bit-Wise,BizTracker,CertifiedPowerBuilderDeveloper,CertifiedSYBASEProfessional,CertifiedSYBASE
ProfessionalLogo,ClearConnect,ClientServices,Client-Library,CodeBank,ColumnDesign,ComponentPack,ConnectionManager,Convoy/DM,
Copernicus,CSP,DataPipeline,DataWorkbench,DataArchitect,DatabaseAnalyzer,DataExpress,DataServer,DataWindow,DB-Library,
dbQueue,DevelopersWorkbench,DirectConnectAnywhere,DirectConnect,DistributionDirector,DynamicMobilityModel,Dynamo,e-ADK,
E-Anywhere,e-BizIntegrator,ECGateway,ECMAP,ECRTP,eFulfillmentAccelerator,ElectronicCaseManagement,EmbeddedSQL,EMS,
EnterpriseApplicationStudio,EnterpriseClient/Server,EnterpriseConnect,EnterpriseDataStudio,EnterpriseManager,EnterprisePortal(logo),
EnterpriseSQLServerManager,EnterpriseWorkArchitecture,EnterpriseWorkDesigner,EnterpriseWorkModeler,eProcurementAccelerator,
eremote,EverythingWorksBetterWhenEverythingWorksTogether,EWA,E-Whatever,FinancialFusion,FinancialFusion(anddesign),Financial
FusionServer,FormulaOne,FusionPowerede-Finance,FusionPoweredFinancialDestinations,FusionPoweredSTP,GatewayManager,
GeoPoint,GlobalFIX,iAnywhere,iAnywhereSolutions,ImpactNow,IndustryWarehouseStudio,InfoMaker,InformationAnywhere,Information
Everywhere,InformationConnect,InstaHelp,IntelligentSelf-Care,InternetBuilder,iremote,iScript,JaguarCTS,jConnectforJDBC,
KnowledgeBase,LogicalMemoryManager,MailAnywhereStudio,MainframeConnect,MaintenanceExpress,ManageAnywhereStudio,MAP,
M-BusinessChannel,M-BusinessNetwork,M-BusinessServer,MDIAccessServer,MDIDatabaseGateway,media.splash,MessageAnywhere
Server,MetaWorks,MethodSet,MLQuery,MobiCATS,MyAvantGo,MyAvantGoMediaChannel,MyAvantGoMobileMarketing,MySupport,
Net-Gateway,Net-Library,NewEraofNetworks,NextGenerationLearning,NextGenerationLearningStudio,ODEVICE,OASiS,OASiSlogo,
ObjectConnect,ObjectCycle,OmniConnect,OmniSQLAccessModule,OmniSQLToolkit,OpenBiz,OpenBusinessInterchange,OpenClient,
OpenClient/Server,OpenClient/ServerInterfaces,OpenClientConnect,OpenGateway,OpenServer,OpenServerConnect,OpenSolutions,
Optima++,OrchestrationStudio,PartnershipsthatWork,PB-Gen,PCAPTExecute,PCDB-Net,PCNetLibrary,PhysicalArchitect,Pocket
PowerBuilder,PocketBuilder,PowerThroughKnowledge,power.stop,Power++,PowerAMC,PowerBuilder,PowerBuilderFoundationClass
Library,PowerDesigner,PowerDimensions,PowerDynamo,PoweringtheNewEconomy,PowerJ,PowerScript,PowerSite,PowerSocket,
Powersoft,PowersoftPortfolio,PowersoftProfessional,PowerStage,PowerStudio,PowerTips,PowerWareDesktop,PowerWareEnterprise,
ProcessAnalyst,QAnywhere,Rapport,RelationalBeans,RepConnector,ReplicationAgent,ReplicationDriver,ReplicationServer,Replication
ServerManager,ReplicationToolkit,ReportWorkbench,Report-Execute,ResourceManager,RW-DisplayLib,RW-Library,S.W.I.F.T.Message
FormatLibraries,SAFE,SAFE/PRO,SDF,SecureSQLServer,SecureSQLToolset,SecurityGuardian,SKILS,smart.partners,smart.parts,
smart.script,SQLAdvantage,SQLAnywhere,SQLAnywhereStudio,SQLCodeChecker,SQLDebug,SQLEdit,SQLEdit/TPU,
SQLEverywhere,SQLModeler,SQLRemote,SQLServer,SQLServerManager,SQLServerSNMPSubAgent,SQLServer/CFT,
SQLServer/DBM,SQLSMART,SQLStation,SQLToolset,SQLJ,StageIIIEngineering,Startup.Com,STEP,SupportNow,SybaseCentral,
SybaseClient/ServerInterfaces,SybaseDevelopmentFramework,SybaseFinancialServer,SybaseGateways,SybaseLearningConnection,
SybaseMPP,SybaseSQLDesktop,SybaseSQLLifecycle,SybaseSQLWorkgroup,SybaseSynergyProgram,SybaseUserWorkbench,Sybase
VirtualServerArchitecture,SybaseWare,SyberFinancial,SyberAssist,SybMD,SyBooks,System10,System11,SystemXI(logo),SystemTools,
TabularDataStream,TheEnterpriseClient/ServerCompany,TheExtensibleSoftwarePlatform,TheFutureIsWideOpen,TheLearning
Connection,TheModelForClient/ServerSolutions,TheOnlineInformationCenter,ThePowerofOne,TotalFix,TradeForce,Transact-SQL,
TranslationToolkit,TurningImaginationIntoReality,UltraLite,UltraLite.NET,UNIBOM,Unilib,Uninull,Unisep,Unistring,URKRuntimeKit
forUniCode,Versacore,Viewer,VisualWriter,VQL,WarehouseControlCenter,WarehouseStudio,WarehouseWORKS,WarehouseArchitect,
Watcom,WatcomSQL,WatcomSQLServer,WebDeploymentKit,Web.PB,Web.SQL,WebSights,WebViewer,WorkGroupSQLServer,
XA-Library,XA-Server,andXPServeraretrademarksofSybase,Inc.oritssubsidiaries.
Allothertrademarksarepropertyoftheirrespectiveowners.
ii
Contents
AboutThisManual vii
SQLAnywhereStudiodocumentation . . . . . . . . . . . . . viii
Documentationconventions . . . . . . . . . . . . . . . . . . . xi
TheAdaptiveServerAnywheresampledatabase . . . . . . . xiii
Findingoutmoreandprovidingfeedback . . . . . . . . . . . xiv
1 ConnectDialogHelp 1
Connectdialog: Identificationtab . . . . . . . . . . . . . . . . 2
Connectdialog: Databasetab. . . . . . . . . . . . . . . . . . 5
Connectdialog: Advancedtab . . . . . . . . . . . . . . . . . 8
2 ODBCConfigurationDialogHelp 11
UsingtheODBCConfigurationdialog . . . . . . . . . . . . . 12
ODBCConfigurationdialog: DBMLSynctab . . . . . . . . . . 13
ODBCConfigurationdialog: ODBCtab . . . . . . . . . . . . 15
ODBCConfigurationdialog: Logintab . . . . . . . . . . . . . 18
ODBCConfigurationdialog: Databasetab . . . . . . . . . . . 20
ODBCConfigurationdialog: Networktab . . . . . . . . . . . 22
ODBCConfigurationdialog: Advancedtab . . . . . . . . . . 25
CerticomEncryptionOptionsdialog . . . . . . . . . . . . . . 26
3 AdaptiveServerAnywhereHelp 27
Introductiontopropertysheets . . . . . . . . . . . . . . . . . 28
Introductiontodialogboxes . . . . . . . . . . . . . . . . . . . 121
Debuggerhelp . . . . . . . . . . . . . . . . . . . . . . . . . . 150
IndexConsultant . . . . . . . . . . . . . . . . . . . . . . . . . 152
4 InteractiveSQLHelp 153
AboutInteractiveSQL . . . . . . . . . . . . . . . . . . . . . . 154
IntroductiontoInteractiveSQLdialogboxes . . . . . . . . . . 156
InteractiveSQLwizards . . . . . . . . . . . . . . . . . . . . . 170
5 MobiLinkHelp 173
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . 174
MobiLinkpropertysheets . . . . . . . . . . . . . . . . . . . . 175
MobiLinkdialogboxes . . . . . . . . . . . . . . . . . . . . . . 192
MobiLinkwizards . . . . . . . . . . . . . . . . . . . . . . . . . 195
iii
6 MobiLinkMonitorHelp 205
ConnecttoMobiLinkServerdialog . . . . . . . . . . . . . . . 206
EditWatchdialog . . . . . . . . . . . . . . . . . . . . . . . . . 209
GoTodialog . . . . . . . . . . . . . . . . . . . . . . . . . . . 210
NewWatchdialog . . . . . . . . . . . . . . . . . . . . . . . . 211
ExporttoDatabasedialog . . . . . . . . . . . . . . . . . . . . 212
Optionsdialog . . . . . . . . . . . . . . . . . . . . . . . . . . 214
Sessionpropertysheet . . . . . . . . . . . . . . . . . . . . . 219
Synchronizationpropertysheet . . . . . . . . . . . . . . . . . 220
WatchManagerdialog . . . . . . . . . . . . . . . . . . . . . . 224
7 QueryEditorHelp 225
IntroducingtheQueryEditor . . . . . . . . . . . . . . . . . . 226
Tablestab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 228
Joinstab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 230
Columnstab . . . . . . . . . . . . . . . . . . . . . . . . . . . 232
INTOtab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 234
WHEREtab . . . . . . . . . . . . . . . . . . . . . . . . . . . . 235
GROUPBYtab . . . . . . . . . . . . . . . . . . . . . . . . . . 236
HAVINGtab . . . . . . . . . . . . . . . . . . . . . . . . . . . . 238
ORDERBYtab . . . . . . . . . . . . . . . . . . . . . . . . . . 239
ExpressionEditor . . . . . . . . . . . . . . . . . . . . . . . . 240
Resultspane . . . . . . . . . . . . . . . . . . . . . . . . . . . 242
SQLpane . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 243
8 AdaptiveServerAnywhereConsoleUtilityHelp 245
UsingtheAdaptiveServerAnywhereConsoleutility . . . . . 246
Optionsdialog . . . . . . . . . . . . . . . . . . . . . . . . . . 247
9 SQLLanguageLinks 251
SQLsyntaxhelp . . . . . . . . . . . . . . . . . . . . . . . . . 252
10 UltraLiteSchemaPainterHelp 261
UltraLiteSchemaPainterOptionsdialog . . . . . . . . . . . . 263
NewUltraLiteSchemadialog . . . . . . . . . . . . . . . . . . 264
SaveSchematoPDBfiledialog . . . . . . . . . . . . . . . . 265
SchemaDeploymentdialog . . . . . . . . . . . . . . . . . . . 266
DatabaseSchemapropertysheet . . . . . . . . . . . . . . . 267
DatabasePropertyEditordialog . . . . . . . . . . . . . . . . 268
NewTabledialog . . . . . . . . . . . . . . . . . . . . . . . . . 269
NewColumnpropertysheet . . . . . . . . . . . . . . . . . . . 270
SetPrimaryKeydialog. . . . . . . . . . . . . . . . . . . . . . 271
SaveCertificatedialog . . . . . . . . . . . . . . . . . . . . . . 272
SetIndexdialog . . . . . . . . . . . . . . . . . . . . . . . . . 273
iv
CreateForeignKeydialog . . . . . . . . . . . . . . . . . . . . 274
MapPrimaryColumndialog . . . . . . . . . . . . . . . . . . . 275
ForeignKeypropertysheet . . . . . . . . . . . . . . . . . . . 276
Tablepropertysheet . . . . . . . . . . . . . . . . . . . . . . . 277
Publicationdialog. . . . . . . . . . . . . . . . . . . . . . . . . 278
MobiLinkSynchronizationpropertysheet . . . . . . . . . . . 279
GenerateConsolidatedDatabaseandMobiLinkScriptsdialog 284
PreviewScriptsandConsolidatedDatabaseTableDefinitions
dialog . . . . . . . . . . . . . . . . . . . . . . . . . . . . 285
MobiLinkTableSettingsdialog . . . . . . . . . . . . . . . . . 286
CreateUltraLiteDatabasedialog . . . . . . . . . . . . . . . . 287
11 UltraLiteInteractiveSQLHelp 289
ConnectionDialog . . . . . . . . . . . . . . . . . . . . . . . . 290
OldDatabaseFormatDialog . . . . . . . . . . . . . . . . . . 291
CommandHistoryDialog . . . . . . . . . . . . . . . . . . . . 292
LookupTableDialog . . . . . . . . . . . . . . . . . . . . . . . 293
OptionsDialog . . . . . . . . . . . . . . . . . . . . . . . . . . 294
Index 295
v
vi
About This Manual
Subject Thismanualprovidescontext-sensitivehelpfortheConnectdialog,the
QueryEditor,theMobiLinkMonitor,theAdaptiveServerAnywhere
Consoleutility,theIndexConsultant,andtheUltraLiteSchemaPainter. It
alsocontainscontext-sensitivehelpforallthepropertysheetsanddialog
boxesthatareavailableinSybaseCentral,aswellasforMobiLinkwizards.
Audience ThismanualisforallusersofSQLAnywhereStudio.
vii
SQL Anywhere Studio documentation
ThisbookispartoftheSQLAnywheredocumentationset. Thissection
describesthebooksinthedocumentationsetandhowyoucanusethem.
TheSQLAnywhere TheSQLAnywhereStudiodocumentationisavailableinavarietyofforms:
Studiodocumentation inanonlineformthatcombinesallbooksinonelargehelpfile;asseparate
PDFfilesforeachbook;andasprintedbooksthatyoucanpurchase. The
documentationconsistsofthefollowingbooks:
¤ IntroducingSQLAnywhereStudio Thisbookprovidesanoverviewof
theSQLAnywhereStudiodatabasemanagementandsynchronization
technologies. Itincludestutorialstointroduceyoutoeachofthepieces
thatmakeupSQLAnywhereStudio.
¤ What’sNewinSQLAnywhereStudio Thisbookisforusersof
previousversionsofthesoftware. Itlistsnewfeaturesinthisand
previousreleasesoftheproductanddescribesupgradeprocedures.
¤ AdaptiveServerAnywhereDatabaseAdministrationGuide This
bookcoversmaterialrelatedtorunning,managing,andconfiguring
databasesanddatabaseservers.
¤ AdaptiveServerAnywhereSQLUser’sGuide Thisbookdescribes
howtodesignandcreatedatabases;howtoimport,export,andmodify
data;howtoretrievedata;andhowtobuildstoredproceduresand
triggers.
¤ AdaptiveServerAnywhereSQLReferenceManual Thisbook
providesacompletereferencefortheSQLlanguageusedbyAdaptive
ServerAnywhere. ItalsodescribestheAdaptiveServerAnywhere
systemtablesandprocedures.
¤ AdaptiveServerAnywhereProgrammingGuide Thisbookdescribes
howtobuildanddeploydatabaseapplicationsusingtheC,C++,andJava
programminglanguages. UsersoftoolssuchasVisualBasicand
PowerBuildercanusetheprogramminginterfacesprovidedbythose
tools. ItalsodescribestheAdaptiveServerAnywhereADO.NETdata
provider.
¤ AdaptiveServerAnywhereSNMPExtensionAgentUser’sGuide
ThisbookdescribeshowtoconfiguretheAdaptiveServerAnywhere
SNMPExtensionAgentforusewithSNMPmanagementapplicationsto
manageAdaptiveServerAnywheredatabases.
¤ AdaptiveServerAnywhereErrorMessages Thisbookprovidesa
completelistingofAdaptiveServerAnywhereerrormessagestogether
withdiagnosticinformation.
viii
¤ SQLAnywhereStudioSecurityGuide Thisbookprovides
informationaboutsecurityfeaturesinAdaptiveServerAnywhere
databases. AdaptiveServerAnywhere7.0wasawardedaTCSEC
(TrustedComputerSystemEvaluationCriteria)C2securityratingfrom
theU.S.Government. Thisbookmaybeofinteresttothosewhowishto
runthecurrentversionofAdaptiveServerAnywhereinamanner
equivalenttotheC2-certifiedenvironment.
¤ MobiLinkAdministrationGuide Thisbookdescribeshowtousethe
MobiLinkdatasynchronizationsystemformobilecomputing,which
enablessharingofdatabetweenasingleOracle,Sybase,Microsoftor
IBMdatabaseandmanyAdaptiveServerAnywhereorUltraLite
databases.
¤ MobiLinkClients Thisbookdescribeshowtosetupandsynchronize
AdaptiveServerAnywhereandUltraLiteremotedatabases.
¤ MobiLinkSynchronizationServer-InitiatedSynchronizationUser’s
Guide ThisbookdescribesMobiLinkserver-initiatedsynchronization,
afeatureofMobiLinkthatallowsyoutoinitiatesynchronizationfromthe
consolidateddatabase.
¤ MobiLinkTutorials Thisbookprovidesseveraltutorialsthatwalkyou
throughhowtosetupandrunMobiLinkapplications.
¤ QAnywhereUser’sGuide ThismanualdescribesMobiLink
QAnywhere,amessagingplatformthatenablesthedevelopmentand
deploymentofmessagingapplicationsformobileandwirelessclients,as
wellastraditionaldesktopandlaptopclients.
¤ iAnywhereSolutionsODBCDrivers Thisbookdescribeshowtoset
upODBCdriverstoaccessconsolidateddatabasesotherthanAdaptive
ServerAnywherefromtheMobiLinksynchronizationserverandfrom
AdaptiveServerAnywhereremotedataaccess.
¤ SQLRemoteUser’sGuide Thisbookdescribesallaspectsofthe
SQLRemotedatareplicationsystemformobilecomputing,which
enablessharingofdatabetweenasingleAdaptiveServerAnywhereor
AdaptiveServerEnterprisedatabaseandmanyAdaptiveServer
Anywheredatabasesusinganindirectlinksuchase-mailorfiletransfer.
¤ SQLAnywhereStudioHelp Thisbookincludesthecontext-sensitive
helpforSybaseCentral,InteractiveSQL,andothergraphicaltools. Itis
notincludedintheprinteddocumentationset.
¤ UltraLiteDatabaseUser’sGuide Thisbookisintendedforall
UltraLitedevelopers. ItintroducestheUltraLitedatabasesystemand
providesinformationcommontoallUltraLiteprogramminginterfaces.
ix
¤ UltraLiteInterfaceGuides Aseparatebookisprovidedforeach
UltraLiteprogramminginterface. Someoftheseinterfacesareprovided
asUltraLitecomponentsforrapidapplicationdevelopment,andothers
areprovidedasstaticinterfacesforC,C++,andJavadevelopment.
Inadditiontothisdocumentationset,PowerDesignerandInfoMakerinclude
theirownonlinedocumentation.
Documentationformats SQLAnywhereStudioprovidesdocumentationinthefollowingformats:
¤ Onlinedocumentation Theonlinedocumentationcontainsthe
completeSQLAnywhereStudiodocumentation,includingboththe
booksandthecontext-sensitivehelpforSQLAnywheretools. Theonline
documentationisupdatedwitheachmaintenancereleaseoftheproduct,
andisthemostcompleteandup-to-datesourceofdocumentation.
ToaccesstheonlinedocumentationonWindowsoperatingsystems,
chooseStart(cid:228) Programs(cid:228) SQLAnywhere9(cid:228) OnlineBooks. Youcan
navigatetheonlinedocumentationusingtheHTMLHelptableof
contents,index,andsearchfacilityintheleftpane,aswellasusingthe
linksandmenusintherightpane.
ToaccesstheonlinedocumentationonUNIXoperatingsystems,seethe
HTMLdocumentationunderyourSQLAnywhereinstallation.
¤ PDFbooks TheSQLAnywherebooksareprovidedasasetofPDF
files,viewablewithAdobeAcrobatReader.
ThePDFbooksareaccessiblefromtheonlinebooks,orfromthe
WindowsStartmenu.
¤ Printedbooks ThecompletesetofbooksisavailablefromSybase
salesorfromeShop,theSybaseonlinestoreat
http://eshop.sybase.com/eshop/documentation.
x