<!--create by iword1.0 pro, http://www.voland.com.cn-->
<!-- saved from url=(0026)http://www.runqian.com.cn/ -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>sqltranslate()</title>
<link rel="stylesheet" href="../images/template.css" type="text/css" />
<link rel="stylesheet" href="document.css" type="text/css" />
<script language="JavaScript" src="../resource/url.js"></script>
</head>
<body>
<div id="content-bg">
<div id="centent">
<div id="centent-title"><h2><span style='mso-bookmark:"_sqltranslate\(\)"'><a name=sqltranslate></a><span
lang=EN-US>sqltranslate()</span></span><span
style='mso-bookmark:"_sqltranslate\(\)"'></span><span
style='mso-bookmark:"_sqltranslate\(\)"'></span></h2></div>
<span style='mso-bookmark:"_sqltranslate\(\)"'></span>
<p class=MsoNormal style='line-height:200%'><b style='mso-bidi-font-weight:
normal'><span lang=EN-US style='font-size:14.0pt;line-height:200%;mso-bidi-language:
AR'>Description:</span></b><span lang=EN-US style='font-size:12.0pt;line-height:
200%;mso-fareast-font-family:等线;mso-font-kerning:0pt'></span></p>
<p class=MsoNormal style='text-indent:21.0pt;mso-char-indent-count:2.0'><span
lang=EN-US style='mso-bidi-font-size:10.5pt;mso-bidi-language:AR'>Translate
standard SQL functions into functions a specified database defines.</span><span
lang=EN-US style='font-size:12.0pt;mso-fareast-font-family:等线;mso-font-kerning:
0pt'></span></p>
<p class=MsoNormal style='line-height:200%'><b style='mso-bidi-font-weight:
normal'><span lang=EN-US style='font-size:14.0pt;line-height:200%;mso-bidi-language:
AR'>Syntax: </span></b><span lang=EN-US style='font-size:12.0pt;line-height:
200%;mso-fareast-font-family:等线;mso-font-kerning:0pt'></span></p>
<p class=MsoNormal style='text-indent:21.0pt;mso-char-indent-count:2.0'><i
style='mso-bidi-font-style:normal'><span lang=EN-US style='mso-bidi-font-size:
10.5pt;mso-fareast-font-family:黑体;mso-bidi-language:AR;mso-bidi-font-weight:
bold'>sql</span></i><b style='mso-bidi-font-weight:normal'><span lang=EN-US
style='mso-bidi-font-size:10.5pt;mso-bidi-language:AR'>.</span></b><b
style='mso-bidi-font-weight:normal'><span lang=EN-US style='mso-bidi-font-size:
10.5pt;mso-fareast-font-family:黑体;mso-bidi-language:AR;mso-bidi-font-style:
italic'>sqltranslate</span></b><span lang=EN-US style='mso-bidi-font-size:10.5pt;
mso-bidi-language:AR'>(<i style='mso-bidi-font-style:normal'>dbtype</i>)</span><span
lang=EN-US style='mso-fareast-font-family:等线'></span></p>
<p class=MsoNormal style='line-height:200%'><b style='mso-bidi-font-weight:
normal'><span lang=EN-US style='font-size:14.0pt;line-height:200%;mso-bidi-language:
AR'>Note: </span></b><span lang=EN-US style='font-size:12.0pt;line-height:200%;
mso-fareast-font-family:等线;mso-font-kerning:0pt'></span></p>
<p class=MsoNormal style='text-indent:21.0pt;mso-char-indent-count:2.0'><span
lang=EN-US style='mso-bidi-font-size:10.5pt;mso-bidi-language:AR'>The function
translates standard SQL functions into functions a specified database defines.
Default database types it supports include </span><span lang=EN-US
style='mso-bidi-language:AR'>ORACLE, SQLSVR, DB2, MYSQL, HSQL, TERADATA and
POSTGRES. Users are allowed to define user-defined database types and functions
by modifying the configuration file.</span></p>
<p class=MsoNormal style='line-height:200%'><b style='mso-bidi-font-weight:
normal'><span lang=EN-US style='mso-bidi-font-size:10.5pt;line-height:200%;
mso-bidi-language:AR'>Standard SQL functions and corresponding functions
defined in certain databases:</span></b></p>
<p class=MsoNormal style='line-height:200%'><b style='mso-bidi-font-weight:
normal'><span lang=EN-US style='mso-bidi-font-size:10.5pt;line-height:200%;
mso-bidi-language:AR'>String functions</span><span lang=EN-US></span></b></p>
<table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0
style='margin-left:-11.85pt;border-collapse:collapse;mso-table-layout-alt:
fixed;border:none;mso-border-alt:solid #A6A6A6 .5pt;mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-border-insideh:.5pt solid #A6A6A6;mso-border-insidev:.5pt solid #A6A6A6'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;height:14.25pt'>
<td width=135 valign=bottom style='width:100.9pt;border:solid #A6A6A6 1.0pt;
mso-border-alt:solid #A6A6A6 .5pt;background:silver;padding:0cm 5.4pt 0cm 5.4pt;
height:14.25pt'>
<p class=MsoNormal style='mso-pagination:widow-orphan'><span lang=EN-US
style='font-size:7.5pt;mso-font-kerning:0pt;mso-bidi-language:AR'>Standard
SQL functions</span><span lang=EN-US style='font-size:7.5pt;mso-font-kerning:
0pt'></span></p>
</td>
<td width=106 valign=bottom style='width:79.15pt;border:solid #A6A6A6 1.0pt;
border-left:none;mso-border-left-alt:solid #A6A6A6 .5pt;mso-border-alt:solid #A6A6A6 .5pt;
background:silver;padding:0cm 5.4pt 0cm 5.4pt;height:14.25pt'>
<p class=MsoNormal style='mso-pagination:widow-orphan'><span lang=EN-US
style='font-size:7.5pt;mso-font-kerning:0pt;mso-bidi-language:AR'>Description</span><span
lang=EN-US style='font-size:7.5pt;mso-font-kerning:0pt'></span></p>
</td>
<td width=125 valign=bottom style='width:93.4pt;border:solid #A6A6A6 1.0pt;
border-left:none;mso-border-left-alt:solid #A6A6A6 .5pt;mso-border-alt:solid #A6A6A6 .5pt;
background:silver;padding:0cm 5.4pt 0cm 5.4pt;height:14.25pt'>
<p class=MsoNormal style='mso-pagination:widow-orphan'><span lang=EN-US
style='font-size:7.5pt;mso-font-kerning:0pt;mso-bidi-language:AR'>oracle</span><span
lang=EN-US style='font-size:7.5pt;mso-font-kerning:0pt'></span></p>
</td>
<td width=200 valign=bottom style='width:149.65pt;border:solid #A6A6A6 1.0pt;
border-left:none;mso-border-left-alt:solid #A6A6A6 .5pt;mso-border-alt:solid #A6A6A6 .5pt;
background:silver;padding:0cm 5.4pt 0cm 5.4pt;height:14.25pt'>
<p class=MsoNormal style='mso-pagination:widow-orphan'><span lang=EN-US
style='font-size:7.5pt;mso-font-kerning:0pt;mso-bidi-language:AR'>sql server</span><span
lang=EN-US style='font-size:7.5pt;mso-font-kerning:0pt'></span></p>
</td>
<td width=130 valign=bottom style='width:97.15pt;border:solid #A6A6A6 1.0pt;
border-left:none;mso-border-left-alt:solid #A6A6A6 .5pt;mso-border-alt:solid #A6A6A6 .5pt;
background:silver;padding:0cm 5.4pt 0cm 5.4pt;height:14.25pt'>
<p class=MsoNormal style='mso-pagination:widow-orphan'><span lang=EN-US
style='font-size:7.5pt;mso-font-kerning:0pt;mso-bidi-language:AR'>db2</span><span
lang=EN-US style='font-size:7.5pt;mso-font-kerning:0pt'></span></p>
</td>
<td width=130 valign=bottom style='width:97.15pt;border:solid #A6A6A6 1.0pt;
border-left:none;mso-border-left-alt:solid #A6A6A6 .5pt;mso-border-alt:solid #A6A6A6 .5pt;
background:silver;padding:0cm 5.4pt 0cm 5.4pt;height:14.25pt'>
<p class=MsoNormal style='mso-pagination:widow-orphan'><span lang=EN-US
style='font-size:7.5pt;mso-font-kerning:0pt;mso-bidi-language:AR'>mysql</span><span
lang=EN-US style='font-size:7.5pt;mso-font-kerning:0pt'></span></p>
</td>
<td width=195 valign=bottom style='width:145.9pt;border:solid #A6A6A6 1.0pt;
border-left:none;mso-border-left-alt:solid #A6A6A6 .5pt;mso-border-alt:solid #A6A6A6 .5pt;
background:silver;padding:0cm 5.4pt 0cm 5.4pt;height:14.25pt'>
<p class=MsoNormal style='mso-pagination:widow-orphan'><span lang=EN-US
style='font-size:7.5pt;mso-font-kerning:0pt;mso-bidi-language:AR'>teradata</span><span
lang=EN-US style='font-size:7.5pt;mso-font-kerning:0pt'></span></p>
</td>
<td width=130 valign=bottom style='width:97.15pt;border:solid #A6A6A6 1.0pt;
border-left:none;mso-border-left-alt:solid #A6A6A6 .5pt;mso-border-alt:solid #A6A6A6 .5pt;
background:silver;padding:0cm 5.4pt 0cm 5.4pt;height:14.25pt'>
<p class=MsoNormal style='mso-pagination:widow-orphan'><span lang=EN-US
style='font-size:7.5pt;mso-font-kerning:0
数据计算和处理引擎：一种用于数据处理的脚本语言，具有丰富的库函数和强大的语法，可以通过JDBC接口和独立计算在Java程序中执行
64 浏览量
2024-02-18
19:49:49
上传
评论
收藏 664.78MB ZIP 举报
数据计算和处理引擎：一种用于数据处理的脚本语言，具有丰富的库函数和强大的语法，可以通过JDBC接口和独立计算在Java程序中执行 （2000个子文件） 
document.css 245KB document.css 164KB document.css 163KB document.css 124KB document.css 101KB document.css 34KB template.css 2KB template.css 2KB template.css 2KB template.css 2KB template.css 2KB template.css 2KB header.htm 9KB header.htm 9KB header.htm 8KB header.htm 8KB header.htm 7KB header.htm 2KB
893.html 373KB 35.html 185KB 38.html 181KB 8.html 165KB 33.html 162KB 16.html 152KB 481.html 147KB 253.html 140KB 214.html 130KB 49.html 122KB 49.html 122KB 152.html 120KB 51.html 120KB 40.html 120KB 216.html 119KB 54.html 117KB 41.html 114KB 50.html 114KB 13.html 113KB 25.html 102KB 512.html 102KB 876.html 101KB 29.html 99KB 23.html 98KB 43.html 96KB 21.html 94KB 18.html 93KB 12.html 93KB 213.html 92KB 791.html 91KB 215.html 88KB 196.html 88KB 336.html 87KB 248.html 87KB 128.html 87KB 17.html 86KB 725.html 86KB 44.html 86KB 985.html 86KB 34.html 85KB 480.html 85KB 9.html 84KB 30.html 82KB 944.html 82KB 697.html 81KB 46.html 80KB 945.html 78KB 52.html 77KB 10.html 77KB 202.html 77KB 420.html 76KB 78.html 76KB 53.html 76KB 59.html 75KB 12.html 75KB 542.html 75KB 26.html 75KB 195.html 74KB 54.html 72KB 117.html 71KB 646.html 71KB 169.html 70KB 77.html 69KB 534.html 69KB 259.html 69KB 641.html 69KB 913.html 68KB 249.html 68KB 19.html 67KB 33.html 67KB 47.html 67KB 39.html 67KB 189.html 67KB 291.html 67KB 83.html 66KB 8.html 66KB 3.html 64KB 153.html 62KB 147.html 61KB 11.html 61KB 698.html 60KB 972.html 60KB共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
