PageRenderTime 48ms CodeModel.GetById 19ms RepoModel.GetById 0ms app.codeStats 0ms

/eclipse-dtp-1.10/org.eclipse.datatools.sqltools-DTP_1_10_0_Release_201206131012/plugins/org.eclipse.datatools.sqltools.sqlbuilder/src/org/eclipse/datatools/sqltools/sqlbuilder/expressionbuilder/MSSQLServerFunctionNamesAndSignatures.java

#
Java | 1302 lines | 1244 code | 47 blank | 11 comment | 291 complexity | 7bfba630c08d7689c90757c048cbd562 MD5 | raw file
    

  1. /*******************************************************************************
    2. 

  2.  * Copyright Š 2000, 2007 IBM Corporation and others.
    3. 

  3.  * All rights reserved. This program and the accompanying materials
    4. 

  4.  * are made available under the terms of the Eclipse Public License v1.0
    5. 

  5.  * which is available at
    6. 

  6.  * http://www.eclipse.org/legal/epl-v10.html
    7. 

  7.  * 
    8. 

  8.  * Contributors:
    9. 

  9.  *     IBM Corporation - initial API and implementation
    10. 

  10.  *******************************************************************************/
    11. 

  11. package org.eclipse.datatools.sqltools.sqlbuilder.expressionbuilder;
    12. 

  12. 

  13. import java.util.Arrays;
    14. 

  14. import java.util.List;
    15. 

  15. 

  16. import org.eclipse.datatools.sqltools.sqlbuilder.Messages;
    17. 

  17. import org.eclipse.datatools.sqltools.sqlbuilder.model.SQLDomainModel;
    18. 

  18. import org.eclipse.swt.widgets.Combo;
    19. 

  19. 

  20. 

  21. public class MSSQLServerFunctionNamesAndSignatures
    22. 

  22. {
    23. 

  23. 

  24.   public static final String msSQLServerAll = Messages._UI_FCN_ALL;
    25. 

  25.   public static final String msSQLServerAggregate = Messages._UI_FCN_AGGREGATE;
    26. 

  26.   public static final String msSQLServerConfiguration = "Configuration";
    27. 

  27.   public static final String msSQLServerCursor = "Cursor";
    28. 

  28.   public static final String msSQLServerDateAndTime = Messages._UI_FCN_DATE_TIME;
    29. 

  29.   public static final String msSQLServerMath = Messages._UI_FCN_MATH;
    30. 

  30.   public static final String msSQLServerMetadata = "Metadata";
    31. 

  31.   public static final String msSQLServerSecurity = "Security";
    32. 

  32.   public static final String msSQLServerString = Messages._UI_FCN_STRING;
    33. 

  33.   public static final String msSQLServerSystem = Messages._UI_FCN_SYSTEM;
    34. 

  34.   public static final String msSQLServerSystemStatistical = "System Statistical";
    35. 

  35.   public static final String msSQLServerTextAndImage = "Text and Image";
    36. 

  36.   public static final String msSQLServerRowset = "Rowset";
    37. 

  37.   public static final String msSQLServerNotSupported = Messages._UI_FCN_NOT_SUPPORTED;
    38. 

  38.   public static String dbUDF = Messages._UI_FCN_UDF;
    39. 

  39. 

  40.   private static final String allFunctions[] =
    41. 

  41.   {
    42. 

  42.     "ABS",
    43. 

  43.     "ACOS",
    44. 

  44.     "APP_NAME",
    45. 

  45.     "ASCII",
    46. 

  46.     "ASIN",
    47. 

  47.     "ATAN",
    48. 

  48.     "ATN2",
    49. 

  49.     "AVG",
    50. 

  50.     "CEILING",
    51. 

  51.     "CHAR",
    52. 

  52.     "CHARINDEX",
    53. 

  53.     "COALESCE",
    54. 

  54.     "COLUMNPROPERTY",
    55. 

  55.     "COL_LENGTH",
    56. 

  56.     "COL_NAME",
    57. 

  57.     "CONTAINSTABLE",
    58. 

  58.     "CONVERT",
    59. 

  59.     "COS",
    60. 

  60.     "COT",
    61. 

  61.     "COUNT",
    62. 

  62.     "CURRENT_TIMESTAMP", // no brackets
    63. 

  63.     "CURRENT_USER", // no brackets
    64. 

  64.     "CURSOR_STATUS",
    65. 

  65.     "DATABASEPROPERTY",
    66. 

  66.     "DATALENGTH",
    67. 

  67.     "DATEADD",
    68. 

  68.     "DATEDIFF",
    69. 

  69.     "DATENAME",
    70. 

  70.     "DATEPART",
    71. 

  71.     "DAY",
    72. 

  72.     "DB_ID",
    73. 

  73.     "DB_NAME",
    74. 

  74.     "DEGREES",
    75. 

  75.     "DIFFERENCE",
    76. 

  76.     "EXP",
    77. 

  77.     "FILEGROUPPROPERTY",
    78. 

  78.     "FILEGROUP_ID",
    79. 

  79.     "FILEGROUP_NAME",
    80. 

  80.     "FILEPROPERTY",
    81. 

  81.     "FILE_ID",
    82. 

  82.     "FILE_NAME",
    83. 

  83.     "FLOOR",
    84. 

  84.     "FORMATMESSAGE",
    85. 

  85.     "FREETEXTTABLE",
    86. 

  86.     "FULLTEXTCATALOGPROPERTY",
    87. 

  87.     "FULLTEXTSERVICEPROPERTY",
    88. 

  88.     "GETANSINULL",
    89. 

  89.     "GETDATE",
    90. 

  90.     "GROUPING",
    91. 

  91.     "HOST_ID",
    92. 

  92.     "HOST_NAME",
    93. 

  93.     "IDENTITY",
    94. 

  94.     "IDENT_INCR",
    95. 

  95.     "IDENT_SEED",
    96. 

  96.     "INDEXPROPERTY",
    97. 

  97.     "INDEX_COL",
    98. 

  98.     "ISDATE",
    99. 

  99.     "ISNULL",
    100. 

  100.     "ISNUMERIC",
    101. 

  101.     "IS_MEMBER",
    102. 

  102.     "IS_SRVROLEMEMBER",
    103. 

  103.     "LEFT",
    104. 

  104.     "LEN",
    105. 

  105.     "LOG10",
    106. 

  106.     "LOG",
    107. 

  107.     "LOWER",
    108. 

  108.     "LTRIM",
    109. 

  109.     "MAX",
    110. 

  110.     "MIN",
    111. 

  111.     "MONTH",
    112. 

  112.     "NCHAR",
    113. 

  113.     "NEWID",
    114. 

  114.     "NULLIF",
    115. 

  115.     "OBJECTPROPERTY",
    116. 

  116.     "OBJECT_ID",
    117. 

  117.     "OBJECT_NAME",
    118. 

  118.     "OPENQUERY",
    119. 

  119.     "OPENROWSET",
    120. 

  120.     "PARSENAME",
    121. 

  121.     "PATINDEX",
    122. 

  122.     "PATINDEX",
    123. 

  123.     "PERMISSIONS",
    124. 

  124.     "PI",
    125. 

  125.     "POWER",
    126. 

  126.     "QUOTENAME",
    127. 

  127.     "RADIANS",
    128. 

  128.     "RAND",
    129. 

  129.     "REPLACE",
    130. 

  130.     "REPLICATE",
    131. 

  131.     "REVERSE",
    132. 

  132.     "RIGHT",
    133. 

  133.     "ROUND",
    134. 

  134.     "RTRIM",
    135. 

  135.     "SESSION_USER",  // no brackets
    136. 

  136.     "SIGN",
    137. 

  137.     "SIN",
    138. 

  138.     "SOUNDEX",
    139. 

  139.     "SPACE",
    140. 

  140.     "SQRT",
    141. 

  141.     "SQUARE",
    142. 

  142.     "STATS_DATE",
    143. 

  143.     "STDEVP",
    144. 

  144.     "STDEV",
    145. 

  145.     "STR",
    146. 

  146.     "STUFF",
    147. 

  147.     "SUBSTRING",
    148. 

  148.     "SUM",
    149. 

  149.     "SUSER_ID",
    150. 

  150.     "SUSER_NAME",
    151. 

  151.     "SUSER_SID",
    152. 

  152.     "SUSER_SNAME",
    153. 

  153.     "SYSTEM_USER",  // no brackets
    154. 

  154.     "TAN",
    155. 

  155.     "TEXTPTR",
    156. 

  156.     "TEXTVALID",
    157. 

  157.     "TYPEPROPERTY",
    158. 

  158.     "UNICODE",
    159. 

  159.     "UPPER",
    160. 

  160.     "USER", // no brackets
    161. 

  161.     "USER_ID",
    162. 

  162.     "USER_NAME",
    163. 

  163.     "VARP",
    164. 

  164.     "VAR",
    165. 

  165.     "YEAR",
    166. 

  166.     "@@CONNECTIONS", // no brackets
    167. 

  167.     "@@CPU_BUSY",
    168. 

  168.     "@@CURSOR_ROWS",
    169. 

  169.     "@@DATEFIRST",
    170. 

  170.     "@@DBTS",
    171. 

  171.     "@@ERROR",
    172. 

  172.     "@@FETCH_STATUS",
    173. 

  173.     "@@IDENTITY",
    174. 

  174.     "@@IDLE",
    175. 

  175.     "@@IO_BUSY",
    176. 

  176.     "@@LANGID",
    177. 

  177.     "@@LANGUAGE",
    178. 

  178.     "@@LOCK_TIMEOUT",
    179. 

  179.     "@@MAX_CONNECTIONS",
    180. 

  180.     "@@MAX_PRECISION",
    181. 

  181.     "@@NESTLEVEL",
    182. 

  182.     "@@OPTIONS",
    183. 

  183.     "@@PACKET_ERRORS",
    184. 

  184.     "@@PACK_RECEIVED",
    185. 

  185.     "@@PACK_SENT",
    186. 

  186.     "@@PROCID",
    187. 

  187.     "@@REMSERVER",
    188. 

  188.     "@@ROWCOUNT",
    189. 

  189.     "@@SERVERNAME",
    190. 

  190.     "@@SERVICENAME",
    191. 

  191.     "@@SPID",
    192. 

  192.     "@@TEXTSIZE",
    193. 

  193.     "@@TIMETICKS",
    194. 

  194.     "@@TOTAL_ERRORS",
    195. 

  195.     "@@TOTAL_READ",
    196. 

  196.     "@@TOTAL_WRITE",
    197. 

  197.     "@@TRANCOUNT",
    198. 

  198.     "@@VERSION"
    199. 

  199.   };
    200. 

  200. 

  201.   private static final String allColumnSupportedFunctions[] = allFunctions;
    202. 

  202. 

  203.   private static final String functionsSupportingStar[] =
    204. 

  204.   {
    205. 

  205.     "COUNT"
    206. 

  206.   };
    207. 

  207. 

  208.   private static final String unsupportedFunctions[] =
    209. 

  209.   {
    210. 

  210.     "COALESCE",
    211. 

  211.     "CONTAINSTABLE",
    212. 

  212.     "CONVERT",
    213. 

  213.     "CURSOR_STATUS",
    214. 

  214.     "FORMATMESSAGE",
    215. 

  215.     "FREETEXTTABLE",
    216. 

  216.     "IDENTITY",
    217. 

  217.     "OPENROWSET"
    218. 

  218.   };
    219. 

  219. 

  220.   private static final String noBracketFunctions[] =
    221. 

  221.   {
    222. 

  222.     "CURRENT_TIMESTAMP",
    223. 

  223.     "CURRENT_USER",
    224. 

  224.     "SESSION_USER",
    225. 

  225.     "SYSTEM_USER",
    226. 

  226.     "USER",
    227. 

  227.     "@@CONNECTIONS",
    228. 

  228.     "@@CPU_BUSY",
    229. 

  229.     "@@CURSOR_ROWS",
    230. 

  230.     "@@DATEFIRST",
    231. 

  231.     "@@DBTS",
    232. 

  232.     "@@ERROR",
    233. 

  233.     "@@FETCH_STATUS",
    234. 

  234.     "@@IDENTITY",
    235. 

  235.     "@@IDLE",
    236. 

  236.     "@@IO_BUSY",
    237. 

  237.     "@@LANGID",
    238. 

  238.     "@@LANGUAGE",
    239. 

  239.     "@@LOCK_TIMEOUT",
    240. 

  240.     "@@MAX_CONNECTIONS",
    241. 

  241.     "@@MAX_PRECISION",
    242. 

  242.     "@@NESTLEVEL",
    243. 

  243.     "@@OPTIONS",
    244. 

  244.     "@@PACKET_ERRORS",
    245. 

  245.     "@@PACK_RECEIVED",
    246. 

  246.     "@@PACK_SENT",
    247. 

  247.     "@@PROCID",
    248. 

  248.     "@@REMSERVER",
    249. 

  249.     "@@ROWCOUNT",
    250. 

  250.     "@@SERVERNAME",
    251. 

  251.     "@@SERVICENAME",
    252. 

  252.     "@@SPID",
    253. 

  253.     "@@TEXTSIZE",
    254. 

  254.     "@@TIMETICKS",
    255. 

  255.     "@@TOTAL_ERRORS",
    256. 

  256.     "@@TOTAL_READ",
    257. 

  257.     "@@TOTAL_WRITE",
    258. 

  258.     "@@TRANCOUNT",
    259. 

  259.     "@@VERSION"
    260. 

  260.   };
    261. 

  261. 

  262.   private static final String aggregateFunctions[] =
    263. 

  263.   {
    264. 

  264.     "AVG",
    265. 

  265.     "COUNT",
    266. 

  266.     "GROUPING",
    267. 

  267.     "MAX",
    268. 

  268.     "MIN",
    269. 

  269.     "SUM",
    270. 

  270.     "STDEV",
    271. 

  271.     "STDEVP",
    272. 

  272.     "VAR",
    273. 

  273.     "VARP"
    274. 

  274.   };
    275. 

  275. 

  276.   private static final String configurationFunctions[] =
    277. 

  277.   {
    278. 

  278.     "@@CONNECTIONS",
    279. 

  279.     "@@DATEFIRST",
    280. 

  280.     "@@DBTS",
    281. 

  281.     "@@LANGID",
    282. 

  282.     "@@LANGUAGE",
    283. 

  283.     "@@LOCK_TIMEOUT",
    284. 

  284.     "@@MAX_CONNECTIONS",
    285. 

  285.     "@@MAX_PRECISION",
    286. 

  286.     "@@NESTLEVEL",
    287. 

  287.     "@@OPTIONS",
    288. 

  288.     "@@REMSERVER",
    289. 

  289.     "@@SERVERNAME",
    290. 

  290.     "@@SERVICENAME",
    291. 

  291.     "@@SPID",
    292. 

  292.     "@@TEXTSIZE",
    293. 

  293.     "@@VERSION"
    294. 

  294.   };
    295. 

  295. 

  296.   private static final String cursorFunctions[] =
    297. 

  297.   {
    298. 

  298.     "CURSOR_STATUS",
    299. 

  299.     "@@CURSOR_ROWS",
    300. 

  300.     "@@FETCH_STATUS"
    301. 

  301.   };
    302. 

  302. 

  303.   private static final String dateAndTimeFunctions[] =
    304. 

  304.   {
    305. 

  305.     "DATEADD",
    306. 

  306.     "DATEDIFF",
    307. 

  307.     "DATENAME",
    308. 

  308.     "DATEPART",
    309. 

  309.     "DAY",
    310. 

  310.     "GETDATE",
    311. 

  311.     "MONTH",
    312. 

  312.     "YEAR"
    313. 

  313.   };
    314. 

  314. 

  315.   private static final String mathFunctions[] =
    316. 

  316.   {
    317. 

  317.     "ABS",
    318. 

  318.     "ACOS",
    319. 

  319.     "ASIN",
    320. 

  320.     "ATAN",
    321. 

  321.     "ATN2",
    322. 

  322.     "CEILING",
    323. 

  323.     "COS",
    324. 

  324.     "COT",
    325. 

  325.     "DEGREES",
    326. 

  326.     "EXP",
    327. 

  327.     "FLOOR",
    328. 

  328.     "LOG",
    329. 

  329.     "LOG10",
    330. 

  330.     "PI",
    331. 

  331.     "POWER",
    332. 

  332.     "RADIANS",
    333. 

  333.     "RAND",
    334. 

  334.     "ROUND",
    335. 

  335.     "SIGN",
    336. 

  336.     "SIN",
    337. 

  337.     "SQUARE",
    338. 

  338.     "SQRT",
    339. 

  339.     "TAN"
    340. 

  340.   };
    341. 

  341. 

  342.   private static final String metadataFunctions[] =
    343. 

  343.   {
    344. 

  344.     "COL_LENGTH",
    345. 

  345.     "COL_NAME",
    346. 

  346.     "COLUMNPROPERTY",
    347. 

  347.     "DATABASEPROPERTY",
    348. 

  348.     "DB_ID",
    349. 

  349.     "DB_NAME",
    350. 

  350.     "FILEGROUPPROPERTY",
    351. 

  351.     "FILEGROUP_ID",
    352. 

  352.     "FILEGROUP_NAME",
    353. 

  353.     "FILEPROPERTY",
    354. 

  354.     "FILE_ID",
    355. 

  355.     "FILE_NAME",
    356. 

  356.     "FULLTEXTCATALOGPROPERTY",
    357. 

  357.     "FULLTEXTSERVICEPROPERTY",
    358. 

  358.     "INDEXPROPERTY",
    359. 

  359.     "INDEX_COL",
    360. 

  360.     "OBJECTPROPERTY",
    361. 

  361.     "OBJECT_ID",
    362. 

  362.     "OBJECT_NAME",
    363. 

  363.     "TYPEPROPERTY",
    364. 

  364.     "@@PROCID"
    365. 

  365.   };
    366. 

  366. 

  367.   private static final String securityFunctions[] =
    368. 

  368.   {
    369. 

  369.     "IS_MEMBER",
    370. 

  370.     "IS_SRVROLEMEMBER",
    371. 

  371.     "SUSER_ID",
    372. 

  372.     "SUSER_NAME",
    373. 

  373.     "SUSER_SID",
    374. 

  374.     "SUSER_SNAME",
    375. 

  375.     "USER_ID",
    376. 

  376.     "USER"  // no brackets
    377. 

  377.   };
    378. 

  378. 

  379.   private static final String stringFunctions[] =
    380. 

  380.   {
    381. 

  381.     "ASCII",
    382. 

  382.     "CHAR",
    383. 

  383.     "CHARINDEX",
    384. 

  384.     "DIFFERENCE",
    385. 

  385.     "LEFT",
    386. 

  386.     "LEN",
    387. 

  387.     "LOWER",
    388. 

  388.     "LTRIM",
    389. 

  389.     "NCHAR",
    390. 

  390.     "PATINDEX",
    391. 

  391.     "QUOTENAME",
    392. 

  392.     "REPLACE",
    393. 

  393.     "REPLICATE",
    394. 

  394.     "REVERSE",
    395. 

  395.     "RIGHT",
    396. 

  396.     "RTRIM",
    397. 

  397.     "SOUNDEX",
    398. 

  398.     "SPACE",
    399. 

  399.     "STR",
    400. 

  400.     "STUFF",
    401. 

  401.     "SUBSTRING",
    402. 

  402.     "UNICODE",
    403. 

  403.     "UPPER"
    404. 

  404.   };
    405. 

  405. 

  406.   private static final String systemFunctions[] =
    407. 

  407.   {
    408. 

  408.     "APP_NAME",
    409. 

  409.     "CONVERT",
    410. 

  410.     "COALESCE",
    411. 

  411.     "CURRENT_TIMESTAMP", // no brackets
    412. 

  412.     "CURRENT_USER", // no brackets
    413. 

  413.     "DATALENGTH",
    414. 

  414.     "FORMATMESSAGE",
    415. 

  415.     "GETANSINULL",
    416. 

  416.     "HOST_ID",
    417. 

  417.     "HOST_NAME",
    418. 

  418.     "IDENT_INCR",
    419. 

  419.     "IDENT_SEED",
    420. 

  420.     "IDENTITY",
    421. 

  421.     "ISDATE",
    422. 

  422.     "ISNULL",
    423. 

  423.     "ISNUMERIC",
    424. 

  424.     "NEWID",
    425. 

  425.     "NULLIF",
    426. 

  426.     "PARSENAME",
    427. 

  427.     "PERMISSIONS",
    428. 

  428.     "SESSION_USER",  // no brackets
    429. 

  429.     "STATS_DATE",
    430. 

  430.     "SYSTEM_USER",  // no brackets
    431. 

  431.     "USER_NAME",
    432. 

  432.     "@@ERROR",
    433. 

  433.     "@@IDENTITY",
    434. 

  434.     "@@ROWCOUNT",
    435. 

  435.     "@@TRANCOUNT"
    436. 

  436.   };
    437. 

  437. 

  438.   private static final String systemStatisticalFunctions[] =
    439. 

  439.   {
    440. 

  440.     "@@CPU_BUSY",
    441. 

  441.     "@@IDLE",
    442. 

  442.     "@@IO_BUSY",
    443. 

  443.     "@@PACKET_ERRORS",
    444. 

  444.     "@@PACK_RECEIVED",
    445. 

  445.     "@@PACK_SENT",
    446. 

  446.     "@@TIMETICKS",
    447. 

  447.     "@@TOTAL_ERRORS",
    448. 

  448.     "@@TOTAL_READ",
    449. 

  449.     "@@TOTAL_WRITE"
    450. 

  450.   };
    451. 

  451. 

  452.   private static final String textAndImageFunctions[] =
    453. 

  453.   {
    454. 

  454.     "PATINDEX",
    455. 

  455.     "TEXTPTR",
    456. 

  456.     "TEXTVALID"
    457. 

  457.   };
    458. 

  458. 

  459.   private static final String rowsetFunctions[] =
    460. 

  460.   {
    461. 

  461.     "CONTAINSTABLE",
    462. 

  462.     "FREETEXTTABLE",
    463. 

  463.     "OPENQUERY",
    464. 

  464.     "OPENROWSET"
    465. 

  465.   };
    466. 

  466. 

  467. 

  468.   public static Object[][] getParms(String func)
    469. 

  469.   {
    470. 

  470.     Object[][] list = new Object[1][2];
    471. 

  471.     list[0][0] = "???"; list[0][1] = "???";
    472. 

  472. 

  473.     if (func.equals("ABS"))
    474. 

  474.     {
    475. 

  475.       list[0][0] = "numeric_expression"; list[0][1] = "numeric_expression";
    476. 

  476.     }
    477. 

  477.     else if (func.equals("ACOS"))
    478. 

  478.     {
    479. 

  479.       list[0][0] = "float_expression"; list[0][1] = "float_expression";
    480. 

  480.     }
    481. 

  481.     else if (func.equals("APP_NAME"))
    482. 

  482.     {
    483. 

  483.       list = new Object[1][1];
    484. 

  484.       list[0][0] = "nvarchar";
    485. 

  485.     }
    486. 

  486.     else if (func.equals("ASCII"))
    487. 

  487.     {
    488. 

  488.       list[0][0] = "int"; list[0][1] = "character_expression";
    489. 

  489.     }
    490. 

  490.     else if (func.equals("ASIN"))
    491. 

  491.     {
    492. 

  492.       list[0][0] = "float_expression"; list[0][1] = "float_expression";
    493. 

  493.     }
    494. 

  494.     else if (func.equals("ATAN"))
    495. 

  495.     {
    496. 

  496.       list[0][0] = "float_expression"; list[0][1] = "float_expression";
    497. 

  497.     }
    498. 

  498.     else if (func.equals("ATN2"))
    499. 

  499.     {
    500. 

  500.       list = new Object[1][3];
    501. 

  501.       list[0][0] = "float_expression"; list[0][1] = "float_expression"; list[0][2] = "float_expression";
    502. 

  502.     }
    503. 

  503.     else if (func.equals("AVG")) // DISTINCT, ALL
    504. 

  504.     {
    505. 

  505.       list[0][0] = "numeric_expression"; list[0][1] = "expression";
    506. 

  506.     }
    507. 

  507.     else if (func.equals("CEILING"))
    508. 

  508.     {
    509. 

  509.       list[0][0] = "numeric_expression"; list[0][1] = "numeric_expression";
    510. 

  510.     }
    511. 

  511.     else if (func.equals("CHAR"))
    512. 

  512.     {
    513. 

  513.       list[0][0] = "char(1)"; list[0][1] = "integer";
    514. 

  514.     }
    515. 

  515.     else if (func.equals("CHARINDEX"))
    516. 

  516.     {
    517. 

  517.       list = new Object[2][];
    518. 

  518.       list[0] = new Object[3];
    519. 

  519.       list[1] = new Object[4];
    520. 

  520. 

  521.       list[0][0] = "int"; list[0][1] = "expression"; list[0][2] = "expression";
    522. 

  522.       list[1][0] = "int"; list[1][1] = "expression"; list[1][2] = "expression"; list[1][3] = "start_location";
    523. 

  523.     }
    524. 

  524.     else if (func.equals("COALESCE"))
    525. 

  525.     {
    526. 

  526.       list = new Object[1][1];
    527. 

  527.       list[0][0] = msSQLServerNotSupported;
    528. 

  528.     }
    529. 

  529.     else if (func.equals("COLUMNPROPERTY")) // property is fixed
    530. 

  530.     {
    531. 

  531.       list = new Object[1][4];
    532. 

  532.       list[0][0] = "property"; list[0][1] = "id"; list[0][2] = "column"; list[0][3] = "property";
    533. 

  533.     }
    534. 

  534.     else if (func.equals("COL_LENGTH"))
    535. 

  535.     {
    536. 

  536.       list = new Object[1][3];
    537. 

  537.       list[0][0] = "int"; list[0][1] = "'table'"; list[0][2] = "'column'";
    538. 

  538.     }
    539. 

  539.     else if (func.equals("COL_NAME"))
    540. 

  540.     {
    541. 

  541.       list = new Object[1][3];
    542. 

  542.       list[0][0] = "sysname"; list[0][1] = "table_id"; list[0][2] = "column_id";
    543. 

  543.     }
    544. 

  544.     else if (func.equals("CONTAINSTABLE"))
    545. 

  545.     {
    546. 

  546.       list = new Object[1][1];
    547. 

  547.       list[0][0] = msSQLServerNotSupported;
    548. 

  548.     }
    549. 

  549.     else if (func.equals("CONVERT"))
    550. 

  550.     {
    551. 

  551.       list = new Object[1][1];
    552. 

  552.       list[0][0] = msSQLServerNotSupported;
    553. 

  553.     }
    554. 

  554.     else if (func.equals("COS"))
    555. 

  555.     {
    556. 

  556.       list[0][0] = "float_expression"; list[0][1] = "float_expression";
    557. 

  557.     }
    558. 

  558.     else if (func.equals("COT"))
    559. 

  559.     {
    560. 

  560.       list[0][0] = "float_expression"; list[0][1] = "float_expression";
    561. 

  561.     }
    562. 

  562.     else if (func.equals("COUNT")) // DISTINCT, ALL
    563. 

  563.     {
    564. 

  564.       list[0][0] = "int"; list[0][1] = "expression";
    565. 

  565.     }
    566. 

  566.     else if (func.equals("CURRENT_TIMESTAMP")) // no brackets
    567. 

  567.     {
    568. 

  568.       list = new Object[1][1];
    569. 

  569.       list[0][0] = "datetime";
    570. 

  570.     }
    571. 

  571.     else if (func.equals("CURRENT_USER")) // no brackets
    572. 

  572.     {
    573. 

  573.       list = new Object[1][1];
    574. 

  574.       list[0][0] = "sysname";
    575. 

  575.     }
    576. 

  576.     else if (func.equals("CURSOR_STATUS"))
    577. 

  577.     {
    578. 

  578.       list = new Object[1][1];
    579. 

  579.       list[0][0] = msSQLServerNotSupported;
    580. 

  580.     }
    581. 

  581.     else if (func.equals("DATABASEPROPERTY")) // property is fixed
    582. 

  582.     {
    583. 

  583.       list = new Object[1][3];
    584. 

  584.       list[0][0] = "property"; list[0][1] = "database"; list[0][2] = "property";
    585. 

  585.     }
    586. 

  586.     else if (func.equals("DATALENGTH"))
    587. 

  587.     {
    588. 

  588.       list[0][0] = "int"; list[0][1] = "expression";
    589. 

  589.     }
    590. 

  590.     else if (func.equals("DATEADD")) // datepart is fixed
    591. 

  591.     {
    592. 

  592.       list = new Object[2][4];
    593. 

  593.       list[0][0] = "datetime"; list[0][1] = "datepart"; list[0][2] = "number"; list[0][3] = "datetime";
    594. 

  594.       list[1][0] = "smalldatetime"; list[1][1] = "datepart"; list[1][2] = "number"; list[1][3] = "smalldatetime";
    595. 

  595.     }
    596. 

  596.     else if (func.equals("DATEDIFF")) // datepart is fixed
    597. 

  597.     {
    598. 

  598.       list = new Object[1][4];
    599. 

  599.       list[0][0] = "integer"; list[0][1] = "datepart"; list[0][2] = "startdate"; list[0][3] = "enddate";
    600. 

  600.     }
    601. 

  601.     else if (func.equals("DATENAME")) // datepart is fixed
    602. 

  602.     {
    603. 

  603.       list = new Object[1][3];
    604. 

  604.       list[0][0] = "nvarchar"; list[0][1] = "datepart"; list[0][2] = "date";
    605. 

  605.     }
    606. 

  606.     else if (func.equals("DATEPART")) // datepart is fixed
    607. 

  607.     {
    608. 

  608.       list = new Object[1][3];
    609. 

  609.       list[0][0] = "int"; list[0][1] = "datepart"; list[0][2] = "date";
    610. 

  610.     }
    611. 

  611.     else if (func.equals("DAY"))
    612. 

  612.     {
    613. 

  613.       list[0][0] = "int"; list[0][1] = "date";
    614. 

  614.     }
    615. 

  615.     else if (func.equals("DB_ID"))
    616. 

  616.     {
    617. 

  617.       list = new Object[2][];
    618. 

  618.       list[0] = new Object[1];
    619. 

  619.       list[1] = new Object[2];
    620. 

  620. 

  621.       list[0][0] = "smallint";
    622. 

  622.       list[1][0] = "smallint"; list[1][1] = "'database_name'";
    623. 

  623.     }
    624. 

  624.     else if (func.equals("DB_NAME"))
    625. 

  625.     {
    626. 

  626.       list[0][0] = "nvarchar(128)"; list[0][1] = "database_id";
    627. 

  627.     }
    628. 

  628.     else if (func.equals("DEGREES"))
    629. 

  629.     {
    630. 

  630.       list[0][0] = "numeric_expression"; list[0][1] = "numeric_expression";
    631. 

  631.     }
    632. 

  632.     else if (func.equals("DIFFERENCE"))
    633. 

  633.     {
    634. 

  634.       list = new Object[1][3];
    635. 

  635.       list[0][0] = "int"; list[0][1] = "character_expression"; list[0][2] = "character_expression";
    636. 

  636.     }
    637. 

  637.     else if (func.equals("EXP"))
    638. 

  638.     {
    639. 

  639.       list[0][0] = "float_expression"; list[0][1] = "float_expression";
    640. 

  640.     }
    641. 

  641.     else if (func.equals("FILEGROUPPROPERTY")) // property is fixed
    642. 

  642.     {
    643. 

  643.       list = new Object[1][3];
    644. 

  644.       list[0][0] = "int"; list[0][1] = "filegroup_name"; list[0][2] = "property";
    645. 

  645.     }
    646. 

  646.     else if (func.equals("FILEGROUP_ID"))
    647. 

  647.     {
    648. 

  648.       list[0][0] = "smallint"; list[0][1] = "'filegroup_name'";
    649. 

  649.     }
    650. 

  650.     else if (func.equals("FILEGROUP_NAME"))
    651. 

  651.     {
    652. 

  652.       list[0][0] = "nvarchar(128)"; list[0][1] = "filegroup_id";
    653. 

  653.     }
    654. 

  654.     else if (func.equals("FILEPROPERTY"))  // property is fixed
    655. 

  655.     {
    656. 

  656.       list = new Object[1][3];
    657. 

  657.       list[0][0] = "int"; list[0][1] = "file_name"; list[0][2] = "property";
    658. 

  658.     }
    659. 

  659.     else if (func.equals("FILE_ID"))
    660. 

  660.     {
    661. 

  661.       list[0][0] = "smallint"; list[0][1] = "'file_name'";
    662. 

  662.     }
    663. 

  663.     else if (func.equals("FILE_NAME"))
    664. 

  664.     {
    665. 

  665.       list[0][0] = "nvarchar(128)"; list[0][1] = "file_id";
    666. 

  666.     }
    667. 

  667.     else if (func.equals("FLOOR"))
    668. 

  668.     {
    669. 

  669.       list[0][0] = "numeric_expression"; list[0][1] = "numeric_expression";
    670. 

  670.     }
    671. 

  671.     else if (func.equals("FORMATMESSAGE"))
    672. 

  672.     {
    673. 

  673.       list = new Object[1][1];
    674. 

  674.       list[0][0] = msSQLServerNotSupported;
    675. 

  675.     }
    676. 

  676.     else if (func.equals("FREETEXTTABLE"))
    677. 

  677.     {
    678. 

  678.       list = new Object[1][1];
    679. 

  679.       list[0][0] = msSQLServerNotSupported;
    680. 

  680.     }
    681. 

  681.     else if (func.equals("FULLTEXTCATALOGPROPERTY")) // property is fixed
    682. 

  682.     {
    683. 

  683.       list = new Object[1][3];
    684. 

  684.       list[0][0] = "int"; list[0][1] = "catalog_name"; list[0][2] = "property";
    685. 

  685.     }
    686. 

  686.     else if (func.equals("FULLTEXTSERVICEPROPERTY")) // property is fixed
    687. 

  687.     {
    688. 

  688.       list[0][0] = "int"; list[0][1] = "property";
    689. 

  689.     }
    690. 

  690.     else if (func.equals("GETANSINULL"))
    691. 

  691.     {
    692. 

  692.       list = new Object[2][];
    693. 

  693.       list[0] = new Object[1];
    694. 

  694.       list[1] = new Object[2];
    695. 

  695. 

  696.       list[0][0] = "int";
    697. 

  697.       list[1][0] = "int"; list[1][1] = "'database'";
    698. 

  698.     }
    699. 

  699.     else if (func.equals("GETDATE"))
    700. 

  700.     {
    701. 

  701.       list = new Object[1][1];
    702. 

  702.       list[0][0] = "datetime";
    703. 

  703.     }
    704. 

  704.     else if (func.equals("GROUPING"))
    705. 

  705.     {
    706. 

  706.       list[0][0] = "int"; list[0][1] = "column_name";
    707. 

  707.     }
    708. 

  708.     else if (func.equals("HOST_ID"))
    709. 

  709.     {
    710. 

  710.       list = new Object[1][1];
    711. 

  711.       list[0][0] = "char(8)";
    712. 

  712.     }
    713. 

  713.     else if (func.equals("HOST_NAME"))
    714. 

  714.     {
    715. 

  715.       list = new Object[1][1];
    716. 

  716.       list[0][0] = "nchar";
    717. 

  717.     }
    718. 

  718.     else if (func.equals("IDENTITY"))
    719. 

  719.     {
    720. 

  720.       list = new Object[1][1];
    721. 

  721.       list[0][0] = msSQLServerNotSupported;
    722. 

  722.     }
    723. 

  723.     else if (func.equals("IDENT_INCR"))
    724. 

  724.     {
    725. 

  725.       list[0][0] = "numeric_expression"; list[0][1] = "'table_or_view'";
    726. 

  726.     }
    727. 

  727.     else if (func.equals("IDENT_SEED"))
    728. 

  728.     {
    729. 

  729.       list[0][0] = "numeric_expression"; list[0][1] = "'table_or_view'";
    730. 

  730.     }
    731. 

  731.     else if (func.equals("INDEXPROPERTY"))
    732. 

  732.     {
    733. 

  733.       list = new Object[1][4];
    734. 

  734.       list[0][0] = "int"; list[0][1] = "table_ID"; list[0][2] = "index"; list[0][3] = "property";
    735. 

  735.     }
    736. 

  736.     else if (func.equals("INDEX_COL"))
    737. 

  737.     {
    738. 

  738.       list = new Object[1][4];
    739. 

  739.       list[0][0] = "nchar"; list[0][1] = "'table'"; list[0][2] = "index_id"; list[0][3] = "key_id";
    740. 

  740.     }
    741. 

  741.     else if (func.equals("ISDATE"))
    742. 

  742.     {
    743. 

  743.       list[0][0] = "int"; list[0][1] = "expression";
    744. 

  744.     }
    745. 

  745.     else if (func.equals("ISNULL"))
    746. 

  746.     {
    747. 

  747.       list = new Object[1][3];
    748. 

  748.       list[0][0] = "integer"; list[0][1] = "check_expression"; list[0][2] = "replacement_value";
    749. 

  749.     }
    750. 

  750.     else if (func.equals("ISNUMERIC"))
    751. 

  751.     {
    752. 

  752.       list[0][0] = "int"; list[0][1] = "expression";
    753. 

  753.     }
    754. 

  754.     else if (func.equals("IS_MEMBER"))
    755. 

  755.     {
    756. 

  756.       list[0][0] = "int"; list[0][1] = "'group' | 'role'";
    757. 

  757.     }
    758. 

  758.     else if (func.equals("IS_SRVROLEMEMBER"))
    759. 

  759.     {
    760. 

  760.       list = new Object[2][];
    761. 

  761.       list[0] = new Object[2];
    762. 

  762.       list[1] = new Object[3];
    763. 

  763. 

  764.       list[0][0] = "int"; list[0][1] = "'role'";
    765. 

  765.       list[1][0] = "int"; list[1][1] = "'role'"; list[1][2] = "'login'";
    766. 

  766.     }
    767. 

  767.     else if (func.equals("LEFT"))
    768. 

  768.     {
    769. 

  769.       list = new Object[1][3];
    770. 

  770.       list[0][0] = "varchar"; list[0][1] = "character_expression"; list[0][2] = "integer_expression";
    771. 

  771.     }
    772. 

  772.     else if (func.equals("LEN"))
    773. 

  773.     {
    774. 

  774.       list[0][0] = "int"; list[0][1] = "string_expression";
    775. 

  775.     }
    776. 

  776.     else if (func.equals("LOG"))
    777. 

  777.     {
    778. 

  778.       list[0][0] = "float"; list[0][1] = "float_expression";
    779. 

  779.     }
    780. 

  780.     else if (func.equals("LOG10"))
    781. 

  781.     {
    782. 

  782.       list[0][0] = "float"; list[0][1] = "float_expression";
    783. 

  783.     }
    784. 

  784.     else if (func.equals("LOWER"))
    785. 

  785.     {
    786. 

  786.       list[0][0] = "varchar"; list[0][1] = "character_expression";
    787. 

  787.     }
    788. 

  788.     else if (func.equals("LTRIM"))
    789. 

  789.     {
    790. 

  790.       list[0][0] = "varchar"; list[0][1] = "character_expression";
    791. 

  791.     }
    792. 

  792.     else if (func.equals("MAX")) // ALL | DISTINCT
    793. 

  793.     {
    794. 

  794.       list[0][0] = "expression"; list[0][1] = "expression";
    795. 

  795.     }
    796. 

  796.     else if (func.equals("MIN")) // ALL | DISTINCT
    797. 

  797.     {
    798. 

  798.       list[0][0] = "expression"; list[0][1] = "expression";
    799. 

  799.     }
    800. 

  800.     else if (func.equals("MONTH"))
    801. 

  801.     {
    802. 

  802.       list[0][0] = "int"; list[0][1] = "date";
    803. 

  803.     }
    804. 

  804.     else if (func.equals("NCHAR"))
    805. 

  805.     {
    806. 

  806.       list[0][0] = "nchar(1)"; list[0][1] = "integer_expression";
    807. 

  807.     }
    808. 

  808.     else if (func.equals("NEWID"))
    809. 

  809.     {
    810. 

  810.       list = new Object[1][1];
    811. 

  811.       list[0][0] = "uniqueidentifier";
    812. 

  812.     }
    813. 

  813.     else if (func.equals("NULLIF"))
    814. 

  814.     {
    815. 

  815.       list = new Object[1][3];
    816. 

  816.       list[0][0] = "expression"; list[0][1] = "expression"; list[0][2] = "expression";
    817. 

  817.     }
    818. 

  818.     else if (func.equals("OBJECTPROPERTY")) // property is fixed
    819. 

  819.     {
    820. 

  820.       list = new Object[1][3];
    821. 

  821.       list[0][0] = "int"; list[0][1] = "object_id"; list[0][2] = "property";
    822. 

  822.     }
    823. 

  823.     else if (func.equals("OBJECT_ID"))
    824. 

  824.     {
    825. 

  825.       list[0][0] = "int"; list[0][1] = "'object'";
    826. 

  826.     }
    827. 

  827.     else if (func.equals("OBJECT_NAME"))
    828. 

  828.     {
    829. 

  829.       list[0][0] = "nchar"; list[0][1] = "object_id";
    830. 

  830.     }
    831. 

  831.     else if (func.equals("OPENQUERY"))
    832. 

  832.     {
    833. 

  833.       list[0][0] = "result_set"; list[0][1] = "'query'";
    834. 

  834.     }
    835. 

  835.     else if (func.equals("OPENROWSET"))
    836. 

  836.     {
    837. 

  837.       list = new Object[1][1];
    838. 

  838.       list[0][0] = msSQLServerNotSupported;
    839. 

  839.     }
    840. 

  840.     else if (func.equals("PARSENAME")) // object_piece is fixed: 1,2,3 or 4
    841. 

  841.     {
    842. 

  842.       list = new Object[1][3];
    843. 

  843.       list[0][0] = "nchar"; list[0][1] = "'object_name'"; list[0][2] = "object_piece";
    844. 

  844.     }
    845. 

  845.     else if (func.equals("PATINDEX"))
    846. 

  846.     {
    847. 

  847.       list = new Object[1][3];
    848. 

  848.       list[0][0] = "int"; list[0][1] = "'%pattern%'"; list[0][2] = "expression";
    849. 

  849.     }
    850. 

  850.     else if (func.equals("PERMISSIONS"))
    851. 

  851.     {
    852. 

  852.       list = new Object[3][];
    853. 

  853.       list[0] = new Object[1];
    854. 

  854.       list[1] = new Object[2];
    855. 

  855.       list[2] = new Object[3];
    856. 

  856. 

  857.       list[0][0] = "int";
    858. 

  858.       list[1][0] = "int"; list[1][1] = "object_id";
    859. 

  859.       list[2][0] = "int"; list[2][1] = "object_id"; list[2][2] = "'column'";
    860. 

  860.     }
    861. 

  861.     else if (func.equals("PI"))
    862. 

  862.     {
    863. 

  863.       list = new Object[1][1];
    864. 

  864.       list[0][0] = "float";
    865. 

  865.     }
    866. 

  866.     else if (func.equals("POWER"))
    867. 

  867.     {
    868. 

  868.       list = new Object[1][3];
    869. 

  869.       list[0][0] = "numeric_expression"; list[0][1] = "numeric_expression"; list[0][2] = "numeric_expression";
    870. 

  870.     }
    871. 

  871.     else if (func.equals("QUOTENAME"))
    872. 

  872.     {
    873. 

  873.       list = new Object[2][];
    874. 

  874.       list[0] = new Object[2];
    875. 

  875.       list[1] = new Object[3];
    876. 

  876. 

  877.       list[0][0] = "nvarchar(129)"; list[0][1] = "'character_string'";
    878. 

  878.       list[1][0] = "nvarchar(129)"; list[1][1] = "'character_string'"; list[1][2] = "'quote_character'";
    879. 

  879.     }
    880. 

  880.     else if (func.equals("RADIANS"))
    881. 

  881.     {
    882. 

  882.       list[0][0] = "numeric_expression"; list[0][1] = "numeric_expression";
    883. 

  883.     }
    884. 

  884.     else if (func.equals("RAND"))
    885. 

  885.     {
    886. 

  886.       list = new Object[2][];
    887. 

  887.       list[0] = new Object[1];
    888. 

  888.       list[1] = new Object[2];
    889. 

  889. 

  890.       list[0][0] = "float";
    891. 

  891.       list[1][0] = "float"; list[1][1] = "integer_expression";
    892. 

  892.     }
    893. 

  893.     else if (func.equals("REPLACE"))
    894. 

  894.     {
    895. 

  895.       list = new Object[1][4];
    896. 

  896.       list[0][0] = "character_data"; list[0][1] = "string_expression1"; list[0][2] = "string_expression2"; list[0][3] = "string_expression3";
    897. 

  897.     }
    898. 

  898.     else if (func.equals("REPLICATE"))
    899. 

  899.     {
    900. 

  900.       list = new Object[1][3];
    901. 

  901.       list[0][0] = "varchar"; list[0][1] = "character_expression"; list[0][2] = "integer_expression";
    902. 

  902.     }
    903. 

  903.     else if (func.equals("REVERSE"))
    904. 

  904.     {
    905. 

  905.       list[0][0] = "varchar"; list[0][1] = "character_expression";
    906. 

  906.     }
    907. 

  907.     else if (func.equals("RIGHT"))
    908. 

  908.     {
    909. 

  909.       list = new Object[1][3];
    910. 

  910.       list[0][0] = "varchar"; list[0][1] = "character_expression"; list[0][2] = "integer_expression";
    911. 

  911.     }
    912. 

  912.     else if (func.equals("ROUND"))
    913. 

  913.     {
    914. 

  914.       list = new Object[2][];
    915. 

  915.       list[0] = new Object[3];
    916. 

  916.       list[1] = new Object[4];
    917. 

  917. 

  918.       list[0][0] = "numeric_expression"; list[0][1] = "numeric_expression"; list[0][2] = "length";
    919. 

  919.       list[1][0] = "numeric_expression"; list[1][1] = "numeric_expression"; list[1][2] = "length"; list[1][3] = "function";
    920. 

  920.     }
    921. 

  921.     else if (func.equals("RTRIM"))
    922. 

  922.     {
    923. 

  923.       list[0][0] = "varchar"; list[0][1] = "character_expression";
    924. 

  924.     }
    925. 

  925.     else if (func.equals("SESSION_USER"))  // no brackets
    926. 

  926.     {
    927. 

  927.       list = new Object[1][1];
    928. 

  928.       list[0][0] = "nchar";
    929. 

  929.     }
    930. 

  930.     else if (func.equals("SIGN"))
    931. 

  931.     {
    932. 

  932.       list[0][0] = "float"; list[0][1] = "numeric_expression";
    933. 

  933.     }
    934. 

  934.     else if (func.equals("SIN"))
    935. 

  935.     {
    936. 

  936.       list[0][0] = "float"; list[0][1] = "float_expression";
    937. 

  937.     }
    938. 

  938.     else if (func.equals("SOUNDEX"))
    939. 

  939.     {
    940. 

  940.       list[0][0] = "char"; list[0][1] = "character_expression";
    941. 

  941.     }
    942. 

  942.     else if (func.equals("SPACE"))
    943. 

  943.     {
    944. 

  944.       list[0][0] = "char"; list[0][1] = "integer_expression";
    945. 

  945.     }
    946. 

  946.     else if (func.equals("SQRT"))
    947. 

  947.     {
    948. 

  948.       list[0][0] = "float"; list[0][1] = "float_expression";
    949. 

  949.     }
    950. 

  950.     else if (func.equals("SQUARE"))
    951. 

  951.     {
    952. 

  952.       list[0][0] = "float"; list[0][1] = "float_expression";
    953. 

  953.     }
    954. 

  954.     else if (func.equals("STATS_DATE"))
    955. 

  955.     {
    956. 

  956.       list = new Object[1][3];
    957. 

  957.       list[0][0] = "datetime"; list[0][1] = "table_id"; list[0][2] = "index_id";
    958. 

  958.     }
    959. 

  959.     else if (func.equals("STDEV"))
    960. 

  960.     {
    961. 

  961.       list[0][0] = "float"; list[0][1] = "expression";
    962. 

  962.     }
    963. 

  963.     else if (func.equals("STDEVP"))
    964. 

  964.     {
    965. 

  965.       list[0][0] = "float"; list[0][1] = "expression";
    966. 

  966.     }
    967. 

  967.     else if (func.equals("STR"))
    968. 

  968.     {
    969. 

  969.       list = new Object[3][];
    970. 

  970.       list[0] = new Object[2];
    971. 

  971.       list[1] = new Object[3];
    972. 

  972.       list[2] = new Object[4];
    973. 

  973. 

  974.       list[0][0] = "char"; list[0][1] = "float_expression";
    975. 

  975.       list[1][0] = "char"; list[1][1] = "float_expression"; list[1][2] = "length";
    976. 

  976.       list[2][0] = "char"; list[2][1] = "float_expression"; list[2][2] = "length"; list[2][3] = "decimal";
    977. 

  977.     }
    978. 

  978.     else if (func.equals("STUFF"))
    979. 

  979.     {
    980. 

  980.       list = new Object[2][5];
    981. 

  981.       list[0][0] = "character_data"; list[0][1] = "character_expression"; list[0][2] = "start"; list[0][3] = "length"; list[0][4] = "character_expression";
    982. 

  982.       list[1][0] = "binary_data"; list[1][1] = "binary_expression"; list[1][2] = "start"; list[1][3] = "length"; list[1][4] = "binary_expression";
    983. 

  983.     }
    984. 

  984.     else if (func.equals("SUBSTRING"))
    985. 

  985.     {
    986. 

  986.       list = new Object[1][4];
    987. 

  987.       list[0][0] = "expression"; list[0][1] = "expression"; list[0][2] = "start"; list[0][3] = "length";
    988. 

  988.     }
    989. 

  989.     else if (func.equals("SUM")) // DISTINCT | ALL
    990. 

  990.     {
    991. 

  991.       list[0][0] = "expression"; list[0][1] = "expression";
    992. 

  992.     }
    993. 

  993.     else if (func.equals("SUSER_ID"))
    994. 

  994.     {
    995. 

  995.       list = new Object[2][];
    996. 

  996.       list[0] = new Object[1];
    997. 

  997.       list[1] = new Object[2];
    998. 

  998. 

  999.       list[0][0] = "int";
    1000. 

  1000.       list[1][0] = "int"; list[1][1] = "'login'";
    1001. 

  1001.     }
    1002. 

  1002.     else if (func.equals("SUSER_NAME"))
    1003. 

  1003.     {
    1004. 

  1004.       list = new Object[2][];
    1005. 

  1005.       list[0] = new Object[1];
    1006. 

  1006.       list[1] = new Object[2];
    1007. 

  1007. 

  1008.       list[0][0] = "nchar";
    1009. 

  1009.       list[1][0] = "nchar"; list[1][1] = "server_user_id";
    1010. 

  1010.     }
    1011. 

  1011.     else if (func.equals("SUSER_SID"))
    1012. 

  1012.     {
    1013. 

  1013.       list = new Object[2][];
    1014. 

  1014.       list[0] = new Object[1];
    1015. 

  1015.       list[1] = new Object[2];
    1016. 

  1016. 

  1017.       list[0][0] = "int";
    1018. 

  1018.       list[1][0] = "int"; list[1][1] = "'login'";
    1019. 

  1019.     }
    1020. 

  1020.     else if (func.equals("SUSER_SNAME"))
    1021. 

  1021.     {
    1022. 

  1022.       list = new Object[2][];
    1023. 

  1023.       list[0] = new Object[1];
    1024. 

  1024.       list[1] = new Object[2];
    1025. 

  1025. 

  1026.       list[0][0] = "nchar";
    1027. 

  1027.       list[1][0] = "nchar"; list[1][1] = "server_user_id";
    1028. 

  1028.     }
    1029. 

  1029.     else if (func.equals("SYSTEM_USER"))  // no brackets
    1030. 

  1030.     {
    1031. 

  1031.       list = new Object[1][1];
    1032. 

  1032.       list[0][0] = "char";
    1033. 

  1033.     }
    1034. 

  1034.     else if (func.equals("TAN"))
    1035. 

  1035.     {
    1036. 

  1036.       list[0][0] = "float"; list[0][1] = "float_expression";
    1037. 

  1037.     }
    1038. 

  1038.     else if (func.equals("TEXTPTR"))
    1039. 

  1039.     {
    1040. 

  1040.       list[0][0] = "varbinary"; list[0][1] = "column";
    1041. 

  1041.     }
    1042. 

  1042.     else if (func.equals("TEXTVALID"))
    1043. 

  1043.     {
    1044. 

  1044.       list = new Object[1][3];
    1045. 

  1045.       list[0][0] = "int"; list[0][1] = "'table.column'"; list[0][2] = "text_ptr";
    1046. 

  1046.     }
    1047. 

  1047.     else if (func.equals("TYPEPROPERTY"))  // property is fixed
    1048. 

  1048.     {
    1049. 

  1049.       list = new Object[1][3];
    1050. 

  1050.       list[0][0] = "int"; list[0][1] = "type"; list[0][2] = "property";
    1051. 

  1051.     }
    1052. 

  1052.     else if (func.equals("UNICODE"))
    1053. 

  1053.     {
    1054. 

  1054.       list[0][0] = "int"; list[0][1] = "'ncharacter_expression'";
    1055. 

  1055.     }
    1056. 

  1056.     else if (func.equals("UPPER"))
    1057. 

  1057.     {
    1058. 

  1058.       list[0][0] = "varchar"; list[0][1] = "character_expression";
    1059. 

  1059.     }
    1060. 

  1060.     else if (func.equals("USER")) // no brackets
    1061. 

  1061.     {
    1062. 

  1062.       list = new Object[1][1];
    1063. 

  1063.       list[0][0] = "char";
    1064. 

  1064.     }
    1065. 

  1065.     else if (func.equals("USER_ID"))
    1066. 

  1066.     {
    1067. 

  1067.       list = new Object[2][];
    1068. 

  1068.       list[0] = new Object[1];
    1069. 

  1069.       list[1] = new Object[2];
    1070. 

  1070. 

  1071.       list[0][0] = "int";
    1072. 

  1072.       list[1][0] = "int"; list[1][1] = "'user'";
    1073. 

  1073.     }
    1074. 

  1074.     else if (func.equals("USER_NAME"))
    1075. 

  1075.     {
    1076. 

  1076.       list = new Object[2][];
    1077. 

  1077.       list[0] = new Object[1];
    1078. 

  1078.       list[1] = new Object[2];
    1079. 

  1079. 

  1080.       list[0][0] = "nchar";
    1081. 

  1081.       list[1][0] = "nchar"; list[1][1] = "id";
    1082. 

  1082.     }
    1083. 

  1083.     else if (func.equals("VAR"))
    1084. 

  1084.     {
    1085. 

  1085.       list[0][0] = "float"; list[0][1] = "expression";
    1086. 

  1086.     }
    1087. 

  1087.     else if (func.equals("VARP"))
    1088. 

  1088.     {
    1089. 

  1089.       list[0][0] = "float"; list[0][1] = "expression";
    1090. 

  1090.     }
    1091. 

  1091.     else if (func.equals("YEAR"))
    1092. 

  1092.     {
    1093. 

  1093.       list[0][0] = "int"; list[0][1] = "date";
    1094. 

  1094.     }
    1095. 

  1095.     else if (func.equals("@@CONNECTIONS") ||
    1096. 

  1096.              func.equals("@@CPU_BUSY") ||
    1097. 

  1097.              func.equals("@@CURSOR_ROWS") ||
    1098. 

  1098.              func.equals("@@ERROR") ||
    1099. 

  1099.              func.equals("@@FETCH_STATUS") ||
    1100. 

  1100.              func.equals("@@IDLE") ||
    1101. 

  1101.              func.equals("@@IO_BUSY") ||
    1102. 

  1102.              func.equals("@@LOCK_TIMEOUT") ||
    1103. 

  1103.              func.equals("@@MAX_CONNECTIONS") ||
    1104. 

  1104.              func.equals("@@NESTLEVEL") ||
    1105. 

  1105.              func.equals("@@OPTIONS") ||
    1106. 

  1106.              func.equals("@@PACKET_ERRORS") ||
    1107. 

  1107.              func.equals("@@PACK_RECEIVED") ||
    1108. 

  1108.              func.equals("@@PACK_SENT") ||
    1109. 

  1109.              func.equals("@@PROCID") ||
    1110. 

  1110.              func.equals("@@ROWCOUNT") ||
    1111. 

  1111.              func.equals("@@TEXTSIZE") ||
    1112. 

  1112.              func.equals("@@TIMETICKS") ||
    1113. 

  1113.              func.equals("@@TOTAL_ERRORS") ||
    1114. 

  1114.              func.equals("@@TOTAL_READ") ||
    1115. 

  1115.              func.equals("@@TOTAL_WRITE") ||
    1116. 

  1116.              func.equals("@@TRANCOUNT"))
    1117. 

  1117.     {
    1118. 

  1118.       list = new Object[1][1];
    1119. 

  1119.       list[0][0] = "int";
    1120. 

  1120.     }
    1121. 

  1121.     else if (func.equals("@@DATEFIRST") ||
    1122. 

  1122.              func.equals("@@MAX_PRECISION"))
    1123. 

  1123.     {
    1124. 

  1124.       list = new Object[1][1];
    1125. 

  1125.       list[0][0] = "tinyint";
    1126. 

  1126.     }
    1127. 

  1127.     else if (func.equals("@@DBTS"))
    1128. 

  1128.     {
    1129. 

  1129.       list = new Object[1][1];
    1130. 

  1130.       list[0][0] = "varbinary";
    1131. 

  1131.     }
    1132. 

  1132.     else if (func.equals("@@IDENTITY"))
    1133. 

  1133.     {
    1134. 

  1134.       list = new Object[1][1];
    1135. 

  1135.       list[0][0] = "numeric";
    1136. 

  1136.     }
    1137. 

  1137.     else if (func.equals("@@LANGID") ||
    1138. 

  1138.              func.equals("@@SPID"))
    1139. 

  1139.     {
    1140. 

  1140.       list = new Object[1][1];
    1141. 

  1141.       list[0][0] = "smallint";
    1142. 

  1142.     }
    1143. 

  1143.     else if (func.equals("@@LANGUAGE") ||
    1144. 

  1144.              func.equals("@@SERVERNAME") ||
    1145. 

  1145.              func.equals("@@SERVICENAME") ||
    1146. 

  1146.              func.equals("@@VERSION"))
    1147. 

  1147.     {
    1148. 

  1148.       list = new Object[1][1];
    1149. 

  1149.       list[0][0] = "nvarchar";
    1150. 

  1150.     }
    1151. 

  1151.     else if (func.equals("@@REMSERVER"))
    1152. 

  1152.     {
    1153. 

  1153.       list = new Object[1][1];
    1154. 

  1154.       list[0][0] = "nvarchar(128)";
    1155. 

  1155.     }
    1156. 

  1156.     else
    1157. 

  1157.     {
    1158. 

  1158.     	list = UDFNamesAndSignatures.getUDFParams(func);
    1159. 

  1159.     }
    1160. 

  1160.     return list;
    1161. 

  1161.   } // end getParms
    1162. 

  1162. 

  1163.   public static Object[][] getParameterFormats(String functionName)
    1164. 

  1164.   {
    1165. 

  1165.     return getParms(functionName);
    1166. 

  1166.   }
    1167. 

  1167. 

  1168.   public static void fillCategoryCombo(Combo functionsCategoryCombo, boolean isColumn)
    1169. 

  1169.   {
    1170. 

  1170.     if (!isColumn)
    1171. 

  1171.     {
    1172. 

  1172.       functionsCategoryCombo.add(msSQLServerAll);
    1173. 

  1173.       functionsCategoryCombo.add(msSQLServerAggregate);
    1174. 

  1174.       functionsCategoryCombo.add(msSQLServerConfiguration);
    1175. 

  1175.       functionsCategoryCombo.add(msSQLServerCursor);
    1176. 

  1176.       functionsCategoryCombo.add(msSQLServerDateAndTime);
    1177. 

  1177.       functionsCategoryCombo.add(msSQLServerMath);
    1178. 

  1178.       functionsCategoryCombo.add(msSQLServerMetadata);
    1179. 

  1179.       functionsCategoryCombo.add(msSQLServerSecurity);
    1180. 

  1180.       functionsCategoryCombo.add(msSQLServerString);
    1181. 

  1181.       functionsCategoryCombo.add(msSQLServerSystem);
    1182. 

  1182.       functionsCategoryCombo.add(msSQLServerSystemStatistical);
    1183. 

  1183.       functionsCategoryCombo.add(msSQLServerTextAndImage);
    1184. 

  1184.       functionsCategoryCombo.add(msSQLServerRowset);
    1185. 

  1185.       functionsCategoryCombo.add(dbUDF);
    1186. 

  1186.     }
    1187. 

  1187.     else
    1188. 

  1188.     {
    1189. 

  1189.       functionsCategoryCombo.add(msSQLServerAll);
    1190. 

  1190.       functionsCategoryCombo.add(msSQLServerAggregate);
    1191. 

  1191.       functionsCategoryCombo.add(msSQLServerConfiguration);
    1192. 

  1192.       functionsCategoryCombo.add(msSQLServerCursor);
    1193. 

  1193.       functionsCategoryCombo.add(msSQLServerDateAndTime);
    1194. 

  1194.       functionsCategoryCombo.add(msSQLServerMath);
    1195. 

  1195.       functionsCategoryCombo.add(msSQLServerMetadata);
    1196. 

  1196.       functionsCategoryCombo.add(msSQLServerSecurity);
    1197. 

  1197.       functionsCategoryCombo.add(msSQLServerString);
    1198. 

  1198.       functionsCategoryCombo.add(msSQLServerSystem);
    1199. 

  1199.       functionsCategoryCombo.add(msSQLServerSystemStatistical);
    1200. 

  1200.       functionsCategoryCombo.add(msSQLServerTextAndImage);
    1201. 

  1201.       functionsCategoryCombo.add(msSQLServerRowset);
    1202. 

  1202.       functionsCategoryCombo.add(dbUDF);
    1203. 

  1203.     }
    1204. 

  1204.   }
    1205. 

  1205. 

  1206.   // Set up superclass for the various vendor function names and signatures
    1207. 

  1207.   public static boolean isFunctionSupportingStar(String s)
    1208. 

  1208.   {
    1209. 

  1209.     List funcList = Arrays.asList(functionsSupportingStar);
    1210. 

  1210.     if (funcList.contains(s))
    1211. 

  1211.     {
    1212. 

  1212.       return true;
    1213. 

  1213.     }
    1214. 

  1214.     return false;
    1215. 

  1215.   }
    1216. 

  1216. 

  1217.   public static boolean requiresNoBrackets(String functionName)
    1218. 

  1218.   {
    1219. 

  1219.     List funcList = Arrays.asList(noBracketFunctions);
    1220. 

  1220.     if (funcList.contains(functionName))
    1221. 

  1221.     {
    1222. 

  1222.       return true;
    1223. 

  1223.     }
    1224. 

  1224.     return false;
    1225. 

  1225.   }
    1226. 

  1226. 

  1227.   public static boolean isNotSupported(String functionName)
    1228. 

  1228.   {
    1229. 

  1229.     List funcList = Arrays.asList(unsupportedFunctions);
    1230. 

  1230.     if (funcList.contains(functionName))
    1231. 

  1231.     {
    1232. 

  1232.       return true;
    1233. 

  1233.     }
    1234. 

  1234.     return false;
    1235. 

  1235.   }
    1236. 

  1236. 

  1237.   public static String[] getFunctionList(String category, boolean isColumn, SQLDomainModel domainModel)
    1238. 

  1238.   {
    1239. 

  1239.     if (category.equals(msSQLServerAll))
    1240. 

  1240.     {
    1241. 

  1241.       if (!isColumn)
    1242. 

  1242.       {
    1243. 

  1243.         return UDFNamesAndSignatures.mergeTwoArrays(allFunctions,UDFNamesAndSignatures.getUDFNames(domainModel)) ;
    1244. 

  1244.       }
    1245. 

  1245.       
    1246. 

  1246.       return UDFNamesAndSignatures.mergeTwoArrays(allColumnSupportedFunctions,UDFNamesAndSignatures.getUDFNames(domainModel)) ;
    1247. 

  1247.     }
    1248. 

  1248.     else if (category.equals(msSQLServerAggregate))
    1249. 

  1249.     {
    1250. 

  1250.       return aggregateFunctions;
    1251. 

  1251.     }
    1252. 

  1252.     else if (category.equals(msSQLServerConfiguration))
    1253. 

  1253.     {
    1254. 

  1254.       return configurationFunctions;
    1255. 

  1255.     }
    1256. 

  1256.     else if (category.equals(msSQLServerCursor))
    1257. 

  1257.     {
    1258. 

  1258.       return cursorFunctions;
    1259. 

  1259.     }
    1260. 

  1260.     else if (category.equals(msSQLServerDateAndTime))
    1261. 

  1261.     {
    1262. 

  1262.       return dateAndTimeFunctions;
    1263. 

  1263.     }
    1264. 

  1264.     else if (category.equals(msSQLServerMath))
    1265. 

  1265.     {
    1266. 

  1266.       return mathFunctions;
    1267. 

  1267.     }
    1268. 

  1268.     else if (category.equals(msSQLServerMetadata))
    1269. 

  1269.     {
    1270. 

  1270.       return metadataFunctions;
    1271. 

  1271.     }
    1272. 

  1272.     else if (category.equals(msSQLServerSecurity))
    1273. 

  1273.     {
    1274. 

  1274.       return securityFunctions;
    1275. 

  1275.     }
    1276. 

  1276.     else if (category.equals(msSQLServerString))
    1277. 

  1277.     {
    1278. 

  1278.       return stringFunctions;
    1279. 

  1279.     }
    1280. 

  1280.     else if (category.equals(msSQLServerSystem))
    1281. 

  1281.     {
    1282. 

  1282.       return systemFunctions;
    1283. 

  1283.     }
    1284. 

  1284.     else if (category.equals(msSQLServerSystemStatistical))
    1285. 

  1285.     {
    1286. 

  1286.       return systemStatisticalFunctions;
    1287. 

  1287.     }
    1288. 

  1288.     else if (category.equals(msSQLServerTextAndImage))
    1289. 

  1289.     {
    1290. 

  1290.       return textAndImageFunctions;
    1291. 

  1291.     }
    1292. 

  1292.     else if (category.equals(msSQLServerRowset))
    1293. 

  1293.     {
    1294. 

  1294.       return rowsetFunctions;
    1295. 

  1295.     }
    1296. 

  1296.     else if (category.equals(dbUDF))
    1297. 

  1297.     {
    1298. 

  1298.       return UDFNamesAndSignatures.getUDFNames(domainModel);
    1299. 

  1299.     }
    1300. 

  1300.     return UDFNamesAndSignatures.mergeTwoArrays(allFunctions,UDFNamesAndSignatures.getUDFNames(domainModel)) ;
    1301. 

  1301.   }
    1302. 

  1302. }
    1303. 

  1303.