Hitachi

Hitachi Advanced Data Binder SQLリファレンス


6.10.1 予約語の一覧

予約語は,SQL文で使用するキーワードとして登録されています。したがって,予約語を表や列の名称として指定できません。予約語と同じ文字列を名前に指定したい場合は,「6.10.2 名前が予約語と重複した場合の対応」を参照してください。

メモ

HADBの予約語は,SQL92(ISO 9075−1992 Database Language SQL)で規定されている予約語に準拠しています。

HADBの予約語を次の表に示します。

表6‒19 HADBの予約語

頭文字

予約語

A

ABSABSOLUTEACCESSACTIONADDADMINAFTERAGGREGATEAGGREGATESALIASALLALLOCATEALTERANDANDNOTANYAREARRAYARRAY_AGGARRAY_MAX_CARDINALITYASASCASENSITIVEASSERTIONASSIGNASYMMETRICATATOMICAUTHORIZATIONAVG

B

BEFOREBEGINBEGIN_FRAMEBEGIN_PARTITIONBETWEENBIGINTBINARYBITBIT_AND_TESTBIT_LENGTHBLOBBOOLEANBOTHBREADTHBY

C

CALLCALLEDCARDINALITYCASCADECASCADEDCASECASTCATALOGCEILCEILINGCHANGECHARCHAR_LENGTHCHARACTERCHARACTER_LENGTHCHECKCHUNKCHUNKIDCLASSCLASSIFIERCLOBCLOSECLUSTERCOALESCECOLLATECOLLATIONCOLLECTCOLUMNCOLUMNSCOMMENTCOMMITCOMPLETIONCONDITIONCONNECTCONNECTIONCONSTRAINTCONSTRAINTSCONSTRUCTORCONTINUECONVERTCORRCORRESPONDINGCOUNTCOUNT_FLOATCOVAR_POPCOVAR_SAMPCREATECROSSCUBECUME_DISTCURRENTCURRENT_CATALOGCURRENT_DATECURRENT_PATHCURRENT_ROLECURRENT_ROWCURRENT_SCHEMACURRENT_TIMECURRENT_TIMESTAMPCURRENT_USERCURRENT_USER_IS_DBACURSORCYCLE

D

DATADATALINKDATEDAYDAYSDBADEALLOCATEDECDECIMALDECLAREDEFAULTDEFERRABLEDEFERREDDEFINEDELETEDENSE_RANKDEPTHDEREFDESCDESCRIBEDESCRIPTORDESTROYDESTRUCTORDETERMINISTICDIAGNOSTICSDICTIONARYDIGITSDISCONNECTDISTINCTDLNEWCOPYDLPREVIOUSCOPYDLURLCOMPLETEDLURLCOMPLETEONLYDLURLCOMPLETEWRITEDLURLPATHDLURLPATHONLYDLURLPATHWRITEDLURLSCHEMEDLURLSERVERDLVALUEDODOMAINDOUBLEDROPDYNAMIC

E

EACHELEMENTELSEELSEIFENDEND_FRAMEEND_PARTITIONEND-EXECEQUALSESCAPEEVERYEXCEPTEXCEPTIONEXCLUSIVEEXECEXECUTEEXISTSEXITEXPEXTERNALEXTRACT

F

FALSEFETCHFILTERFIRSTFIRST_VALUEFIXFLATFLOATFLOORFORFOREIGNFOUNDFRAME_ROWFREEFROMFULLFUNCTIONFUSION

G

GENERALGETGLOBALGOGOTOGRANTGROUPGROUPINGGROUPS

H

HANDLERHASHHAVINGHEXHOLDHOSTHOURHOURS

I

IDENTIFIEDIDENTITYIFIGNOREIMMEDIATEIMPORTININCREMENTALINDEXINDICATORINITIALINITIALIZEINITIALLYINNERINOUTINPUTINSENSITIVEINSERTINTINTEGERINTERSECTINTERSECTIONINTERVALINTOISISOLATIONITERATE

J

JARJOIN

K

KEY

L

LAGLANGUAGELARGELASTLAST_VALUELATERALLEADLEADINGLEAVELEFTLENGTHLESSLEVELLIKELIKE_REGEXLIMITLISTLISTAGGLNLOCALLOCALTIMELOCALTIMESTAMPLOCATORLOCKLONGLOOPLOWER

