i am try to run SQL query on MYSQL DB. i encounter following error.

(FOC1400) SQLCODE IS 1 (HEX: 00000001)
L (FOC1406) SQL OPEN CURSOR ERROR. : SQLOUT

i am running followings query:

SQL SQLMYSQL
CREATE OR REPLACE VIEW v_member AS
SELECT
members.member_id,
members.member_store_number,
members.member_store_district,
members.member_store_region
FROM members
WHERE
((members.member_store_number)!='99999')
AND ((trade_in_opt_out) = 0) AND ((partner_id)= 109);
END

SQL SQLMYSQL
PREPARE SQLOUT FOR
SELECT
v_member.member_store_region,
v_member.member_store_district,
v_member.member_store_number,
cart_items.ordered_time,
cart_items.physical_status,
cart_items.sku,
cart_items.description,
cart_items.original_price,
cart_items.cart_item_id,
orders.order_id,
cart_items.inspected_price,
cart_items.pre_promo_price,
cart_items.inspected_time

FROM
v_member
INNER JOIN (cart_items INNER JOIN orders ON cart_items.order_id = orders.order_id) ON v_member.member_id = orders.order_store_id
INNER JOIN products ON cart_items.product_id = products.product_id
INNER JOIN prod_categories ON products.category_id = prod_categories.category_id
WHERE
((cart_items.ordered_time) Between '2/3/2013' and ADDDATE(CURDATE(), INTERVAL WEEKDAY(CURDATE())+1 DAY)) AND
((cart_items.financial_status)='paid') AND ((category_reporting_id) NOT IN(4,10,11));
END

TABLE FILE SQLOUT
PRINT
*

This message has been edited. Last edited by: <Kathryn Henning>,

DB may have Lock.. issue with DB.. make sure you read DB