0.000000 2024/02/28 09:18:04.830 0 DebugView++.exe File Identification Header, DebugView++ Format Version 1 0.000000 2024/02/28 09:16:42.347 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.347 PSQLTBL FILE,DRIVER('ODBC','/TURBOSQL=TRUE'),OWNER(******),NAME('PSQLTBL'),THREAD 0.000189 2024/02/28 09:16:42.347 5692 TestPSQLTrace.exe 0.000238 2024/02/28 09:16:42.347 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.347 0.000436 2024/02/28 09:16:42.347 5692 TestPSQLTrace.exe RECORD 0.000584 2024/02/28 09:16:42.347 5692 TestPSQLTrace.exe 0.000691 2024/02/28 09:16:42.348 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.347 PSQL:FIELD1 CSTRING(50000) 0.000789 2024/02/28 09:16:42.348 5692 TestPSQLTrace.exe 0.000835 2024/02/28 09:16:42.348 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.348 PSQL:FIELD2 CSTRING(50000) 0.000913 2024/02/28 09:16:42.348 5692 TestPSQLTrace.exe 0.000993 2024/02/28 09:16:42.348 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.348 PSQL:FIELD3 CSTRING(50000) 0.001046 2024/02/28 09:16:42.348 5692 TestPSQLTrace.exe 0.001109 2024/02/28 09:16:42.348 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.348 PSQL:FIELD4 CSTRING(50000) 0.001182 2024/02/28 09:16:42.348 5692 TestPSQLTrace.exe 0.001331 2024/02/28 09:16:42.348 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.348 PSQL:FIELD5 CSTRING(50000) 0.001398 2024/02/28 09:16:42.348 5692 TestPSQLTrace.exe 0.001719 2024/02/28 09:16:42.349 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.348 PSQL:FIELD6 CSTRING(50000) 0.001779 2024/02/28 09:16:42.349 5692 TestPSQLTrace.exe 0.001860 2024/02/28 09:16:42.349 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.349 PSQL:FIELD7 CSTRING(50000) 0.001931 2024/02/28 09:16:42.349 5692 TestPSQLTrace.exe 0.002010 2024/02/28 09:16:42.349 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.349 PSQL:FIELD8 CSTRING(50000) 0.002077 2024/02/28 09:16:42.349 5692 TestPSQLTrace.exe 0.002151 2024/02/28 09:16:42.349 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.349 PSQL:FIELD9 CSTRING(50000) 0.002220 2024/02/28 09:16:42.349 5692 TestPSQLTrace.exe 0.002291 2024/02/28 09:16:42.349 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.349 PSQL:FIELD10 CSTRING(50000) 0.002365 2024/02/28 09:16:42.349 5692 TestPSQLTrace.exe 0.002438 2024/02/28 09:16:42.349 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.349 PSQL:FIELD11 CSTRING(50000) 0.002517 2024/02/28 09:16:42.349 5692 TestPSQLTrace.exe 0.002811 2024/02/28 09:16:42.350 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.350 PSQL:FIELD12 CSTRING(50000) 0.002949 2024/02/28 09:16:42.350 5692 TestPSQLTrace.exe 0.003037 2024/02/28 09:16:42.350 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.350 PSQL:FIELD13 CSTRING(50000) 0.003126 2024/02/28 09:16:42.350 5692 TestPSQLTrace.exe 0.003212 2024/02/28 09:16:42.350 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.350 PSQL:FIELD14 CSTRING(50000) 0.003295 2024/02/28 09:16:42.350 5692 TestPSQLTrace.exe 0.003417 2024/02/28 09:16:42.350 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.350 PSQL:FIELD15 CSTRING(50000) 0.003570 2024/02/28 09:16:42.350 5692 TestPSQLTrace.exe 0.003698 2024/02/28 09:16:42.350 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.350 PSQL:FIELD16 CSTRING(50000) 0.003919 2024/02/28 09:16:42.350 5692 TestPSQLTrace.exe 0.003980 2024/02/28 09:16:42.350 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.350 PSQL:FIELD17 CSTRING(50000) 0.004104 2024/02/28 09:16:42.350 5692 TestPSQLTrace.exe 0.004165 2024/02/28 09:16:42.350 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.350 PSQL:FIELD18 CSTRING(50000) 0.004291 2024/02/28 09:16:42.350 5692 TestPSQLTrace.exe 0.004362 2024/02/28 09:16:42.350 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.350 PSQL:FIELD19 CSTRING(50000) 0.004450 2024/02/28 09:16:42.350 5692 TestPSQLTrace.exe 0.004587 2024/02/28 09:16:42.350 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.350 PSQL:FIELD20 CSTRING(50000) 0.004737 2024/02/28 09:16:42.352 5692 TestPSQLTrace.exe 0.004878 2024/02/28 09:16:42.352 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.352 PSQL:FIELD21 CSTRING(50000) 0.005011 2024/02/28 09:16:42.352 5692 TestPSQLTrace.exe 0.005083 2024/02/28 09:16:42.352 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.352 PSQL:FIELD22 CSTRING(50000) 0.005206 2024/02/28 09:16:42.352 5692 TestPSQLTrace.exe 0.005326 2024/02/28 09:16:42.352 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.352 PSQL:FIELD23 CSTRING(50000) 0.005467 2024/02/28 09:16:42.352 5692 TestPSQLTrace.exe 0.005531 2024/02/28 09:16:42.352 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.352 PSQL:FIELD24 CSTRING(50000) 0.005652 2024/02/28 09:16:42.352 5692 TestPSQLTrace.exe 0.005823 2024/02/28 09:16:42.353 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.352 PSQL:FIELD25 CSTRING(50000) 0.005961 2024/02/28 09:16:42.353 5692 TestPSQLTrace.exe 0.006043 2024/02/28 09:16:42.353 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.353 0.006155 2024/02/28 09:16:42.353 5692 TestPSQLTrace.exe END 0.006290 2024/02/28 09:16:42.353 5692 TestPSQLTrace.exe 0.006328 2024/02/28 09:16:42.353 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.353 0.006465 2024/02/28 09:16:42.353 5692 TestPSQLTrace.exe END 0.006567 2024/02/28 09:16:42.353 5692 TestPSQLTrace.exe 0.006756 2024/02/28 09:16:42.354 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.353 0.006816 2024/02/28 09:16:42.354 5692 TestPSQLTrace.exe 0.006941 2024/02/28 09:16:42.354 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.354 SET_PROPERTY(PSQLTBL:047A0008H) Time Taken: 0.006980 2024/02/28 09:16:42.354 5692 TestPSQLTrace.exe 0.00 secs 0.007076 2024/02/28 09:16:42.354 5692 TestPSQLTrace.exe 0.007205 2024/02/28 09:16:42.354 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.354 SET_PROPERTY(PSQLTBL:047A0008H) Time Taken: 0.007291 2024/02/28 09:16:42.354 5692 TestPSQLTrace.exe 0.00 secs 0.007375 2024/02/28 09:16:42.354 5692 TestPSQLTrace.exe 0.007463 2024/02/28 09:16:42.354 5692 TestPSQLTrace.exe Your ODS messages can be interspersed with the database trace messages before the DB operation. 0.007578 2024/02/28 09:16:42.354 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.354 Allocating Statement 0D25F98H on Connection 0D25C50H Time Taken: 0.007662 2024/02/28 09:16:42.354 5692 TestPSQLTrace.exe 0.00 secs 0.007746 2024/02/28 09:16:42.354 5692 TestPSQLTrace.exe 0.007854 2024/02/28 09:16:42.354 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.354 Setting Concurrency to Read Only for Statement 0D25F98H Time Taken: 0.007938 2024/02/28 09:16:42.354 5692 TestPSQLTrace.exe 0.00 secs 0.008023 2024/02/28 09:16:42.354 5692 TestPSQLTrace.exe 0.008112 2024/02/28 09:16:42.354 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.354 Setting Cursor Type to Forward Only for Statement 0D25F98H Time Taken: 0.008196 2024/02/28 09:16:42.354 5692 TestPSQLTrace.exe 0.00 secs 0.008291 2024/02/28 09:16:42.354 5692 TestPSQLTrace.exe 0.008424 2024/02/28 09:16:42.354 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.354 Resetting Parameters Statement 0D25F98H Time Taken: 0.008494 2024/02/28 09:16:42.355 5692 TestPSQLTrace.exe 0.00 secs 0.008581 2024/02/28 09:16:42.355 5692 TestPSQLTrace.exe 0.008713 2024/02/28 09:16:42.355 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.355 Preparing Statement 0D25F98H : select count(*) from activationdatahistory where ipaddress is not null Time Taken: 0.008797 2024/02/28 09:16:42.355 5692 TestPSQLTrace.exe 0.00 secs 0.008881 2024/02/28 09:16:42.355 5692 TestPSQLTrace.exe 0.293182 2024/02/28 09:16:42.640 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.355 Executing prepared Statement 0D25F98H Time Taken: 0.293663 2024/02/28 09:16:42.640 5692 TestPSQLTrace.exe 0.28 secs 0.293776 2024/02/28 09:16:42.640 5692 TestPSQLTrace.exe 0.294001 2024/02/28 09:16:42.640 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.640 Getting Number of columns for Statement 0D25F98H Time Taken: 0.294402 2024/02/28 09:16:42.641 5692 TestPSQLTrace.exe 0.00 secs 0.294437 2024/02/28 09:16:42.641 5692 TestPSQLTrace.exe 0.294614 2024/02/28 09:16:42.641 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.641 Setting number of rows to fetch to 1 for Statement 0D25F98H Time Taken: 0.295011 2024/02/28 09:16:42.641 5692 TestPSQLTrace.exe 0.00 secs 0.295112 2024/02/28 09:16:42.641 5692 TestPSQLTrace.exe 0.295285 2024/02/28 09:16:42.641 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.641 Describing Column 1 for Statement 0D25F98H Time Taken: 0.295366 2024/02/28 09:16:42.641 5692 TestPSQLTrace.exe 0.00 secs 0.295491 2024/02/28 09:16:42.641 5692 TestPSQLTrace.exe 0.295673 2024/02/28 09:16:42.643 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.641 Getting Auto-increment state for Column 1 for Statement 0D25F98H Time Taken: 0.295725 2024/02/28 09:16:42.643 5692 TestPSQLTrace.exe 0.00 secs 0.295818 2024/02/28 09:16:42.643 5692 TestPSQLTrace.exe 0.295872 2024/02/28 09:16:42.643 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.643 Getting Searchable state for Column 1 for Statement 0D25F98H Time Taken: 0.295982 2024/02/28 09:16:42.643 5692 TestPSQLTrace.exe 0.00 secs 0.296172 2024/02/28 09:16:42.643 5692 TestPSQLTrace.exe 0.296351 2024/02/28 09:16:42.643 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.643 SET_PROPERTY(PSQLTBL:047A0008H) Time Taken: 0.296464 2024/02/28 09:16:42.643 5692 TestPSQLTrace.exe 0.30 secs 0.296548 2024/02/28 09:16:42.643 5692 TestPSQLTrace.exe 0.296717 2024/02/28 09:16:42.643 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.643 Binding Column 1 to C type CHAR(50000) for Statement 0D25F98H Time Taken: 0.296901 2024/02/28 09:16:42.644 5692 TestPSQLTrace.exe 0.00 secs 0.296967 2024/02/28 09:16:42.644 5692 TestPSQLTrace.exe 0.297074 2024/02/28 09:16:42.644 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.644 Fetching Row from Statement 0D25F98H Return Code: 0 Time Taken: 0.297139 2024/02/28 09:16:42.644 5692 TestPSQLTrace.exe 0.00 secs 0.297210 2024/02/28 09:16:42.644 5692 TestPSQLTrace.exe 0.299260 2024/02/28 09:16:42.646 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.646 NEXT(PSQLTBL:047A0008H) Time Taken: 0.299331 2024/02/28 09:16:42.646 5692 TestPSQLTrace.exe 0.00 secs 0.299429 2024/02/28 09:16:42.646 5692 TestPSQLTrace.exe 0.299814 2024/02/28 09:16:42.647 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.646 PSQL:FIELD1 : '1156342' 0.299874 2024/02/28 09:16:42.647 5692 TestPSQLTrace.exe 0.300017 2024/02/28 09:16:42.647 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.647 PSQL:FIELD2 : '' 0.300079 2024/02/28 09:16:42.647 5692 TestPSQLTrace.exe 0.300179 2024/02/28 09:16:42.647 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.647 PSQL:FIELD3 : '' 0.300385 2024/02/28 09:16:42.647 5692 TestPSQLTrace.exe 0.300476 2024/02/28 09:16:42.647 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.647 PSQL:FIELD4 : '' 0.300602 2024/02/28 09:16:42.647 5692 TestPSQLTrace.exe 0.300678 2024/02/28 09:16:42.647 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.647 PSQL:FIELD5 : '' 0.300759 2024/02/28 09:16:42.647 5692 TestPSQLTrace.exe 0.300868 2024/02/28 09:16:42.647 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.647 PSQL:FIELD6 : '' 0.300951 2024/02/28 09:16:42.647 5692 TestPSQLTrace.exe 0.301016 2024/02/28 09:16:42.647 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.647 PSQL:FIELD7 : '' 0.301128 2024/02/28 09:16:42.647 5692 TestPSQLTrace.exe 0.301387 2024/02/28 09:16:42.648 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.648 PSQL:FIELD8 : '' 0.301488 2024/02/28 09:16:42.648 5692 TestPSQLTrace.exe 0.301661 2024/02/28 09:16:42.648 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.648 PSQL:FIELD9 : '' 0.301780 2024/02/28 09:16:42.648 5692 TestPSQLTrace.exe 0.301870 2024/02/28 09:16:42.648 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.648 PSQL:FIELD10: '' 0.301956 2024/02/28 09:16:42.648 5692 TestPSQLTrace.exe 0.302088 2024/02/28 09:16:42.648 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.648 PSQL:FIELD11: '' 0.302182 2024/02/28 09:16:42.648 5692 TestPSQLTrace.exe 0.302533 2024/02/28 09:16:42.649 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.648 PSQL:FIELD12: '' 0.302640 2024/02/28 09:16:42.649 5692 TestPSQLTrace.exe 0.302745 2024/02/28 09:16:42.649 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.649 PSQL:FIELD13: '' 0.302832 2024/02/28 09:16:42.649 5692 TestPSQLTrace.exe 0.302927 2024/02/28 09:16:42.649 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.649 PSQL:FIELD14: '' 0.303013 2024/02/28 09:16:42.649 5692 TestPSQLTrace.exe 0.303113 2024/02/28 09:16:42.649 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.649 PSQL:FIELD15: '' 0.303197 2024/02/28 09:16:42.649 5692 TestPSQLTrace.exe 0.303305 2024/02/28 09:16:42.649 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.649 PSQL:FIELD16: '' 0.303390 2024/02/28 09:16:42.649 5692 TestPSQLTrace.exe 0.303483 2024/02/28 09:16:42.649 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.649 PSQL:FIELD17: '' 0.303566 2024/02/28 09:16:42.649 5692 TestPSQLTrace.exe 0.303659 2024/02/28 09:16:42.649 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.649 PSQL:FIELD18: '' 0.303742 2024/02/28 09:16:42.649 5692 TestPSQLTrace.exe 0.303833 2024/02/28 09:16:42.649 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.649 PSQL:FIELD19: '' 0.303916 2024/02/28 09:16:42.649 5692 TestPSQLTrace.exe 0.304015 2024/02/28 09:16:42.649 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.649 PSQL:FIELD20: '' 0.304076 2024/02/28 09:16:42.649 5692 TestPSQLTrace.exe 0.304181 2024/02/28 09:16:42.651 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.649 PSQL:FIELD21: '' 0.304292 2024/02/28 09:16:42.651 5692 TestPSQLTrace.exe 0.304377 2024/02/28 09:16:42.651 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.651 PSQL:FIELD22: '' 0.304459 2024/02/28 09:16:42.651 5692 TestPSQLTrace.exe 0.304551 2024/02/28 09:16:42.651 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.651 PSQL:FIELD23: '' 0.304642 2024/02/28 09:16:42.651 5692 TestPSQLTrace.exe 0.304731 2024/02/28 09:16:42.651 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.651 PSQL:FIELD24: '' 0.304812 2024/02/28 09:16:42.651 5692 TestPSQLTrace.exe 0.304917 2024/02/28 09:16:42.651 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.651 PSQL:FIELD25: '' 0.304999 2024/02/28 09:16:42.651 5692 TestPSQLTrace.exe 0.305084 2024/02/28 09:16:42.651 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.651 0.305153 2024/02/28 09:16:42.651 5692 TestPSQLTrace.exe 0.305259 2024/02/28 09:16:42.652 5692 TestPSQLTrace.exe query ok, returned value=1156342 0.305361 2024/02/28 09:16:42.652 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.652 SET_PROPERTY(PSQLTBL:047A0008H) Time Taken: 0.305445 2024/02/28 09:16:42.652 5692 TestPSQLTrace.exe 0.00 secs 0.305527 2024/02/28 09:16:42.652 5692 TestPSQLTrace.exe 0.305622 2024/02/28 09:16:42.652 5692 TestPSQLTrace.exe 0163CH(1) 09:16:42.652 SET_PROPERTY(PSQLTBL:047A0008H) Time Taken: 0.305721 2024/02/28 09:16:42.652 5692 TestPSQLTrace.exe 0.00 secs 0.305813 2024/02/28 09:16:42.652 5692 TestPSQLTrace.exe 0.306143 2024/02/28 09:16:42.652 5692 TestPSQLTrace.exe Your ODS messages can be interspersed with the database trace messages after the DB operation. 0.382316 2024/02/28 09:16:42.729 5692 TestPSQLTrace.exe