When i execute the below code in a STORED PROCEDURE i get an syntax error saying "Expects somthing like an EXCEPT keyword UNION keyword or MINUS keyword between a between a String and YYYYMMDD". Please help me fix this syntax error. Thanks.
Replace Procedure Sample_Proc(
BEGIN
DBC.SYSEXECSQL('Select CAST( (Event_Date (FORMAT 'YYYYMMDD') ) AS CHAR(10) ) AS EVNT_DATE;');
END
);
Regards
Arun