Category : Windows 3.X Files
Archive : QWNSQL2A.ZIP
Filename : SYNTAX.HLP
Output of file : SYNTAX.HLP contained in archive : QWNSQL2A.ZIP
%/8@HOZ^g¦±·»É< U ] j o y ¬ Å ç
'
+
/
9
@
G
L
P
Y
a
h
n
¢
¨
®
»
Á
Þ
æ
ë
î
ò
' . > M \ | Û ä ë î ø þ ) - 4 9 B E J N R X ^ e k t | ¡ ¦ » ¿ Ã É æ ë
]
¤
³
Á
Ñ
ã
ç
÷
8@ITkpw|¥¬²º½ÀÇÊÒØ#&BHR[elsµ»ÁÈÏÓÛÞâçíö
&.7;EOX`js¥´ÀÄÉÑØàëðöý %.4C¡©²¶ÁÇÏ×Ýâçðù %0>DGXhlqy¤µæñø
!,28?IMPr} ¤ª±µºÁÅÎØÞãèëóú ")£¬´ÀÃÇÍÓØáèïøý")-6?ELQYaio{¦¬´¼ÁÇÏØù &,27=CGKORW[_dimquz ©ÄÉÒÜâèìñôøü %(,>CJOSY]agj"Grouped"SYSTEM"."grouped table". "Grouped tables" are fully supported by the Quasar Database Administrator.(ColumnName(Subquery)(Value1(for(whichever occurred most recently), otherwise the condition evaluates to FALSE.-2147483647. ...1.7976931348623158e+3082.2250738585072014e-308.2047.2147483647.<= <= 19 and 0 <=<= 19.A comment.ALLASCAdditionalAdditional columns may be included within theAdministratorApproximateArithmetic expressions are evaluatedAs queries are executed within a transaction and records are created, read, updated or deleted; the database applies various kinds of locks on the applicable records. These locks are released when the transaction is committed or rolled back. In order tBuilt-inCHARCHARACTER(COLUMNCOMMIT WORKCOUNT(CREATECREATE TABLECatalogChanges made to the database are not made permanent untilCharacterCharacter data, length assumed to be 1.Character data, length specified by n where 1 <= n <= 2047.Character data, variable length where maximum length isColumnColumnNameColumnNameColumnName1 DataType1ColumnSpecificationCommentsConditionCorrelationNameCreatesCreatorNameDECDELETEDELETE FROMDESCDESC]]DISTINCTDROPDROP INDEXDROP TABLEData TypesData typeDataTypeDatabaseDeletesDescriptionEachEvaluatesEvaluates to TRUE if and only ifExpressionExpressionExpression1Expression2FALSE.FROMFloating pointFloating point number with magnitude ranging from approximately 1.7976931348623158e+308 to 2.2250738585072014e-308.For each record selected,GROUP BYIN (Subquery)INDEXINDEX_NAMEINSERTINSERT INTOINTIndexNameIndicatesIndicates theIndicates the name of theIndicates the number of columns inIndicates the position of the column within theIndicates whetherInstNULLNUMBER_OF_NUMERICNumericORDEROnlyOperatorsOverviewPatternPhrasePlease refer to a text book for a description of theQuasarREMARKROLLBACK WORKSELECTSET ColumnName1 = Expression1SMALLINTSOME]SQLSQL.SYSTEM.COLUMNSSYSTEM.INDICESSYSTEM.TABLESSYSTEM.USERSSame asSearch ConditionSearchConditionSelectStatementSigned decimal number with up toSigned decimal number with up to 19 digits of which 0 appear to the right of the decimal point.SpecifiesSpecifyStaStatementsStringSubquerySyntaxSystem CatalogTABLETABLE_NAMETRUETRUE ifTRUE.TableNameTheTheseThisThisTypes:UNIQUEUNKNOWNUPDATEUSER_NAMEUserNameVALUES (Value1VARCHAR(128)VARCHAR(32)ValueWHERE SearchConditionWORKWhenWhen aWhen a column is specified asWhileWhole number ranging from -2147483647 to 2147483647.You may only modify the REMARK field of records in this table.[(ColumnName1[, ColumnName2] ... )][, ColumnName2[, ColumnSpecification[, Expression2][, Value2] ...[ALL | DISTINCT][ANY | ALL | SOME][ASC[CorrelationName[CreatorName.][NOT[NOT][UNIQUE (ColumnNameA[, ColumnNameB] ... )][UNIQUE][UserName[UserName.][WHERE SearchCondition][not][optionaboutacceacrossadministratoragainstallallowed.alreadyamountanalyzedandandanotheranyanytime,appearappear to the right of the decimal point; 1 <=applicableapplieapproximatelyareare limited to 32 charactersarise.arithmeticascendingassociatedassumedattemptautomaticallyavailablebackbarbecomes the name of the newly createdbeforebelongbelongsbetweenbookbuilt-incancasecausechangecharactercharacters.clausecolumncolumnscombinationcommas.comment.committedcompcompatibleconcatenatconditionconflictconstraintconstructconstructed.containingcontainscontentcontrolcreatecreatingcurrentcurrent userdatadata,databasedecimaldefault.definitionsdeletdeletedeleteddepositeddescending.descriptiondeterminedifferentdigitsdigits of whichdigits of which 0 appear to the right of the decimal point; 1 <=distinguishabledocumentdroppeddroppingduplicateeacheffectivelyeitherelementseliminatentireequalerrorevaluatedevaluatesevaluatiexampleexecuteexecutiexpressionfieldfixed pointfloating pointfollowforfor ascending andfor descending. fromfullyfunctiongeneragenerategreatgrouphashavehelphowever,identifieidentifyif the table belongs to a user different from theif you wishimpliesincludedincludesindexindiindicatesindicesinformationinsertinsureintegerinternallyintois is analyzed and a value obtained. is default.issuingjournalkeykey valueskeywordsleftlengthlimitedlistlockslogicalmademagnitudemaintainedmanagematchmaximmayminimizemodifiemodifymoremultiplimustnamenamesnotnumbernumerico minimize the conflict between transactions, be sure to minimize the amount of time these locks are in place by issuing aobtained.occurredon the tableoneonlyoperatoptionorderotherwisepatternperformpermanentplacepointpoint;positionpossibleprequeriesrangingreadrecently)recommendrecordrecordsreferreferredreleasedrepeatedresultresult tableresultingreturnrightrolledsamescrollsectionselectselectedseparatesincesinglespecificspecifiedspecifies which records are to bestandard.startsstatementstringsuppliedsupportsyntaxsystemtabletable.tablestextthanthatthetheirthemthentherethesetheythistimetopictransactiontypetype is typically referred to astype is used to store text.typestypicallyunderlineduniqueupdateuponupperuseuseduservaluevaluesvariablevariousviolatesvisiblewaswhenwhenever possible.wherewhetherwhichwillwindowwishwithwithinyou/ & ;) z4 missing. Con ÿÿ
ÿÿÿÿ|CTXOMAP |FONT ð |KWBTREE S |KWDATA |KWMAP B |Phrases |SYSTEM ¶ |TOMAP |TOPIC ì |TTLBTREE g.ßgcßgÞßgÐxßgU!ßg ßgZbßgbßg ßgA ßg¥ßg^0ßg
ßg°ßgIßgßg"ßgIÍßg2ÇßgNÂßg5Ößg£ÛßgÌßg^ÄßgZßgéßg`_ßg{ßg#ßg«ßgUßg%Óßg^UßgWßgCÂßgYßgôZßg Vßgþ[ßgç{ßgeßgßgßgTßg#ßg4ßgÉÊßg"Ëßg½Ôßg>SßgbÊßg Ðßgznßg"'ßgêÎßgJßg)Ôßgé¦ßgÌÙßg4ßgßg¤ ßgâCßgPßg_Ùßg GßgxLßgÏßg¢Üßg=ßgUßghßgsßgÆYßgeSßgßg¦#ßgkcßg ßg4ßg1'ßg¦ßgISßgH¥ßg ßg¯ ßgòUßgý£ßgÝZßg´ßgpSßgËxßgßg1ÜßgIÂßgòßgP¢ßgCßgÖ]ßgnßgüÉßgþRßg¢mßg ßg¡ßg²Yßgãßg~VßgßgüßgëßgUßg_ßg)ßgVßg¢ßg ßgWßg [ßg´Ußgßgßgßg"ÑßgæYßgWØßgñßgßgè¡ßgëßgL[ßgßgÈßgÉßgÄ ßgaßg¨¤ßgåßgó¥ßgH¡ßg]£ßgßßgV_ßgàUßg ±ßgßg
ßgMßg{ßgêÖßgNÇßgúvßgµVßgMßgDåßgìßgâßgÈkßgÉßg«ßgßgh©ßg5 ßg]ßgé²ßg('ßg¥ßgâgßgaßgqbßgkßgßg&Ðßg_Øßg5Ãßg¾ßgWßgýßg ×ßgQÖßg4ßgUßg/Ôßg. ßg}ÈßgAÔßghÊßgxÊßgOßg ßgßgeÙßg£«ßgVßgîYßgºßgßg©ÈßgºYßgÏÊßg»*ßgèCßgyßglßgÒlßgBßgÃlßgsßgÒÙßgm<ßg(ËßgÂÆßgõÔßg]6ßg¶kßg1¯ßgeÍßgPmßgÐßgÒÀßgÈWßg#ßgzßg)ß6 - l \>)
Quasar ÎK=U* ÝKþ
Þ[ 3n *n ÿÿÿÿ ÿÿÿÿ) ) ! È ÿÿ á)Yj: ) : % T* ÿ Ò áHelp Index ' s : ' - , ¾JBÑ à. ÿ ks 9YJs ¡A9á(. Using 9board, tab to
9YKwant to view, 8n âss enter. Using 9mouse, Ûto 9YKwant to view, }click 9mouse button. Use 8 ¤ to see entries ¹currently sin 9Y. To learn how to cX, âss F1. z l ' z 4 : ¾JRB°±S~±á ÿ Ê describes, in Ll terms, what áis }9¸ation ein G. Ä é z Ä â ÂJRB±S~±á á á! á" á# á$ á% ÿ þ ia of 9)of qáÿr program µb. z ia of qïUrecognized by â È ia of qÊors eâ 9Functions ia of q³Js eâ s ia of 9)of 6s eâ î ia of 9)eto
ï . ia of 91eby 9Ó1to keep track of 9ò. @ , Ä @ ! å General s}¸ation conventions' @ ' " T* ÿ Ê @ ' @ * & ²JRB!ã~! ÿ General Information ÿ @ ÿ . . ²JB!Ñ ÿ Structured Query Language (SQL) is 9ó ment language declared by 9American National ündards ºitute (ANSI) as a áis 9 lingua franca of 9Îuter óworld. áis eon mainframes, minicomputers }PCs. C ÿ C * & ²JRB!ã~! ÿ Notational Conventions Y 9 C e 6 > ²JB!Ñ ÿ ;`case is ethroughout Gto lcate áwords (COMMIT, Ø, etc), in actuality 9Ó1hpt words in aor lowercase. word 'COMMIT' §be spelled 'commit', 'Commit', 'COMMIT', etc. ·of brs, 0, lces }Ä, }9ãof ½8s , [·sensitive. If esome Çof a}lower ·to ç8m, Wto c9Çto hss 8m. All +·were æd using a·È. Optional !lcated by color }enclosing 8m square brackets as in d] When a choice §be among a of áÌal , lvidual selections d by vertical ¤s as inz ½ Ô d1 | Ì2 | Ì3] . » e . . ÂJB!Ñ ÿ When a Ó§be ø, an ellipsis >s 9Óas in "ColumnName1 B] ". 1ea of Çor ¯Ã·d by È . . ! á s defined'
. ' " T* ÿ þ L < ' L & ¾JBÑ ÿ áis based on obs of 9>ing s: l L l 4 : ¾JRB°±S~±á ÿ @ ºructs 9ómto make qºs to 9óby 9ëMÖ. l ¤ ÂJRB±S~±á á á á á á á á á ÿ E¢ ean kon a ó. F ea ó. j ñGa ó. v an kGa ó. x a ó. ¦ eñin a ó. Ö ºructs 9ómto @get qºs to 9óby 9ëL. Ø Retrieves ïGó0. " Modifies 9ãof ñó0. 0 0 ! Committing work1 0 1 " T* ÿ ütement: @ 4 1 4 + ( ²JRB!ã~! ÿ @; ä f 4 ä A T ²JB!Ñ à* á ÿ KG!is 2d. Should 9 ì 3a Ö or unexpectedly log off, qºs by 9br logging in or 4ng a @ vanish. During órecovery ÉÍLs restored. ¹ ä : F ²JRB!ã~! ÿ ^ 6o ©9ׯLs, be sure to ©9wof I8se in Ùby a @ or Ö x ¯ . . ÂJB!Ñ ÿ Committing a M a new L. @ is very fast 9ºs Wubeen , 8y merely flagged as Ö. / / ! é Creating an j3 / 3 " T* ÿ ütement: E¢ @ ! 3 @ 1 4 ²JRB!ã~! ÿ E Z ¢ B 7 @ B / 0 T*P H ÿ R ¬ ON ^ ( I < B I * & T*P ÍH ÿ X1 O| n][, X2 O| p * I * % T*P H ÿ );  * Î 4 : ²JB!Ñ ÿ !æs 9k ¬ Å While lces never òenced explicitly in á(other 5é}8m), 8y eextensively by 9Ó1to ¤ize + F ï
Ôance. 3 Î 3 + ( ²JRB°ÑS~Ñ ÿ Î 8 3 8 , * T*R [H ÿ E Z ¢ ¡ 8 ¡ 4 : ²JBÑÑ à, ÿ û c to be , ÇG~, k9%-_9kis Ý If an is to ça ïin 9-qG[Ø, an )Õ 1 ¡ 1 ) $ T*R [H ÿ R ¬ k 1 k 7 @ ²JBÑÑ à* ÿ ¬ §j. û f c9kto «to a br G9 ì . 8 k 8 , * T*R [H ÿ ON ^ h £ 8 h 7 @ ²JBÑÑ à* ÿ \s 9-_9kis to be Ý û & a ì . 8 h 8 ) $ T*R [H ÿ X1 O| n] Í ÿ 8 Í I d ²JBÑÑ à+ ÿ X \s a Ãin 9-to be gin 9k Specify * C n A * We ío9cof n , it is gin Ïto conform to 9ANSI 3 # Í 3 & T*R [H ÿ CO| q z Å 3 z . . ²JBÑÑ à+ ÿ /k by éa of Åd by É kbe Úed in 9Ïin Å in G. ° á z ° . . ²JRB!ã~! ÿ ^ ;lces §be æd at we í7çlces immediately after ç;base table; Ð, E£Uto é}rewrite qï~already in 9. r ° A T ÂJB!Ñ ÿ âsence of suitable lces §Ply enhance +Ôance. Indices do, [¹a moderate increase in 9wof Iit takes to write a ïto 9-_9kis Ý óbr should add lces judiciously. X , f , ¬, } & . . . ! w Creating a ,1 . 1 " T* ÿ ütement: F @ / 1 @ 1 4 ²JRB!ã~! ÿ G ^ ( j ¹ @ j - , T*P ÍH ÿ [ U½Z][, X2 ~2 U½Z]] X[, A[, XB] )] * j * % T*P H ÿ ); N N * N . . ²JB!Ñ ÿ !æs 9- 9Åas . 3 N 3 + ( ²JRB°ÑS~Ñ ÿ Î 7 & 3 7 , * T*R [H ÿ G ^ i 7 u 7 @ ²JBÑÑ à* ÿ Ã Ø §/ û & c9-to «to a br G9 ì . 6 - u 6 ) $ T*R [H ÿ [ U½Z] ? s 6 ? E \ ²JBÑÑ á ÿ X \s a Ãto be gin 9/ ~ o9ïOof 9Â. 9 NOT ¼ , to uor ]a ïwould ûin a ½iin Gùan )Õto 9 , an kis æd A7Â. kw7qkA7Ã, ÇG~, k9%/ Any to uor ]a ïqG[Ù¹an )Õto ; 3 ? ; & T*R [H ÿ C~2 U½ ]]] H t ; H ( " ²JBÑÑ ÿ /-by éa of Ãùd by È + - H + & T*R [H ÿ X á ¦ + á 5 < ²JBÑÑ à, ÿ Çof XA, XB, to be [kqñin 9. An ki9´d Åis æd. kw7 A8se Å, ÇG~, k9%/ Any to uor ]a ïqG[Ù¹an )Õto = / á = & T*R [H ÿ [, N[, XO] )] z ¸ = z ( " ²JBÑÑ ÿ Additional [Øs §be added by éa of [Ùùd by É [Ùis by a j. \ S z \ @ R ÂJRB!ã~! ÿ ^ X , } & . , \ , ! ¹ Deleting ð1 , 1 " T* ÿ ütement: j ? , 1 ? 1 4 ²JRB!ã~! ÿ m ^ / ? / ( " T*P H ÿ ` ; _ } / _ : F ²JB!Ñ á$ ÿ !üs ñG9- ð þ. 3 _ 3 + ( ²JRB°ÑS~Ñ ÿ Î 7 % 3 7 , * T*R [H ÿ m ^ k ¢ 7 k 7 @ ²JBÑÑ à* ÿ is 9µof 9-ß9ñto be þ. û & a ì . + k + & T*R [H ÿ 0 ? @ + ? 1 4 ²JBÑÑá$ ÿ ð þ. P E ? P : F ÂJRB!ã~! ÿ ^ } & . / P / ! Dropping an j1 / 1 " T* ÿ ütement: v ? . 1 ? 1 4 ²JRB!ã~! ÿ w R ¬ 8 ? 8 + ( T*P H ÿ ON ^ ; O I 8 [ 4 : ²JB!§ ß Ñ ÿ !üs 9k ¬ Å . 3 [ 3 + ( ²JRB°ÑS~Ñ ÿ Î 7 ' 3 7 , * T*R [H ÿ w R ¬ { 7 { 7 @ ²JBÑÑ à* ÿ ¬ is 9µof 9kto be þ. û f if 9kto a br G9 ì . 8 { 8 , * T*R [H ÿ ON ^ ` 8 ` 4 : ²JBÑÑ à* ÿ \s 9-_9kexists. û & a ì . o y ` o . . ²JRB!ã~! ÿ ^ ;lces §be at an kon a -¸s 9%-to be rebuilt. v o v 5 < ÂJB!Ñ ÿ When a -is þ, qlces 7-. f, ¬, } & . v . ! ? Dropping a ,1 . 1 " T* ÿ ütement: x @ , 1 @ 1 4 ²JRB!ã~! ÿ y ^ ; B 0 @ B . . ²JB!Ñ ÿ !üs 9- . 3 B 3 + ( ²JRB°ÑS~Ñ ÿ Î 7 $ 3 7 , * T*R [H ÿ y ^ e 7 e 7 @ ²JBÑÑ à* ÿ is 9µof 9-to be þ. û & a ì . N M e N . . ²JRB!ã~! ÿ ^ All lces 9-. A 9 N A 1 4 ÂJB!Ñ ÿ } & - A - ! ö Inserting ð1 - 1 " T* ÿ ütement: ¦ ? , 1 ? 1 4 ²JRB!ã~! ÿ © ^ F I ? F / 0 T*P H ÿ @ ( [, .2] ); >
F > 1 4 ²JVB!ã~! ÿ -- or -- ? , > ? 1 4 ²JRB!ã~! ÿ © ^ 3 8 ? 3 ) $ T*P H ÿ @ ò; > ; 3 > ( " ²JB!Ñ ÿ !ts ñ}9-. 3 > 3 + ( ²JRB°ÑS~Ñ ÿ Î 7 % 3 7 , * T*R [H ÿ © ^ o £ 7 o 7 @ ²JBÑÑ à* ÿ is 9µof 9-}ñto be ted. û & a ì . 7 $ o 7 & T*R [H ÿ 1[, X2] ) Å 7 Ñ ( " ²JBÑÑ ÿ Identifies Å}ïis to be ' ¼' Û$ . If Åexist in 9-¹ed, 8y set to 9½h. A õ§¹be ø. U·do ¹Wto be in 9Ïas 8y in 9-itself. 7 # Ñ 7 , * T*R [H ÿ ( H ) 1 7 1 ) $ ²JBÑÑ ÿ ù9kto be in 9î. If a of Åu$, 8re ³be a £¯9»of ÷in 9}9»of k$. If a of Åu¹$, 8re ³be a £¯9total »of Åin 9-}9»of k$. ïOof 9i³be Ñ9ïOof 9Ã}it is to be . When 9Ãallows 9½h, 9i§be 'NULL'. + 1 + & T*R [H ÿ ò U 5 + U G ` ²JBÑÑ á ÿ ò Ns a set of ñto be ted. If a of Åu$, 8re ³be a £¯9»of ÷in 9}9»of ÅNd by 9 ò If a of Åu¹$, 8re ³be a £¯9total »of Åin 9-}9»of ÅNd by 9 ò . ïUof 9ÅNd by 9 ò ³be Ñ9ïUof 9Å}8y to be . \ S U \ @ R ÂJRB!ã~! ÿ ^ X , } & . 0 \ 0 ! J Rolling work ¢1 0 1 " T* ÿ ütement: Ö 4 1 4 + ( ²JRB!ã~! ÿ Ö; ± 4 ± F ^ ²JB!Ñ á à* ÿ Ka @ !is 2d. Ö instructs 9óto purge qºs to 9óby 9 ì logging in or 4ng a @ . ¹ ± : F ²JRB!ã~! ÿ ^ 6o ©9ׯLs, be sure to ©9wof I8se in Ùby a @ or Ö x x x . . ÂJB!Ñ ÿ Rolling a M£ a new L. Ö §take some Iwhile 9ómpurges \s. - x - ! · Selecting î1 - 1 " T* ÿ ütement: Ø 9 " 1 9 . . ²JRB!ã~! ÿ Ù J V W 9 V 5 < T*P H ÿ G \1.] 1 P1][, A 1 V A & T*P ÍH ÿ \2.]TableName2 P2]] H ; A H & T*P H ÿ ` [GROUP BY TSpecification1[, K 6 H K ' T*P ÍH ÿ TSpecification2] [HAVING ð]] L 0 K X % T*P H / Ü/ . ÿ [ORDER BY TSpecificationA O| n][, I , X I ) $ T*P ÍH ÿ TSpecificationB O| p ] ; ¶ I ¶ : F ²JB!Ñ à- ÿ !Ns a ü There is ÇÃin 9ýA in 97of 9Ù . kin 9Åof 9ýNd by .ng 9corresponding . 3 ¶ 3 + ( ²JRB°ÑS~Ñ ÿ Î 1 3 1 ) $ T*R [H ÿ Ù J Ì 1 = L ²JBÑÑ à- ÿ ( r vs 7qñin 9 ü , ÇG~. 5 r is , ñ"ed G9ü. 1 1 ) $ T*R [H ÿ F 6 ¹ 1 6 G ` ²JBÑÑ ÿ specifies 9kto be ted }9Åof 9ü. ïUof 9Åof 9ýd by 9ïUof 9kúing G96s in G. You §substitute a ' * ' in Ùof 9of 6s. ' * ' ea of qÅof q1\d in 9 À. You §¹c' * ' if c9 À. E 4 6 E / 0 T*R [H ÿ \1.] 1 P1] ï E D Z ²JBÑÑ à* ÿ is 9µof 9-Gñto be è. û & a ì . b is an alias A9 it >s. D 4 D & T*R [H ÿ [, \2.]TableName2 P2]] £ D ( " ²JBÑÑ ÿ Additional 1§be gby éa of 1d by É æs a Cartesian product of q91in 9. + + & T*R [H ÿ 0 ? = + ? 1 4 ²JBÑÑá$ ÿ ð è. ; ? ; & T*R [H ÿ TSpecification1 Ó £ ; Ó ; H ²JBÑÑ ÿ Rearranges 9,(s) \d by 9 Á}Rs such 7ÇSqrows W9iA9 Â(s). Ø Áis 8n d to 8se Rs. SNs a ïin 9ü. Ñ 0 Ó 0 & T*R [H ÿ D2] W 0 W / 0 ²JBÑÑ ÿ / Áby éa of Åd by È Ñ 2 W 2 & T*R [H ÿ HAVING ð 2 ¡ / 0 ²JBÑÑ ÿ ùa restriction on 9Red -úing G9Áby "ing Rs ¹meeting 9 ð . Ñ XXXXXXXXXXXXXXXXXXXXXXk7 8 . F - ¡ F & T*R [H ÿ ÅBY TSpecificationA O| n] g é F g _ ²JBÑÑ à- ÿ Records in 9 ü be sorted on 9basis of 9ïin 9Åby 9 ÅBY À. û * C n A * TSpecification ³_Çof 9 s 9of 6s of 9 ÙSTATEMENT An y§be ein Ùof 9 TSpecification ; wan yis eit \s Ãin 9ýis to be eto 9Î. 5 , g 5 & T*R [H ÿ DB O| q § 5 . . ²JBÑÑ ÿ Additional Îing TSpecifications (or xs) §be g9ÅBY Áby éa of Å(or xs) d by È T V T : F ÂJRB!ã~! ÿ ^ b, } & . - T - ! Modifying ð1 - 1 " T* ÿ ütement: " ? ' 1 ? 1 4 ²JRB!ã~! ÿ # ^ 0 # ? 0 ( " T*P H ÿ Ú [, 6 ! 0 6 & T*P ÍH ÿ X2 = 2] / 6 / ( " T*P H ÿ ` ; a } / a : F ²JB!Ñ á$ ÿ !ªs ñin 9- ð ªd. 3 a 3 + ( ²JRB°ÑS~Ñ ÿ Î 7 3 7 , * T*R [H ÿ # ^ o ¡ 7 o 7 @ ²JBÑÑ à* ÿ is 9µof 9-in ñto be ªd. û & a ì . + o + & T*R [H ÿ Ú + 1 4 ²JBÑÑ ÿ is +}9ûØd in 9Ã\d by X Columns ¹ally \d unaffected. 4 $ 4 & T*R [H ÿ C= 2] 4 4 : ²JBÑÑ ÿ Additional ŧbe ªd by éa of Xs } s d by É A õ§¹be ø. + + & T*R [H ÿ ` @ A + @ 1 4 ²JBÑÑá$ ÿ ð ªd. T Q @ T : F ÂJRB!ã~! ÿ ^ X, } & . . T . ! áïUdefined(
. ( " T* ÿ |s R 8 ( ^ & ¾JBÑ ÿ |s organized }three basic categorie? ²? \? s: N Q ^ N : F ¾JRB°±S~±á ÿ 3 Q < . ~ N H b ÂJRB±S~±á á ÿ Exact  Q : . M Ois eto store 2. ' ' ! 3Ãz- " ' - " T* ÿ z: 3 8 : - 8 , * ²JBÑ ÿ Q < . 3 8 3 + ( ²JRB°ÑS~Ñ ÿ | Ñ 3 Ñ j ¦ ÂJRBÑS~ Ñí 'Ea}·Õñ
+Ge ÿ FLOAT FLOAT(p) » p significant digits, çGto REAL DOUBLE PRECISION + Ñ + ! í Exact Ãz1 + 1 " T* ÿ z: Exact  8 7 1 8 , * ²JBÑ ÿ Q : . 3 8 3 + ( ²JRB°ÑS~Ñ ÿ | & , 3 & " ÂJRBÑS~ Ñí 'Ea}·Õñ
+Ge ÿ h ö h(p) õ p p $ h(p, s) õ p
s p # s p . hIMAL ö hIMAL(p) õ p p $ hIMAL(p, s) õ p
s p # s p . ª < ªEGER < À ö À(p) õ p p $ À(p, s) õ p
s p # s p . Ü < ' & ' ! ! Mz- ' - " T* ÿ z: M > # - > & ²JBÑ ÿ Ois eto store 2. 3 > 3 + ( ²JRB°ÑS~Ñ ÿ | Ó § 3 Ó t º ÂJRBÑS~ Ñí 'Ea}·Õñ
+Ge ÿ : N :(n) P :ACTER N
t  V ÂJRBÑS~ Ñí 'Ea}·Õñ
+Ge ÿ AVG(Expression) AVG s 9average of 8se j. Çk¹½f. BDISTINCT ) BDISTINCT) s 9»of 8se k, ÇG~. Çk¹½f. B*) B*) s 9»of ñ. MAX(Expression) MAX s 9¤um of 8se j. Çk¹½f. MIN(Expression) MIN s 9minimum of 8se j. Çk¹½f. SUM(Expression) SUM s 9sum of 8se j. Çk¹½f. . t . ! 1 " $ á6s defined( . ( " T* ÿ s 2 ( 2 & ²JBÑ ÿ s µbe: i 2 K h ²JRBÑS~ Ñí 'Ea}·Õñ
+Ge ÿ A ô A constant or literal h A ³J An Çof 6s 8 8 & ²JBÑ ÿ Constants µbe: æ Í 8 æ K h ²JRBÑS~ Ñí 'Ea}·Õñ
+Ge ÿ Integer
0: 100, -5, +127) Decimal
0: 100.0, -.001, 1., +1.5)
0: 1E10, -2E-7, +3.14159E0) Character #
0: 'SMITH' '-@k9-22', '-1', 'Quasar') 7 æ 7 & ²JBÑ ÿ Order of 4on: Ò 7 Ò I d ÂJRBÑS~ Ñí 'Ea}·Õñ
+Ge ÿ 5©Îarisons }Êions. 5to except 7°cation }division Ôed ©addition }subtraction. Parentheses µbe eto å9Ïof .on. 5 Ò 5 ! ë # % ásearch Ôs defined( 5 ( " T* ÿ îs » ( ' ²JBÑ ÿ A search Õµbe a simple Õor a Çof Ôs. If 9iof 7~NULL 8n 9Õ-to : Simple UO }O O Ôs: 0 0 & T*R [H ÿ = 2 U 0 U 4 : ²JBÑÑ ÿ Ua i'to 7of 2 0 U 0 & T*R [H ÿ < 2 W 0 W 4 : ²JBÑÑ ÿ Ua iless 57of 2 1 W 1 & T*R [H ÿ <= 2 _ 1 _ 4 : ²JBÑÑ ÿ Ua iless 5or 'to 7of 2 0 _ 0 & T*R [H ÿ > 2 W 0 W 4 : ²JBÑÑ ÿ Ua iPer 57of 2 1 W 1 & T*R [H ÿ >= 2 _ 1 _ 4 : ²JBÑÑ ÿ Ua iPer 5or 'to 7of 2 1 _ 1 & T*R [H ÿ <> 2 \ 1 \ 4 : ²JBÑÑ ÿ Ua iis ¹'to 7of 2 I : \ I , * T*R [H ÿ V BETWEEN 2 AND 3 w [ I w I d ²JBÑÑ ÿ í V (( 2 ) AND ( 3 ). F 2 w F 2 6 T*R [H ÿ V IN
H ) } S F } C X ²JBÑÑ ÿ í V (( = .1 ) [ OR (Expression1 = .2)] . 8 $ } 8 , * T*R [H ÿ V a N 8 a : F ²JBÑÑ
ÿ ~ b 'to i ed by . = " a = , * T*R [H ÿ Y V LIKE Ì ¿ = 4 : ²JBÑÑ
ÿ Ç¡A½T: b 9#in 9âes Ì. In Ì , '_' ¢es ¼, '%' ¢es ½sequence. ; ; , * T*R [H ÿ YIS V ¼ L 3 ; L . . ²JBÑÑ
ÿ True if 9iof Y~ b ¼. 9 L 9 ) $ T*R [H ÿ V EXISTS T 9 9 T 1 4 ²JBÑÑ
ÿ [Not] s at least Çî. 8 $ T 8 , * T*R [H ÿ V h X 8 7 @ ²JBÑÑ
ÿ [Not] s at least Çiis 'to . XXXXXXXXXXXXXXXXXW X O O p T*R [H ÿ = L < L L > L >= L <> L [ [ ( " ²JBÑÑ ÿ Ñ"quantified" âdicate. ;&ed, we íoits b. : % [ : & ²JBÑ ÿ Logical Çof Ôs: / : / & T*R [H ÿ NOT ` i q / i 4 : ²JBÑÑ ÿ ` ~FALSE. to FALSE if }Éif ` ~TRUE. 4 i 4 & T*R [H ÿ `1 AND `2 P P 4 P 4 : ²JBÑÑ ÿ both `1 } `2 3 P 3 & T*R [H ÿ `1 OR `2 3 4 : ÂJBÑÑ ÿ to `1 or `2 ~TRUE or both to
even if ÇÕ~UNKNOWN. 7 7 ! j $ & Contents of +catalogs' 7 ' " T* ÿ ¼ _ ' ¼ * & ¾JBÑ ÿ +catalog is Îosed of four 0: ä, æ, é}ê. All 8se 1«to 9br 1by 9Ó0. Unless Ñlcated, ³¹9ä, æ, é}ë0. [ ^ ¼ [ 4 : ¾JRB°±S~±á& ÿ >S -ásgqÅof q1in 9ò. õ W [ õ P r ÂJRB±S~±á' á( á) ÿ INDICES -ásgqlces in 9ò. When ¯5ÇÃis gin an j, 8re ~a ïAÃf. S -ásgq1in 9ò. USERS -ásgqbrs known to 9ò. 5 õ 5 ! ç % ' Contents of 9>S ,+ ! 5 + " T* ÿ : ä J + J & ²JBÑ ÿ -ásgqÅof q1in 9ò. > A J A + ( ²JRB°ÑS~Ñ ÿ T Type/Description ð x A ü Î n ÂJRBÑS~ Ñí 'Ea}·Õñ
+Ge á ÿ SEQUENCE_NUMBER Ü ·. LENGTH Ü ±of ½"s or 9âcision of ½j. SCALE Ü Indicates 9scale of ½j. DATA_TYPE , ¯ ïN . NOT_NULL <5) ¹½ks TRUE o½is ¹r $ , Indicat ^ `^ u] es 9br µof 9owner of 9.
, ³. >_NAME , ³Â. Ô * & 9 ü 9 ! & ( Contents of 9INDICES ,+ 9 + # T* ÿ æ µ S + µ ' ²JBÑ ÿ -ásgqlces in 9ò. When ¯5ÇÃis gin an j, 8re ~a ïAÃf. > ¥of lces æd to enforce [Øs Wa '~' as ;first ¼. 3 µ 3 + ( ²JRB°ÑS~Ñ ÿ T * i 3 * º F ²JRBÑS~ Ñí 'Ea}·Õñ
+Ge à+ ÿ $ , Indicates 9br µof 9owner of 9-_9kis Ü
, ³-_9kis Ü ¤ , ³j. SEGMENT_NUMBER Ü ·k. ¾SEGMENTS Ü ´cluded in 9k . nENDING <5) ¹9kis marked as or +owhile oo <5) ¹ks TRUE oqk³be , ÇG~. FALSE okr CREATOR_NAME , Indicates 9br µof 9creator of 9j. © * © f ÂJRBÑS~ Ñí 'Ea}·Õñ
+Ge à+ ÿ >_NAME , ³Ãmakes up Gsegment of 9k . Ô * & 5 © 5 ! p ' ) Contents of 9S ,+ 5 + # T* ÿ è ñ + ' ²JBÑ ÿ -ásgq1in 9ò. > of temporary 1eduring 94on of a query Wa '~' as ;first ¼. 3 3 + ( ²JRB°ÑS~Ñ ÿ T T 3 T ö ÂJRBÑS~ Ñí 'Ea}·Õñ
+Ge ÿ _ID Ü Used {to _9MSDOS files ein 9. ¾COLUMNS Ü µ9. ISAM_CONTROL_BLOCK BINARY Used {to save 9ISAM åblock A9. $ ³br who owns 9.
, ³. Ô * & 7 T 7 !
( ÿÿ Contents of 9USERS ,+ 7 + # T* ÿ ê ± + ¿ ' ²JBÑ ÿ -ásgqbrs known to 9ò. You §¡br hss by ¬ing 9ë/ Use Caution: úing qbr ñÖly lock out of 9ò. Do ¹ý9br XXMg h ëf 3 ¿ 3 + ( ²JRB°ÑS~Ñ ÿ T ¹ 3 ¹ n ® ÂJRBÑS~ Ñí 'Ea}·Õñ
+Ge ÿ $ , ¯a br ´. USER_PASSWORD , ¯a br password. Ô * & ! ¹ ! ! ÿÿÿÿÿÿÿÿ+ ! + & ²JBÑ ÿ ì T R + T & ÂJBÑ ÿ íis 9br who logged }9óto 39query. ! T ! ! ÿÿÿÿÿÿÿÿ+ ! + & ²JBÑ ÿ T W + T & ÂJBÑ ÿ A is 9set of Åa -eto Ûan kon 7. ! T ! ! Ü ÿÿÿÿÿÿÿÿ- ! - & ²JBÑ ÿ h Õ - & ÂJBÑ ÿ ómæs a iby Òing 9kof qÅdefined in an j. ÅÒed in 9Ïin 8y were w9kuæd. ! ! ! é ÿÿÿÿÿÿÿÿ+ ! + & ²JBÑ ÿ ü Ó + , * ÂJBÑ ÿ All ÙåOa -ß9chosen ð. is called 9 ü Its âs ¡to Çat a Ithrough Çof 9ÓáAPI fetch þ. ! ! ! ü ÿÿÿÿÿÿÿÿ-
! - & ²JBÑ ÿ ¤ ® â - ® & ÂJBÑ ÿ A ¥7s at 9|/or bottom edge of a whose âs n't Îletely r. ¥átwo arrows }a box, pow to 9or box. ! ® ! ! ï ÿÿÿÿÿÿÿÿ- ! - & ²JBÑ ÿ M ¡ Í - ¡ & ÂJBÑ ÿ A M~a pair of files ('or_log.dat' }'or_log.idx') written by 9ó r. Máa ïof every event ¸d a »to 9ò. ! ¡ ! ! ! ÿÿÿÿÿÿÿÿ! ! ! ! ÿÿÿÿÿÿÿÿÑ È Ô ¹ Y ï
Ø O " Û$ Ñ+ . Ò: \? Ý@ mB ZE òF ¤H ïK O [ u] \` {d ëf øh i 8j k ýk ùl èm n A Helv ßgßgqßgÿ`ßgpica ßg¯ßg
!ßgûßgCourier *:ßgv&ßgßgelite ßgñßgØZßgíUßgprestige Ußg%.ßg§¼ßglettergothic ßgr}ßggothicPS ßgÖbßg&ßgcubicPS ßg)ßg»Éßglineprinter dßgéqßgHelvetica ßgnßgFßgavantegarde ,ßg»Ïßgspartan ÏßgÉ.ßg}ßgmetro ßgßg ßg\ßgpresentation àßgS?ßgAPL ¦ßgbHßg<¥ßg EßgOCRA ßgPßgÂßgßWßgOCRB ´ßgòRßgo&ßg CßgboldPS g&ßgú¹ßg¢ßgemperorPS ßgtÙßg¤Ýßgmadaleine ßgu9ßg~?ßgzapf humanist emperoclassic X maroman f roman g umanist roman h assic timesroman oman f century X roman palatino X rosouvenir garamond man caledonia ury bodini X palatino university X souvenscript X gascriptPS script c ia script d ini commercial script typark avenue Z scriptcoronet ! Z scscript h " greek pt c kana script d hebrew Z commercialroman s % Z park arussian & Z coroman u ' roman v h roman w eek narrator kana emphasis * X hebrewzapf chancery + X rodecor d , old english decor f man u decor g X roman v cooper black roman Symbol 0 E nalinedraw 1 math7 asis math8 one column isbar3of9 d in an indeEAN here is a separapcline rd for each ctech h ncluded. C ÿ ÿ ÿ ÿ ÿ © ï
ï
ï
Ô Ô Ô ¹ Y Y Y ï
Ø O " Û$ Ñ+ . Ò: Y Ñ+ Y Ñ+ ï
. ï
Ø ï
ï
. ï
Ø Ø Ø Ø Ø " " O O . Ò: " " Û$ Û$ Û$ Ñ+ Ñ+ . . . . . Ò: . . . Ò: Ò: \? Ý@ mB ZE Ý@ Ý@ Ý@ mB mB mB mB mB mB ZE ZE ZE òF òF òF òF òF ¤H ¤H ¤H ¤H ¤H ¤H ïK O [ u] [ \` [ [ [ {d [ ëf / & ;) i24 ÿÿ ÿÿ F F ÿÿÿÿ* P + H - L / T ALL Ø ASC h AVG \ Built-in functions X CHAR 8 CHARACTER < COLUMNS x COMMIT ( COMMIT WORK , conventions Correlation Name Ü COUNT ` CREATE p CREATE INDEX x CREATE TABLE Data types DEC DECIMAL $ DELETE ¤ DESC | DISTINCT à DOUBLE PRECISION DROP ¸ DROP INDEX ´ DROP TABLE À expressions p FLOAT FROM ä GROUP BY ð HAVING ô Index INDICES INSERT Ä INT ( INTEGER , INTO È MAX d MIN h NOT NULL notation NUMERIC 0 Operators D ORDER BY ø overview REAL ROLLBACK Ð ROLLBACK WORK Ô search conditions t SearchCondition ¨ SET ü SMALLINT 4 Statement
0 Statements $ SUM l SYSTEM System catalog TABLE TABLES Transaction X UNIQUE UPDATE USERS VALUES Ì VARCHAR @ WHERE è WORK ` Y[^éìý QNáÀùÀtmNá8ùt
ùtá0ù0uTöÇÀt ç?6 ;6 uèGýÆ 6 ÙöÛ<NQá ÁNèÁ è^ Yá8ùtùt.ñÉÁNè ë;Ná8ù(t
á8ù tè è$ ë Ì@ÛâÙÉØÑÙÉÝØÝ>
Y$ýé-ýÛ~N÷Áÿt!öFußnÛ~~ t é>@NÛnÃ3ÉNNNNNëèPF%Àô=À Xsè éÕüöÄ@u\Ì@ WVQSÛâ×> t>V NÙåÍØãÀóÀt á8ÉÅv
é~~~ÆFNÆFËÿ^[Y^_ Ý>
à S³öÄu8³öÄu1³¨u+³öÄu$³¨u ³¨u³¨u³ ¨u ³¨ u³¨@u . 0¹¡ u´LÍ![ÿ XÏ£ %<ÿ> t£ Ù. £
á Ã3À: t Ý> $? %ÿ £ Ã% > t Ù>
åó Á£ Ù. ÙüÙ.
Ã
Qåó
å& Uèê]
èg Ã% > t)Ù>
åó Á£ Ù. Û Ù.
¡ Ã
Qåó
å& Uèd]ÂÓè 6 ;6 uèæúî 6
à öÑ. ÍÂå?
ÍöÑ. ÷ÁÿßtÙéþûPU VìÅv ÀNNvÐèÐèÐèöÐ$ &Ä°S» ë ûP¸ ëûP¸ U VìÅvNNv)S3ÛTX;Äu(@%û0=Ù0u@<ðr@%ÿþ=Ûât @=ßàtÆ[^ ]XÏÆBÆpÆäÆÆDÆrÆäÆÆ4ÆbÆäÆÆ2Æ`ÆäÆÆJÆxÆäÆ ÆHÆvÆäÆÆ$ÆRÆäÆ ÆFÆtÆäÆfÉLÉ#Ù ÙFÉ@ÉTÉ^ÉVÈ9É`ÈjÈ9ÉÈ9ÉÈÈÉ/É É«ÈóÈÿÈ ÉÙÏåÔÂÑ0ÔÐ;ÕðÒÔÀØz×9ÉÕÉØzØÐØ÷Õ"Ú ÚÚÚÚÚ Ú9ÉsÞÞ¹ÝåÝ9É9É9/ & ;) Lz C |TOMAP |FON ÿÿ ' ÿÿÿÿ SQL syntax help index Ô General information and notation conventions ¹ SQL statements defined Y Committing work ï
Creating an index Ø Creating a table O Deleting records Dropping an index " Dropping a table Û$ Inserting records Ñ+ Rolling work back . Selecting data Ò: Modifying records \? SQL data types defined Ý@ Approximate Numeric Data Types mB Exact Numeric Data Types ZE Character String Data Types òF SQL operators defined ¤H Built-in functions defined ïK SQL expressions defined O SQL search conditions defined [ Contents of system catalogs u] Contents of the COLUMNS table \` Contents of the INDICES table {d Contents of the TABLES table ëf Contents of the USERS table hen the transaction is committed or rolled back. In order t
Built-in
CHAR
CHARACTER(
COLUMN
COMMIT WORK
COUNT(
CREATE
CREATE TABLE
Catalog
Changes made to the database are not made permanent until
Character
Character data, length assumed to be 1.
Character data, length specified by n where 1 <= n <= 2047.
Character data, variable length where maximum length is
Column
ColumnName
ColumnName1 DataType1
ColumnName
ColumnSpecification
Comments
Condition
CorrelationName
Creates
CreatorName
DEC
DELETE
DELETE FROM
DESC
DESC]]
DISTINCT
DROP
DROP INDEX
DROP TABLE
Data Types
Data type
DataType
Database
Deletes
Description
Each
Evaluates
Evaluates to TRUE if and only if
Expression
Expression1
Expression2
Expression
FALSE.
FROM
Floating point
Floating point number with magnitude ranging from approximately 1.7976931348623158e+308 to 2.2250738585072014e-308.
For each record selected,
GROUP BY
IN (Subquery)
INDEX
INDEX_NAME
INSERT
INSERT INTO
INT
IndexName
Indicates
Indicates the name of the
Indicates the number of columns in
Indicates the position of the column within the
Indicates the
Indicates whether
Inst
NULL
NUMBER_OF_
NUMERIC
Numeric
ORDER
Only
Operators
Overview
Pattern
Phrase
Please refer to a text book for a description of the
Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!
This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.
But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/