| <html lang=en> |
| <head> |
| <meta name="Generated by Rational Rose model" content="C:\Aurora_Oct20\RSM\eclipse\workspace-cascadeplus\org.eclipse.wst.rdb.models.dbdefinition\src\model\DatabaseDefinitionModel.mdl"> |
| <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> |
| <meta name="Description" content="From 5WD-02-Foundation-2002-12 11.50 SQL-invoked routine null-call clause ::= RETURNS NULL ON NULL INPUT | CALLED ON NULL INPUT If PROCEDURE is specified, then: - null-call clause shall not be specified. if null-call clause is not specified, then - CALLED ON NULL INPUT is implicit. If the SQL-invoked routine is an SQL-invoked function, then: - The SQL-invoked routine descriptor includes an indication of whether the SQL-invoked routine is a null-call function. 4.27 SQL-invoked routines A null-call function is an SQL-invoked function that is defined to return the null value if any of its input arguments is the null value. A null-call function is an SQL-invoked function whose null-call clause specifies RETURNS NULL ON NULL INPUT ."> |
| <meta name="KeyWords" content="nullCall,Attribute nullCall,DatabaseDefinitionModel,model DatabaseDefinitionModel,"> |
| <a href="../../../root.html" target=_top><IMG SRC="../../../webviewer/home.gif"BORDER=0></a> |
| </head> |
| <body bgcolor = "#FFFFFF"> |
| <p><font FACE="Arial, Geneva" SIZE=3><b>boolean <IMG SRC="../../../webviewer/30.jpg"BORDER=0>nullCall, in Class <a href="class3f3d3b50012c.htm" target="contents_frame">Function</a></b></font></p> |
| <font FACE="Arial, Geneva" SIZE=2><b>Documentation</b></font><BR><font FACE="Arial, Geneva" SIZE=2>From 5WD-02-Foundation-2002-12 |
| <BR>11.50 <SQL-invoked routine> |
| <BR><null-call clause> ::= RETURNS NULL ON NULL INPUT | CALLED ON NULL INPUT |
| <BR> |
| <BR>If PROCEDURE is specified, then: |
| <BR>- <null-call clause> shall not be specified. |
| <BR> |
| <BR>if <null-call clause> is not specified, then |
| <BR>- CALLED ON NULL INPUT is implicit. |
| <BR> |
| <BR>If the SQL-invoked routine is an SQL-invoked function, then: |
| <BR>- The SQL-invoked routine descriptor includes an indication of whether the SQL-invoked routine |
| <BR>is a null-call function. |
| <BR> |
| <BR>4.27 SQL-invoked routines |
| <BR>A null-call function is an SQL-invoked function that is defined to return the null value if any of its input arguments is the null value. A null-call function is an SQL-invoked function whose <null-call clause> specifies |
| <BR>"RETURNS NULL ON NULL INPUT".</font><BR><BR> |
| <TABLE BORDER=1 CELLSPACING=0 CELLPADDING=3><TR><TD><font FACE="Arial, Geneva" SIZE=2><b>Export Control</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>PublicAccess</font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>Containment</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>Unspecified</font></TD></TR><TR><TD><font FACE="Arial, Geneva" SIZE=2><b>Static</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>No</font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>Derived</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>No</font></TD></TR></TABLE><BR> |
| <BR><p><font FACE="Arial, Geneva" SIZE=3><b>Property Settings</b></font></p> |
| <font FACE="Arial, Geneva" SIZE=2><b>Data Modeler</b></font> |
| <TABLE BORDER=1 CELLSPACING=0 CELLPADDING=3> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><b>dmItem</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>False</font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>DMName</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><b>Ordinal</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>0</font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>IsIdentity</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>False</font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><b>IsUnique</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>False</font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>NullsAllowed</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>False</font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><b>Length</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>0</font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>Scale</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>0</font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><b>ColumnType</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>Native</font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>ForBitData</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>False</font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><b>DefaultValueType</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>DefaultValue</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><b>SourceId</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>SourceType</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><b>OID</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>False</font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD></TR> |
| </TABLE><BR><BR> |
| </body> |
| </html> |
