create function allows a new keyword, exportable, that determines whether the function can be forwarded to a remote server when used against a proxy table. exportable does not specify that a function must be exported, but only that it must be exported when the function is used with a proxy table. When possible, CIS includes the function in the SQL statement sent to the remote server. If the remote server is another Adaptive Server, the function must be defined in the user’s default database, so that the remote server can locate the function.
create function[ owner ] function_name
( [ { @parameter_name [ AS ] parameter_datatype [ = default ] } [,...n ] ] )
returns return_datatype
[ exportable ]
[ with recompile] ]
[ as ]
begin
function_body
return scalar_expression
end
