SQL query

[arpitapal]

EXEC SQL
SELECT VOTE_RCVD_ERS
, VOTE_RSLT
, VOTE_CTGRY
INTO :TWGRTVOT-VOTE-RCVD-ERS
,:TWGRTVOT-VOTE-RSLT
,:TWGRTVOT-VOTE-CTGRY
FROM TWGRTVOT
WHERE SYS_ID = :TWGMSCP-SYS-ID
AND SCHM_POL_IND = :TWGMSCP-SCHM-POL-IND
AND EXT_SCHM_POL_REF = :TWGMSCP-EXT-SCHM-POL-REF
AND MDFD_SEQ = :W03-MAX-MDFD-SEQ
AND VOTE_RCVD_ERS BETWEEN DATE(:P-H5-DTE-1)
AND DATE(:P-H5-DTE-12)
END-EXEC


Here it is giving error ,I am not getting the error,

[debasisdas]

As you have posted a question in the articles section it is being moved to SQL Server Forum.

MODERATOR.

[azimmer]

EXEC SQL
SELECT VOTE_RCVD_ERS
, VOTE_RSLT
, VOTE_CTGRY
INTO :TWGRTVOT-VOTE-RCVD-ERS
,:TWGRTVOT-VOTE-RSLT
,:TWGRTVOT-VOTE-CTGRY
FROM TWGRTVOT
WHERE SYS_ID = :TWGMSCP-SYS-ID
AND SCHM_POL_IND = :TWGMSCP-SCHM-POL-IND
AND EXT_SCHM_POL_REF = :TWGMSCP-EXT-SCHM-POL-REF
AND MDFD_SEQ = :W03-MAX-MDFD-SEQ
AND VOTE_RCVD_ERS BETWEEN DATE(:P-H5-DTE-1)
AND DATE(:P-H5-DTE-12)
END-EXEC


Here it is giving error ,I am not getting the error,

Sorry, but it's rather confuse: where do you get what error, and where do you not? What are the items starting with colons? (They're not SQL-compliant.) What is it that you're trying to achieve?

[debasisdas]

Here it is giving error ,I am not getting the error,

please specify clearly what is the error .
Post your table structure.