Hi,

When I try to create asp in db2, it gives me the following error:

db2 -tf sp_get_flag_data.sql
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "CREATE PROCEDURE sp_get_flag_data ( IN p"
was
found following "BEGIN-OF-STATEMENT". Expected tokens may include:
"<values>". LINE NUMBER=14. SQLSTATE=42601

sp_get_flag_data.sql
CREATE PROCEDURE sp_get_flag_data
(
IN p_mdata_source_i INT,
IN p_mdata_dob_d DATE,
IN p_mdata_source_instance_c VARCHAR(12),
IN p_mdata_record_i INT
)
LANGUAGE SQL
BEGIN
SELECT FLAG_TRANSACTION_STREAM_I
,FLAG_TYPE_I
,FLAG_DOMAIN_I
,FLAG_C
FROM JS_FLAG_TRAN_DATA_TB
WHERE MDATA_SOURCE_I =
p_mdata_source_i
AND MDATA_DOB_D =
p_mdata_dob_d
AND MDATA_SOURCE_INSTANCE_I =
p_mdata_source_instance_i
AND MDATA_RECORD_I =
p_mdata_record_i
WITH UR
;
END

Any thoughts .......

DB2 & UDB email list listserv db2-l LazyDBA home page