BINDV810L`'H $8L\l|$!B$dNULLID fSQLSERVIg110330!"$!$"!$#!$[ INCLUDE '../inc/sqlServices.h'nBEGIN DECLARE SECTIONpEND DECLARE SECTIONtCOMMITz ROLLBACKBEGIN DECLARE SECTIONEND DECLARE SECTIONKCONNECT TO :H00002 USER :H00003 USING :H00004 CONNECT TO :H00002  PREPARE S1 FROM :H00005  PREPARE S1 FROM :H00005 DECLARE C1 CURSOR FOR S1 DESCRIBE S1 INTO :H00006 OPEN C1(FETCH C1 USING DESCRIPTOR :H00006 (FETCH C1 USING DESCRIPTOR :H00006 BEGIN DECLARE SECTION END DECLARE SECTION*VALUES CURRENT TIMESTAMP into :H00007 *VALUES CURRENT TIMESTAMP into :H00007 BEGIN DECLARE SECTION"END DECLARE SECTION&#VALUES SYSTEM_USER into :H00008 *#VALUES SYSTEM_USER into :H00008 8BEGIN DECLARE SECTION:END DECLARE SECTION>%VALUES SESSION_USER into :H00009 B%VALUES SESSION_USER into :H00009 PBEGIN DECLARE SECTIONREND DECLARE SECTIONX(SET SESSION AUTHORIZATION :H00010 [ (SET SESSION AUTHORIZATION :H00010 b EXECUTE IMMEDIATE :H00005 BEGIN DECLARE SECTIONEND DECLARE SECTION NCALL db2qp.cancel(:H00011 :H00014, :H00012 :H00015, :H00013 :H00016) NCALL db2qp.cancel(:H00011 :H00017, :H00012 :H00018, :H00013 :H00019)BEGIN DECLARE SECTIONEND DECLARE SECTION  BCALL db2qp.setCompEnv(:H00020 :H00022, :H00021 :H00023)BCALL db2qp.setCompEnv(:H00020 :H00024, :H00021 :H00025)"BEGIN DECLARE SECTION$END DECLARE SECTION(1SET COMPILATION ENVIRONMENT = :H00026 +1SET COMPILATION ENVIRONMENT = :H00026 JBEGIN DECLARE SECTIONMEND DECLARE SECTIONQ=VALUES (TIMESTAMP(:H00028 )) into :H00027 U=VALUES (TIMESTAMP(:H00028 )) into :H00027 hBEGIN DECLARE SECTIONlEND DECLARE SECTIONqSELECT 1 INTO :H00029 FROM syscat.tables WHERE tabschema = :H00031 AND tabname = :H00030 wSELECT 1 INTO :H00029 FROM syscat.tables WHERE tabschema = :H00031 AND tabname = :H00030 BEGIN DECLARE SECTIONEND DECLARE SECTIONDECLARE RES_TABLE_ALIASES CURSOR FOR WITH A AS (SELECT TABSCHEMA, TABNAME FROM SYSCAT.TABLES WHERE TYPE = 'A' AND TABNAME LIKE 'QUERY%_RESULTS'), T AS (SELECT TABNAME FROM SYSCAT.TABLES WHERE TYPE = 'T' AND TABNAME LIKE 'QUERY%_RESULTS') SELECT ALL TABSCHEMA, TABNAME FROM A WHERE NOT EXISTS (SELECT * FROM T WHERE T.TABNAME = A.TABNAME) FOR FETCH ONLYOPEN RES_TABLE_ALIASESOPEN RES_TABLE_ALIASES;FETCH RES_TABLE_ALIASES INTO :H00032 , :H00033 $CLOSE RES_TABLE_ALIASES WITH RELEASEBEGIN DECLARE SECTIONEND DECLARE SECTIONSELECT 1 INTO :H00034 FROM syscat.routines WHERE routineschema = :H00036 AND routinename = :H00035 AND sql_data_access = 'R'SELECT 1 INTO :H00034 FROM syscat.routines WHERE routineschema = :H00036 AND routinename = :H00035 AND sql_data_access = 'R'NBEGIN DECLARE SECTIONPEND DECLARE SECTIONBEGIN DECLARE SECTIONEND DECLARE SECTION PREPARE S1 FROM :H00038  PREPARE S1 FROM :H00038  DESCRIBE S1 INTO :H00039 6 DESCRIBE S1 INTO :H00039 'H00001outputH00002connectDBAliasH00003 connectUserIdH00004connectPassword<H00005 sqlStatement<H00006 sqldaPointerH00007 currentTimeH00008 systemUserH00009 sessionUserH00010 sessionAuthIdH00011 cancelHandleH00012cancelIdH00013cancelRcH00014H00015H00016H00017H00018H00019H00020environmentValuesH00021envRcH00022H00023H00024H00025H00026environmentValues2H00027formattedTimestampH00028timestampStringH00029 dummyValueH00030tableNameStringH00031tableSchemaStringH00032 aliasSchemaH00033 aliasNameH00034 dummyValue2H00035procNameStringH00036procSchemaStringH00037procStmt H00038 queryText<H00039 querySqlda