M

MAPMATCHMATCH_NUMBERMATCH_RECOGNIZEMAXMAXIMALMCHARMEASURESMEMBERMERGEMETHODMICROSECONDMICROSECONDSMILLISECONDMILLISECONDSMINMINUTEMINUTESMODMODEMODIFIESMODIFYMODULEMONTHMONTHSMULTISETMVARCHAR

N

NAMESNANOSECONDNANOSECONDSNATIONALNATURALNCHARNCLOBNESTINGNEWNEXTNONONENORMALIZENOTNOWAITNTH_VALUENTILENULLNULLIFNUMERICNVARCHAR

O

OBJECTOCCURRENCES_REGEXOCTET_LENGTHOFOFFOFFSETOLDONONEONLYOPENOPERATIONOPTIMIZEOPTIONORORDERORDINALITYOUTOUTEROUTPUTOVEROVERLAPSOVERLAY

P

PADPAGEPARAMETERPARAMETERSPARTIALPARTITIONPARTITIONEDPATHPATTERNPCTFREEPERPERCENTPERCENT_RANKPERCENTILE_CONTPERCENTILE_DISCPERIODPICOSECOND,PICOSECONDSPORTIONPOSITION,POSITION_REGEXPOSTFIXPOWERPRECISIONPREFIXPREORDERPREPAREPRESERVEPRIMARYPRIORPRIVATEPRIVILEGESPROCEDUREPROGRAMPROTECTEDPUBLICPURGE

R

RANGERANKREADREADSREALRECOVERYRECURSIVEREDOREFREFERENCESREFERENCINGREGR_AVGXREGR_AVGYREGR_COUNTREGR_INTERCEPTREGR_R2,REGR_SLOPEREGR_SXXREGR_SXYREGR_SYYRELATIVERELEASEREPEATRESIGNALRESTRICTRESULTRETURNRETURNSREVOKERIGHTROLEROLLBACKROLLUPROUTINEROWROW_NUMBERROWIDROWS

S

SAVEPOINTSCHEMASCOPESCROLLSEARCHSECONDSECONDSSECTIONSEEKSELECTSENSITIVESEQUENCESESSIONSESSION_USERSETSETSSHARESIGNALSIMILARSIZESKIPSMALLFLTSMALLINTSOMESPACESPECIFICSPECIFICTYPESQLSQLCODESQLCODE_OF_LAST_CONDITIONSQLCOUNT,SQLERRM_OF_LAST_CONDITIONSQLERRORSQLEXCEPTIONSQLSTATESQLWARNINGSQRTSTARTSTATESTATEMENTSTATICSTDDEV_POPSTDDEV_SAMPSTRUCTURESUBMULTISETSUBSESUBSTRSUBSTRINGSUBSTRING_REGEXSUMSUPPRESSSYMMETRICSYSTEMSYSTEM_TIMESYSTEM_USER

T

TABLETABLESAMPLETEMPORARYTERMINATETESTTHANTHENTIMETIMESTAMPTIMESTAMP_FORMATTIMEZONE_HOURTIMEZONE_MINUTETOTRAILINGTRANSACTIONTRANSLATETRANSLATE_REGEXTRANSLATIONTREATTRIGGERTRIMTRIM_ARRAYTRUETRUNCATETYPE

U

UESCAPEUNDERUNDOUNIONUNIQUEUNKNOWNUNNESTUNTILUPDATEUPPERUSAGEUSERUSING

V

VALUEVALUE_OFVALUESVAR_POPVAR_SAMPVARBINARYVARCHARVARCHAR_FORMATVARIABLEVARYINGVERSIONINGVIEW

W

WAITWHENWHENEVERWHEREWHILEWIDTH_BUCKETWINDOWWITHWITHINWITHOUTWORKWRITE

X

XLIKEXMLXMLAGGXMLATTRIBUTESXMLBINARYXMLCASTXMLCOMMENTXMLCONCATXMLDOCUMENTXMLELEMENTXMLEXISTSXMLFORESTXMLITERATEXMLNAMESPACESXMLPARSEXMLPIXMLQUERYXMLSERIALIZEXMLTABLEXMLTEXTXMLVALIDATE

Y

YEARYEARS

Z

ZONE