Link Search Menu Expand Document Documentation Menu

Calling a procedure or function with DEFAULT parameter values

In T-SQL, you can pass the DEFAULT keyword in a call to a procedure or function to choose the default value of the parameter. Babelfish doesn’t support the DEFAULT keyword in procedure or function calls.

You can run Babelfish Compass with the -rewrite option on SQL source files containing procedure and function calls. Babelfish Compass rewrites the calls with actual default parameter values in place of the DEFAULT keyword. Each literal value that replaces a DEFAULT keyword is preceded and followed by comments that identify which parameters represent default values. If you need to change the default value in the future, update the specific values that are embedded in the source code of the function calls.

–Before rewrite

dbo.stored_procedure_1( @variable1, parameter_value, DEFAULT, DEFAULT, DEFAULT)

–After Babelfish Compass rewrite

dbo.stored_procedure_1( @variable1, parameter_value, /*REWRITTEN*/ 'N/A' /*DEFAULT*/,
/*REWRITTEN*/ NULL /*DEFAULT*/, /*REWRITTEN*/ 0 /*DEFAULT*/)

For information about using Babelfish from both the TDS port and the PostgreSQL port, visit the Babelfish website.

Babelfish for PostgreSQL Links