Why column alias is not set with the keyword "AS"?

Question

As mentioned in the title, I am unable to perform some simple query using the AS keyword. For example

SELECT COLUMN1 AS TESTING FROM TESTINGTABLE;

I get the following result.

COLUMN1
-------------
VALUE1

instead of

TESTING
--------------
VALUE1

However for

select 'abcd' as TESTING from sysibm.sysdummy1; 

I can get the following result

TESTING
--------------
abcd

Please help to give some direction... my db2 version is DB2 v11.1.0.1527

Answer 1

strange, try this formats:

SELECT COLUMN1 TESTING FROM TESTINGTABLE;

or this :

SELECT COLUMN1 AS "TESTING" FROM TESTINGTABLE;