Ibm Db2 Error Code 104
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site
Errorcode=-4463 Sqlstate=42601
About Us Learn more about Stack Overflow the company Business Learn more sqlcode 514 about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss 42601 les mis Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up db2 sql error http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n104.html sqlcode=-104 sqlstate=42601 up vote 1 down vote favorite I am relatively new to DB2 but not to sql. I am experiencing the below error when trying a select statement while substracting a few minutes from a timestamp as below. SELECT * TCCAWZTXD.TCC_COIL_DEMODATA WHERE CURRENT_INSERTTIME BETWEEN(CURRENT_TIMESTAMP)-5 minutes AND CURRENT_TIMESTAMP The error that am experiencing is as below. DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=TCCAWZTXD;SELECT*;
here for a quick overview of the site Help Center Detailed answers to any questions you http://stackoverflow.com/questions/31960981/sql-error-db2-sql-error-sqlcode-104-sqlstate-42601-sqlerrmc-asfirst-100-ro might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community db2 sql of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQL Error: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=AS;FIRST 100 ROWS ONLY);), DRIVER=3.57.82 up vote -1 down vote favorite The below DB2 stored procedure compiled successfully but getting runtime error SQL Error: DB2 SQL Error: SQLCODE=-104, db2 sql error SQLSTATE=42601, SQLERRMC=AS;FIRST 100 ROWS ONLY);), DRIVER=3.57.82 Intention of the below db2 procedure is to delete the records from multiple tables with prepared statements. CREATE PROCEDURE ALL_DATA_PURGE1(IN v_SCHEMA_NAME VARCHAR(24),IN v_DAYS INTEGER, IN v_COMMIT_COUNT INTEGER) NOT DETERMINISTIC LANGUAGE SQL BEGIN -- DECLARE Statements DECLARE SQLCODE INTEGER; DECLARE v_CRAD_DELETE_QUERY VARCHAR(1024); DECLARE v_APPDATA_DELETE_QUERY VARCHAR(1024); DECLARE v_CRAD_DELETE_STATEMENT STATEMENT; DECLARE v_APPDATA_DELETE_STATEMENT STATEMENT; SET v_CRAD_DELETE_QUERY = 'DELETE FROM (SELECT 1 FROM ' || v_SCHEMA_NAME || '.CRAD WHERE UNIQUE_ID IN (SELECT UNIQUE_ID FROM ' || v_SCHEMA_NAME || '.APPDATA WHERE ORIGINATOR_TIMESTAMP < ( SELECT CURRENT TIMESTAMP - '|| v_DAYS ||' DAYS FROM SYSIBM.SYSDUMMY1) ) FETCH FIRST ' || v_COMMIT_COUNT || ' ROWS ONLY) AS DELETE_CRAD_TABLE'; SET v_APPDATA_DELETE_QUERY = 'DELETE FROM (SELECT 1 FROM ' || v_SCHEMA_NAME || '.APPDATA WHERE SOME_TIMESTAMP < ( SELECT CURRENT TIMESTAMP - ' || v_DAYS || ' days FROM sysibm.sysdummy1 ) FETCH FIRST ' || v_COMMIT_COUNT || ' ROWS ONLY) AS DELETE_APPDATA_TABLE'; PREPARE v_CRAD_DELETE_STATEMENT FROM v_CRAD_DELETE_QUERY; PREPARE v_APPDATA_DELETE_STATEMENT FROM v_APPDATA_DELETE_QUERY; DELETE_LOOP: LOOP EXECUTE v_CRAD_DELETE