Skip to Content
0
Jun 19, 2015 at 05:05 PM

Syntax issue in script

28 Views

Hi All,

Please correct my syntax below, In debug mode the below is throwing error.

$GV_SQL = 'select distinct FILE_TYPE from ADMIN.SCH_EXE_HISTORY a where a.CYC_DATE = [$GV_DATE_CYC] and status = \'TRANSMITTED\' and file_type in (\'REV\',\'AUM\')';

25166 4112746272 DBS-070404 6/19/2015 1:04:21 PM SQL submitted to ODBC data source <apex> resulted in error <[IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token 25166 4112746272 DBS-070404 6/19/2015 1:04:21 PM "status = 'TRANSMITTED'" was found following "a.CYC_DATE = and". Expected tokens may include: "<space>". SQLSTATE=42601 25166 4112746272 DBS-070404 6/19/2015 1:04:21 PM >. The SQL submitted is <select distinct FILE_TYPE from ADMIN.SCH_EXE_HISTORY a where a.CYC_DATE = and status =