| |
- Causa
- INVALID USE OF 'DISTINCT' OR 'ALL' WITH SCALAR FUNCTION function-name.
The keyword 'DISTINCT' or 'ALL' was detected within parentheses in a reference to function function-name and the function has been resolved as a
scalar function.
Use of the keyword 'DISTINCT' or 'ALL' with a scalar function is invalid.
- Ação do sistema
- The statement cannot be executed.
- Resposta ao Desenvolvedor
- If a scalar function is being used, then remove the keyword 'DISTINCT' or 'ALL'.
If a column function is being used, then there is a problem with function resolution.
Check your current path to see if the desired function is in one of the schemas, and also check the SYSIBM.SYSROUTINES catalog for the spelling
of the function name and the number and types of parameters.
SQLSTATE: 42601
© Copyright IBM Corp.
|
| |
