ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/branches/udr/udr/testsuite/udrlib/Reference.log
Revision: 392
Committed: Wed Feb 9 16:17:50 2022 UTC (2 years, 2 months ago) by tony
File size: 136844 byte(s)
Log Message: 
cloneAttachment and GetServiceManager added

File Contents

# Content
1 Running UDR Lib Testsuite
2 ------------------------
3 Running Test01
4 ------------------------
5 No entry for terminal type "xterm-256color";
6 using dumb terminal settings.
7
8 MYROWCOUNT
9 ============
10 42
11
12
13 MYROWCOUNT
14 ============
15 21
16
17
18 MYROWCOUNT
19 ============
20 Statement failed, SQLSTATE = 42S02
21 Dynamic SQL Error
22 -SQL error code = -204
23 -Table unknown
24 -BAD
25 -At line 1, column 22
26 -At function 'MYROWCOUNT'
27
28 UDRINFO
29 ===============================
30 Hello World
31
32 Repeat with USER=TESTER
33 No entry for terminal type "xterm-256color";
34 using dumb terminal settings.
35
36 MYROWCOUNT
37 ============
38 42
39
40
41 MYROWCOUNT
42 ============
43 21
44
45
46 MYROWCOUNT
47 ============
48 Statement failed, SQLSTATE = 42S02
49 Dynamic SQL Error
50 -SQL error code = -204
51 -Table unknown
52 -BAD
53 -At line 1, column 22
54 -At function 'MYROWCOUNT'
55
56 UDRINFO
57 ===============================
58 Hello World
59
60 ------------------------
61 Running Test02
62 ------------------------
63 No entry for terminal type "xterm-256color";
64 using dumb terminal settings.
65
66 SALARY FULLNAME
67 ===================== ====================================
68 81810.19 Fisher, Pete
69
70 Statement failed, SQLSTATE = 42S01
71 unsuccessful metadata update
72 -CREATE TABLE TESTME failed
73 -Table TESTME already exists
74 -At procedure 'MYERRORPROC'
75 Statement failed, SQLSTATE = 23000
76 validation error for column "EMPLOYEE"."FIRST_NAME", value "*** null ***"
77 -At procedure 'MYERRORPROC'
78 Statement failed, SQLSTATE = HY000
79 You have a bug
80 -At procedure 'MYERRORPROC'
81 Repeat with USER=TESTER
82 No entry for terminal type "xterm-256color";
83 using dumb terminal settings.
84
85 SALARY FULLNAME
86 ===================== ====================================
87 81810.19 Fisher, Pete
88
89 Statement failed, SQLSTATE = 42000
90 unsuccessful metadata update
91 -CREATE TABLE TESTME failed
92 -No permission for CREATE TABLE operation
93 -At procedure 'MYERRORPROC'
94 Statement failed, SQLSTATE = 28000
95 no permission for USAGE access to GENERATOR EMP_NO_GEN
96 -Effective user is TESTER
97 -At procedure 'MYERRORPROC'
98 Statement failed, SQLSTATE = HY000
99 You have a bug
100 -At procedure 'MYERRORPROC'
101 ------------------------
102 Running Test03
103 ------------------------
104 No entry for terminal type "xterm-256color";
105 using dumb terminal settings.
106
107 FULLNAME SALARY ACCSALARY
108 ==================================== ===================== =====================
109 Nelson, Robert 105900.00 105900.00
110 Young, Bruce 97500.00 203400.00
111 Lambert, Kim 102750.00 306150.00
112 Johnson, Leslie 64635.00 370785.00
113 Forest, Phil 75060.00 445845.00
114 Weston, K. J. 86292.94 532137.94
115 Lee, Terri 53793.00 585930.94
116 Hall, Stewart 69482.63 655413.57
117 Young, Katherine 67241.25 722654.82
118 Papadopoulos, Chris 89655.00 812309.82
119 Fisher, Pete 81810.19 894120.01
120 Bennet, Ann 22935.00 917055.01
121 De Souza, Roger 69482.63 986537.64
122 Baldwin, Janet 61637.81 1048175.45
123 Reeves, Roger 33620.63 1081796.08
124 Stansbury, Willie 39224.06 1121020.14
125 Phong, Leslie 56034.38 1177054.52
126 Ramanathan, Ashok 80689.50 1257744.02
127 Steadman, Walter 116100.00 1373844.02
128 Nordstrom, Carol 42742.50 1416586.52
129
130 FULLNAME SALARY ACCSALARY
131 ==================================== ===================== =====================
132 Leung, Luke 68805.00 1485391.52
133 O'Brien, Sue Anne 31275.00 1516666.52
134 Burbank, Jennifer M. 53167.50 1569834.02
135 Sutherland, Claudia 100914.00 1670748.02
136 Bishop, Dana 62550.00 1733298.02
137 MacDonald, Mary S. 111262.50 1844560.52
138 Williams, Randy 56295.00 1900855.52
139 Bender, Oliver H. 212850.00 2113705.52
140 Cook, Kevin 111262.50 2224968.02
141 Brown, Kelly 27000.00 2251968.02
142 Ichida, Yuki 6000000.00 8251968.02
143 Page, Mary 48000.00 8299968.02
144 Parker, Bill 35000.00 8334968.02
145 Yamamoto, Takashi 7480000.00 15814968.02
146 Ferrari, Roberto 33000.00 15847968.02
147 Yanowski, Michael 44000.00 15891968.02
148 Glon, Jacques 38500.00 15930468.02
149 Johnson, Scott 60000.00 15990468.02
150 Green, T.J. 36000.00 16026468.02
151 Osborne, Pierre 110000.00 16136468.02
152
153 FULLNAME SALARY ACCSALARY
154 ==================================== ===================== =====================
155 Montgomery, John 35000.00 16171468.02
156 Guckenheimer, Mark 32000.00 16203468.02
157
158
159 TEXT
160 ====================================================================================================
161 To be or not to be-that is the question:
162 Whether 'tis nobler in the mind to suffer
163 The slings and arrows of outrageous fortune,
164 Or to take arms against a sea of troubles,
165 And, by opposing, end them. To die, to sleep-
166 No more-and by a sleep to say we end
167 The heartache and the thousand natural shocks
168 That flesh is heir to-'tis a consummation
169 Devoutly to be wished. To die, to sleep-
170 To sleep, perchance to dream. Aye, there's the rub,
171 For in that sleep of death what dreams may come,
172 When we have shuffled off this mortal coil,
173 Must give us pause. There's the respect
174 That makes calamity of so long life.
175 For who would bear the whips and scorns of time,
176 Th' oppressor's wrong, the proud man's contumely,
177 The pangs of despised love, the law’s delay,
178 The insolence of office, and the spurns
179 That patient merit of the unworthy takes,
180 When he himself might his quietus make
181
182 TEXT
183 ====================================================================================================
184 With a bare bodkin? Who would fardels bear,
185 To grunt and sweat under a weary life,
186 But that the dread of something after death,
187 The undiscovered country from whose bourn
188 No traveler returns, puzzles the will
189 And makes us rather bear those ills we have
190 Than fly to others that we know not of?
191 Thus conscience does make cowards of us all,
192 And thus the native hue of resolution
193 Is sicklied o'er with the pale cast of thought,
194 And enterprises of great pitch and moment,
195 With this regard their currents turn awry,
196 And lose the name of action.-Soft you now,
197 The fair Ophelia.-Nymph, in thy orisons
198 Be all my sins remembered
199
200
201 TEXT
202 ====================================================================================================
203 Statement failed, SQLSTATE = 42000
204 validation error for variable TEXT, value "*** null ***"
205 -At procedure 'MYREADTEXT'
206 Repeat with USER=TESTER
207 No entry for terminal type "xterm-256color";
208 using dumb terminal settings.
209
210 FULLNAME SALARY ACCSALARY
211 ==================================== ===================== =====================
212 Nelson, Robert 105900.00 105900.00
213 Young, Bruce 97500.00 203400.00
214 Lambert, Kim 102750.00 306150.00
215 Johnson, Leslie 64635.00 370785.00
216 Forest, Phil 75060.00 445845.00
217 Weston, K. J. 86292.94 532137.94
218 Lee, Terri 53793.00 585930.94
219 Hall, Stewart 69482.63 655413.57
220 Young, Katherine 67241.25 722654.82
221 Papadopoulos, Chris 89655.00 812309.82
222 Fisher, Pete 81810.19 894120.01
223 Bennet, Ann 22935.00 917055.01
224 De Souza, Roger 69482.63 986537.64
225 Baldwin, Janet 61637.81 1048175.45
226 Reeves, Roger 33620.63 1081796.08
227 Stansbury, Willie 39224.06 1121020.14
228 Phong, Leslie 56034.38 1177054.52
229 Ramanathan, Ashok 80689.50 1257744.02
230 Steadman, Walter 116100.00 1373844.02
231 Nordstrom, Carol 42742.50 1416586.52
232
233 FULLNAME SALARY ACCSALARY
234 ==================================== ===================== =====================
235 Leung, Luke 68805.00 1485391.52
236 O'Brien, Sue Anne 31275.00 1516666.52
237 Burbank, Jennifer M. 53167.50 1569834.02
238 Sutherland, Claudia 100914.00 1670748.02
239 Bishop, Dana 62550.00 1733298.02
240 MacDonald, Mary S. 111262.50 1844560.52
241 Williams, Randy 56295.00 1900855.52
242 Bender, Oliver H. 212850.00 2113705.52
243 Cook, Kevin 111262.50 2224968.02
244 Brown, Kelly 27000.00 2251968.02
245 Ichida, Yuki 6000000.00 8251968.02
246 Page, Mary 48000.00 8299968.02
247 Parker, Bill 35000.00 8334968.02
248 Yamamoto, Takashi 7480000.00 15814968.02
249 Ferrari, Roberto 33000.00 15847968.02
250 Yanowski, Michael 44000.00 15891968.02
251 Glon, Jacques 38500.00 15930468.02
252 Johnson, Scott 60000.00 15990468.02
253 Green, T.J. 36000.00 16026468.02
254 Osborne, Pierre 110000.00 16136468.02
255
256 FULLNAME SALARY ACCSALARY
257 ==================================== ===================== =====================
258 Montgomery, John 35000.00 16171468.02
259 Guckenheimer, Mark 32000.00 16203468.02
260
261
262 TEXT
263 ====================================================================================================
264 To be or not to be-that is the question:
265 Whether 'tis nobler in the mind to suffer
266 The slings and arrows of outrageous fortune,
267 Or to take arms against a sea of troubles,
268 And, by opposing, end them. To die, to sleep-
269 No more-and by a sleep to say we end
270 The heartache and the thousand natural shocks
271 That flesh is heir to-'tis a consummation
272 Devoutly to be wished. To die, to sleep-
273 To sleep, perchance to dream. Aye, there's the rub,
274 For in that sleep of death what dreams may come,
275 When we have shuffled off this mortal coil,
276 Must give us pause. There's the respect
277 That makes calamity of so long life.
278 For who would bear the whips and scorns of time,
279 Th' oppressor's wrong, the proud man's contumely,
280 The pangs of despised love, the law’s delay,
281 The insolence of office, and the spurns
282 That patient merit of the unworthy takes,
283 When he himself might his quietus make
284
285 TEXT
286 ====================================================================================================
287 With a bare bodkin? Who would fardels bear,
288 To grunt and sweat under a weary life,
289 But that the dread of something after death,
290 The undiscovered country from whose bourn
291 No traveler returns, puzzles the will
292 And makes us rather bear those ills we have
293 Than fly to others that we know not of?
294 Thus conscience does make cowards of us all,
295 And thus the native hue of resolution
296 Is sicklied o'er with the pale cast of thought,
297 And enterprises of great pitch and moment,
298 With this regard their currents turn awry,
299 And lose the name of action.-Soft you now,
300 The fair Ophelia.-Nymph, in thy orisons
301 Be all my sins remembered
302
303
304 TEXT
305 ====================================================================================================
306 Statement failed, SQLSTATE = 42000
307 validation error for variable TEXT, value "*** null ***"
308 -At procedure 'MYREADTEXT'
309 ------------------------
310 Running Test04
311 ------------------------
312 No entry for terminal type "xterm-256color";
313 using dumb terminal settings.
314
315 PHONE_EXT PREVIOUS_PHONE_EXT
316 ========= ==================
317 999 250
318
319
320 PHONE_EXT PREVIOUS_PHONE_EXT
321 ========= ==================
322 250 999
323
324 Repeat with USER=TESTER
325 No entry for terminal type "xterm-256color";
326 using dumb terminal settings.
327
328 PHONE_EXT PREVIOUS_PHONE_EXT
329 ========= ==================
330 999 250
331
332
333 PHONE_EXT PREVIOUS_PHONE_EXT
334 ========= ==================
335 250 999
336
337 ------------------------
338 Running Test05
339 ------------------------
340 No entry for terminal type "xterm-256color";
341 using dumb terminal settings.
342
343 MON$ATTACHMENT_ID MON$ATTACHMENT_NAME MON$USER MON$ROLE MON$REMOTE_HOST
344 ===================== =============================================================================================================================================================================================================================================================== =============================================================== =============================================================== ===============================================================================================================================================================================================================================================================
345 591 /opt/firebird/4.0.1/examples/empbuild/employee.fdb SYSDBA <null>
346 590 /opt/firebird/4.0.1/examples/empbuild/employee.fdb Garbage Collector <null>
347 589 /opt/firebird/4.0.1/examples/empbuild/employee.fdb Cache Writer <null>
348 588 employee SYSDBA <null>
349
350
351 MON$ATTACHMENT_ID MON$ATTACHMENT_NAME MON$USER MON$ROLE MON$REMOTE_HOST
352 ===================== =============================================================================================================================================================================================================================================================== =============================================================== =============================================================== ===============================================================================================================================================================================================================================================================
353 590 /opt/firebird/4.0.1/examples/empbuild/employee.fdb Garbage Collector <null>
354 589 /opt/firebird/4.0.1/examples/empbuild/employee.fdb Cache Writer <null>
355 588 employee SYSDBA <null>
356
357
358 MON$ATTACHMENT_ID MON$ATTACHMENT_NAME MON$USER MON$ROLE MON$REMOTE_HOST
359 ===================== =============================================================================================================================================================================================================================================================== =============================================================== =============================================================== ===============================================================================================================================================================================================================================================================
360 592 /opt/firebird/4.0.1/examples/empbuild/employee.fdb TESTER <null>
361
362
363 MON$ATTACHMENT_ID MON$ATTACHMENT_NAME MON$USER MON$ROLE MON$REMOTE_HOST
364 ===================== =============================================================================================================================================================================================================================================================== =============================================================== =============================================================== ===============================================================================================================================================================================================================================================================
365 593 /opt/firebird/4.0.1/examples/empbuild/employee.fdb SYSDBA <null>
366 590 /opt/firebird/4.0.1/examples/empbuild/employee.fdb Garbage Collector <null>
367 589 /opt/firebird/4.0.1/examples/empbuild/employee.fdb Cache Writer <null>
368 588 employee SYSDBA <null>
369
370
371 SERVERINFO
372 ================================================================================================================================================================================================================================================================
373 Service Manager Version = 2
374 Server Version = LI-V4.0.1.2692 Firebird 4.0
375 Implementation = Firebird/Linux/AMD/Intel/x64
376 Lock Directory = /tmp/firebird/
377 Message File = /opt/firebird/4.0.1/
378 Security File = /opt/firebird/4.0.1/security4.fdb
379
380 Repeat with USER=TESTER
381 No entry for terminal type "xterm-256color";
382 using dumb terminal settings.
383
384 MON$ATTACHMENT_ID MON$ATTACHMENT_NAME MON$USER MON$ROLE MON$REMOTE_HOST
385 ===================== =============================================================================================================================================================================================================================================================== =============================================================== =============================================================== ===============================================================================================================================================================================================================================================================
386 Statement failed, SQLSTATE = 28000
387 Unable to perform operation
388 -System privilege CHANGE_HEADER_SETTINGS is missing
389 -At procedure 'SHOWATTACHMENTS'
390
391 MON$ATTACHMENT_ID MON$ATTACHMENT_NAME MON$USER MON$ROLE MON$REMOTE_HOST
392 ===================== =============================================================================================================================================================================================================================================================== =============================================================== =============================================================== ===============================================================================================================================================================================================================================================================
393 594 employee TESTER <null>
394
395
396 MON$ATTACHMENT_ID MON$ATTACHMENT_NAME MON$USER MON$ROLE MON$REMOTE_HOST
397 ===================== =============================================================================================================================================================================================================================================================== =============================================================== =============================================================== ===============================================================================================================================================================================================================================================================
398 598 /opt/firebird/4.0.1/examples/empbuild/employee.fdb TESTER <null>
399 594 employee TESTER <null>
400
401
402 MON$ATTACHMENT_ID MON$ATTACHMENT_NAME MON$USER MON$ROLE MON$REMOTE_HOST
403 ===================== =============================================================================================================================================================================================================================================================== =============================================================== =============================================================== ===============================================================================================================================================================================================================================================================
404 599 /opt/firebird/4.0.1/examples/empbuild/employee.fdb SYSDBA <null>
405 596 /opt/firebird/4.0.1/examples/empbuild/employee.fdb Garbage Collector <null>
406 595 /opt/firebird/4.0.1/examples/empbuild/employee.fdb Cache Writer <null>
407 594 employee TESTER <null>
408
409
410 SERVERINFO
411 ================================================================================================================================================================================================================================================================
412 Statement failed, SQLSTATE = 28000
413 Service isc_info_svc_get_env requires SYSDBA permissions. Reattach to the Service Manager using the SYSDBA account.
414 -Service isc_info_svc_get_env requires SYSDBA permissions. Reattach to the Service Manager using the SYSDBA account.
415 -Service isc_info_svc_user_dbpath requires SYSDBA permissions. Reattach to the Service Manager using the SYSDBA account.
416 -At procedure 'GETSERVERINFO'
417 UDR Log Contents
418 ----------------
419 @dd-mm-yy hh:mm:ss.zzzz:Registering Function row_count
420 @dd-mm-yy hh:mm:ss.zzzz:Registering Function bad_row_count
421 @dd-mm-yy hh:mm:ss.zzzz:Registering Function return_info
422 @dd-mm-yy hh:mm:ss.zzzz:Registering Procedure test_proc
423 @dd-mm-yy hh:mm:ss.zzzz:Registering Procedure error_proc
424 @dd-mm-yy hh:mm:ss.zzzz:Registering Procedure select_proc
425 @dd-mm-yy hh:mm:ss.zzzz:Registering Procedure read_txt
426 @dd-mm-yy hh:mm:ss.zzzz:Registering Trigger my_employee_update
427 @dd-mm-yy hh:mm:ss.zzzz:Registering Procedure show_att
428 @dd-mm-yy hh:mm:ss.zzzz:Registering Procedure server_info
429 @dd-mm-yy hh:mm:ss.zzzz:Setup Function row_count
430 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
431 Package Name =
432 Name = MYROWCOUNT
433 Entry Point = fbudrtests!row_count (fbudrtests,row_count,)
434 Body =
435 Input Metadata:
436 Field Count = 1
437 Alignment = 2
438 Aligned Length = 36
439 Field No. 0
440 Field Name = TABLE_NAME
441 Relation Name =
442 Alias Name =
443 SQLType = SQL_VARYING
444 IsNullable = yes
445 SubType = 0
446 Length = 31
447 Scale = 0
448 Offset = 0
449 Null Offset = 34
450 Message Length = 31
451
452 Output Metadata:
453 Field Count = 1
454 Alignment = 4
455 Aligned Length = 8
456 Field No. 0
457 Field Name =
458 Relation Name =
459 Alias Name =
460 SQLType = SQL_LONG
461 IsNullable = yes
462 SubType = 0
463 Length = 4
464 Scale = 0
465 Offset = 0
466 Null Offset = 4
467 Message Length = 4
468
469 @dd-mm-yy hh:mm:ss.zzzz:Setup Function row_count
470 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
471 Package Name =
472 Name = MYROWCOUNT
473 Entry Point = fbudrtests!row_count (fbudrtests,row_count,)
474 Body =
475 Input Metadata:
476 Field Count = 1
477 Alignment = 2
478 Aligned Length = 36
479 Field No. 0
480 Field Name = TABLE_NAME
481 Relation Name =
482 Alias Name =
483 SQLType = SQL_VARYING
484 IsNullable = yes
485 SubType = 0
486 Length = 31
487 Scale = 0
488 Offset = 0
489 Null Offset = 34
490 Message Length = 31
491
492 Output Metadata:
493 Field Count = 1
494 Alignment = 4
495 Aligned Length = 8
496 Field No. 0
497 Field Name =
498 Relation Name =
499 Alias Name =
500 SQLType = SQL_LONG
501 IsNullable = yes
502 SubType = 0
503 Length = 4
504 Scale = 0
505 Offset = 0
506 Null Offset = 4
507 Message Length = 4
508
509 @dd-mm-yy hh:mm:ss.zzzz:Setup Function bad_row_count
510 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
511 Package Name =
512 Name = BADROWCOUNT
513 Entry Point = fbudrtests!bad_row_count (fbudrtests,bad_row_count,)
514 Body =
515 Input Metadata:
516 Field Count = 1
517 Alignment = 2
518 Aligned Length = 36
519 Field No. 0
520 Field Name = TABLE_NAME
521 Relation Name =
522 Alias Name =
523 SQLType = SQL_VARYING
524 IsNullable = yes
525 SubType = 0
526 Length = 31
527 Scale = 0
528 Offset = 0
529 Null Offset = 34
530 Message Length = 31
531
532 Output Metadata:
533 Field Count = 1
534 Alignment = 4
535 Aligned Length = 8
536 Field No. 0
537 Field Name =
538 Relation Name =
539 Alias Name =
540 SQLType = SQL_LONG
541 IsNullable = yes
542 SubType = 0
543 Length = 4
544 Scale = 0
545 Offset = 0
546 Null Offset = 4
547 Message Length = 4
548
549 @dd-mm-yy hh:mm:ss.zzzz:Setup Function bad_row_count
550 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
551 Package Name =
552 Name = BADROWCOUNT
553 Entry Point = fbudrtests!bad_row_count (fbudrtests,bad_row_count,)
554 Body =
555 Input Metadata:
556 Field Count = 1
557 Alignment = 2
558 Aligned Length = 36
559 Field No. 0
560 Field Name = TABLE_NAME
561 Relation Name =
562 Alias Name =
563 SQLType = SQL_VARYING
564 IsNullable = yes
565 SubType = 0
566 Length = 31
567 Scale = 0
568 Offset = 0
569 Null Offset = 34
570 Message Length = 31
571
572 Output Metadata:
573 Field Count = 1
574 Alignment = 4
575 Aligned Length = 8
576 Field No. 0
577 Field Name =
578 Relation Name =
579 Alias Name =
580 SQLType = SQL_LONG
581 IsNullable = yes
582 SubType = 0
583 Length = 4
584 Scale = 0
585 Offset = 0
586 Null Offset = 4
587 Message Length = 4
588
589 @dd-mm-yy hh:mm:ss.zzzz:Setup Function return_info
590 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
591 Package Name =
592 Name = UDRINFO
593 Entry Point = fbudrtests!return_info!Hello World (fbudrtests,return_info,Hello World)
594 Body =
595 Input Metadata:
596 Field Count = 0
597 Alignment = 2
598 Aligned Length = 0
599
600 Output Metadata:
601 Field Count = 1
602 Alignment = 2
603 Aligned Length = 36
604 Field No. 0
605 Field Name =
606 Relation Name =
607 Alias Name =
608 SQLType = SQL_VARYING
609 IsNullable = yes
610 SubType = 0
611 Length = 31
612 Scale = 0
613 Offset = 0
614 Null Offset = 34
615 Message Length = 31
616
617 @dd-mm-yy hh:mm:ss.zzzz:Setup Function return_info
618 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
619 Package Name =
620 Name = UDRINFO
621 Entry Point = fbudrtests!return_info!Hello World (fbudrtests,return_info,Hello World)
622 Body =
623 Input Metadata:
624 Field Count = 0
625 Alignment = 2
626 Aligned Length = 0
627
628 Output Metadata:
629 Field Count = 1
630 Alignment = 2
631 Aligned Length = 36
632 Field No. 0
633 Field Name =
634 Relation Name =
635 Alias Name =
636 SQLType = SQL_VARYING
637 IsNullable = yes
638 SubType = 0
639 Length = 31
640 Scale = 0
641 Offset = 0
642 Null Offset = 34
643 Message Length = 31
644
645 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure test_proc
646 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
647 Package Name =
648 Name = MYTESTPROC
649 Entry Point = fbudrtests!test_proc (fbudrtests,test_proc,)
650 Body =
651 Input Metadata:
652 Field Count = 1
653 Alignment = 2
654 Aligned Length = 4
655 Field No. 0
656 Field Name = EMP_NO
657 Relation Name =
658 Alias Name =
659 SQLType = SQL_SHORT
660 IsNullable = yes
661 SubType = 0
662 Length = 2
663 Scale = 0
664 Offset = 0
665 Null Offset = 2
666 Message Length = 2
667
668 Output Metadata:
669 Field Count = 2
670 Alignment = 8
671 Aligned Length = 56
672 Field No. 0
673 Field Name = SALARY
674 Relation Name =
675 Alias Name =
676 SQLType = SQL_INT64
677 IsNullable = yes
678 SubType = 1
679 Length = 8
680 Scale = -2
681 Offset = 0
682 Null Offset = 8
683 Message Length = 8
684 Field No. 1
685 Field Name = FULLNAME
686 Relation Name =
687 Alias Name =
688 SQLType = SQL_VARYING
689 IsNullable = yes
690 SubType = 0
691 Length = 36
692 Scale = 0
693 Offset = 10
694 Null Offset = 48
695 Message Length = 36
696
697 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure test_proc
698 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
699 Package Name =
700 Name = MYTESTPROC
701 Entry Point = fbudrtests!test_proc (fbudrtests,test_proc,)
702 Body =
703 Input Metadata:
704 Field Count = 1
705 Alignment = 2
706 Aligned Length = 4
707 Field No. 0
708 Field Name = EMP_NO
709 Relation Name =
710 Alias Name =
711 SQLType = SQL_SHORT
712 IsNullable = yes
713 SubType = 0
714 Length = 2
715 Scale = 0
716 Offset = 0
717 Null Offset = 2
718 Message Length = 2
719
720 Output Metadata:
721 Field Count = 2
722 Alignment = 8
723 Aligned Length = 56
724 Field No. 0
725 Field Name = SALARY
726 Relation Name =
727 Alias Name =
728 SQLType = SQL_INT64
729 IsNullable = yes
730 SubType = 1
731 Length = 8
732 Scale = -2
733 Offset = 0
734 Null Offset = 8
735 Message Length = 8
736 Field No. 1
737 Field Name = FULLNAME
738 Relation Name =
739 Alias Name =
740 SQLType = SQL_VARYING
741 IsNullable = yes
742 SubType = 0
743 Length = 36
744 Scale = 0
745 Offset = 10
746 Null Offset = 48
747 Message Length = 36
748
749 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure error_proc
750 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
751 Package Name =
752 Name = MYERRORPROC
753 Entry Point = fbudrtests!error_proc (fbudrtests,error_proc,)
754 Body =
755 Input Metadata:
756 Field Count = 1
757 Alignment = 2
758 Aligned Length = 4
759 Field No. 0
760 Field Name = ERRORCASE
761 Relation Name =
762 Alias Name =
763 SQLType = SQL_SHORT
764 IsNullable = yes
765 SubType = 0
766 Length = 2
767 Scale = 0
768 Offset = 0
769 Null Offset = 2
770 Message Length = 2
771
772 Output Metadata:
773 Field Count = 0
774 Alignment = 2
775 Aligned Length = 0
776
777 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure error_proc
778 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
779 Package Name =
780 Name = MYERRORPROC
781 Entry Point = fbudrtests!error_proc (fbudrtests,error_proc,)
782 Body =
783 Input Metadata:
784 Field Count = 1
785 Alignment = 2
786 Aligned Length = 4
787 Field No. 0
788 Field Name = ERRORCASE
789 Relation Name =
790 Alias Name =
791 SQLType = SQL_SHORT
792 IsNullable = yes
793 SubType = 0
794 Length = 2
795 Scale = 0
796 Offset = 0
797 Null Offset = 2
798 Message Length = 2
799
800 Output Metadata:
801 Field Count = 0
802 Alignment = 2
803 Aligned Length = 0
804
805 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure select_proc
806 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
807 Package Name =
808 Name = MYSELECTPROC
809 Entry Point = fbudrtests!select_proc (fbudrtests,select_proc,)
810 Body =
811 Input Metadata:
812 Field Count = 0
813 Alignment = 2
814 Aligned Length = 0
815
816 Output Metadata:
817 Field Count = 3
818 Alignment = 8
819 Aligned Length = 72
820 Field No. 0
821 Field Name = FULLNAME
822 Relation Name =
823 Alias Name =
824 SQLType = SQL_VARYING
825 IsNullable = yes
826 SubType = 0
827 Length = 36
828 Scale = 0
829 Offset = 0
830 Null Offset = 38
831 Message Length = 36
832 Field No. 1
833 Field Name = SALARY
834 Relation Name =
835 Alias Name =
836 SQLType = SQL_INT64
837 IsNullable = yes
838 SubType = 1
839 Length = 8
840 Scale = -2
841 Offset = 40
842 Null Offset = 48
843 Message Length = 8
844 Field No. 2
845 Field Name = ACCSALARY
846 Relation Name =
847 Alias Name =
848 SQLType = SQL_INT64
849 IsNullable = yes
850 SubType = 1
851 Length = 8
852 Scale = -2
853 Offset = 56
854 Null Offset = 64
855 Message Length = 8
856
857 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure select_proc
858 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
859 Package Name =
860 Name = MYSELECTPROC
861 Entry Point = fbudrtests!select_proc (fbudrtests,select_proc,)
862 Body =
863 Input Metadata:
864 Field Count = 0
865 Alignment = 2
866 Aligned Length = 0
867
868 Output Metadata:
869 Field Count = 3
870 Alignment = 8
871 Aligned Length = 72
872 Field No. 0
873 Field Name = FULLNAME
874 Relation Name =
875 Alias Name =
876 SQLType = SQL_VARYING
877 IsNullable = yes
878 SubType = 0
879 Length = 36
880 Scale = 0
881 Offset = 0
882 Null Offset = 38
883 Message Length = 36
884 Field No. 1
885 Field Name = SALARY
886 Relation Name =
887 Alias Name =
888 SQLType = SQL_INT64
889 IsNullable = yes
890 SubType = 1
891 Length = 8
892 Scale = -2
893 Offset = 40
894 Null Offset = 48
895 Message Length = 8
896 Field No. 2
897 Field Name = ACCSALARY
898 Relation Name =
899 Alias Name =
900 SQLType = SQL_INT64
901 IsNullable = yes
902 SubType = 1
903 Length = 8
904 Scale = -2
905 Offset = 56
906 Null Offset = 64
907 Message Length = 8
908
909 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure read_txt
910 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
911 Package Name =
912 Name = MYREADTEXT
913 Entry Point = fbudrtests!read_txt (fbudrtests,read_txt,)
914 Body =
915 Input Metadata:
916 Field Count = 1
917 Alignment = 2
918 Aligned Length = 204
919 Field No. 0
920 Field Name = PATH
921 Relation Name =
922 Alias Name =
923 SQLType = SQL_VARYING
924 IsNullable = no
925 SubType = 0
926 Length = 200
927 Scale = 0
928 Offset = 0
929 Null Offset = 202
930 Message Length = 200
931
932 Output Metadata:
933 Field Count = 1
934 Alignment = 2
935 Aligned Length = 104
936 Field No. 0
937 Field Name = TEXT
938 Relation Name =
939 Alias Name =
940 SQLType = SQL_VARYING
941 IsNullable = no
942 SubType = 0
943 Length = 100
944 Scale = 0
945 Offset = 0
946 Null Offset = 102
947 Message Length = 100
948
949 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure read_txt
950 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
951 Package Name =
952 Name = MYREADTEXT
953 Entry Point = fbudrtests!read_txt (fbudrtests,read_txt,)
954 Body =
955 Input Metadata:
956 Field Count = 1
957 Alignment = 2
958 Aligned Length = 204
959 Field No. 0
960 Field Name = PATH
961 Relation Name =
962 Alias Name =
963 SQLType = SQL_VARYING
964 IsNullable = no
965 SubType = 0
966 Length = 200
967 Scale = 0
968 Offset = 0
969 Null Offset = 202
970 Message Length = 200
971
972 Output Metadata:
973 Field Count = 1
974 Alignment = 2
975 Aligned Length = 104
976 Field No. 0
977 Field Name = TEXT
978 Relation Name =
979 Alias Name =
980 SQLType = SQL_VARYING
981 IsNullable = no
982 SubType = 0
983 Length = 100
984 Scale = 0
985 Offset = 0
986 Null Offset = 102
987 Message Length = 100
988
989 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure show_att
990 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
991 Package Name =
992 Name = SHOWATTACHMENTS
993 Entry Point = fbudrtests!show_att (fbudrtests,show_att,)
994 Body =
995 Input Metadata:
996 Field Count = 1
997 Alignment = 2
998 Aligned Length = 36
999 Field No. 0
1000 Field Name = USER_NAME
1001 Relation Name =
1002 Alias Name =
1003 SQLType = SQL_VARYING
1004 IsNullable = yes
1005 SubType = 0
1006 Length = 32
1007 Scale = 0
1008 Offset = 0
1009 Null Offset = 34
1010 Message Length = 32
1011
1012 Output Metadata:
1013 Field Count = 5
1014 Alignment = 8
1015 Aligned Length = 664
1016 Field No. 0
1017 Field Name = MON$ATTACHMENT_ID
1018 Relation Name =
1019 Alias Name =
1020 SQLType = SQL_INT64
1021 IsNullable = yes
1022 SubType = 0
1023 Length = 8
1024 Scale = 0
1025 Offset = 0
1026 Null Offset = 8
1027 Message Length = 8
1028 Field No. 1
1029 Field Name = MON$ATTACHMENT_NAME
1030 Relation Name =
1031 Alias Name =
1032 SQLType = SQL_VARYING
1033 IsNullable = yes
1034 SubType = 0
1035 Length = 255
1036 Scale = 0
1037 Offset = 10
1038 Null Offset = 268
1039 Message Length = 255
1040 Field No. 2
1041 Field Name = MON$USER
1042 Relation Name =
1043 Alias Name =
1044 SQLType = SQL_TEXT
1045 IsNullable = yes
1046 SubType = 0
1047 Length = 63
1048 Scale = 0
1049 Offset = 270
1050 Null Offset = 334
1051 Message Length = 63
1052 Field No. 3
1053 Field Name = MON$ROLE
1054 Relation Name =
1055 Alias Name =
1056 SQLType = SQL_TEXT
1057 IsNullable = yes
1058 SubType = 0
1059 Length = 63
1060 Scale = 0
1061 Offset = 336
1062 Null Offset = 400
1063 Message Length = 63
1064 Field No. 4
1065 Field Name = MON$REMOTE_HOST
1066 Relation Name =
1067 Alias Name =
1068 SQLType = SQL_VARYING
1069 IsNullable = yes
1070 SubType = 0
1071 Length = 255
1072 Scale = 0
1073 Offset = 402
1074 Null Offset = 660
1075 Message Length = 255
1076
1077 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure show_att
1078 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
1079 Package Name =
1080 Name = SHOWATTACHMENTS
1081 Entry Point = fbudrtests!show_att (fbudrtests,show_att,)
1082 Body =
1083 Input Metadata:
1084 Field Count = 1
1085 Alignment = 2
1086 Aligned Length = 36
1087 Field No. 0
1088 Field Name = USER_NAME
1089 Relation Name =
1090 Alias Name =
1091 SQLType = SQL_VARYING
1092 IsNullable = yes
1093 SubType = 0
1094 Length = 32
1095 Scale = 0
1096 Offset = 0
1097 Null Offset = 34
1098 Message Length = 32
1099
1100 Output Metadata:
1101 Field Count = 5
1102 Alignment = 8
1103 Aligned Length = 664
1104 Field No. 0
1105 Field Name = MON$ATTACHMENT_ID
1106 Relation Name =
1107 Alias Name =
1108 SQLType = SQL_INT64
1109 IsNullable = yes
1110 SubType = 0
1111 Length = 8
1112 Scale = 0
1113 Offset = 0
1114 Null Offset = 8
1115 Message Length = 8
1116 Field No. 1
1117 Field Name = MON$ATTACHMENT_NAME
1118 Relation Name =
1119 Alias Name =
1120 SQLType = SQL_VARYING
1121 IsNullable = yes
1122 SubType = 0
1123 Length = 255
1124 Scale = 0
1125 Offset = 10
1126 Null Offset = 268
1127 Message Length = 255
1128 Field No. 2
1129 Field Name = MON$USER
1130 Relation Name =
1131 Alias Name =
1132 SQLType = SQL_TEXT
1133 IsNullable = yes
1134 SubType = 0
1135 Length = 63
1136 Scale = 0
1137 Offset = 270
1138 Null Offset = 334
1139 Message Length = 63
1140 Field No. 3
1141 Field Name = MON$ROLE
1142 Relation Name =
1143 Alias Name =
1144 SQLType = SQL_TEXT
1145 IsNullable = yes
1146 SubType = 0
1147 Length = 63
1148 Scale = 0
1149 Offset = 336
1150 Null Offset = 400
1151 Message Length = 63
1152 Field No. 4
1153 Field Name = MON$REMOTE_HOST
1154 Relation Name =
1155 Alias Name =
1156 SQLType = SQL_VARYING
1157 IsNullable = yes
1158 SubType = 0
1159 Length = 255
1160 Scale = 0
1161 Offset = 402
1162 Null Offset = 660
1163 Message Length = 255
1164
1165 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure server_info
1166 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
1167 Package Name =
1168 Name = GETSERVERINFO
1169 Entry Point = fbudrtests!server_info (fbudrtests,server_info,)
1170 Body =
1171 Input Metadata:
1172 Field Count = 0
1173 Alignment = 2
1174 Aligned Length = 0
1175
1176 Output Metadata:
1177 Field Count = 1
1178 Alignment = 2
1179 Aligned Length = 260
1180 Field No. 0
1181 Field Name = SERVERINFO
1182 Relation Name =
1183 Alias Name =
1184 SQLType = SQL_VARYING
1185 IsNullable = yes
1186 SubType = 0
1187 Length = 256
1188 Scale = 0
1189 Offset = 0
1190 Null Offset = 258
1191 Message Length = 256
1192
1193 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure server_info
1194 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
1195 Package Name =
1196 Name = GETSERVERINFO
1197 Entry Point = fbudrtests!server_info (fbudrtests,server_info,)
1198 Body =
1199 Input Metadata:
1200 Field Count = 0
1201 Alignment = 2
1202 Aligned Length = 0
1203
1204 Output Metadata:
1205 Field Count = 1
1206 Alignment = 2
1207 Aligned Length = 260
1208 Field No. 0
1209 Field Name = SERVERINFO
1210 Relation Name =
1211 Alias Name =
1212 SQLType = SQL_VARYING
1213 IsNullable = yes
1214 SubType = 0
1215 Length = 256
1216 Scale = 0
1217 Offset = 0
1218 Null Offset = 258
1219 Message Length = 256
1220
1221 @dd-mm-yy hh:mm:ss.zzzz:Setup Function row_count
1222 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
1223 Package Name =
1224 Name = MYROWCOUNT
1225 Entry Point = fbudrtests!row_count (fbudrtests,row_count,)
1226 Body =
1227 Input Metadata:
1228 Field Count = 1
1229 Alignment = 2
1230 Aligned Length = 36
1231 Field No. 0
1232 Field Name = TABLE_NAME
1233 Relation Name =
1234 Alias Name =
1235 SQLType = SQL_VARYING
1236 IsNullable = yes
1237 SubType = 0
1238 Length = 31
1239 Scale = 0
1240 Offset = 0
1241 Null Offset = 34
1242 Message Length = 31
1243
1244 Output Metadata:
1245 Field Count = 1
1246 Alignment = 4
1247 Aligned Length = 8
1248 Field No. 0
1249 Field Name =
1250 Relation Name =
1251 Alias Name =
1252 SQLType = SQL_LONG
1253 IsNullable = yes
1254 SubType = 0
1255 Length = 4
1256 Scale = 0
1257 Offset = 0
1258 Null Offset = 4
1259 Message Length = 4
1260
1261 @dd-mm-yy hh:mm:ss.zzzz:Function row_count created
1262 @dd-mm-yy hh:mm:ss.zzzz:Package Name =
1263 Name = MYROWCOUNT
1264 Entry Point = fbudrtests!row_count (fbudrtests,row_count,)
1265 Body =
1266 Input Metadata:
1267 Field Count = 1
1268 Alignment = 2
1269 Aligned Length = 36
1270 Field No. 0
1271 Field Name = TABLE_NAME
1272 Relation Name =
1273 Alias Name =
1274 SQLType = SQL_VARYING
1275 IsNullable = yes
1276 SubType = 0
1277 Length = 31
1278 Scale = 0
1279 Offset = 0
1280 Null Offset = 34
1281 Message Length = 31
1282
1283 Output Metadata:
1284 Field Count = 1
1285 Alignment = 4
1286 Aligned Length = 8
1287 Field No. 0
1288 Field Name =
1289 Relation Name =
1290 Alias Name =
1291 SQLType = SQL_LONG
1292 IsNullable = yes
1293 SubType = 0
1294 Length = 4
1295 Scale = 0
1296 Offset = 0
1297 Null Offset = 4
1298 Message Length = 4
1299
1300 @dd-mm-yy hh:mm:ss.zzzz:Execute Function row_count
1301 @dd-mm-yy hh:mm:ss.zzzz:External Context:
1302 Attachment ID = 564
1303 Transaction ID = 1531
1304 User Name = SYSDBA
1305 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
1306 Client Character Set = NONE
1307
1308 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
1309 Parameter 0:
1310 Field Name = TABLE_NAME
1311 Alias Name =
1312 SQLType = SQL_VARYING
1313 sub type = 0
1314 Scale = 0
1315 Charset = NONE
1316 Nullable
1317 Size = 31
1318 Value = EMPLOYEE
1319
1320 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters with data
1321 Column 0
1322 Field Name =
1323 SQLType = SQL_LONG
1324 sub type = 0
1325 Scale = 0
1326 Charset = NONE
1327 Nullable
1328 Size = 4
1329 Value = 42
1330
1331 @dd-mm-yy hh:mm:ss.zzzz:Execute Function row_count
1332 @dd-mm-yy hh:mm:ss.zzzz:External Context:
1333 Attachment ID = 564
1334 Transaction ID = 1531
1335 User Name = SYSDBA
1336 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
1337 Client Character Set = NONE
1338
1339 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
1340 Parameter 0:
1341 Field Name = TABLE_NAME
1342 Alias Name =
1343 SQLType = SQL_VARYING
1344 sub type = 0
1345 Scale = 0
1346 Charset = NONE
1347 Nullable
1348 Size = 31
1349 Value = DEPARTMENT
1350
1351 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters with data
1352 Column 0
1353 Field Name =
1354 SQLType = SQL_LONG
1355 sub type = 0
1356 Scale = 0
1357 Charset = NONE
1358 Nullable
1359 Size = 4
1360 Value = 21
1361
1362 @dd-mm-yy hh:mm:ss.zzzz:Execute Function row_count
1363 @dd-mm-yy hh:mm:ss.zzzz:External Context:
1364 Attachment ID = 564
1365 Transaction ID = 1531
1366 User Name = SYSDBA
1367 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
1368 Client Character Set = NONE
1369
1370 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
1371 Parameter 0:
1372 Field Name = TABLE_NAME
1373 Alias Name =
1374 SQLType = SQL_VARYING
1375 sub type = 0
1376 Scale = 0
1377 Charset = NONE
1378 Nullable
1379 Size = 31
1380 Value = BAD
1381
1382 @dd-mm-yy hh:mm:ss.zzzz:Exception raised
1383 Engine Code: 335544569
1384 Dynamic SQL Error
1385 -SQL error code = -204
1386 -Table unknown
1387 -BAD
1388 -At line 1, column 22 When Executing: Select count(*) from BAD
1389 @dd-mm-yy hh:mm:ss.zzzz:Setup Function return_info
1390 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
1391 Package Name =
1392 Name = UDRINFO
1393 Entry Point = fbudrtests!return_info!Hello World (fbudrtests,return_info,Hello World)
1394 Body =
1395 Input Metadata:
1396 Field Count = 0
1397 Alignment = 2
1398 Aligned Length = 0
1399
1400 Output Metadata:
1401 Field Count = 1
1402 Alignment = 2
1403 Aligned Length = 36
1404 Field No. 0
1405 Field Name =
1406 Relation Name =
1407 Alias Name =
1408 SQLType = SQL_VARYING
1409 IsNullable = yes
1410 SubType = 0
1411 Length = 31
1412 Scale = 0
1413 Offset = 0
1414 Null Offset = 34
1415 Message Length = 31
1416
1417 @dd-mm-yy hh:mm:ss.zzzz:Function return_info created
1418 @dd-mm-yy hh:mm:ss.zzzz:Package Name =
1419 Name = UDRINFO
1420 Entry Point = fbudrtests!return_info!Hello World (fbudrtests,return_info,Hello World)
1421 Body =
1422 Input Metadata:
1423 Field Count = 0
1424 Alignment = 2
1425 Aligned Length = 0
1426
1427 Output Metadata:
1428 Field Count = 1
1429 Alignment = 2
1430 Aligned Length = 36
1431 Field No. 0
1432 Field Name =
1433 Relation Name =
1434 Alias Name =
1435 SQLType = SQL_VARYING
1436 IsNullable = yes
1437 SubType = 0
1438 Length = 31
1439 Scale = 0
1440 Offset = 0
1441 Null Offset = 34
1442 Message Length = 31
1443
1444 @dd-mm-yy hh:mm:ss.zzzz:Execute Function return_info
1445 @dd-mm-yy hh:mm:ss.zzzz:External Context:
1446 Attachment ID = 564
1447 Transaction ID = 1531
1448 User Name = SYSDBA
1449 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
1450 Client Character Set = NONE
1451
1452 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
1453
1454 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters with data
1455 Column 0
1456 Field Name =
1457 SQLType = SQL_VARYING
1458 sub type = 0
1459 Scale = 0
1460 Charset = NONE
1461 Nullable
1462 Size = 31
1463 Value = Hello World
1464
1465 @dd-mm-yy hh:mm:ss.zzzz:Function return_info: dispose called
1466 @dd-mm-yy hh:mm:ss.zzzz:Function row_count: dispose called
1467 @dd-mm-yy hh:mm:ss.zzzz:Setup Function row_count
1468 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
1469 Package Name =
1470 Name = MYROWCOUNT
1471 Entry Point = fbudrtests!row_count (fbudrtests,row_count,)
1472 Body =
1473 Input Metadata:
1474 Field Count = 1
1475 Alignment = 2
1476 Aligned Length = 36
1477 Field No. 0
1478 Field Name = TABLE_NAME
1479 Relation Name =
1480 Alias Name =
1481 SQLType = SQL_VARYING
1482 IsNullable = yes
1483 SubType = 0
1484 Length = 31
1485 Scale = 0
1486 Offset = 0
1487 Null Offset = 34
1488 Message Length = 31
1489
1490 Output Metadata:
1491 Field Count = 1
1492 Alignment = 4
1493 Aligned Length = 8
1494 Field No. 0
1495 Field Name =
1496 Relation Name =
1497 Alias Name =
1498 SQLType = SQL_LONG
1499 IsNullable = yes
1500 SubType = 0
1501 Length = 4
1502 Scale = 0
1503 Offset = 0
1504 Null Offset = 4
1505 Message Length = 4
1506
1507 @dd-mm-yy hh:mm:ss.zzzz:Function row_count created
1508 @dd-mm-yy hh:mm:ss.zzzz:Package Name =
1509 Name = MYROWCOUNT
1510 Entry Point = fbudrtests!row_count (fbudrtests,row_count,)
1511 Body =
1512 Input Metadata:
1513 Field Count = 1
1514 Alignment = 2
1515 Aligned Length = 36
1516 Field No. 0
1517 Field Name = TABLE_NAME
1518 Relation Name =
1519 Alias Name =
1520 SQLType = SQL_VARYING
1521 IsNullable = yes
1522 SubType = 0
1523 Length = 31
1524 Scale = 0
1525 Offset = 0
1526 Null Offset = 34
1527 Message Length = 31
1528
1529 Output Metadata:
1530 Field Count = 1
1531 Alignment = 4
1532 Aligned Length = 8
1533 Field No. 0
1534 Field Name =
1535 Relation Name =
1536 Alias Name =
1537 SQLType = SQL_LONG
1538 IsNullable = yes
1539 SubType = 0
1540 Length = 4
1541 Scale = 0
1542 Offset = 0
1543 Null Offset = 4
1544 Message Length = 4
1545
1546 @dd-mm-yy hh:mm:ss.zzzz:Execute Function row_count
1547 @dd-mm-yy hh:mm:ss.zzzz:External Context:
1548 Attachment ID = 567
1549 Transaction ID = 1535
1550 User Name = TESTER
1551 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
1552 Client Character Set = NONE
1553
1554 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
1555 Parameter 0:
1556 Field Name = TABLE_NAME
1557 Alias Name =
1558 SQLType = SQL_VARYING
1559 sub type = 0
1560 Scale = 0
1561 Charset = NONE
1562 Nullable
1563 Size = 31
1564 Value = EMPLOYEE
1565
1566 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters with data
1567 Column 0
1568 Field Name =
1569 SQLType = SQL_LONG
1570 sub type = 0
1571 Scale = 0
1572 Charset = NONE
1573 Nullable
1574 Size = 4
1575 Value = 42
1576
1577 @dd-mm-yy hh:mm:ss.zzzz:Execute Function row_count
1578 @dd-mm-yy hh:mm:ss.zzzz:External Context:
1579 Attachment ID = 567
1580 Transaction ID = 1535
1581 User Name = TESTER
1582 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
1583 Client Character Set = NONE
1584
1585 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
1586 Parameter 0:
1587 Field Name = TABLE_NAME
1588 Alias Name =
1589 SQLType = SQL_VARYING
1590 sub type = 0
1591 Scale = 0
1592 Charset = NONE
1593 Nullable
1594 Size = 31
1595 Value = DEPARTMENT
1596
1597 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters with data
1598 Column 0
1599 Field Name =
1600 SQLType = SQL_LONG
1601 sub type = 0
1602 Scale = 0
1603 Charset = NONE
1604 Nullable
1605 Size = 4
1606 Value = 21
1607
1608 @dd-mm-yy hh:mm:ss.zzzz:Execute Function row_count
1609 @dd-mm-yy hh:mm:ss.zzzz:External Context:
1610 Attachment ID = 567
1611 Transaction ID = 1535
1612 User Name = TESTER
1613 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
1614 Client Character Set = NONE
1615
1616 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
1617 Parameter 0:
1618 Field Name = TABLE_NAME
1619 Alias Name =
1620 SQLType = SQL_VARYING
1621 sub type = 0
1622 Scale = 0
1623 Charset = NONE
1624 Nullable
1625 Size = 31
1626 Value = BAD
1627
1628 @dd-mm-yy hh:mm:ss.zzzz:Exception raised
1629 Engine Code: 335544569
1630 Dynamic SQL Error
1631 -SQL error code = -204
1632 -Table unknown
1633 -BAD
1634 -At line 1, column 22 When Executing: Select count(*) from BAD
1635 @dd-mm-yy hh:mm:ss.zzzz:Setup Function return_info
1636 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
1637 Package Name =
1638 Name = UDRINFO
1639 Entry Point = fbudrtests!return_info!Hello World (fbudrtests,return_info,Hello World)
1640 Body =
1641 Input Metadata:
1642 Field Count = 0
1643 Alignment = 2
1644 Aligned Length = 0
1645
1646 Output Metadata:
1647 Field Count = 1
1648 Alignment = 2
1649 Aligned Length = 36
1650 Field No. 0
1651 Field Name =
1652 Relation Name =
1653 Alias Name =
1654 SQLType = SQL_VARYING
1655 IsNullable = yes
1656 SubType = 0
1657 Length = 31
1658 Scale = 0
1659 Offset = 0
1660 Null Offset = 34
1661 Message Length = 31
1662
1663 @dd-mm-yy hh:mm:ss.zzzz:Function return_info created
1664 @dd-mm-yy hh:mm:ss.zzzz:Package Name =
1665 Name = UDRINFO
1666 Entry Point = fbudrtests!return_info!Hello World (fbudrtests,return_info,Hello World)
1667 Body =
1668 Input Metadata:
1669 Field Count = 0
1670 Alignment = 2
1671 Aligned Length = 0
1672
1673 Output Metadata:
1674 Field Count = 1
1675 Alignment = 2
1676 Aligned Length = 36
1677 Field No. 0
1678 Field Name =
1679 Relation Name =
1680 Alias Name =
1681 SQLType = SQL_VARYING
1682 IsNullable = yes
1683 SubType = 0
1684 Length = 31
1685 Scale = 0
1686 Offset = 0
1687 Null Offset = 34
1688 Message Length = 31
1689
1690 @dd-mm-yy hh:mm:ss.zzzz:Execute Function return_info
1691 @dd-mm-yy hh:mm:ss.zzzz:External Context:
1692 Attachment ID = 567
1693 Transaction ID = 1535
1694 User Name = TESTER
1695 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
1696 Client Character Set = NONE
1697
1698 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
1699
1700 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters with data
1701 Column 0
1702 Field Name =
1703 SQLType = SQL_VARYING
1704 sub type = 0
1705 Scale = 0
1706 Charset = NONE
1707 Nullable
1708 Size = 31
1709 Value = Hello World
1710
1711 @dd-mm-yy hh:mm:ss.zzzz:Function row_count: dispose called
1712 @dd-mm-yy hh:mm:ss.zzzz:Function return_info: dispose called
1713 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure test_proc
1714 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
1715 Package Name =
1716 Name = MYTESTPROC
1717 Entry Point = fbudrtests!test_proc (fbudrtests,test_proc,)
1718 Body =
1719 Input Metadata:
1720 Field Count = 1
1721 Alignment = 2
1722 Aligned Length = 4
1723 Field No. 0
1724 Field Name = EMP_NO
1725 Relation Name =
1726 Alias Name =
1727 SQLType = SQL_SHORT
1728 IsNullable = yes
1729 SubType = 0
1730 Length = 2
1731 Scale = 0
1732 Offset = 0
1733 Null Offset = 2
1734 Message Length = 2
1735
1736 Output Metadata:
1737 Field Count = 2
1738 Alignment = 8
1739 Aligned Length = 56
1740 Field No. 0
1741 Field Name = SALARY
1742 Relation Name =
1743 Alias Name =
1744 SQLType = SQL_INT64
1745 IsNullable = yes
1746 SubType = 1
1747 Length = 8
1748 Scale = -2
1749 Offset = 0
1750 Null Offset = 8
1751 Message Length = 8
1752 Field No. 1
1753 Field Name = FULLNAME
1754 Relation Name =
1755 Alias Name =
1756 SQLType = SQL_VARYING
1757 IsNullable = yes
1758 SubType = 0
1759 Length = 36
1760 Scale = 0
1761 Offset = 10
1762 Null Offset = 48
1763 Message Length = 36
1764
1765 @dd-mm-yy hh:mm:ss.zzzz:Open Execute Procedure test_proc
1766 @dd-mm-yy hh:mm:ss.zzzz:External Context:
1767 Attachment ID = 570
1768 Transaction ID = 1539
1769 User Name = SYSDBA
1770 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
1771 Client Character Set = NONE
1772
1773 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
1774 Parameter 0:
1775 Field Name = EMP_NO
1776 Alias Name =
1777 SQLType = SQL_SHORT
1778 sub type = 0
1779 Scale = 0
1780 Charset = NONE
1781 Nullable
1782 Size = 2
1783 Value = 24
1784
1785 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
1786 Column 0
1787 Field Name = SALARY
1788 SQLType = SQL_INT64
1789 sub type = 0
1790 Scale = -2
1791 Charset = NONE
1792 Nullable
1793 Size = 8
1794 Value = NULL
1795 Column 1
1796 Field Name = FULLNAME
1797 SQLType = SQL_VARYING
1798 sub type = 0
1799 Scale = 0
1800 Charset = NONE
1801 Nullable
1802 Size = 36
1803 Value = NULL
1804
1805 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters with data
1806 Column 0
1807 Field Name = SALARY
1808 SQLType = SQL_INT64
1809 sub type = 0
1810 Scale = -2
1811 Charset = NONE
1812 Nullable
1813 Size = 8
1814 Value = 81810.19
1815 Column 1
1816 Field Name = FULLNAME
1817 SQLType = SQL_VARYING
1818 sub type = 0
1819 Scale = 0
1820 Charset = NONE
1821 Nullable
1822 Size = 36
1823 Value = Fisher, Pete
1824
1825 @dd-mm-yy hh:mm:ss.zzzz:Procedure test_proc: dispose called with refcount = 2
1826 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure error_proc
1827 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
1828 Package Name =
1829 Name = MYERRORPROC
1830 Entry Point = fbudrtests!error_proc (fbudrtests,error_proc,)
1831 Body =
1832 Input Metadata:
1833 Field Count = 1
1834 Alignment = 2
1835 Aligned Length = 4
1836 Field No. 0
1837 Field Name = ERRORCASE
1838 Relation Name =
1839 Alias Name =
1840 SQLType = SQL_SHORT
1841 IsNullable = yes
1842 SubType = 0
1843 Length = 2
1844 Scale = 0
1845 Offset = 0
1846 Null Offset = 2
1847 Message Length = 2
1848
1849 Output Metadata:
1850 Field Count = 0
1851 Alignment = 2
1852 Aligned Length = 0
1853
1854 @dd-mm-yy hh:mm:ss.zzzz:Open Execute Procedure error_proc
1855 @dd-mm-yy hh:mm:ss.zzzz:External Context:
1856 Attachment ID = 570
1857 Transaction ID = 1539
1858 User Name = SYSDBA
1859 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
1860 Client Character Set = NONE
1861
1862 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
1863 Parameter 0:
1864 Field Name = ERRORCASE
1865 Alias Name =
1866 SQLType = SQL_SHORT
1867 sub type = 0
1868 Scale = 0
1869 Charset = NONE
1870 Nullable
1871 Size = 2
1872 Value = 0
1873
1874 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
1875
1876 *S:'dd-mm-yy hh:mm:ss.zzzz',570,0,1545,0:,53:[isc_tpb_write,isc_tpb_nowait,isc_tpb_read_committed],1
1877 *R:'dd-mm-yy hh:mm:ss.zzzz',570,0,1545
1878 @dd-mm-yy hh:mm:ss.zzzz:Procedure error_proc: dispose called with refcount = 2
1879 @dd-mm-yy hh:mm:ss.zzzz:Exception raised
1880 Engine Code: 335544351
1881 unsuccessful metadata update
1882 -CREATE TABLE TESTME failed
1883 -Table TESTME already exists
1884 @dd-mm-yy hh:mm:ss.zzzz:Open Execute Procedure error_proc
1885 @dd-mm-yy hh:mm:ss.zzzz:External Context:
1886 Attachment ID = 570
1887 Transaction ID = 1539
1888 User Name = SYSDBA
1889 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
1890 Client Character Set = NONE
1891
1892 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
1893 Parameter 0:
1894 Field Name = ERRORCASE
1895 Alias Name =
1896 SQLType = SQL_SHORT
1897 sub type = 0
1898 Scale = 0
1899 Charset = NONE
1900 Nullable
1901 Size = 2
1902 Value = 1
1903
1904 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
1905
1906 *S:'dd-mm-yy hh:mm:ss.zzzz',570,0,1546,0:,53:[isc_tpb_write,isc_tpb_nowait,isc_tpb_read_committed],1
1907 *Q:'dd-mm-yy hh:mm:ss.zzzz',570,0,1546,56:Insert into EMPLOYEE(EMP_NO,LAST_NAME) Values (2,No one)
1908 *C:'dd-mm-yy hh:mm:ss.zzzz',570,0,1546
1909 @dd-mm-yy hh:mm:ss.zzzz:Procedure error_proc: dispose called with refcount = 2
1910 @dd-mm-yy hh:mm:ss.zzzz:Exception raised
1911 Engine Code: 335544347
1912 validation error for column "EMPLOYEE"."FIRST_NAME", value "*** null ***"
1913 @dd-mm-yy hh:mm:ss.zzzz:Open Execute Procedure error_proc
1914 @dd-mm-yy hh:mm:ss.zzzz:External Context:
1915 Attachment ID = 570
1916 Transaction ID = 1539
1917 User Name = SYSDBA
1918 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
1919 Client Character Set = NONE
1920
1921 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
1922 Parameter 0:
1923 Field Name = ERRORCASE
1924 Alias Name =
1925 SQLType = SQL_SHORT
1926 sub type = 0
1927 Scale = 0
1928 Charset = NONE
1929 Nullable
1930 Size = 2
1931 Value = 2
1932
1933 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
1934
1935 @dd-mm-yy hh:mm:ss.zzzz:Procedure error_proc: dispose called with refcount = 2
1936 @dd-mm-yy hh:mm:ss.zzzz:Exception raised
1937 You have a bug
1938 @dd-mm-yy hh:mm:ss.zzzz:Procedure error_proc: dispose called with refcount = 1
1939 @dd-mm-yy hh:mm:ss.zzzz:Procedure test_proc: dispose called with refcount = 1
1940 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure test_proc
1941 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
1942 Package Name =
1943 Name = MYTESTPROC
1944 Entry Point = fbudrtests!test_proc (fbudrtests,test_proc,)
1945 Body =
1946 Input Metadata:
1947 Field Count = 1
1948 Alignment = 2
1949 Aligned Length = 4
1950 Field No. 0
1951 Field Name = EMP_NO
1952 Relation Name =
1953 Alias Name =
1954 SQLType = SQL_SHORT
1955 IsNullable = yes
1956 SubType = 0
1957 Length = 2
1958 Scale = 0
1959 Offset = 0
1960 Null Offset = 2
1961 Message Length = 2
1962
1963 Output Metadata:
1964 Field Count = 2
1965 Alignment = 8
1966 Aligned Length = 56
1967 Field No. 0
1968 Field Name = SALARY
1969 Relation Name =
1970 Alias Name =
1971 SQLType = SQL_INT64
1972 IsNullable = yes
1973 SubType = 1
1974 Length = 8
1975 Scale = -2
1976 Offset = 0
1977 Null Offset = 8
1978 Message Length = 8
1979 Field No. 1
1980 Field Name = FULLNAME
1981 Relation Name =
1982 Alias Name =
1983 SQLType = SQL_VARYING
1984 IsNullable = yes
1985 SubType = 0
1986 Length = 36
1987 Scale = 0
1988 Offset = 10
1989 Null Offset = 48
1990 Message Length = 36
1991
1992 @dd-mm-yy hh:mm:ss.zzzz:Open Execute Procedure test_proc
1993 @dd-mm-yy hh:mm:ss.zzzz:External Context:
1994 Attachment ID = 573
1995 Transaction ID = 1547
1996 User Name = TESTER
1997 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
1998 Client Character Set = NONE
1999
2000 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
2001 Parameter 0:
2002 Field Name = EMP_NO
2003 Alias Name =
2004 SQLType = SQL_SHORT
2005 sub type = 0
2006 Scale = 0
2007 Charset = NONE
2008 Nullable
2009 Size = 2
2010 Value = 24
2011
2012 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
2013 Column 0
2014 Field Name = SALARY
2015 SQLType = SQL_INT64
2016 sub type = 0
2017 Scale = -2
2018 Charset = NONE
2019 Nullable
2020 Size = 8
2021 Value = NULL
2022 Column 1
2023 Field Name = FULLNAME
2024 SQLType = SQL_VARYING
2025 sub type = 0
2026 Scale = 0
2027 Charset = NONE
2028 Nullable
2029 Size = 36
2030 Value = NULL
2031
2032 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters with data
2033 Column 0
2034 Field Name = SALARY
2035 SQLType = SQL_INT64
2036 sub type = 0
2037 Scale = -2
2038 Charset = NONE
2039 Nullable
2040 Size = 8
2041 Value = 81810.19
2042 Column 1
2043 Field Name = FULLNAME
2044 SQLType = SQL_VARYING
2045 sub type = 0
2046 Scale = 0
2047 Charset = NONE
2048 Nullable
2049 Size = 36
2050 Value = Fisher, Pete
2051
2052 @dd-mm-yy hh:mm:ss.zzzz:Procedure test_proc: dispose called with refcount = 2
2053 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure error_proc
2054 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
2055 Package Name =
2056 Name = MYERRORPROC
2057 Entry Point = fbudrtests!error_proc (fbudrtests,error_proc,)
2058 Body =
2059 Input Metadata:
2060 Field Count = 1
2061 Alignment = 2
2062 Aligned Length = 4
2063 Field No. 0
2064 Field Name = ERRORCASE
2065 Relation Name =
2066 Alias Name =
2067 SQLType = SQL_SHORT
2068 IsNullable = yes
2069 SubType = 0
2070 Length = 2
2071 Scale = 0
2072 Offset = 0
2073 Null Offset = 2
2074 Message Length = 2
2075
2076 Output Metadata:
2077 Field Count = 0
2078 Alignment = 2
2079 Aligned Length = 0
2080
2081 @dd-mm-yy hh:mm:ss.zzzz:Open Execute Procedure error_proc
2082 @dd-mm-yy hh:mm:ss.zzzz:External Context:
2083 Attachment ID = 573
2084 Transaction ID = 1547
2085 User Name = TESTER
2086 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
2087 Client Character Set = NONE
2088
2089 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
2090 Parameter 0:
2091 Field Name = ERRORCASE
2092 Alias Name =
2093 SQLType = SQL_SHORT
2094 sub type = 0
2095 Scale = 0
2096 Charset = NONE
2097 Nullable
2098 Size = 2
2099 Value = 0
2100
2101 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
2102
2103 *S:'dd-mm-yy hh:mm:ss.zzzz',573,0,1553,0:,53:[isc_tpb_write,isc_tpb_nowait,isc_tpb_read_committed],1
2104 *R:'dd-mm-yy hh:mm:ss.zzzz',573,0,1553
2105 @dd-mm-yy hh:mm:ss.zzzz:Procedure error_proc: dispose called with refcount = 2
2106 @dd-mm-yy hh:mm:ss.zzzz:Exception raised
2107 Engine Code: 335544351
2108 unsuccessful metadata update
2109 -CREATE TABLE TESTME failed
2110 -No permission for CREATE TABLE operation
2111 @dd-mm-yy hh:mm:ss.zzzz:Open Execute Procedure error_proc
2112 @dd-mm-yy hh:mm:ss.zzzz:External Context:
2113 Attachment ID = 573
2114 Transaction ID = 1547
2115 User Name = TESTER
2116 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
2117 Client Character Set = NONE
2118
2119 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
2120 Parameter 0:
2121 Field Name = ERRORCASE
2122 Alias Name =
2123 SQLType = SQL_SHORT
2124 sub type = 0
2125 Scale = 0
2126 Charset = NONE
2127 Nullable
2128 Size = 2
2129 Value = 1
2130
2131 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
2132
2133 *S:'dd-mm-yy hh:mm:ss.zzzz',573,0,1554,0:,53:[isc_tpb_write,isc_tpb_nowait,isc_tpb_read_committed],1
2134 *C:'dd-mm-yy hh:mm:ss.zzzz',573,0,1554
2135 @dd-mm-yy hh:mm:ss.zzzz:Procedure error_proc: dispose called with refcount = 2
2136 @dd-mm-yy hh:mm:ss.zzzz:Exception raised
2137 Engine Code: 335544352
2138 no permission for USAGE access to GENERATOR EMP_NO_GEN
2139 -Effective user is TESTER When Executing: Insert into EMPLOYEE(EMP_NO,LAST_NAME) Values (2,'No one')
2140 @dd-mm-yy hh:mm:ss.zzzz:Open Execute Procedure error_proc
2141 @dd-mm-yy hh:mm:ss.zzzz:External Context:
2142 Attachment ID = 573
2143 Transaction ID = 1547
2144 User Name = TESTER
2145 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
2146 Client Character Set = NONE
2147
2148 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
2149 Parameter 0:
2150 Field Name = ERRORCASE
2151 Alias Name =
2152 SQLType = SQL_SHORT
2153 sub type = 0
2154 Scale = 0
2155 Charset = NONE
2156 Nullable
2157 Size = 2
2158 Value = 2
2159
2160 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
2161
2162 @dd-mm-yy hh:mm:ss.zzzz:Procedure error_proc: dispose called with refcount = 2
2163 @dd-mm-yy hh:mm:ss.zzzz:Exception raised
2164 You have a bug
2165 @dd-mm-yy hh:mm:ss.zzzz:Procedure test_proc: dispose called with refcount = 1
2166 @dd-mm-yy hh:mm:ss.zzzz:Procedure error_proc: dispose called with refcount = 1
2167 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure select_proc
2168 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
2169 Package Name =
2170 Name = MYSELECTPROC
2171 Entry Point = fbudrtests!select_proc (fbudrtests,select_proc,)
2172 Body =
2173 Input Metadata:
2174 Field Count = 0
2175 Alignment = 2
2176 Aligned Length = 0
2177
2178 Output Metadata:
2179 Field Count = 3
2180 Alignment = 8
2181 Aligned Length = 72
2182 Field No. 0
2183 Field Name = FULLNAME
2184 Relation Name =
2185 Alias Name =
2186 SQLType = SQL_VARYING
2187 IsNullable = yes
2188 SubType = 0
2189 Length = 36
2190 Scale = 0
2191 Offset = 0
2192 Null Offset = 38
2193 Message Length = 36
2194 Field No. 1
2195 Field Name = SALARY
2196 Relation Name =
2197 Alias Name =
2198 SQLType = SQL_INT64
2199 IsNullable = yes
2200 SubType = 1
2201 Length = 8
2202 Scale = -2
2203 Offset = 40
2204 Null Offset = 48
2205 Message Length = 8
2206 Field No. 2
2207 Field Name = ACCSALARY
2208 Relation Name =
2209 Alias Name =
2210 SQLType = SQL_INT64
2211 IsNullable = yes
2212 SubType = 1
2213 Length = 8
2214 Scale = -2
2215 Offset = 56
2216 Null Offset = 64
2217 Message Length = 8
2218
2219 @dd-mm-yy hh:mm:ss.zzzz:Open Select Procedure select_proc
2220 @dd-mm-yy hh:mm:ss.zzzz:External Context:
2221 Attachment ID = 576
2222 Transaction ID = 1555
2223 User Name = SYSDBA
2224 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
2225 Client Character Set = NONE
2226
2227 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
2228
2229 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
2230 Column 0
2231 Field Name = FULLNAME
2232 SQLType = SQL_VARYING
2233 sub type = 0
2234 Scale = 0
2235 Charset = NONE
2236 Nullable
2237 Size = 36
2238 Value = NULL
2239 Column 1
2240 Field Name = SALARY
2241 SQLType = SQL_INT64
2242 sub type = 0
2243 Scale = -2
2244 Charset = NONE
2245 Nullable
2246 Size = 8
2247 Value = NULL
2248 Column 2
2249 Field Name = ACCSALARY
2250 SQLType = SQL_INT64
2251 sub type = 0
2252 Scale = -2
2253 Charset = NONE
2254 Nullable
2255 Size = 8
2256 Value = NULL
2257
2258 @dd-mm-yy hh:mm:ss.zzzz:Procedure select_proc: dispose called with refcount = 2
2259 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure read_txt
2260 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
2261 Package Name =
2262 Name = MYREADTEXT
2263 Entry Point = fbudrtests!read_txt (fbudrtests,read_txt,)
2264 Body =
2265 Input Metadata:
2266 Field Count = 1
2267 Alignment = 2
2268 Aligned Length = 204
2269 Field No. 0
2270 Field Name = PATH
2271 Relation Name =
2272 Alias Name =
2273 SQLType = SQL_VARYING
2274 IsNullable = no
2275 SubType = 0
2276 Length = 200
2277 Scale = 0
2278 Offset = 0
2279 Null Offset = 202
2280 Message Length = 200
2281
2282 Output Metadata:
2283 Field Count = 1
2284 Alignment = 2
2285 Aligned Length = 104
2286 Field No. 0
2287 Field Name = TEXT
2288 Relation Name =
2289 Alias Name =
2290 SQLType = SQL_VARYING
2291 IsNullable = no
2292 SubType = 0
2293 Length = 100
2294 Scale = 0
2295 Offset = 0
2296 Null Offset = 102
2297 Message Length = 100
2298
2299 @dd-mm-yy hh:mm:ss.zzzz:Open Select Procedure read_txt
2300 @dd-mm-yy hh:mm:ss.zzzz:External Context:
2301 Attachment ID = 576
2302 Transaction ID = 1555
2303 User Name = SYSDBA
2304 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
2305 Client Character Set = NONE
2306
2307 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
2308 Parameter 0:
2309 Field Name = PATH
2310 Alias Name =
2311 SQLType = SQL_VARYING
2312 sub type = 0
2313 Scale = 0
2314 Charset = NONE
2315 Not Nullable
2316 Size = 200
2317 Value = /home/tony/lazarus/2.2/otherComponents/fbintf/udr/testsuite/udrlib/testtext.txt
2318
2319 @dd-mm-yy hh:mm:ss.zzzz:Read Text called in directory /tmp
2320 @dd-mm-yy hh:mm:ss.zzzz:Reading from /home/tony/lazarus/2.2/otherComponents/fbintf/udr/testsuite/udrlib/testtext.txt
2321 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
2322 Column 0
2323 Field Name = TEXT
2324 SQLType = SQL_VARYING
2325 sub type = 0
2326 Scale = 0
2327 Charset = NONE
2328 Not Nullable
2329 Size = 100
2330 Value =
2331
2332 @dd-mm-yy hh:mm:ss.zzzz:Procedure read_txt: dispose called with refcount = 2
2333 @dd-mm-yy hh:mm:ss.zzzz:Open Select Procedure read_txt
2334 @dd-mm-yy hh:mm:ss.zzzz:External Context:
2335 Attachment ID = 576
2336 Transaction ID = 1555
2337 User Name = SYSDBA
2338 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
2339 Client Character Set = NONE
2340
2341 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
2342 Parameter 0:
2343 Field Name = PATH
2344 Alias Name =
2345 SQLType = SQL_VARYING
2346 sub type = 0
2347 Scale = 0
2348 Charset = NONE
2349 Not Nullable
2350 Size = 200
2351 Value = /home/tony/lazarus/2.2/otherComponents/fbintf/udr/testsuite/udrlib/test.empty
2352
2353 @dd-mm-yy hh:mm:ss.zzzz:Read Text called in directory /tmp
2354 @dd-mm-yy hh:mm:ss.zzzz:Reading from /home/tony/lazarus/2.2/otherComponents/fbintf/udr/testsuite/udrlib/test.empty
2355 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
2356 Column 0
2357 Field Name = TEXT
2358 SQLType = SQL_VARYING
2359 sub type = 0
2360 Scale = 0
2361 Charset = NONE
2362 Not Nullable
2363 Size = 100
2364 Value =
2365
2366 @dd-mm-yy hh:mm:ss.zzzz:Procedure read_txt: dispose called with refcount = 2
2367 @dd-mm-yy hh:mm:ss.zzzz:Procedure read_txt: dispose called with refcount = 1
2368 @dd-mm-yy hh:mm:ss.zzzz:Procedure select_proc: dispose called with refcount = 1
2369 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure select_proc
2370 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
2371 Package Name =
2372 Name = MYSELECTPROC
2373 Entry Point = fbudrtests!select_proc (fbudrtests,select_proc,)
2374 Body =
2375 Input Metadata:
2376 Field Count = 0
2377 Alignment = 2
2378 Aligned Length = 0
2379
2380 Output Metadata:
2381 Field Count = 3
2382 Alignment = 8
2383 Aligned Length = 72
2384 Field No. 0
2385 Field Name = FULLNAME
2386 Relation Name =
2387 Alias Name =
2388 SQLType = SQL_VARYING
2389 IsNullable = yes
2390 SubType = 0
2391 Length = 36
2392 Scale = 0
2393 Offset = 0
2394 Null Offset = 38
2395 Message Length = 36
2396 Field No. 1
2397 Field Name = SALARY
2398 Relation Name =
2399 Alias Name =
2400 SQLType = SQL_INT64
2401 IsNullable = yes
2402 SubType = 1
2403 Length = 8
2404 Scale = -2
2405 Offset = 40
2406 Null Offset = 48
2407 Message Length = 8
2408 Field No. 2
2409 Field Name = ACCSALARY
2410 Relation Name =
2411 Alias Name =
2412 SQLType = SQL_INT64
2413 IsNullable = yes
2414 SubType = 1
2415 Length = 8
2416 Scale = -2
2417 Offset = 56
2418 Null Offset = 64
2419 Message Length = 8
2420
2421 @dd-mm-yy hh:mm:ss.zzzz:Open Select Procedure select_proc
2422 @dd-mm-yy hh:mm:ss.zzzz:External Context:
2423 Attachment ID = 579
2424 Transaction ID = 1561
2425 User Name = TESTER
2426 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
2427 Client Character Set = NONE
2428
2429 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
2430
2431 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
2432 Column 0
2433 Field Name = FULLNAME
2434 SQLType = SQL_VARYING
2435 sub type = 0
2436 Scale = 0
2437 Charset = NONE
2438 Nullable
2439 Size = 36
2440 Value = NULL
2441 Column 1
2442 Field Name = SALARY
2443 SQLType = SQL_INT64
2444 sub type = 0
2445 Scale = -2
2446 Charset = NONE
2447 Nullable
2448 Size = 8
2449 Value = NULL
2450 Column 2
2451 Field Name = ACCSALARY
2452 SQLType = SQL_INT64
2453 sub type = 0
2454 Scale = -2
2455 Charset = NONE
2456 Nullable
2457 Size = 8
2458 Value = NULL
2459
2460 @dd-mm-yy hh:mm:ss.zzzz:Procedure select_proc: dispose called with refcount = 2
2461 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure read_txt
2462 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
2463 Package Name =
2464 Name = MYREADTEXT
2465 Entry Point = fbudrtests!read_txt (fbudrtests,read_txt,)
2466 Body =
2467 Input Metadata:
2468 Field Count = 1
2469 Alignment = 2
2470 Aligned Length = 204
2471 Field No. 0
2472 Field Name = PATH
2473 Relation Name =
2474 Alias Name =
2475 SQLType = SQL_VARYING
2476 IsNullable = no
2477 SubType = 0
2478 Length = 200
2479 Scale = 0
2480 Offset = 0
2481 Null Offset = 202
2482 Message Length = 200
2483
2484 Output Metadata:
2485 Field Count = 1
2486 Alignment = 2
2487 Aligned Length = 104
2488 Field No. 0
2489 Field Name = TEXT
2490 Relation Name =
2491 Alias Name =
2492 SQLType = SQL_VARYING
2493 IsNullable = no
2494 SubType = 0
2495 Length = 100
2496 Scale = 0
2497 Offset = 0
2498 Null Offset = 102
2499 Message Length = 100
2500
2501 @dd-mm-yy hh:mm:ss.zzzz:Open Select Procedure read_txt
2502 @dd-mm-yy hh:mm:ss.zzzz:External Context:
2503 Attachment ID = 579
2504 Transaction ID = 1561
2505 User Name = TESTER
2506 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
2507 Client Character Set = NONE
2508
2509 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
2510 Parameter 0:
2511 Field Name = PATH
2512 Alias Name =
2513 SQLType = SQL_VARYING
2514 sub type = 0
2515 Scale = 0
2516 Charset = NONE
2517 Not Nullable
2518 Size = 200
2519 Value = /home/tony/lazarus/2.2/otherComponents/fbintf/udr/testsuite/udrlib/testtext.txt
2520
2521 @dd-mm-yy hh:mm:ss.zzzz:Read Text called in directory /tmp
2522 @dd-mm-yy hh:mm:ss.zzzz:Reading from /home/tony/lazarus/2.2/otherComponents/fbintf/udr/testsuite/udrlib/testtext.txt
2523 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
2524 Column 0
2525 Field Name = TEXT
2526 SQLType = SQL_VARYING
2527 sub type = 0
2528 Scale = 0
2529 Charset = NONE
2530 Not Nullable
2531 Size = 100
2532 Value =
2533
2534 @dd-mm-yy hh:mm:ss.zzzz:Procedure read_txt: dispose called with refcount = 2
2535 @dd-mm-yy hh:mm:ss.zzzz:Open Select Procedure read_txt
2536 @dd-mm-yy hh:mm:ss.zzzz:External Context:
2537 Attachment ID = 579
2538 Transaction ID = 1561
2539 User Name = TESTER
2540 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
2541 Client Character Set = NONE
2542
2543 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
2544 Parameter 0:
2545 Field Name = PATH
2546 Alias Name =
2547 SQLType = SQL_VARYING
2548 sub type = 0
2549 Scale = 0
2550 Charset = NONE
2551 Not Nullable
2552 Size = 200
2553 Value = /home/tony/lazarus/2.2/otherComponents/fbintf/udr/testsuite/udrlib/test.empty
2554
2555 @dd-mm-yy hh:mm:ss.zzzz:Read Text called in directory /tmp
2556 @dd-mm-yy hh:mm:ss.zzzz:Reading from /home/tony/lazarus/2.2/otherComponents/fbintf/udr/testsuite/udrlib/test.empty
2557 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
2558 Column 0
2559 Field Name = TEXT
2560 SQLType = SQL_VARYING
2561 sub type = 0
2562 Scale = 0
2563 Charset = NONE
2564 Not Nullable
2565 Size = 100
2566 Value =
2567
2568 @dd-mm-yy hh:mm:ss.zzzz:Procedure read_txt: dispose called with refcount = 2
2569 @dd-mm-yy hh:mm:ss.zzzz:Procedure select_proc: dispose called with refcount = 1
2570 @dd-mm-yy hh:mm:ss.zzzz:Procedure read_txt: dispose called with refcount = 1
2571 @dd-mm-yy hh:mm:ss.zzzz:Setup Trigger my_employee_update
2572 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
2573 Package Name =
2574 Name = MYEMPLOYEEUPDATE
2575 Entry Point = fbudrtests!my_employee_update (fbudrtests,my_employee_update,)
2576 Body =
2577 Trigger Metadata:
2578 Field Count = 12
2579 Alignment = 0
2580 Aligned Length = 0
2581 Field No. 0
2582 Field Name = EMP_NO
2583 Relation Name =
2584 Alias Name =
2585 SQLType = SQL_SHORT
2586 IsNullable = no
2587 SubType = 0
2588 Length = 2
2589 Scale = 0
2590 Offset = 0
2591 Null Offset = 0
2592 Message Length = 2
2593 Field No. 1
2594 Field Name = FIRST_NAME
2595 Relation Name =
2596 Alias Name =
2597 SQLType = SQL_VARYING
2598 IsNullable = no
2599 SubType = 0
2600 Length = 15
2601 Scale = 0
2602 Offset = 0
2603 Null Offset = 0
2604 Message Length = 15
2605 Field No. 2
2606 Field Name = LAST_NAME
2607 Relation Name =
2608 Alias Name =
2609 SQLType = SQL_VARYING
2610 IsNullable = no
2611 SubType = 0
2612 Length = 20
2613 Scale = 0
2614 Offset = 0
2615 Null Offset = 0
2616 Message Length = 20
2617 Field No. 3
2618 Field Name = PHONE_EXT
2619 Relation Name =
2620 Alias Name =
2621 SQLType = SQL_VARYING
2622 IsNullable = yes
2623 SubType = 0
2624 Length = 4
2625 Scale = 0
2626 Offset = 0
2627 Null Offset = 0
2628 Message Length = 4
2629 Field No. 4
2630 Field Name = HIRE_DATE
2631 Relation Name =
2632 Alias Name =
2633 SQLType = SQL_TIMESTAMP
2634 IsNullable = no
2635 SubType = 0
2636 Length = 8
2637 Scale = 0
2638 Offset = 0
2639 Null Offset = 0
2640 Message Length = 8
2641 Field No. 5
2642 Field Name = DEPT_NO
2643 Relation Name =
2644 Alias Name =
2645 SQLType = SQL_TEXT
2646 IsNullable = no
2647 SubType = 0
2648 Length = 3
2649 Scale = 0
2650 Offset = 0
2651 Null Offset = 0
2652 Message Length = 3
2653 Field No. 6
2654 Field Name = JOB_CODE
2655 Relation Name =
2656 Alias Name =
2657 SQLType = SQL_VARYING
2658 IsNullable = no
2659 SubType = 0
2660 Length = 5
2661 Scale = 0
2662 Offset = 0
2663 Null Offset = 0
2664 Message Length = 5
2665 Field No. 7
2666 Field Name = JOB_GRADE
2667 Relation Name =
2668 Alias Name =
2669 SQLType = SQL_SHORT
2670 IsNullable = no
2671 SubType = 0
2672 Length = 2
2673 Scale = 0
2674 Offset = 0
2675 Null Offset = 0
2676 Message Length = 2
2677 Field No. 8
2678 Field Name = JOB_COUNTRY
2679 Relation Name =
2680 Alias Name =
2681 SQLType = SQL_VARYING
2682 IsNullable = no
2683 SubType = 0
2684 Length = 15
2685 Scale = 0
2686 Offset = 0
2687 Null Offset = 0
2688 Message Length = 15
2689 Field No. 9
2690 Field Name = SALARY
2691 Relation Name =
2692 Alias Name =
2693 SQLType = SQL_INT64
2694 IsNullable = no
2695 SubType = 1
2696 Length = 8
2697 Scale = -2
2698 Offset = 0
2699 Null Offset = 0
2700 Message Length = 8
2701 Field No. 10
2702 Field Name = FULL_NAME
2703 Relation Name =
2704 Alias Name =
2705 SQLType = SQL_VARYING
2706 IsNullable = yes
2707 SubType = 0
2708 Length = 37
2709 Scale = 0
2710 Offset = 0
2711 Null Offset = 0
2712 Message Length = 37
2713 Field No. 11
2714 Field Name = PREVIOUS_PHONE_EXT
2715 Relation Name =
2716 Alias Name =
2717 SQLType = SQL_VARYING
2718 IsNullable = yes
2719 SubType = 0
2720 Length = 4
2721 Scale = 0
2722 Offset = 0
2723 Null Offset = 0
2724 Message Length = 4
2725 Trigger Table = EMPLOYEE
2726 Trigger Type = Before
2727
2728 @dd-mm-yy hh:mm:ss.zzzz:Execute Trigger my_employee_update
2729 @dd-mm-yy hh:mm:ss.zzzz:Old Field Values:
2730 Parameter 0:
2731 Field Name = EMP_NO
2732 Alias Name =
2733 SQLType = SQL_SHORT
2734 sub type = 0
2735 Scale = 0
2736 Charset = NONE
2737 Not Nullable
2738 Size = 2
2739 Value = 2
2740 Parameter 1:
2741 Field Name = FIRST_NAME
2742 Alias Name =
2743 SQLType = SQL_VARYING
2744 sub type = 0
2745 Scale = 0
2746 Charset = NONE
2747 Not Nullable
2748 Size = 15
2749 Value = Robert
2750 Parameter 2:
2751 Field Name = LAST_NAME
2752 Alias Name =
2753 SQLType = SQL_VARYING
2754 sub type = 0
2755 Scale = 0
2756 Charset = NONE
2757 Not Nullable
2758 Size = 20
2759 Value = Nelson
2760 Parameter 3:
2761 Field Name = PHONE_EXT
2762 Alias Name =
2763 SQLType = SQL_VARYING
2764 sub type = 0
2765 Scale = 0
2766 Charset = NONE
2767 Nullable
2768 Size = 4
2769 Value = 250
2770 Parameter 4:
2771 Field Name = HIRE_DATE
2772 Alias Name =
2773 SQLType = SQL_TIMESTAMP
2774 sub type = 0
2775 Scale = 0
2776 Charset = NONE
2777 Not Nullable
2778 Size = 8
2779 Value = dd-mm-yy hh:mm:ss.zzzz
2780 Parameter 5:
2781 Field Name = DEPT_NO
2782 Alias Name =
2783 SQLType = SQL_TEXT
2784 sub type = 0
2785 Scale = 0
2786 Charset = NONE
2787 Not Nullable
2788 Size = 3
2789 Value = 600
2790 Parameter 6:
2791 Field Name = JOB_CODE
2792 Alias Name =
2793 SQLType = SQL_VARYING
2794 sub type = 0
2795 Scale = 0
2796 Charset = NONE
2797 Not Nullable
2798 Size = 5
2799 Value = VP
2800 Parameter 7:
2801 Field Name = JOB_GRADE
2802 Alias Name =
2803 SQLType = SQL_SHORT
2804 sub type = 0
2805 Scale = 0
2806 Charset = NONE
2807 Not Nullable
2808 Size = 2
2809 Value = 2
2810 Parameter 8:
2811 Field Name = JOB_COUNTRY
2812 Alias Name =
2813 SQLType = SQL_VARYING
2814 sub type = 0
2815 Scale = 0
2816 Charset = NONE
2817 Not Nullable
2818 Size = 15
2819 Value = USA
2820 Parameter 9:
2821 Field Name = SALARY
2822 Alias Name =
2823 SQLType = SQL_INT64
2824 sub type = 0
2825 Scale = -2
2826 Charset = NONE
2827 Not Nullable
2828 Size = 8
2829 Value = 105900
2830 Parameter 10:
2831 Field Name = FULL_NAME
2832 Alias Name =
2833 SQLType = SQL_VARYING
2834 sub type = 0
2835 Scale = 0
2836 Charset = NONE
2837 Nullable
2838 Size = 37
2839 Value = Nelson, Robert
2840 Parameter 11:
2841 Field Name = PREVIOUS_PHONE_EXT
2842 Alias Name =
2843 SQLType = SQL_VARYING
2844 sub type = 0
2845 Scale = 0
2846 Charset = NONE
2847 Nullable
2848 Size = 4
2849 Value = NULL
2850
2851 @dd-mm-yy hh:mm:ss.zzzz:New Field Values:
2852 Column 0
2853 Field Name = EMP_NO
2854 SQLType = SQL_SHORT
2855 sub type = 0
2856 Scale = 0
2857 Charset = NONE
2858 Not Nullable
2859 Size = 2
2860 Value = 2
2861 Column 1
2862 Field Name = FIRST_NAME
2863 SQLType = SQL_VARYING
2864 sub type = 0
2865 Scale = 0
2866 Charset = NONE
2867 Not Nullable
2868 Size = 15
2869 Value = Robert
2870 Column 2
2871 Field Name = LAST_NAME
2872 SQLType = SQL_VARYING
2873 sub type = 0
2874 Scale = 0
2875 Charset = NONE
2876 Not Nullable
2877 Size = 20
2878 Value = Nelson
2879 Column 3
2880 Field Name = PHONE_EXT
2881 SQLType = SQL_VARYING
2882 sub type = 0
2883 Scale = 0
2884 Charset = NONE
2885 Nullable
2886 Size = 4
2887 Value = 999
2888 Column 4
2889 Field Name = HIRE_DATE
2890 SQLType = SQL_TIMESTAMP
2891 sub type = 0
2892 Scale = 0
2893 Charset = NONE
2894 Not Nullable
2895 Size = 8
2896 Value = dd-mm-yy hh:mm:ss.zzzz
2897 Column 5
2898 Field Name = DEPT_NO
2899 SQLType = SQL_TEXT
2900 sub type = 0
2901 Scale = 0
2902 Charset = NONE
2903 Not Nullable
2904 Size = 3
2905 Value = 600
2906 Column 6
2907 Field Name = JOB_CODE
2908 SQLType = SQL_VARYING
2909 sub type = 0
2910 Scale = 0
2911 Charset = NONE
2912 Not Nullable
2913 Size = 5
2914 Value = VP
2915 Column 7
2916 Field Name = JOB_GRADE
2917 SQLType = SQL_SHORT
2918 sub type = 0
2919 Scale = 0
2920 Charset = NONE
2921 Not Nullable
2922 Size = 2
2923 Value = 2
2924 Column 8
2925 Field Name = JOB_COUNTRY
2926 SQLType = SQL_VARYING
2927 sub type = 0
2928 Scale = 0
2929 Charset = NONE
2930 Not Nullable
2931 Size = 15
2932 Value = USA
2933 Column 9
2934 Field Name = SALARY
2935 SQLType = SQL_INT64
2936 sub type = 0
2937 Scale = -2
2938 Charset = NONE
2939 Not Nullable
2940 Size = 8
2941 Value = 105900
2942 Column 10
2943 Field Name = FULL_NAME
2944 SQLType = SQL_VARYING
2945 sub type = 0
2946 Scale = 0
2947 Charset = NONE
2948 Nullable
2949 Size = 37
2950 Value = Nelson, Robert
2951 Column 11
2952 Field Name = PREVIOUS_PHONE_EXT
2953 SQLType = SQL_VARYING
2954 sub type = 0
2955 Scale = 0
2956 Charset = NONE
2957 Nullable
2958 Size = 4
2959 Value = NULL
2960
2961 @dd-mm-yy hh:mm:ss.zzzz:New Field Values after trigger execution
2962 Column 0
2963 Field Name = EMP_NO
2964 SQLType = SQL_SHORT
2965 sub type = 0
2966 Scale = 0
2967 Charset = NONE
2968 Not Nullable
2969 Size = 2
2970 Value = 2
2971 Column 1
2972 Field Name = FIRST_NAME
2973 SQLType = SQL_VARYING
2974 sub type = 0
2975 Scale = 0
2976 Charset = NONE
2977 Not Nullable
2978 Size = 15
2979 Value = Robert
2980 Column 2
2981 Field Name = LAST_NAME
2982 SQLType = SQL_VARYING
2983 sub type = 0
2984 Scale = 0
2985 Charset = NONE
2986 Not Nullable
2987 Size = 20
2988 Value = Nelson
2989 Column 3
2990 Field Name = PHONE_EXT
2991 SQLType = SQL_VARYING
2992 sub type = 0
2993 Scale = 0
2994 Charset = NONE
2995 Nullable
2996 Size = 4
2997 Value = 999
2998 Column 4
2999 Field Name = HIRE_DATE
3000 SQLType = SQL_TIMESTAMP
3001 sub type = 0
3002 Scale = 0
3003 Charset = NONE
3004 Not Nullable
3005 Size = 8
3006 Value = dd-mm-yy hh:mm:ss.zzzz
3007 Column 5
3008 Field Name = DEPT_NO
3009 SQLType = SQL_TEXT
3010 sub type = 0
3011 Scale = 0
3012 Charset = NONE
3013 Not Nullable
3014 Size = 3
3015 Value = 600
3016 Column 6
3017 Field Name = JOB_CODE
3018 SQLType = SQL_VARYING
3019 sub type = 0
3020 Scale = 0
3021 Charset = NONE
3022 Not Nullable
3023 Size = 5
3024 Value = VP
3025 Column 7
3026 Field Name = JOB_GRADE
3027 SQLType = SQL_SHORT
3028 sub type = 0
3029 Scale = 0
3030 Charset = NONE
3031 Not Nullable
3032 Size = 2
3033 Value = 2
3034 Column 8
3035 Field Name = JOB_COUNTRY
3036 SQLType = SQL_VARYING
3037 sub type = 0
3038 Scale = 0
3039 Charset = NONE
3040 Not Nullable
3041 Size = 15
3042 Value = USA
3043 Column 9
3044 Field Name = SALARY
3045 SQLType = SQL_INT64
3046 sub type = 0
3047 Scale = -2
3048 Charset = NONE
3049 Not Nullable
3050 Size = 8
3051 Value = 105900
3052 Column 10
3053 Field Name = FULL_NAME
3054 SQLType = SQL_VARYING
3055 sub type = 0
3056 Scale = 0
3057 Charset = NONE
3058 Nullable
3059 Size = 37
3060 Value = Nelson, Robert
3061 Column 11
3062 Field Name = PREVIOUS_PHONE_EXT
3063 SQLType = SQL_VARYING
3064 sub type = 0
3065 Scale = 0
3066 Charset = NONE
3067 Nullable
3068 Size = 4
3069 Value = 250
3070
3071 @dd-mm-yy hh:mm:ss.zzzz:Execute Trigger my_employee_update
3072 @dd-mm-yy hh:mm:ss.zzzz:Old Field Values:
3073 Parameter 0:
3074 Field Name = EMP_NO
3075 Alias Name =
3076 SQLType = SQL_SHORT
3077 sub type = 0
3078 Scale = 0
3079 Charset = NONE
3080 Not Nullable
3081 Size = 2
3082 Value = 2
3083 Parameter 1:
3084 Field Name = FIRST_NAME
3085 Alias Name =
3086 SQLType = SQL_VARYING
3087 sub type = 0
3088 Scale = 0
3089 Charset = NONE
3090 Not Nullable
3091 Size = 15
3092 Value = Robert
3093 Parameter 2:
3094 Field Name = LAST_NAME
3095 Alias Name =
3096 SQLType = SQL_VARYING
3097 sub type = 0
3098 Scale = 0
3099 Charset = NONE
3100 Not Nullable
3101 Size = 20
3102 Value = Nelson
3103 Parameter 3:
3104 Field Name = PHONE_EXT
3105 Alias Name =
3106 SQLType = SQL_VARYING
3107 sub type = 0
3108 Scale = 0
3109 Charset = NONE
3110 Nullable
3111 Size = 4
3112 Value = 999
3113 Parameter 4:
3114 Field Name = HIRE_DATE
3115 Alias Name =
3116 SQLType = SQL_TIMESTAMP
3117 sub type = 0
3118 Scale = 0
3119 Charset = NONE
3120 Not Nullable
3121 Size = 8
3122 Value = dd-mm-yy hh:mm:ss.zzzz
3123 Parameter 5:
3124 Field Name = DEPT_NO
3125 Alias Name =
3126 SQLType = SQL_TEXT
3127 sub type = 0
3128 Scale = 0
3129 Charset = NONE
3130 Not Nullable
3131 Size = 3
3132 Value = 600
3133 Parameter 6:
3134 Field Name = JOB_CODE
3135 Alias Name =
3136 SQLType = SQL_VARYING
3137 sub type = 0
3138 Scale = 0
3139 Charset = NONE
3140 Not Nullable
3141 Size = 5
3142 Value = VP
3143 Parameter 7:
3144 Field Name = JOB_GRADE
3145 Alias Name =
3146 SQLType = SQL_SHORT
3147 sub type = 0
3148 Scale = 0
3149 Charset = NONE
3150 Not Nullable
3151 Size = 2
3152 Value = 2
3153 Parameter 8:
3154 Field Name = JOB_COUNTRY
3155 Alias Name =
3156 SQLType = SQL_VARYING
3157 sub type = 0
3158 Scale = 0
3159 Charset = NONE
3160 Not Nullable
3161 Size = 15
3162 Value = USA
3163 Parameter 9:
3164 Field Name = SALARY
3165 Alias Name =
3166 SQLType = SQL_INT64
3167 sub type = 0
3168 Scale = -2
3169 Charset = NONE
3170 Not Nullable
3171 Size = 8
3172 Value = 105900
3173 Parameter 10:
3174 Field Name = FULL_NAME
3175 Alias Name =
3176 SQLType = SQL_VARYING
3177 sub type = 0
3178 Scale = 0
3179 Charset = NONE
3180 Nullable
3181 Size = 37
3182 Value = Nelson, Robert
3183 Parameter 11:
3184 Field Name = PREVIOUS_PHONE_EXT
3185 Alias Name =
3186 SQLType = SQL_VARYING
3187 sub type = 0
3188 Scale = 0
3189 Charset = NONE
3190 Nullable
3191 Size = 4
3192 Value = 250
3193
3194 @dd-mm-yy hh:mm:ss.zzzz:New Field Values:
3195 Column 0
3196 Field Name = EMP_NO
3197 SQLType = SQL_SHORT
3198 sub type = 0
3199 Scale = 0
3200 Charset = NONE
3201 Not Nullable
3202 Size = 2
3203 Value = 2
3204 Column 1
3205 Field Name = FIRST_NAME
3206 SQLType = SQL_VARYING
3207 sub type = 0
3208 Scale = 0
3209 Charset = NONE
3210 Not Nullable
3211 Size = 15
3212 Value = Robert
3213 Column 2
3214 Field Name = LAST_NAME
3215 SQLType = SQL_VARYING
3216 sub type = 0
3217 Scale = 0
3218 Charset = NONE
3219 Not Nullable
3220 Size = 20
3221 Value = Nelson
3222 Column 3
3223 Field Name = PHONE_EXT
3224 SQLType = SQL_VARYING
3225 sub type = 0
3226 Scale = 0
3227 Charset = NONE
3228 Nullable
3229 Size = 4
3230 Value = 250
3231 Column 4
3232 Field Name = HIRE_DATE
3233 SQLType = SQL_TIMESTAMP
3234 sub type = 0
3235 Scale = 0
3236 Charset = NONE
3237 Not Nullable
3238 Size = 8
3239 Value = dd-mm-yy hh:mm:ss.zzzz
3240 Column 5
3241 Field Name = DEPT_NO
3242 SQLType = SQL_TEXT
3243 sub type = 0
3244 Scale = 0
3245 Charset = NONE
3246 Not Nullable
3247 Size = 3
3248 Value = 600
3249 Column 6
3250 Field Name = JOB_CODE
3251 SQLType = SQL_VARYING
3252 sub type = 0
3253 Scale = 0
3254 Charset = NONE
3255 Not Nullable
3256 Size = 5
3257 Value = VP
3258 Column 7
3259 Field Name = JOB_GRADE
3260 SQLType = SQL_SHORT
3261 sub type = 0
3262 Scale = 0
3263 Charset = NONE
3264 Not Nullable
3265 Size = 2
3266 Value = 2
3267 Column 8
3268 Field Name = JOB_COUNTRY
3269 SQLType = SQL_VARYING
3270 sub type = 0
3271 Scale = 0
3272 Charset = NONE
3273 Not Nullable
3274 Size = 15
3275 Value = USA
3276 Column 9
3277 Field Name = SALARY
3278 SQLType = SQL_INT64
3279 sub type = 0
3280 Scale = -2
3281 Charset = NONE
3282 Not Nullable
3283 Size = 8
3284 Value = 105900
3285 Column 10
3286 Field Name = FULL_NAME
3287 SQLType = SQL_VARYING
3288 sub type = 0
3289 Scale = 0
3290 Charset = NONE
3291 Nullable
3292 Size = 37
3293 Value = Nelson, Robert
3294 Column 11
3295 Field Name = PREVIOUS_PHONE_EXT
3296 SQLType = SQL_VARYING
3297 sub type = 0
3298 Scale = 0
3299 Charset = NONE
3300 Nullable
3301 Size = 4
3302 Value = 250
3303
3304 @dd-mm-yy hh:mm:ss.zzzz:New Field Values after trigger execution
3305 Column 0
3306 Field Name = EMP_NO
3307 SQLType = SQL_SHORT
3308 sub type = 0
3309 Scale = 0
3310 Charset = NONE
3311 Not Nullable
3312 Size = 2
3313 Value = 2
3314 Column 1
3315 Field Name = FIRST_NAME
3316 SQLType = SQL_VARYING
3317 sub type = 0
3318 Scale = 0
3319 Charset = NONE
3320 Not Nullable
3321 Size = 15
3322 Value = Robert
3323 Column 2
3324 Field Name = LAST_NAME
3325 SQLType = SQL_VARYING
3326 sub type = 0
3327 Scale = 0
3328 Charset = NONE
3329 Not Nullable
3330 Size = 20
3331 Value = Nelson
3332 Column 3
3333 Field Name = PHONE_EXT
3334 SQLType = SQL_VARYING
3335 sub type = 0
3336 Scale = 0
3337 Charset = NONE
3338 Nullable
3339 Size = 4
3340 Value = 250
3341 Column 4
3342 Field Name = HIRE_DATE
3343 SQLType = SQL_TIMESTAMP
3344 sub type = 0
3345 Scale = 0
3346 Charset = NONE
3347 Not Nullable
3348 Size = 8
3349 Value = dd-mm-yy hh:mm:ss.zzzz
3350 Column 5
3351 Field Name = DEPT_NO
3352 SQLType = SQL_TEXT
3353 sub type = 0
3354 Scale = 0
3355 Charset = NONE
3356 Not Nullable
3357 Size = 3
3358 Value = 600
3359 Column 6
3360 Field Name = JOB_CODE
3361 SQLType = SQL_VARYING
3362 sub type = 0
3363 Scale = 0
3364 Charset = NONE
3365 Not Nullable
3366 Size = 5
3367 Value = VP
3368 Column 7
3369 Field Name = JOB_GRADE
3370 SQLType = SQL_SHORT
3371 sub type = 0
3372 Scale = 0
3373 Charset = NONE
3374 Not Nullable
3375 Size = 2
3376 Value = 2
3377 Column 8
3378 Field Name = JOB_COUNTRY
3379 SQLType = SQL_VARYING
3380 sub type = 0
3381 Scale = 0
3382 Charset = NONE
3383 Not Nullable
3384 Size = 15
3385 Value = USA
3386 Column 9
3387 Field Name = SALARY
3388 SQLType = SQL_INT64
3389 sub type = 0
3390 Scale = -2
3391 Charset = NONE
3392 Not Nullable
3393 Size = 8
3394 Value = 105900
3395 Column 10
3396 Field Name = FULL_NAME
3397 SQLType = SQL_VARYING
3398 sub type = 0
3399 Scale = 0
3400 Charset = NONE
3401 Nullable
3402 Size = 37
3403 Value = Nelson, Robert
3404 Column 11
3405 Field Name = PREVIOUS_PHONE_EXT
3406 SQLType = SQL_VARYING
3407 sub type = 0
3408 Scale = 0
3409 Charset = NONE
3410 Nullable
3411 Size = 4
3412 Value = 999
3413
3414 @dd-mm-yy hh:mm:ss.zzzz:Trigger my_employee_update: dispose called
3415 @dd-mm-yy hh:mm:ss.zzzz:Setup Trigger my_employee_update
3416 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
3417 Package Name =
3418 Name = MYEMPLOYEEUPDATE
3419 Entry Point = fbudrtests!my_employee_update (fbudrtests,my_employee_update,)
3420 Body =
3421 Trigger Metadata:
3422 Field Count = 12
3423 Alignment = 0
3424 Aligned Length = 0
3425 Field No. 0
3426 Field Name = EMP_NO
3427 Relation Name =
3428 Alias Name =
3429 SQLType = SQL_SHORT
3430 IsNullable = no
3431 SubType = 0
3432 Length = 2
3433 Scale = 0
3434 Offset = 0
3435 Null Offset = 0
3436 Message Length = 2
3437 Field No. 1
3438 Field Name = FIRST_NAME
3439 Relation Name =
3440 Alias Name =
3441 SQLType = SQL_VARYING
3442 IsNullable = no
3443 SubType = 0
3444 Length = 15
3445 Scale = 0
3446 Offset = 0
3447 Null Offset = 0
3448 Message Length = 15
3449 Field No. 2
3450 Field Name = LAST_NAME
3451 Relation Name =
3452 Alias Name =
3453 SQLType = SQL_VARYING
3454 IsNullable = no
3455 SubType = 0
3456 Length = 20
3457 Scale = 0
3458 Offset = 0
3459 Null Offset = 0
3460 Message Length = 20
3461 Field No. 3
3462 Field Name = PHONE_EXT
3463 Relation Name =
3464 Alias Name =
3465 SQLType = SQL_VARYING
3466 IsNullable = yes
3467 SubType = 0
3468 Length = 4
3469 Scale = 0
3470 Offset = 0
3471 Null Offset = 0
3472 Message Length = 4
3473 Field No. 4
3474 Field Name = HIRE_DATE
3475 Relation Name =
3476 Alias Name =
3477 SQLType = SQL_TIMESTAMP
3478 IsNullable = no
3479 SubType = 0
3480 Length = 8
3481 Scale = 0
3482 Offset = 0
3483 Null Offset = 0
3484 Message Length = 8
3485 Field No. 5
3486 Field Name = DEPT_NO
3487 Relation Name =
3488 Alias Name =
3489 SQLType = SQL_TEXT
3490 IsNullable = no
3491 SubType = 0
3492 Length = 3
3493 Scale = 0
3494 Offset = 0
3495 Null Offset = 0
3496 Message Length = 3
3497 Field No. 6
3498 Field Name = JOB_CODE
3499 Relation Name =
3500 Alias Name =
3501 SQLType = SQL_VARYING
3502 IsNullable = no
3503 SubType = 0
3504 Length = 5
3505 Scale = 0
3506 Offset = 0
3507 Null Offset = 0
3508 Message Length = 5
3509 Field No. 7
3510 Field Name = JOB_GRADE
3511 Relation Name =
3512 Alias Name =
3513 SQLType = SQL_SHORT
3514 IsNullable = no
3515 SubType = 0
3516 Length = 2
3517 Scale = 0
3518 Offset = 0
3519 Null Offset = 0
3520 Message Length = 2
3521 Field No. 8
3522 Field Name = JOB_COUNTRY
3523 Relation Name =
3524 Alias Name =
3525 SQLType = SQL_VARYING
3526 IsNullable = no
3527 SubType = 0
3528 Length = 15
3529 Scale = 0
3530 Offset = 0
3531 Null Offset = 0
3532 Message Length = 15
3533 Field No. 9
3534 Field Name = SALARY
3535 Relation Name =
3536 Alias Name =
3537 SQLType = SQL_INT64
3538 IsNullable = no
3539 SubType = 1
3540 Length = 8
3541 Scale = -2
3542 Offset = 0
3543 Null Offset = 0
3544 Message Length = 8
3545 Field No. 10
3546 Field Name = FULL_NAME
3547 Relation Name =
3548 Alias Name =
3549 SQLType = SQL_VARYING
3550 IsNullable = yes
3551 SubType = 0
3552 Length = 37
3553 Scale = 0
3554 Offset = 0
3555 Null Offset = 0
3556 Message Length = 37
3557 Field No. 11
3558 Field Name = PREVIOUS_PHONE_EXT
3559 Relation Name =
3560 Alias Name =
3561 SQLType = SQL_VARYING
3562 IsNullable = yes
3563 SubType = 0
3564 Length = 4
3565 Scale = 0
3566 Offset = 0
3567 Null Offset = 0
3568 Message Length = 4
3569 Trigger Table = EMPLOYEE
3570 Trigger Type = Before
3571
3572 @dd-mm-yy hh:mm:ss.zzzz:Execute Trigger my_employee_update
3573 @dd-mm-yy hh:mm:ss.zzzz:Old Field Values:
3574 Parameter 0:
3575 Field Name = EMP_NO
3576 Alias Name =
3577 SQLType = SQL_SHORT
3578 sub type = 0
3579 Scale = 0
3580 Charset = NONE
3581 Not Nullable
3582 Size = 2
3583 Value = 2
3584 Parameter 1:
3585 Field Name = FIRST_NAME
3586 Alias Name =
3587 SQLType = SQL_VARYING
3588 sub type = 0
3589 Scale = 0
3590 Charset = NONE
3591 Not Nullable
3592 Size = 15
3593 Value = Robert
3594 Parameter 2:
3595 Field Name = LAST_NAME
3596 Alias Name =
3597 SQLType = SQL_VARYING
3598 sub type = 0
3599 Scale = 0
3600 Charset = NONE
3601 Not Nullable
3602 Size = 20
3603 Value = Nelson
3604 Parameter 3:
3605 Field Name = PHONE_EXT
3606 Alias Name =
3607 SQLType = SQL_VARYING
3608 sub type = 0
3609 Scale = 0
3610 Charset = NONE
3611 Nullable
3612 Size = 4
3613 Value = 250
3614 Parameter 4:
3615 Field Name = HIRE_DATE
3616 Alias Name =
3617 SQLType = SQL_TIMESTAMP
3618 sub type = 0
3619 Scale = 0
3620 Charset = NONE
3621 Not Nullable
3622 Size = 8
3623 Value = dd-mm-yy hh:mm:ss.zzzz
3624 Parameter 5:
3625 Field Name = DEPT_NO
3626 Alias Name =
3627 SQLType = SQL_TEXT
3628 sub type = 0
3629 Scale = 0
3630 Charset = NONE
3631 Not Nullable
3632 Size = 3
3633 Value = 600
3634 Parameter 6:
3635 Field Name = JOB_CODE
3636 Alias Name =
3637 SQLType = SQL_VARYING
3638 sub type = 0
3639 Scale = 0
3640 Charset = NONE
3641 Not Nullable
3642 Size = 5
3643 Value = VP
3644 Parameter 7:
3645 Field Name = JOB_GRADE
3646 Alias Name =
3647 SQLType = SQL_SHORT
3648 sub type = 0
3649 Scale = 0
3650 Charset = NONE
3651 Not Nullable
3652 Size = 2
3653 Value = 2
3654 Parameter 8:
3655 Field Name = JOB_COUNTRY
3656 Alias Name =
3657 SQLType = SQL_VARYING
3658 sub type = 0
3659 Scale = 0
3660 Charset = NONE
3661 Not Nullable
3662 Size = 15
3663 Value = USA
3664 Parameter 9:
3665 Field Name = SALARY
3666 Alias Name =
3667 SQLType = SQL_INT64
3668 sub type = 0
3669 Scale = -2
3670 Charset = NONE
3671 Not Nullable
3672 Size = 8
3673 Value = 105900
3674 Parameter 10:
3675 Field Name = FULL_NAME
3676 Alias Name =
3677 SQLType = SQL_VARYING
3678 sub type = 0
3679 Scale = 0
3680 Charset = NONE
3681 Nullable
3682 Size = 37
3683 Value = Nelson, Robert
3684 Parameter 11:
3685 Field Name = PREVIOUS_PHONE_EXT
3686 Alias Name =
3687 SQLType = SQL_VARYING
3688 sub type = 0
3689 Scale = 0
3690 Charset = NONE
3691 Nullable
3692 Size = 4
3693 Value = 999
3694
3695 @dd-mm-yy hh:mm:ss.zzzz:New Field Values:
3696 Column 0
3697 Field Name = EMP_NO
3698 SQLType = SQL_SHORT
3699 sub type = 0
3700 Scale = 0
3701 Charset = NONE
3702 Not Nullable
3703 Size = 2
3704 Value = 2
3705 Column 1
3706 Field Name = FIRST_NAME
3707 SQLType = SQL_VARYING
3708 sub type = 0
3709 Scale = 0
3710 Charset = NONE
3711 Not Nullable
3712 Size = 15
3713 Value = Robert
3714 Column 2
3715 Field Name = LAST_NAME
3716 SQLType = SQL_VARYING
3717 sub type = 0
3718 Scale = 0
3719 Charset = NONE
3720 Not Nullable
3721 Size = 20
3722 Value = Nelson
3723 Column 3
3724 Field Name = PHONE_EXT
3725 SQLType = SQL_VARYING
3726 sub type = 0
3727 Scale = 0
3728 Charset = NONE
3729 Nullable
3730 Size = 4
3731 Value = 999
3732 Column 4
3733 Field Name = HIRE_DATE
3734 SQLType = SQL_TIMESTAMP
3735 sub type = 0
3736 Scale = 0
3737 Charset = NONE
3738 Not Nullable
3739 Size = 8
3740 Value = dd-mm-yy hh:mm:ss.zzzz
3741 Column 5
3742 Field Name = DEPT_NO
3743 SQLType = SQL_TEXT
3744 sub type = 0
3745 Scale = 0
3746 Charset = NONE
3747 Not Nullable
3748 Size = 3
3749 Value = 600
3750 Column 6
3751 Field Name = JOB_CODE
3752 SQLType = SQL_VARYING
3753 sub type = 0
3754 Scale = 0
3755 Charset = NONE
3756 Not Nullable
3757 Size = 5
3758 Value = VP
3759 Column 7
3760 Field Name = JOB_GRADE
3761 SQLType = SQL_SHORT
3762 sub type = 0
3763 Scale = 0
3764 Charset = NONE
3765 Not Nullable
3766 Size = 2
3767 Value = 2
3768 Column 8
3769 Field Name = JOB_COUNTRY
3770 SQLType = SQL_VARYING
3771 sub type = 0
3772 Scale = 0
3773 Charset = NONE
3774 Not Nullable
3775 Size = 15
3776 Value = USA
3777 Column 9
3778 Field Name = SALARY
3779 SQLType = SQL_INT64
3780 sub type = 0
3781 Scale = -2
3782 Charset = NONE
3783 Not Nullable
3784 Size = 8
3785 Value = 105900
3786 Column 10
3787 Field Name = FULL_NAME
3788 SQLType = SQL_VARYING
3789 sub type = 0
3790 Scale = 0
3791 Charset = NONE
3792 Nullable
3793 Size = 37
3794 Value = Nelson, Robert
3795 Column 11
3796 Field Name = PREVIOUS_PHONE_EXT
3797 SQLType = SQL_VARYING
3798 sub type = 0
3799 Scale = 0
3800 Charset = NONE
3801 Nullable
3802 Size = 4
3803 Value = 999
3804
3805 @dd-mm-yy hh:mm:ss.zzzz:New Field Values after trigger execution
3806 Column 0
3807 Field Name = EMP_NO
3808 SQLType = SQL_SHORT
3809 sub type = 0
3810 Scale = 0
3811 Charset = NONE
3812 Not Nullable
3813 Size = 2
3814 Value = 2
3815 Column 1
3816 Field Name = FIRST_NAME
3817 SQLType = SQL_VARYING
3818 sub type = 0
3819 Scale = 0
3820 Charset = NONE
3821 Not Nullable
3822 Size = 15
3823 Value = Robert
3824 Column 2
3825 Field Name = LAST_NAME
3826 SQLType = SQL_VARYING
3827 sub type = 0
3828 Scale = 0
3829 Charset = NONE
3830 Not Nullable
3831 Size = 20
3832 Value = Nelson
3833 Column 3
3834 Field Name = PHONE_EXT
3835 SQLType = SQL_VARYING
3836 sub type = 0
3837 Scale = 0
3838 Charset = NONE
3839 Nullable
3840 Size = 4
3841 Value = 999
3842 Column 4
3843 Field Name = HIRE_DATE
3844 SQLType = SQL_TIMESTAMP
3845 sub type = 0
3846 Scale = 0
3847 Charset = NONE
3848 Not Nullable
3849 Size = 8
3850 Value = dd-mm-yy hh:mm:ss.zzzz
3851 Column 5
3852 Field Name = DEPT_NO
3853 SQLType = SQL_TEXT
3854 sub type = 0
3855 Scale = 0
3856 Charset = NONE
3857 Not Nullable
3858 Size = 3
3859 Value = 600
3860 Column 6
3861 Field Name = JOB_CODE
3862 SQLType = SQL_VARYING
3863 sub type = 0
3864 Scale = 0
3865 Charset = NONE
3866 Not Nullable
3867 Size = 5
3868 Value = VP
3869 Column 7
3870 Field Name = JOB_GRADE
3871 SQLType = SQL_SHORT
3872 sub type = 0
3873 Scale = 0
3874 Charset = NONE
3875 Not Nullable
3876 Size = 2
3877 Value = 2
3878 Column 8
3879 Field Name = JOB_COUNTRY
3880 SQLType = SQL_VARYING
3881 sub type = 0
3882 Scale = 0
3883 Charset = NONE
3884 Not Nullable
3885 Size = 15
3886 Value = USA
3887 Column 9
3888 Field Name = SALARY
3889 SQLType = SQL_INT64
3890 sub type = 0
3891 Scale = -2
3892 Charset = NONE
3893 Not Nullable
3894 Size = 8
3895 Value = 105900
3896 Column 10
3897 Field Name = FULL_NAME
3898 SQLType = SQL_VARYING
3899 sub type = 0
3900 Scale = 0
3901 Charset = NONE
3902 Nullable
3903 Size = 37
3904 Value = Nelson, Robert
3905 Column 11
3906 Field Name = PREVIOUS_PHONE_EXT
3907 SQLType = SQL_VARYING
3908 sub type = 0
3909 Scale = 0
3910 Charset = NONE
3911 Nullable
3912 Size = 4
3913 Value = 250
3914
3915 @dd-mm-yy hh:mm:ss.zzzz:Execute Trigger my_employee_update
3916 @dd-mm-yy hh:mm:ss.zzzz:Old Field Values:
3917 Parameter 0:
3918 Field Name = EMP_NO
3919 Alias Name =
3920 SQLType = SQL_SHORT
3921 sub type = 0
3922 Scale = 0
3923 Charset = NONE
3924 Not Nullable
3925 Size = 2
3926 Value = 2
3927 Parameter 1:
3928 Field Name = FIRST_NAME
3929 Alias Name =
3930 SQLType = SQL_VARYING
3931 sub type = 0
3932 Scale = 0
3933 Charset = NONE
3934 Not Nullable
3935 Size = 15
3936 Value = Robert
3937 Parameter 2:
3938 Field Name = LAST_NAME
3939 Alias Name =
3940 SQLType = SQL_VARYING
3941 sub type = 0
3942 Scale = 0
3943 Charset = NONE
3944 Not Nullable
3945 Size = 20
3946 Value = Nelson
3947 Parameter 3:
3948 Field Name = PHONE_EXT
3949 Alias Name =
3950 SQLType = SQL_VARYING
3951 sub type = 0
3952 Scale = 0
3953 Charset = NONE
3954 Nullable
3955 Size = 4
3956 Value = 999
3957 Parameter 4:
3958 Field Name = HIRE_DATE
3959 Alias Name =
3960 SQLType = SQL_TIMESTAMP
3961 sub type = 0
3962 Scale = 0
3963 Charset = NONE
3964 Not Nullable
3965 Size = 8
3966 Value = dd-mm-yy hh:mm:ss.zzzz
3967 Parameter 5:
3968 Field Name = DEPT_NO
3969 Alias Name =
3970 SQLType = SQL_TEXT
3971 sub type = 0
3972 Scale = 0
3973 Charset = NONE
3974 Not Nullable
3975 Size = 3
3976 Value = 600
3977 Parameter 6:
3978 Field Name = JOB_CODE
3979 Alias Name =
3980 SQLType = SQL_VARYING
3981 sub type = 0
3982 Scale = 0
3983 Charset = NONE
3984 Not Nullable
3985 Size = 5
3986 Value = VP
3987 Parameter 7:
3988 Field Name = JOB_GRADE
3989 Alias Name =
3990 SQLType = SQL_SHORT
3991 sub type = 0
3992 Scale = 0
3993 Charset = NONE
3994 Not Nullable
3995 Size = 2
3996 Value = 2
3997 Parameter 8:
3998 Field Name = JOB_COUNTRY
3999 Alias Name =
4000 SQLType = SQL_VARYING
4001 sub type = 0
4002 Scale = 0
4003 Charset = NONE
4004 Not Nullable
4005 Size = 15
4006 Value = USA
4007 Parameter 9:
4008 Field Name = SALARY
4009 Alias Name =
4010 SQLType = SQL_INT64
4011 sub type = 0
4012 Scale = -2
4013 Charset = NONE
4014 Not Nullable
4015 Size = 8
4016 Value = 105900
4017 Parameter 10:
4018 Field Name = FULL_NAME
4019 Alias Name =
4020 SQLType = SQL_VARYING
4021 sub type = 0
4022 Scale = 0
4023 Charset = NONE
4024 Nullable
4025 Size = 37
4026 Value = Nelson, Robert
4027 Parameter 11:
4028 Field Name = PREVIOUS_PHONE_EXT
4029 Alias Name =
4030 SQLType = SQL_VARYING
4031 sub type = 0
4032 Scale = 0
4033 Charset = NONE
4034 Nullable
4035 Size = 4
4036 Value = 250
4037
4038 @dd-mm-yy hh:mm:ss.zzzz:New Field Values:
4039 Column 0
4040 Field Name = EMP_NO
4041 SQLType = SQL_SHORT
4042 sub type = 0
4043 Scale = 0
4044 Charset = NONE
4045 Not Nullable
4046 Size = 2
4047 Value = 2
4048 Column 1
4049 Field Name = FIRST_NAME
4050 SQLType = SQL_VARYING
4051 sub type = 0
4052 Scale = 0
4053 Charset = NONE
4054 Not Nullable
4055 Size = 15
4056 Value = Robert
4057 Column 2
4058 Field Name = LAST_NAME
4059 SQLType = SQL_VARYING
4060 sub type = 0
4061 Scale = 0
4062 Charset = NONE
4063 Not Nullable
4064 Size = 20
4065 Value = Nelson
4066 Column 3
4067 Field Name = PHONE_EXT
4068 SQLType = SQL_VARYING
4069 sub type = 0
4070 Scale = 0
4071 Charset = NONE
4072 Nullable
4073 Size = 4
4074 Value = 250
4075 Column 4
4076 Field Name = HIRE_DATE
4077 SQLType = SQL_TIMESTAMP
4078 sub type = 0
4079 Scale = 0
4080 Charset = NONE
4081 Not Nullable
4082 Size = 8
4083 Value = dd-mm-yy hh:mm:ss.zzzz
4084 Column 5
4085 Field Name = DEPT_NO
4086 SQLType = SQL_TEXT
4087 sub type = 0
4088 Scale = 0
4089 Charset = NONE
4090 Not Nullable
4091 Size = 3
4092 Value = 600
4093 Column 6
4094 Field Name = JOB_CODE
4095 SQLType = SQL_VARYING
4096 sub type = 0
4097 Scale = 0
4098 Charset = NONE
4099 Not Nullable
4100 Size = 5
4101 Value = VP
4102 Column 7
4103 Field Name = JOB_GRADE
4104 SQLType = SQL_SHORT
4105 sub type = 0
4106 Scale = 0
4107 Charset = NONE
4108 Not Nullable
4109 Size = 2
4110 Value = 2
4111 Column 8
4112 Field Name = JOB_COUNTRY
4113 SQLType = SQL_VARYING
4114 sub type = 0
4115 Scale = 0
4116 Charset = NONE
4117 Not Nullable
4118 Size = 15
4119 Value = USA
4120 Column 9
4121 Field Name = SALARY
4122 SQLType = SQL_INT64
4123 sub type = 0
4124 Scale = -2
4125 Charset = NONE
4126 Not Nullable
4127 Size = 8
4128 Value = 105900
4129 Column 10
4130 Field Name = FULL_NAME
4131 SQLType = SQL_VARYING
4132 sub type = 0
4133 Scale = 0
4134 Charset = NONE
4135 Nullable
4136 Size = 37
4137 Value = Nelson, Robert
4138 Column 11
4139 Field Name = PREVIOUS_PHONE_EXT
4140 SQLType = SQL_VARYING
4141 sub type = 0
4142 Scale = 0
4143 Charset = NONE
4144 Nullable
4145 Size = 4
4146 Value = 250
4147
4148 @dd-mm-yy hh:mm:ss.zzzz:New Field Values after trigger execution
4149 Column 0
4150 Field Name = EMP_NO
4151 SQLType = SQL_SHORT
4152 sub type = 0
4153 Scale = 0
4154 Charset = NONE
4155 Not Nullable
4156 Size = 2
4157 Value = 2
4158 Column 1
4159 Field Name = FIRST_NAME
4160 SQLType = SQL_VARYING
4161 sub type = 0
4162 Scale = 0
4163 Charset = NONE
4164 Not Nullable
4165 Size = 15
4166 Value = Robert
4167 Column 2
4168 Field Name = LAST_NAME
4169 SQLType = SQL_VARYING
4170 sub type = 0
4171 Scale = 0
4172 Charset = NONE
4173 Not Nullable
4174 Size = 20
4175 Value = Nelson
4176 Column 3
4177 Field Name = PHONE_EXT
4178 SQLType = SQL_VARYING
4179 sub type = 0
4180 Scale = 0
4181 Charset = NONE
4182 Nullable
4183 Size = 4
4184 Value = 250
4185 Column 4
4186 Field Name = HIRE_DATE
4187 SQLType = SQL_TIMESTAMP
4188 sub type = 0
4189 Scale = 0
4190 Charset = NONE
4191 Not Nullable
4192 Size = 8
4193 Value = dd-mm-yy hh:mm:ss.zzzz
4194 Column 5
4195 Field Name = DEPT_NO
4196 SQLType = SQL_TEXT
4197 sub type = 0
4198 Scale = 0
4199 Charset = NONE
4200 Not Nullable
4201 Size = 3
4202 Value = 600
4203 Column 6
4204 Field Name = JOB_CODE
4205 SQLType = SQL_VARYING
4206 sub type = 0
4207 Scale = 0
4208 Charset = NONE
4209 Not Nullable
4210 Size = 5
4211 Value = VP
4212 Column 7
4213 Field Name = JOB_GRADE
4214 SQLType = SQL_SHORT
4215 sub type = 0
4216 Scale = 0
4217 Charset = NONE
4218 Not Nullable
4219 Size = 2
4220 Value = 2
4221 Column 8
4222 Field Name = JOB_COUNTRY
4223 SQLType = SQL_VARYING
4224 sub type = 0
4225 Scale = 0
4226 Charset = NONE
4227 Not Nullable
4228 Size = 15
4229 Value = USA
4230 Column 9
4231 Field Name = SALARY
4232 SQLType = SQL_INT64
4233 sub type = 0
4234 Scale = -2
4235 Charset = NONE
4236 Not Nullable
4237 Size = 8
4238 Value = 105900
4239 Column 10
4240 Field Name = FULL_NAME
4241 SQLType = SQL_VARYING
4242 sub type = 0
4243 Scale = 0
4244 Charset = NONE
4245 Nullable
4246 Size = 37
4247 Value = Nelson, Robert
4248 Column 11
4249 Field Name = PREVIOUS_PHONE_EXT
4250 SQLType = SQL_VARYING
4251 sub type = 0
4252 Scale = 0
4253 Charset = NONE
4254 Nullable
4255 Size = 4
4256 Value = 999
4257
4258 @dd-mm-yy hh:mm:ss.zzzz:Trigger my_employee_update: dispose called
4259 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure show_att
4260 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
4261 Package Name =
4262 Name = SHOWATTACHMENTS
4263 Entry Point = fbudrtests!show_att (fbudrtests,show_att,)
4264 Body =
4265 Input Metadata:
4266 Field Count = 1
4267 Alignment = 2
4268 Aligned Length = 36
4269 Field No. 0
4270 Field Name = USER_NAME
4271 Relation Name =
4272 Alias Name =
4273 SQLType = SQL_VARYING
4274 IsNullable = yes
4275 SubType = 0
4276 Length = 32
4277 Scale = 0
4278 Offset = 0
4279 Null Offset = 34
4280 Message Length = 32
4281
4282 Output Metadata:
4283 Field Count = 5
4284 Alignment = 8
4285 Aligned Length = 664
4286 Field No. 0
4287 Field Name = MON$ATTACHMENT_ID
4288 Relation Name =
4289 Alias Name =
4290 SQLType = SQL_INT64
4291 IsNullable = yes
4292 SubType = 0
4293 Length = 8
4294 Scale = 0
4295 Offset = 0
4296 Null Offset = 8
4297 Message Length = 8
4298 Field No. 1
4299 Field Name = MON$ATTACHMENT_NAME
4300 Relation Name =
4301 Alias Name =
4302 SQLType = SQL_VARYING
4303 IsNullable = yes
4304 SubType = 0
4305 Length = 255
4306 Scale = 0
4307 Offset = 10
4308 Null Offset = 268
4309 Message Length = 255
4310 Field No. 2
4311 Field Name = MON$USER
4312 Relation Name =
4313 Alias Name =
4314 SQLType = SQL_TEXT
4315 IsNullable = yes
4316 SubType = 0
4317 Length = 63
4318 Scale = 0
4319 Offset = 270
4320 Null Offset = 334
4321 Message Length = 63
4322 Field No. 3
4323 Field Name = MON$ROLE
4324 Relation Name =
4325 Alias Name =
4326 SQLType = SQL_TEXT
4327 IsNullable = yes
4328 SubType = 0
4329 Length = 63
4330 Scale = 0
4331 Offset = 336
4332 Null Offset = 400
4333 Message Length = 63
4334 Field No. 4
4335 Field Name = MON$REMOTE_HOST
4336 Relation Name =
4337 Alias Name =
4338 SQLType = SQL_VARYING
4339 IsNullable = yes
4340 SubType = 0
4341 Length = 255
4342 Scale = 0
4343 Offset = 402
4344 Null Offset = 660
4345 Message Length = 255
4346
4347 @dd-mm-yy hh:mm:ss.zzzz:Open Select Procedure show_att
4348 @dd-mm-yy hh:mm:ss.zzzz:External Context:
4349 Attachment ID = 588
4350 Transaction ID = 1573
4351 User Name = SYSDBA
4352 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
4353 Client Character Set = NONE
4354
4355 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
4356 Parameter 0:
4357 Field Name = USER_NAME
4358 Alias Name =
4359 SQLType = SQL_VARYING
4360 sub type = 0
4361 Scale = 0
4362 Charset = NONE
4363 Nullable
4364 Size = 32
4365 Value = NULL
4366
4367 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
4368 Column 0
4369 Field Name = MON$ATTACHMENT_ID
4370 SQLType = SQL_INT64
4371 sub type = 0
4372 Scale = 0
4373 Charset = NONE
4374 Nullable
4375 Size = 8
4376 Value = NULL
4377 Column 1
4378 Field Name = MON$ATTACHMENT_NAME
4379 SQLType = SQL_VARYING
4380 sub type = 0
4381 Scale = 0
4382 Charset = NONE
4383 Nullable
4384 Size = 255
4385 Value = NULL
4386 Column 2
4387 Field Name = MON$USER
4388 SQLType = SQL_TEXT
4389 sub type = 0
4390 Scale = 0
4391 Charset = NONE
4392 Nullable
4393 Size = 63
4394 Value = NULL
4395 Column 3
4396 Field Name = MON$ROLE
4397 SQLType = SQL_TEXT
4398 sub type = 0
4399 Scale = 0
4400 Charset = NONE
4401 Nullable
4402 Size = 63
4403 Value = NULL
4404 Column 4
4405 Field Name = MON$REMOTE_HOST
4406 SQLType = SQL_VARYING
4407 sub type = 0
4408 Scale = 0
4409 Charset = NONE
4410 Nullable
4411 Size = 255
4412 Value = NULL
4413
4414 @dd-mm-yy hh:mm:ss.zzzz:Procedure show_att: dispose called with refcount = 2
4415 @dd-mm-yy hh:mm:ss.zzzz:Open Select Procedure show_att
4416 @dd-mm-yy hh:mm:ss.zzzz:External Context:
4417 Attachment ID = 588
4418 Transaction ID = 1573
4419 User Name = SYSDBA
4420 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
4421 Client Character Set = NONE
4422
4423 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
4424 Parameter 0:
4425 Field Name = USER_NAME
4426 Alias Name =
4427 SQLType = SQL_VARYING
4428 sub type = 0
4429 Scale = 0
4430 Charset = NONE
4431 Nullable
4432 Size = 32
4433 Value =
4434
4435 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
4436 Column 0
4437 Field Name = MON$ATTACHMENT_ID
4438 SQLType = SQL_INT64
4439 sub type = 0
4440 Scale = 0
4441 Charset = NONE
4442 Nullable
4443 Size = 8
4444 Value = NULL
4445 Column 1
4446 Field Name = MON$ATTACHMENT_NAME
4447 SQLType = SQL_VARYING
4448 sub type = 0
4449 Scale = 0
4450 Charset = NONE
4451 Nullable
4452 Size = 255
4453 Value = NULL
4454 Column 2
4455 Field Name = MON$USER
4456 SQLType = SQL_TEXT
4457 sub type = 0
4458 Scale = 0
4459 Charset = NONE
4460 Nullable
4461 Size = 63
4462 Value = NULL
4463 Column 3
4464 Field Name = MON$ROLE
4465 SQLType = SQL_TEXT
4466 sub type = 0
4467 Scale = 0
4468 Charset = NONE
4469 Nullable
4470 Size = 63
4471 Value = NULL
4472 Column 4
4473 Field Name = MON$REMOTE_HOST
4474 SQLType = SQL_VARYING
4475 sub type = 0
4476 Scale = 0
4477 Charset = NONE
4478 Nullable
4479 Size = 255
4480 Value = NULL
4481
4482 @dd-mm-yy hh:mm:ss.zzzz:Procedure show_att: dispose called with refcount = 2
4483 @dd-mm-yy hh:mm:ss.zzzz:Open Select Procedure show_att
4484 @dd-mm-yy hh:mm:ss.zzzz:External Context:
4485 Attachment ID = 588
4486 Transaction ID = 1573
4487 User Name = SYSDBA
4488 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
4489 Client Character Set = NONE
4490
4491 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
4492 Parameter 0:
4493 Field Name = USER_NAME
4494 Alias Name =
4495 SQLType = SQL_VARYING
4496 sub type = 0
4497 Scale = 0
4498 Charset = NONE
4499 Nullable
4500 Size = 32
4501 Value = TESTER
4502
4503 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
4504 Column 0
4505 Field Name = MON$ATTACHMENT_ID
4506 SQLType = SQL_INT64
4507 sub type = 0
4508 Scale = 0
4509 Charset = NONE
4510 Nullable
4511 Size = 8
4512 Value = NULL
4513 Column 1
4514 Field Name = MON$ATTACHMENT_NAME
4515 SQLType = SQL_VARYING
4516 sub type = 0
4517 Scale = 0
4518 Charset = NONE
4519 Nullable
4520 Size = 255
4521 Value = NULL
4522 Column 2
4523 Field Name = MON$USER
4524 SQLType = SQL_TEXT
4525 sub type = 0
4526 Scale = 0
4527 Charset = NONE
4528 Nullable
4529 Size = 63
4530 Value = NULL
4531 Column 3
4532 Field Name = MON$ROLE
4533 SQLType = SQL_TEXT
4534 sub type = 0
4535 Scale = 0
4536 Charset = NONE
4537 Nullable
4538 Size = 63
4539 Value = NULL
4540 Column 4
4541 Field Name = MON$REMOTE_HOST
4542 SQLType = SQL_VARYING
4543 sub type = 0
4544 Scale = 0
4545 Charset = NONE
4546 Nullable
4547 Size = 255
4548 Value = NULL
4549
4550 @dd-mm-yy hh:mm:ss.zzzz:Procedure show_att: dispose called with refcount = 2
4551 @dd-mm-yy hh:mm:ss.zzzz:Open Select Procedure show_att
4552 @dd-mm-yy hh:mm:ss.zzzz:External Context:
4553 Attachment ID = 588
4554 Transaction ID = 1573
4555 User Name = SYSDBA
4556 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
4557 Client Character Set = NONE
4558
4559 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
4560 Parameter 0:
4561 Field Name = USER_NAME
4562 Alias Name =
4563 SQLType = SQL_VARYING
4564 sub type = 0
4565 Scale = 0
4566 Charset = NONE
4567 Nullable
4568 Size = 32
4569 Value = SYSDBA
4570
4571 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
4572 Column 0
4573 Field Name = MON$ATTACHMENT_ID
4574 SQLType = SQL_INT64
4575 sub type = 0
4576 Scale = 0
4577 Charset = NONE
4578 Nullable
4579 Size = 8
4580 Value = NULL
4581 Column 1
4582 Field Name = MON$ATTACHMENT_NAME
4583 SQLType = SQL_VARYING
4584 sub type = 0
4585 Scale = 0
4586 Charset = NONE
4587 Nullable
4588 Size = 255
4589 Value = NULL
4590 Column 2
4591 Field Name = MON$USER
4592 SQLType = SQL_TEXT
4593 sub type = 0
4594 Scale = 0
4595 Charset = NONE
4596 Nullable
4597 Size = 63
4598 Value = NULL
4599 Column 3
4600 Field Name = MON$ROLE
4601 SQLType = SQL_TEXT
4602 sub type = 0
4603 Scale = 0
4604 Charset = NONE
4605 Nullable
4606 Size = 63
4607 Value = NULL
4608 Column 4
4609 Field Name = MON$REMOTE_HOST
4610 SQLType = SQL_VARYING
4611 sub type = 0
4612 Scale = 0
4613 Charset = NONE
4614 Nullable
4615 Size = 255
4616 Value = NULL
4617
4618 @dd-mm-yy hh:mm:ss.zzzz:Procedure show_att: dispose called with refcount = 2
4619 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure server_info
4620 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
4621 Package Name =
4622 Name = GETSERVERINFO
4623 Entry Point = fbudrtests!server_info (fbudrtests,server_info,)
4624 Body =
4625 Input Metadata:
4626 Field Count = 0
4627 Alignment = 2
4628 Aligned Length = 0
4629
4630 Output Metadata:
4631 Field Count = 1
4632 Alignment = 2
4633 Aligned Length = 260
4634 Field No. 0
4635 Field Name = SERVERINFO
4636 Relation Name =
4637 Alias Name =
4638 SQLType = SQL_VARYING
4639 IsNullable = yes
4640 SubType = 0
4641 Length = 256
4642 Scale = 0
4643 Offset = 0
4644 Null Offset = 258
4645 Message Length = 256
4646
4647 @dd-mm-yy hh:mm:ss.zzzz:Open Select Procedure server_info
4648 @dd-mm-yy hh:mm:ss.zzzz:External Context:
4649 Attachment ID = 588
4650 Transaction ID = 1573
4651 User Name = SYSDBA
4652 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
4653 Client Character Set = NONE
4654
4655 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
4656
4657 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
4658 Column 0
4659 Field Name = SERVERINFO
4660 SQLType = SQL_VARYING
4661 sub type = 0
4662 Scale = 0
4663 Charset = NONE
4664 Nullable
4665 Size = 256
4666 Value = NULL
4667
4668 @dd-mm-yy hh:mm:ss.zzzz:Procedure server_info: dispose called with refcount = 2
4669 @dd-mm-yy hh:mm:ss.zzzz:Procedure server_info: dispose called with refcount = 1
4670 @dd-mm-yy hh:mm:ss.zzzz:Procedure show_att: dispose called with refcount = 1
4671 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure show_att
4672 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
4673 Package Name =
4674 Name = SHOWATTACHMENTS
4675 Entry Point = fbudrtests!show_att (fbudrtests,show_att,)
4676 Body =
4677 Input Metadata:
4678 Field Count = 1
4679 Alignment = 2
4680 Aligned Length = 36
4681 Field No. 0
4682 Field Name = USER_NAME
4683 Relation Name =
4684 Alias Name =
4685 SQLType = SQL_VARYING
4686 IsNullable = yes
4687 SubType = 0
4688 Length = 32
4689 Scale = 0
4690 Offset = 0
4691 Null Offset = 34
4692 Message Length = 32
4693
4694 Output Metadata:
4695 Field Count = 5
4696 Alignment = 8
4697 Aligned Length = 664
4698 Field No. 0
4699 Field Name = MON$ATTACHMENT_ID
4700 Relation Name =
4701 Alias Name =
4702 SQLType = SQL_INT64
4703 IsNullable = yes
4704 SubType = 0
4705 Length = 8
4706 Scale = 0
4707 Offset = 0
4708 Null Offset = 8
4709 Message Length = 8
4710 Field No. 1
4711 Field Name = MON$ATTACHMENT_NAME
4712 Relation Name =
4713 Alias Name =
4714 SQLType = SQL_VARYING
4715 IsNullable = yes
4716 SubType = 0
4717 Length = 255
4718 Scale = 0
4719 Offset = 10
4720 Null Offset = 268
4721 Message Length = 255
4722 Field No. 2
4723 Field Name = MON$USER
4724 Relation Name =
4725 Alias Name =
4726 SQLType = SQL_TEXT
4727 IsNullable = yes
4728 SubType = 0
4729 Length = 63
4730 Scale = 0
4731 Offset = 270
4732 Null Offset = 334
4733 Message Length = 63
4734 Field No. 3
4735 Field Name = MON$ROLE
4736 Relation Name =
4737 Alias Name =
4738 SQLType = SQL_TEXT
4739 IsNullable = yes
4740 SubType = 0
4741 Length = 63
4742 Scale = 0
4743 Offset = 336
4744 Null Offset = 400
4745 Message Length = 63
4746 Field No. 4
4747 Field Name = MON$REMOTE_HOST
4748 Relation Name =
4749 Alias Name =
4750 SQLType = SQL_VARYING
4751 IsNullable = yes
4752 SubType = 0
4753 Length = 255
4754 Scale = 0
4755 Offset = 402
4756 Null Offset = 660
4757 Message Length = 255
4758
4759 @dd-mm-yy hh:mm:ss.zzzz:Open Select Procedure show_att
4760 @dd-mm-yy hh:mm:ss.zzzz:External Context:
4761 Attachment ID = 594
4762 Transaction ID = 1583
4763 User Name = TESTER
4764 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
4765 Client Character Set = NONE
4766
4767 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
4768 Parameter 0:
4769 Field Name = USER_NAME
4770 Alias Name =
4771 SQLType = SQL_VARYING
4772 sub type = 0
4773 Scale = 0
4774 Charset = NONE
4775 Nullable
4776 Size = 32
4777 Value = NULL
4778
4779 @dd-mm-yy hh:mm:ss.zzzz:Exception raised
4780 Engine Code: 335544788
4781 Unable to perform operation
4782 -System privilege CHANGE_HEADER_SETTINGS is missing
4783 @dd-mm-yy hh:mm:ss.zzzz:Open Select Procedure show_att
4784 @dd-mm-yy hh:mm:ss.zzzz:External Context:
4785 Attachment ID = 594
4786 Transaction ID = 1583
4787 User Name = TESTER
4788 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
4789 Client Character Set = NONE
4790
4791 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
4792 Parameter 0:
4793 Field Name = USER_NAME
4794 Alias Name =
4795 SQLType = SQL_VARYING
4796 sub type = 0
4797 Scale = 0
4798 Charset = NONE
4799 Nullable
4800 Size = 32
4801 Value =
4802
4803 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
4804 Column 0
4805 Field Name = MON$ATTACHMENT_ID
4806 SQLType = SQL_INT64
4807 sub type = 0
4808 Scale = 0
4809 Charset = NONE
4810 Nullable
4811 Size = 8
4812 Value = NULL
4813 Column 1
4814 Field Name = MON$ATTACHMENT_NAME
4815 SQLType = SQL_VARYING
4816 sub type = 0
4817 Scale = 0
4818 Charset = NONE
4819 Nullable
4820 Size = 255
4821 Value = NULL
4822 Column 2
4823 Field Name = MON$USER
4824 SQLType = SQL_TEXT
4825 sub type = 0
4826 Scale = 0
4827 Charset = NONE
4828 Nullable
4829 Size = 63
4830 Value = NULL
4831 Column 3
4832 Field Name = MON$ROLE
4833 SQLType = SQL_TEXT
4834 sub type = 0
4835 Scale = 0
4836 Charset = NONE
4837 Nullable
4838 Size = 63
4839 Value = NULL
4840 Column 4
4841 Field Name = MON$REMOTE_HOST
4842 SQLType = SQL_VARYING
4843 sub type = 0
4844 Scale = 0
4845 Charset = NONE
4846 Nullable
4847 Size = 255
4848 Value = NULL
4849
4850 @dd-mm-yy hh:mm:ss.zzzz:Procedure show_att: dispose called with refcount = 2
4851 @dd-mm-yy hh:mm:ss.zzzz:Open Select Procedure show_att
4852 @dd-mm-yy hh:mm:ss.zzzz:External Context:
4853 Attachment ID = 594
4854 Transaction ID = 1583
4855 User Name = TESTER
4856 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
4857 Client Character Set = NONE
4858
4859 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
4860 Parameter 0:
4861 Field Name = USER_NAME
4862 Alias Name =
4863 SQLType = SQL_VARYING
4864 sub type = 0
4865 Scale = 0
4866 Charset = NONE
4867 Nullable
4868 Size = 32
4869 Value = TESTER
4870
4871 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
4872 Column 0
4873 Field Name = MON$ATTACHMENT_ID
4874 SQLType = SQL_INT64
4875 sub type = 0
4876 Scale = 0
4877 Charset = NONE
4878 Nullable
4879 Size = 8
4880 Value = NULL
4881 Column 1
4882 Field Name = MON$ATTACHMENT_NAME
4883 SQLType = SQL_VARYING
4884 sub type = 0
4885 Scale = 0
4886 Charset = NONE
4887 Nullable
4888 Size = 255
4889 Value = NULL
4890 Column 2
4891 Field Name = MON$USER
4892 SQLType = SQL_TEXT
4893 sub type = 0
4894 Scale = 0
4895 Charset = NONE
4896 Nullable
4897 Size = 63
4898 Value = NULL
4899 Column 3
4900 Field Name = MON$ROLE
4901 SQLType = SQL_TEXT
4902 sub type = 0
4903 Scale = 0
4904 Charset = NONE
4905 Nullable
4906 Size = 63
4907 Value = NULL
4908 Column 4
4909 Field Name = MON$REMOTE_HOST
4910 SQLType = SQL_VARYING
4911 sub type = 0
4912 Scale = 0
4913 Charset = NONE
4914 Nullable
4915 Size = 255
4916 Value = NULL
4917
4918 @dd-mm-yy hh:mm:ss.zzzz:Procedure show_att: dispose called with refcount = 2
4919 @dd-mm-yy hh:mm:ss.zzzz:Open Select Procedure show_att
4920 @dd-mm-yy hh:mm:ss.zzzz:External Context:
4921 Attachment ID = 594
4922 Transaction ID = 1583
4923 User Name = TESTER
4924 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
4925 Client Character Set = NONE
4926
4927 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
4928 Parameter 0:
4929 Field Name = USER_NAME
4930 Alias Name =
4931 SQLType = SQL_VARYING
4932 sub type = 0
4933 Scale = 0
4934 Charset = NONE
4935 Nullable
4936 Size = 32
4937 Value = SYSDBA
4938
4939 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
4940 Column 0
4941 Field Name = MON$ATTACHMENT_ID
4942 SQLType = SQL_INT64
4943 sub type = 0
4944 Scale = 0
4945 Charset = NONE
4946 Nullable
4947 Size = 8
4948 Value = NULL
4949 Column 1
4950 Field Name = MON$ATTACHMENT_NAME
4951 SQLType = SQL_VARYING
4952 sub type = 0
4953 Scale = 0
4954 Charset = NONE
4955 Nullable
4956 Size = 255
4957 Value = NULL
4958 Column 2
4959 Field Name = MON$USER
4960 SQLType = SQL_TEXT
4961 sub type = 0
4962 Scale = 0
4963 Charset = NONE
4964 Nullable
4965 Size = 63
4966 Value = NULL
4967 Column 3
4968 Field Name = MON$ROLE
4969 SQLType = SQL_TEXT
4970 sub type = 0
4971 Scale = 0
4972 Charset = NONE
4973 Nullable
4974 Size = 63
4975 Value = NULL
4976 Column 4
4977 Field Name = MON$REMOTE_HOST
4978 SQLType = SQL_VARYING
4979 sub type = 0
4980 Scale = 0
4981 Charset = NONE
4982 Nullable
4983 Size = 255
4984 Value = NULL
4985
4986 @dd-mm-yy hh:mm:ss.zzzz:Procedure show_att: dispose called with refcount = 2
4987 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure server_info
4988 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
4989 Package Name =
4990 Name = GETSERVERINFO
4991 Entry Point = fbudrtests!server_info (fbudrtests,server_info,)
4992 Body =
4993 Input Metadata:
4994 Field Count = 0
4995 Alignment = 2
4996 Aligned Length = 0
4997
4998 Output Metadata:
4999 Field Count = 1
5000 Alignment = 2
5001 Aligned Length = 260
5002 Field No. 0
5003 Field Name = SERVERINFO
5004 Relation Name =
5005 Alias Name =
5006 SQLType = SQL_VARYING
5007 IsNullable = yes
5008 SubType = 0
5009 Length = 256
5010 Scale = 0
5011 Offset = 0
5012 Null Offset = 258
5013 Message Length = 256
5014
5015 @dd-mm-yy hh:mm:ss.zzzz:Open Select Procedure server_info
5016 @dd-mm-yy hh:mm:ss.zzzz:External Context:
5017 Attachment ID = 594
5018 Transaction ID = 1583
5019 User Name = TESTER
5020 Database Name = /opt/firebird/4.0.1/examples/empbuild/employee.fdb
5021 Client Character Set = NONE
5022
5023 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
5024
5025 @dd-mm-yy hh:mm:ss.zzzz:Exception raised
5026 Engine Code: 335544790
5027 Service isc_info_svc_get_env requires SYSDBA permissions. Reattach to the Service Manager using the SYSDBA account.
5028 -Service isc_info_svc_get_env requires SYSDBA permissions. Reattach to the Service Manager using the SYSDBA account.
5029 -Service isc_info_svc_user_dbpath requires SYSDBA permissions. Reattach to the Service Manager using the SYSDBA account
5030 @dd-mm-yy hh:mm:ss.zzzz:Procedure show_att: dispose called with refcount = 1
5031 @dd-mm-yy hh:mm:ss.zzzz:Procedure server_info: dispose called with refcount = 1

Properties

Name Value
svn:eol-style native