how to declare and use a variable

[bkj123]

Hello -
2 questions please:
(1) How do I declare and use a variable? In the code below, I'm looking to declare a variable and use it in a WHERE statement..

DECLARE vsor_id CHAR(7);
SET vsor_id = 'V','I';

SELECT
count(*)
FROM
bkj_churn_def
WHERE
sor_id in vsor_id);

/* The actual code is*/
SELECT
count(*)
FROM
bkj_churn_def
WHERE
sor_id in ('V','I');

However, I'm getting a syntax error: 3706: syntax error: expected something between the beginning of the request and the 'DECLARE' keyword.

How can I resolve?

(2) What terdata reference books would you recommend besides "Teradata SQL Unleash the Power" by Larkins & Coffing?

Thank you.

 

[ns1909]

am assuming that u r trying to submit a stored procedure.
u cannot perform SELECT in sp. u need to have SELECT INTO.



Try referencing manual provided by Teradata.
These manual are also available on

http://www.ncr.com