469,632 Members | 1,796 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,632 developers. It's quick & easy.

SQL query

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,
Sep 3 '07 #1
3 837
debasisdas
8,127 Expert 4TB
As you have posted a question in the articles section it is being moved to SQL Server Forum.

MODERATOR.
Sep 3 '07 #2
azimmer
200 Expert 100+
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?
Sep 3 '07 #3
debasisdas
8,127 Expert 4TB
Here it is giving error ,I am not getting the error,
please specify clearly what is the error .
Post your table structure.
Sep 5 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by jaysonsch | last post: by
9 posts views Thread by netpurpose | last post: by
3 posts views Thread by Harvey | last post: by
4 posts views Thread by Diamondback | last post: by
14 posts views Thread by Dave Thomas | last post: by
4 posts views Thread by Stan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.