Re: Stored Procedures and I/O

Hi, I am new to stored procedures. I have understood the concept of stored procedure. But I am not able to understand that where to code the stored procedure. If I code it in SQL assistance it is giving me syntax error in creates statement itself. Same is the case with BTEQ utility. Please help me out. Thanks in advance

Conditions- All columns (except for filter and sub_period) must contain data- Output-table must exist before the script is executed- format of the output-table: main_period, sub_period, KPI_RULE, KPI_Value