All for some reason the BITAND function is not working. The query I am trying to run through SQL Assistant is SELECT BITAND(9,8);
The error I am getting is:
SELECT Failed. 9881: Function BITAND called with an invalid number or type of parameters
Any clue on what is going on?
Works for me, what's your TD release?
Which overloaded functions exist on your system?
SELECT DatabaseName, FunctionName, ParameterDataTypes
WHERE FunctionName = 'BITAND'
Here is the ouput of the query. The version is 14.10.03.03
TD_SYSFNLIB BITAND I8BF
Figured it out. It is being overloaded so I basically did SELECT TD_SYSFNLIB.BITAND(9,8) and it worked. Thanks for making me think that it might be getting overloaded!
It's the BITAND in SYSLIB (previously installed as user UDFs at your site), which comes before TD_SYSFNLIB in the search path.