HANA_SQLScript_Guide

SAPIn-MemoryDatabase–SQLScriptGuideSAPIn-MemoryAppliance(SAPHANA)1.0TargetAudienceConsultantsAdministratorsPublicDocumentversion3.1–08/12/2011©Copyright2011SAPAG.Allrightsreserved.NopartofthispublicationmaybereproducedortransmittedinanyformorforanypurposewithouttheexpresspermissionofSAPAG.Theinformationcontainedhereinmaybechangedwithoutpriornotice.SomesoftwareproductsmarketedbySAPAGanditsdistributorscontainproprietarysoftwarecomponentsofothersoftwarevendors.©Copyright2011Sybase,Inc.Allrightsreserved.UnpublishedrightsreservedunderU.S.copyrightlaws.Sybase,theSybaselogo,AdaptiveServer,iAnywhere,Sybase365,SQLAnywhereandotherSybaseproductsandservicesmentionedhereinaswellastheirrespectivelogosaretrademarksorregisteredtrademarksofSybase,Inc.Allothertrademarksarethepropertyoftheirrespectiveowners.Microsoft,Windows,Outlook,andPowerPointareregisteredtrademarksofMicrosoftCorporation.IBM,DB2,DB2UniversalDatabase,Systemi,Systemi5,Systemp,Systemp5,Systemx,Systemz,Systemz10,Systemz9,z10,z9,iSeries,pSeries,xSeries,zSeries,eServer,z/VM,z/OS,i5/OS,S/390,OS/390,OS/400,AS/400,S/390ParallelEnterpriseServer,PowerVM,PowerArchitecture,POWER6+,POWER6,POWER5+,POWER5,POWER,OpenPower,PowerPC,BatchPipes,BladeCenter,SystemStorage,GPFS,HACMP,RETAIN,DB2Connect,RACF,Redbooks,OS/2,ParallelSysplex,MVS/ESA,AIX,IntelligentMiner,WebSphere,Netfinity,TivoliandInformixaretrademarksorregisteredtrademarksofIBMCorporation.LinuxistheregisteredtrademarkofLinusTorvaldsintheU.S.andothercountries.Adobe,theAdobelogo,Acrobat,PostScript,andReaderareeithertrademarksorregisteredtrademarksofAdobeSystemsIncorporatedintheUnitedStatesand/orothercountries.OracleisaregisteredtrademarkofOracleCorporation.UNIX,X/Open,OSF/1,andMotifareregisteredtrademarksoftheOpenGroup.Citrix,ICA,ProgramNeighborhood,MetaFrame,WinFrame,VideoFrame,andMultiWinaretrademarksorregisteredtrademarksofCitrixSystems,Inc.HTML,XML,XHTMLandW3CaretrademarksorregisteredtrademarksofW3C®,WorldWideWebConsortium,MassachusettsInstituteofTechnology.JavaisaregisteredtrademarkofSunMicrosystems,Inc.JavaScriptisaregisteredtrademarkofSunMicrosystems,Inc.,usedunderlicensefortechnologyinventedandimplementedbyNetscape.SAP,R/3,SAPNetWeaver,Duet,PartnerEdge,ByDesign,SAPBusinessObjectsExplorer,andotherSAPproductsandservicesmentionedhereinaswellastheirrespectivelogosaretrademarksorregisteredtrademarksofSAPAGinGermanyandothercountries.BusinessObjectsandtheBusinessObjectslogo,BusinessObjects,CrystalReports,CrystalDecisions,WebIntelligence,Xcelsius,andotherBusinessObjectsproductsandservicesmentionedhereinaswellastheirrespectivelogosaretrademarksorregisteredtrademarksofBusinessObjectsSoftwareLtd.intheUnitedStatesandinothercountries.SybaseandAdaptiveServer,iAnywhere,Sybase365,SQLAnywhere,andotherSybaseproductsandservicesmentionedhereinaswellastheirrespectivelogosaretrademarksorregisteredtrademarksofSybase,Inc.SybaseisanSAPcompany.Allotherproductandservicenamesmentionedarethetrademarksoftheirrespectivecompanies.Datacontainedinthisdocumentservesinformationalpurposesonly.Nationalproductspecificationsmayvary.Thesematerialsaresubjecttochangewithoutnotice.ThesematerialsareprovidedbySAPAGanditsaffiliatedcompanies(SAPGroup)forinformationalpurposesonly,withoutrepresentationorwarrantyofanykind,andSAPGroupshallnotbeliableforerrorsoromissionswithrespecttothematerials.TheonlywarrantiesforSAPGroupproductsandservicesarethosethataresetforthintheexpressSAPAGDietmar-Hopp-Allee1669190WalldorfGermanyT+49/1805/343424F+49/1805/343420™.Anycodechangeinthesecomponentsmaycauseunpredictableandseveremalfunctionsandisthereforeexpressivelyprohibited,asisanydecompilationofthesecomponents.AnyJava™SourceCodedeliveredwiththisproductisonlytobeusedbySAP’sSupportServicesandmaynotbemodifiedoralteredinanyway.DocumentationintheSAPServiceMarketplaceYoucanfindthisdocumentationatthefollowingaddress:(C)2001-2004RobertA.vanEngelen,Geniviainc.AllRightsReserved.THESOFTWAREINTHISPRODUCTWASINPARTPROVIDEDBYGENIVIAINCANDANYEXPRESSORIMPLIEDWARRANTIES,INCLUDING,BUTNOTLIMITEDTO,THEIMPLIEDWARRANTIESOFMERCHANTABILITYANDFITNESSFORAPARTICULARPURPOSEAREDISCLAIMED.INNOEVENTSHALLTHEAUTHORBELIABLEFORANYDIRECT,INDIRECT,INCIDENTAL,SPECIAL,EXEMPLARY,ORCONSEQUENTIALDAMAGES(INCLUDING,BUTNOTLIMITEDTO,PROCUREMENTOFSUBSTITUTEGOODSORSERVICES;LOSSOFUSE,DATA,ORPROFITS;ORBUSINESSINTERRUPTION)HOWEVERCAUSEDANDONANYTHEORYOFLIABILITY,WHETHERINCONTRACT,STRICTLIABILITY,ORTORT(INCLUDINGNEGLIGENCEOROTHERWISE)ARISINGINANYWAYOUTOFTHEUSEOFTHISSOFTWARE,EVENIFADVISEDOFTHEP