We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
I keep getting this error, eventought the output is correct.
SQL0440N No authorized routine named "CONCAT" of type "FUNCTION" having
compatible arguments was found. SQLSTATE=42884
SQL0440N No authorized routine named "CONCAT" of type "FUNCTION" having
compatible arguments was found. SQLSTATE=42884
This is my query:
SELECT CONCAT(NAME,'(',LEFT(Occupation,1),')')
FROM OCCUPATIONS
ORDER BY NAME;
SELECT CONCAT('There are a total of',COUNT(OCCUPATION),' ',LOWER(Occupation),'s')
FROM OCCUPATIONS
GROUP BY OCCUPATION
ORDER BY COUNT(OCCUPATION), OCCUPATION;
The PADS
You are viewing a single comment's thread. Return to all comments →
I keep getting this error, eventought the output is correct.
SQL0440N No authorized routine named "CONCAT" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884 SQL0440N No authorized routine named "CONCAT" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884
This is my query: SELECT CONCAT(NAME,'(',LEFT(Occupation,1),')') FROM OCCUPATIONS ORDER BY NAME;
SELECT CONCAT('There are a total of',COUNT(OCCUPATION),' ',LOWER(Occupation),'s') FROM OCCUPATIONS GROUP BY OCCUPATION ORDER BY COUNT(OCCUPATION), OCCUPATION;
It seems some versions of SQL only allow CONCAT for 2 expressions. For more you can use || e.g. SELECT 'hello'||'world'
Or change the version of SQL in the top right corner.
I chose DB2 and got similar error. Changing it to MySQL worked, it is due to syntax of different sql servers.