OBTEDOCUENTA

CREATE OR ALTER PROCEDURE OBTEDOCUENTA (PAR_CLIENTE_ID INTEGER)
RETURNS (FECHA DATE,
MONTO FLOAT,
TIPO VARCHAR(50) CHARACTER SET NONE)
AS
BEGIN SUSPEND; END ^
CREATE OR ALTER PROCEDURE OBTEDOCUENTA2 (PAR_CLIENTE_ID INTEGER)
RETURNS (FECHA TIMESTAMP,
MONTO NUMERIC(15, 4),
TIPO VARCHAR(50) CHARACTER SET NONE)
AS
BEGIN SUSPEND; END ^
CREATE OR ALTER PROCEDURE OBTEDOCUENTA3 (PAR_CLIENTE_ID INTEGER)
RETURNS (FECHA TIMESTAMP,
MONTO NUMERIC(15, 4),
TIPO VARCHAR(50) CHARACTER SET NONE)
AS
BEGIN SUSPEND; END ^
CREATE OR ALTER PROCEDURE POS (SUBSTR VARCHAR(255) CHARACTER SET NONE,
STR VARCHAR(255) CHARACTER SET NONE)
RETURNS (POS INTEGER)
AS
BEGIN SUSPEND; END ^
CREATE OR ALTER PROCEDURE YEARWEEK (D DATE)
RETURNS (WEEK_NO VARCHAR(8) CHARACTER SET NONE)
AS
BEGIN SUSPEND; END ^
CREATE OR ALTER PROCEDURE YEAR_WEEK (IDENTRADA INTEGER,
D DATE)
RETURNS (ID INTEGER,
WEEK_NO VARCHAR(8) CHARACTER SET NONE)
AS
BEGIN SUSPEND; END ^

SET TERM ;