We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Submitted by: Oleg Matveyev (o_matveev)
1. Correct command with no error messages: DECLARE EXTERNAL FUNCTION udfTest15 INTEGER, -- 1 INTEGER, -- 2 INTEGER, -- 3 INTEGER, -- 4 INTEGER, -- 5 INTEGER, -- 6 INTEGER, -- 7 INTEGER, -- 8 INTEGER, -- 9 INTEGER, -- 10 INTEGER, -- 11 INTEGER, -- 12 INTEGER, -- 13 INTEGER, -- 14 INTEGER -- 15 RETURNS INTEGER BY VALUE ENTRY_POINT 'udf' MODULE_NAME 'fbudf';
2. Command with error Dynamic SQL Error. SQL error code = -607. Invalid command. External functions cannot have more than 10 parameters.
DECLARE EXTERNAL FUNCTION udfTest16 INTEGER, -- 1 INTEGER, -- 2 INTEGER, -- 3 INTEGER, -- 4 INTEGER, -- 5 INTEGER, -- 6 INTEGER, -- 7 INTEGER, -- 8 INTEGER, -- 9 INTEGER, -- 10 INTEGER, -- 11 INTEGER, -- 12 INTEGER, -- 13 INTEGER, -- 14 INTEGER, -- 15 INTEGER -- 16 RETURNS INTEGER BY VALUE ENTRY_POINT 'udf' MODULE_NAME 'fbudf';
The text was updated successfully, but these errors were encountered:
Commented by: @asfernandes
UDFs was been deprecated already, so does not seems as a thing that will change.
Sorry, something went wrong.
No branches or pull requests
Submitted by: Oleg Matveyev (o_matveev)
1. Correct command with no error messages:
DECLARE EXTERNAL FUNCTION udfTest15
INTEGER, -- 1
INTEGER, -- 2
INTEGER, -- 3
INTEGER, -- 4
INTEGER, -- 5
INTEGER, -- 6
INTEGER, -- 7
INTEGER, -- 8
INTEGER, -- 9
INTEGER, -- 10
INTEGER, -- 11
INTEGER, -- 12
INTEGER, -- 13
INTEGER, -- 14
INTEGER -- 15
RETURNS INTEGER BY VALUE
ENTRY_POINT 'udf' MODULE_NAME 'fbudf';
2. Command with error
Dynamic SQL Error.
SQL error code = -607.
Invalid command.
External functions cannot have more than 10 parameters.
DECLARE EXTERNAL FUNCTION udfTest16
INTEGER, -- 1
INTEGER, -- 2
INTEGER, -- 3
INTEGER, -- 4
INTEGER, -- 5
INTEGER, -- 6
INTEGER, -- 7
INTEGER, -- 8
INTEGER, -- 9
INTEGER, -- 10
INTEGER, -- 11
INTEGER, -- 12
INTEGER, -- 13
INTEGER, -- 14
INTEGER, -- 15
INTEGER -- 16
RETURNS INTEGER BY VALUE
ENTRY_POINT 'udf' MODULE_NAME 'fbudf';
The text was updated successfully, but these errors were encountered: