Hi All,

PLease help me solve this syntax error.

select * ,'ALL' as all from TEST.SAMPLE;

Error:
3:42:37 [SELECT - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] An unexpected token "*" was found following "select ". Expected tokens may include: "?".

Trying to add a column to the select results.

Thanks in Advance,
Venky

Select * tells DB2 to Select all columns.
Your statement should look like - SELECT * FROM Test.Sample

When naming your own column in your results you would do something like:
SELECT count(*) as CNT FROM Test.Sample
or
SELECT fName as FirstName FROM Test.Sample

try:
select T.* ,'ALL' as all from TEST.SAMPLE T;

Thanks this works,