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: 379
Committed: Mon Jan 10 10:08:03 2022 UTC (2 years, 2 months ago) by tony
File size: 44754 byte(s)
Log Message:
set line ending property

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 ------------------------
33 Running Test02
34 ------------------------
35 No entry for terminal type "xterm-256color";
36 using dumb terminal settings.
37
38 SALARY FULLNAME
39 ===================== ====================================
40 81810.19 Fisher, Pete
41
42 ------------------------
43 Running Test03
44 ------------------------
45 No entry for terminal type "xterm-256color";
46 using dumb terminal settings.
47
48 FULLNAME SALARY ACCSALARY
49 ==================================== ===================== =====================
50 Nelson, Robert 105900.00 105900.00
51 Young, Bruce 97500.00 203400.00
52 Lambert, Kim 102750.00 306150.00
53 Johnson, Leslie 64635.00 370785.00
54 Forest, Phil 75060.00 445845.00
55 Weston, K. J. 86292.94 532137.94
56 Lee, Terri 53793.00 585930.94
57 Hall, Stewart 69482.63 655413.57
58 Young, Katherine 67241.25 722654.82
59 Papadopoulos, Chris 89655.00 812309.82
60 Fisher, Pete 81810.19 894120.01
61 Bennet, Ann 22935.00 917055.01
62 De Souza, Roger 69482.63 986537.64
63 Baldwin, Janet 61637.81 1048175.45
64 Reeves, Roger 33620.63 1081796.08
65 Stansbury, Willie 39224.06 1121020.14
66 Phong, Leslie 56034.38 1177054.52
67 Ramanathan, Ashok 80689.50 1257744.02
68 Steadman, Walter 116100.00 1373844.02
69 Nordstrom, Carol 42742.50 1416586.52
70
71 FULLNAME SALARY ACCSALARY
72 ==================================== ===================== =====================
73 Leung, Luke 68805.00 1485391.52
74 O'Brien, Sue Anne 31275.00 1516666.52
75 Burbank, Jennifer M. 53167.50 1569834.02
76 Sutherland, Claudia 100914.00 1670748.02
77 Bishop, Dana 62550.00 1733298.02
78 MacDonald, Mary S. 111262.50 1844560.52
79 Williams, Randy 56295.00 1900855.52
80 Bender, Oliver H. 212850.00 2113705.52
81 Cook, Kevin 111262.50 2224968.02
82 Brown, Kelly 27000.00 2251968.02
83 Ichida, Yuki 6000000.00 8251968.02
84 Page, Mary 48000.00 8299968.02
85 Parker, Bill 35000.00 8334968.02
86 Yamamoto, Takashi 7480000.00 15814968.02
87 Ferrari, Roberto 33000.00 15847968.02
88 Yanowski, Michael 44000.00 15891968.02
89 Glon, Jacques 38500.00 15930468.02
90 Johnson, Scott 60000.00 15990468.02
91 Green, T.J. 36000.00 16026468.02
92 Osborne, Pierre 110000.00 16136468.02
93
94 FULLNAME SALARY ACCSALARY
95 ==================================== ===================== =====================
96 Montgomery, John 35000.00 16171468.02
97 Guckenheimer, Mark 32000.00 16203468.02
98
99
100 TEXT
101 ====================================================================================================
102 To be or not to be-that is the question:
103 Whether 'tis nobler in the mind to suffer
104 The slings and arrows of outrageous fortune,
105 Or to take arms against a sea of troubles,
106 And, by opposing, end them. To die, to sleep-
107 No more-and by a sleep to say we end
108 The heartache and the thousand natural shocks
109 That flesh is heir to-'tis a consummation
110 Devoutly to be wished. To die, to sleep-
111 To sleep, perchance to dream. Aye, there's the rub,
112 For in that sleep of death what dreams may come,
113 When we have shuffled off this mortal coil,
114 Must give us pause. There's the respect
115 That makes calamity of so long life.
116 For who would bear the whips and scorns of time,
117 Th' oppressor's wrong, the proud man's contumely,
118 The pangs of despised love, the law’s delay,
119 The insolence of office, and the spurns
120 That patient merit of the unworthy takes,
121 When he himself might his quietus make
122
123 TEXT
124 ====================================================================================================
125 With a bare bodkin? Who would fardels bear,
126 To grunt and sweat under a weary life,
127 But that the dread of something after death,
128 The undiscovered country from whose bourn
129 No traveler returns, puzzles the will
130 And makes us rather bear those ills we have
131 Than fly to others that we know not of?
132 Thus conscience does make cowards of us all,
133 And thus the native hue of resolution
134 Is sicklied o'er with the pale cast of thought,
135 And enterprises of great pitch and moment,
136 With this regard their currents turn awry,
137 And lose the name of action.-Soft you now,
138 The fair Ophelia.-Nymph, in thy orisons
139 Be all my sins remembered
140
141 ------------------------
142 Running Test04
143 ------------------------
144 No entry for terminal type "xterm-256color";
145 using dumb terminal settings.
146
147 PHONE_EXT PREVIOUS_PHONE_EXT
148 ========= ==================
149 999 250
150
151
152 PHONE_EXT PREVIOUS_PHONE_EXT
153 ========= ==================
154 250 999
155
156 UDR Log Contents
157 ----------------
158 @dd-mm-yy hh:mm:ss.zzzz:Registering Function row_count
159 @dd-mm-yy hh:mm:ss.zzzz:Registering Function bad_row_count
160 @dd-mm-yy hh:mm:ss.zzzz:Registering Function return_info
161 @dd-mm-yy hh:mm:ss.zzzz:Registering Procedure test_proc
162 @dd-mm-yy hh:mm:ss.zzzz:Registering Procedure select_proc
163 @dd-mm-yy hh:mm:ss.zzzz:Registering Procedure read_txt
164 @dd-mm-yy hh:mm:ss.zzzz:Registering Trigger my_employee_update
165 @dd-mm-yy hh:mm:ss.zzzz:Setup Function row_count
166 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
167 Package Name =
168 Name = MYROWCOUNT
169 Entry Point = fbudrtests!row_count (fbudrtests,row_count,)
170 Body =
171 Input Metadata:
172 Field Count = 1
173 Alignment = 2
174 Aligned Length = 36
175 Field No. 0
176 Field Name = TABLE_NAME
177 Relation Name =
178 Alias Name =
179 SQLType = SQL_VARYING
180 IsNullable = yes
181 SubType = 0
182 Length = 31
183 Scale = 0
184 Offset = 0
185 Null Offset = 34
186 Message Length = 31
187
188 Output Metadata:
189 Field Count = 1
190 Alignment = 4
191 Aligned Length = 8
192 Field No. 0
193 Field Name =
194 Relation Name =
195 Alias Name =
196 SQLType = SQL_LONG
197 IsNullable = yes
198 SubType = 0
199 Length = 4
200 Scale = 0
201 Offset = 0
202 Null Offset = 4
203 Message Length = 4
204
205 @dd-mm-yy hh:mm:ss.zzzz:Setup Function row_count
206 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
207 Package Name =
208 Name = MYROWCOUNT
209 Entry Point = fbudrtests!row_count (fbudrtests,row_count,)
210 Body =
211 Input Metadata:
212 Field Count = 1
213 Alignment = 2
214 Aligned Length = 36
215 Field No. 0
216 Field Name = TABLE_NAME
217 Relation Name =
218 Alias Name =
219 SQLType = SQL_VARYING
220 IsNullable = yes
221 SubType = 0
222 Length = 31
223 Scale = 0
224 Offset = 0
225 Null Offset = 34
226 Message Length = 31
227
228 Output Metadata:
229 Field Count = 1
230 Alignment = 4
231 Aligned Length = 8
232 Field No. 0
233 Field Name =
234 Relation Name =
235 Alias Name =
236 SQLType = SQL_LONG
237 IsNullable = yes
238 SubType = 0
239 Length = 4
240 Scale = 0
241 Offset = 0
242 Null Offset = 4
243 Message Length = 4
244
245 @dd-mm-yy hh:mm:ss.zzzz:Setup Function bad_row_count
246 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
247 Package Name =
248 Name = BADROWCOUNT
249 Entry Point = fbudrtests!bad_row_count (fbudrtests,bad_row_count,)
250 Body =
251 Input Metadata:
252 Field Count = 1
253 Alignment = 2
254 Aligned Length = 36
255 Field No. 0
256 Field Name = TABLE_NAME
257 Relation Name =
258 Alias Name =
259 SQLType = SQL_VARYING
260 IsNullable = yes
261 SubType = 0
262 Length = 31
263 Scale = 0
264 Offset = 0
265 Null Offset = 34
266 Message Length = 31
267
268 Output Metadata:
269 Field Count = 1
270 Alignment = 4
271 Aligned Length = 8
272 Field No. 0
273 Field Name =
274 Relation Name =
275 Alias Name =
276 SQLType = SQL_LONG
277 IsNullable = yes
278 SubType = 0
279 Length = 4
280 Scale = 0
281 Offset = 0
282 Null Offset = 4
283 Message Length = 4
284
285 @dd-mm-yy hh:mm:ss.zzzz:Setup Function bad_row_count
286 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
287 Package Name =
288 Name = BADROWCOUNT
289 Entry Point = fbudrtests!bad_row_count (fbudrtests,bad_row_count,)
290 Body =
291 Input Metadata:
292 Field Count = 1
293 Alignment = 2
294 Aligned Length = 36
295 Field No. 0
296 Field Name = TABLE_NAME
297 Relation Name =
298 Alias Name =
299 SQLType = SQL_VARYING
300 IsNullable = yes
301 SubType = 0
302 Length = 31
303 Scale = 0
304 Offset = 0
305 Null Offset = 34
306 Message Length = 31
307
308 Output Metadata:
309 Field Count = 1
310 Alignment = 4
311 Aligned Length = 8
312 Field No. 0
313 Field Name =
314 Relation Name =
315 Alias Name =
316 SQLType = SQL_LONG
317 IsNullable = yes
318 SubType = 0
319 Length = 4
320 Scale = 0
321 Offset = 0
322 Null Offset = 4
323 Message Length = 4
324
325 @dd-mm-yy hh:mm:ss.zzzz:Setup Function return_info
326 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
327 Package Name =
328 Name = UDRINFO
329 Entry Point = fbudrtests!return_info!Hello World (fbudrtests,return_info,Hello World)
330 Body =
331 Input Metadata:
332 Field Count = 0
333 Alignment = 2
334 Aligned Length = 0
335
336 Output Metadata:
337 Field Count = 1
338 Alignment = 2
339 Aligned Length = 36
340 Field No. 0
341 Field Name =
342 Relation Name =
343 Alias Name =
344 SQLType = SQL_VARYING
345 IsNullable = yes
346 SubType = 0
347 Length = 31
348 Scale = 0
349 Offset = 0
350 Null Offset = 34
351 Message Length = 31
352
353 @dd-mm-yy hh:mm:ss.zzzz:Setup Function return_info
354 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
355 Package Name =
356 Name = UDRINFO
357 Entry Point = fbudrtests!return_info!Hello World (fbudrtests,return_info,Hello World)
358 Body =
359 Input Metadata:
360 Field Count = 0
361 Alignment = 2
362 Aligned Length = 0
363
364 Output Metadata:
365 Field Count = 1
366 Alignment = 2
367 Aligned Length = 36
368 Field No. 0
369 Field Name =
370 Relation Name =
371 Alias Name =
372 SQLType = SQL_VARYING
373 IsNullable = yes
374 SubType = 0
375 Length = 31
376 Scale = 0
377 Offset = 0
378 Null Offset = 34
379 Message Length = 31
380
381 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure test_proc
382 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
383 Package Name =
384 Name = MYTESTPROC
385 Entry Point = fbudrtests!test_proc (fbudrtests,test_proc,)
386 Body =
387 Input Metadata:
388 Field Count = 1
389 Alignment = 2
390 Aligned Length = 4
391 Field No. 0
392 Field Name = EMP_NO
393 Relation Name =
394 Alias Name =
395 SQLType = SQL_SHORT
396 IsNullable = yes
397 SubType = 0
398 Length = 2
399 Scale = 0
400 Offset = 0
401 Null Offset = 2
402 Message Length = 2
403
404 Output Metadata:
405 Field Count = 2
406 Alignment = 8
407 Aligned Length = 56
408 Field No. 0
409 Field Name = SALARY
410 Relation Name =
411 Alias Name =
412 SQLType = SQL_INT64
413 IsNullable = yes
414 SubType = 1
415 Length = 8
416 Scale = -2
417 Offset = 0
418 Null Offset = 8
419 Message Length = 8
420 Field No. 1
421 Field Name = FULLNAME
422 Relation Name =
423 Alias Name =
424 SQLType = SQL_VARYING
425 IsNullable = yes
426 SubType = 0
427 Length = 36
428 Scale = 0
429 Offset = 10
430 Null Offset = 48
431 Message Length = 36
432
433 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure test_proc
434 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
435 Package Name =
436 Name = MYTESTPROC
437 Entry Point = fbudrtests!test_proc (fbudrtests,test_proc,)
438 Body =
439 Input Metadata:
440 Field Count = 1
441 Alignment = 2
442 Aligned Length = 4
443 Field No. 0
444 Field Name = EMP_NO
445 Relation Name =
446 Alias Name =
447 SQLType = SQL_SHORT
448 IsNullable = yes
449 SubType = 0
450 Length = 2
451 Scale = 0
452 Offset = 0
453 Null Offset = 2
454 Message Length = 2
455
456 Output Metadata:
457 Field Count = 2
458 Alignment = 8
459 Aligned Length = 56
460 Field No. 0
461 Field Name = SALARY
462 Relation Name =
463 Alias Name =
464 SQLType = SQL_INT64
465 IsNullable = yes
466 SubType = 1
467 Length = 8
468 Scale = -2
469 Offset = 0
470 Null Offset = 8
471 Message Length = 8
472 Field No. 1
473 Field Name = FULLNAME
474 Relation Name =
475 Alias Name =
476 SQLType = SQL_VARYING
477 IsNullable = yes
478 SubType = 0
479 Length = 36
480 Scale = 0
481 Offset = 10
482 Null Offset = 48
483 Message Length = 36
484
485 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure select_proc
486 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
487 Package Name =
488 Name = MYSELECTPROC
489 Entry Point = fbudrtests!select_proc (fbudrtests,select_proc,)
490 Body =
491 Input Metadata:
492 Field Count = 0
493 Alignment = 2
494 Aligned Length = 0
495
496 Output Metadata:
497 Field Count = 3
498 Alignment = 8
499 Aligned Length = 72
500 Field No. 0
501 Field Name = FULLNAME
502 Relation Name =
503 Alias Name =
504 SQLType = SQL_VARYING
505 IsNullable = yes
506 SubType = 0
507 Length = 36
508 Scale = 0
509 Offset = 0
510 Null Offset = 38
511 Message Length = 36
512 Field No. 1
513 Field Name = SALARY
514 Relation Name =
515 Alias Name =
516 SQLType = SQL_INT64
517 IsNullable = yes
518 SubType = 1
519 Length = 8
520 Scale = -2
521 Offset = 40
522 Null Offset = 48
523 Message Length = 8
524 Field No. 2
525 Field Name = ACCSALARY
526 Relation Name =
527 Alias Name =
528 SQLType = SQL_INT64
529 IsNullable = yes
530 SubType = 1
531 Length = 8
532 Scale = -2
533 Offset = 56
534 Null Offset = 64
535 Message Length = 8
536
537 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure select_proc
538 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
539 Package Name =
540 Name = MYSELECTPROC
541 Entry Point = fbudrtests!select_proc (fbudrtests,select_proc,)
542 Body =
543 Input Metadata:
544 Field Count = 0
545 Alignment = 2
546 Aligned Length = 0
547
548 Output Metadata:
549 Field Count = 3
550 Alignment = 8
551 Aligned Length = 72
552 Field No. 0
553 Field Name = FULLNAME
554 Relation Name =
555 Alias Name =
556 SQLType = SQL_VARYING
557 IsNullable = yes
558 SubType = 0
559 Length = 36
560 Scale = 0
561 Offset = 0
562 Null Offset = 38
563 Message Length = 36
564 Field No. 1
565 Field Name = SALARY
566 Relation Name =
567 Alias Name =
568 SQLType = SQL_INT64
569 IsNullable = yes
570 SubType = 1
571 Length = 8
572 Scale = -2
573 Offset = 40
574 Null Offset = 48
575 Message Length = 8
576 Field No. 2
577 Field Name = ACCSALARY
578 Relation Name =
579 Alias Name =
580 SQLType = SQL_INT64
581 IsNullable = yes
582 SubType = 1
583 Length = 8
584 Scale = -2
585 Offset = 56
586 Null Offset = 64
587 Message Length = 8
588
589 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure read_txt
590 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
591 Package Name =
592 Name = MYREADTEXT
593 Entry Point = fbudrtests!read_txt (fbudrtests,read_txt,)
594 Body =
595 Input Metadata:
596 Field Count = 1
597 Alignment = 2
598 Aligned Length = 204
599 Field No. 0
600 Field Name = PATH
601 Relation Name =
602 Alias Name =
603 SQLType = SQL_VARYING
604 IsNullable = no
605 SubType = 0
606 Length = 200
607 Scale = 0
608 Offset = 0
609 Null Offset = 202
610 Message Length = 200
611
612 Output Metadata:
613 Field Count = 1
614 Alignment = 2
615 Aligned Length = 104
616 Field No. 0
617 Field Name = TEXT
618 Relation Name =
619 Alias Name =
620 SQLType = SQL_VARYING
621 IsNullable = no
622 SubType = 0
623 Length = 100
624 Scale = 0
625 Offset = 0
626 Null Offset = 102
627 Message Length = 100
628
629 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure read_txt
630 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
631 Package Name =
632 Name = MYREADTEXT
633 Entry Point = fbudrtests!read_txt (fbudrtests,read_txt,)
634 Body =
635 Input Metadata:
636 Field Count = 1
637 Alignment = 2
638 Aligned Length = 204
639 Field No. 0
640 Field Name = PATH
641 Relation Name =
642 Alias Name =
643 SQLType = SQL_VARYING
644 IsNullable = no
645 SubType = 0
646 Length = 200
647 Scale = 0
648 Offset = 0
649 Null Offset = 202
650 Message Length = 200
651
652 Output Metadata:
653 Field Count = 1
654 Alignment = 2
655 Aligned Length = 104
656 Field No. 0
657 Field Name = TEXT
658 Relation Name =
659 Alias Name =
660 SQLType = SQL_VARYING
661 IsNullable = no
662 SubType = 0
663 Length = 100
664 Scale = 0
665 Offset = 0
666 Null Offset = 102
667 Message Length = 100
668
669 @dd-mm-yy hh:mm:ss.zzzz:Setup Function row_count
670 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
671 Package Name =
672 Name = MYROWCOUNT
673 Entry Point = fbudrtests!row_count (fbudrtests,row_count,)
674 Body =
675 Input Metadata:
676 Field Count = 1
677 Alignment = 2
678 Aligned Length = 36
679 Field No. 0
680 Field Name = TABLE_NAME
681 Relation Name =
682 Alias Name =
683 SQLType = SQL_VARYING
684 IsNullable = yes
685 SubType = 0
686 Length = 31
687 Scale = 0
688 Offset = 0
689 Null Offset = 34
690 Message Length = 31
691
692 Output Metadata:
693 Field Count = 1
694 Alignment = 4
695 Aligned Length = 8
696 Field No. 0
697 Field Name =
698 Relation Name =
699 Alias Name =
700 SQLType = SQL_LONG
701 IsNullable = yes
702 SubType = 0
703 Length = 4
704 Scale = 0
705 Offset = 0
706 Null Offset = 4
707 Message Length = 4
708
709 @dd-mm-yy hh:mm:ss.zzzz:Function row_count created
710 @dd-mm-yy hh:mm:ss.zzzz:Package Name =
711 Name = MYROWCOUNT
712 Entry Point = fbudrtests!row_count (fbudrtests,row_count,)
713 Body =
714 Input Metadata:
715 Field Count = 1
716 Alignment = 2
717 Aligned Length = 36
718 Field No. 0
719 Field Name = TABLE_NAME
720 Relation Name =
721 Alias Name =
722 SQLType = SQL_VARYING
723 IsNullable = yes
724 SubType = 0
725 Length = 31
726 Scale = 0
727 Offset = 0
728 Null Offset = 34
729 Message Length = 31
730
731 Output Metadata:
732 Field Count = 1
733 Alignment = 4
734 Aligned Length = 8
735 Field No. 0
736 Field Name =
737 Relation Name =
738 Alias Name =
739 SQLType = SQL_LONG
740 IsNullable = yes
741 SubType = 0
742 Length = 4
743 Scale = 0
744 Offset = 0
745 Null Offset = 4
746 Message Length = 4
747
748 @dd-mm-yy hh:mm:ss.zzzz:Execute Function row_count
749 @dd-mm-yy hh:mm:ss.zzzz:External Context:
750 Attachment ID = 1374
751 Transaction ID = 4964
752 User Name = SYSDBA
753 Database Name = /opt/firebird4.0.1/examples/empbuild/employee.fdb
754 Client Character Set = NONE
755
756 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
757 Parameter 0:
758 Field Name = TABLE_NAME
759 Alias Name =
760 SQLType = SQL_VARYING
761 sub type = 0
762 Scale = 0
763 Charset = NONE
764 Nullable
765 Size = 31
766 Value = EMPLOYEE
767
768 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters with data
769 Column 0
770 Field Name =
771 SQLType = SQL_LONG
772 sub type = 0
773 Scale = 0
774 Charset = NONE
775 Nullable
776 Size = 4
777 Value = 42
778
779 @dd-mm-yy hh:mm:ss.zzzz:Execute Function row_count
780 @dd-mm-yy hh:mm:ss.zzzz:External Context:
781 Attachment ID = 1374
782 Transaction ID = 4964
783 User Name = SYSDBA
784 Database Name = /opt/firebird4.0.1/examples/empbuild/employee.fdb
785 Client Character Set = NONE
786
787 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
788 Parameter 0:
789 Field Name = TABLE_NAME
790 Alias Name =
791 SQLType = SQL_VARYING
792 sub type = 0
793 Scale = 0
794 Charset = NONE
795 Nullable
796 Size = 31
797 Value = DEPARTMENT
798
799 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters with data
800 Column 0
801 Field Name =
802 SQLType = SQL_LONG
803 sub type = 0
804 Scale = 0
805 Charset = NONE
806 Nullable
807 Size = 4
808 Value = 21
809
810 @dd-mm-yy hh:mm:ss.zzzz:Execute Function row_count
811 @dd-mm-yy hh:mm:ss.zzzz:External Context:
812 Attachment ID = 1374
813 Transaction ID = 4964
814 User Name = SYSDBA
815 Database Name = /opt/firebird4.0.1/examples/empbuild/employee.fdb
816 Client Character Set = NONE
817
818 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
819 Parameter 0:
820 Field Name = TABLE_NAME
821 Alias Name =
822 SQLType = SQL_VARYING
823 sub type = 0
824 Scale = 0
825 Charset = NONE
826 Nullable
827 Size = 31
828 Value = BAD
829
830 @dd-mm-yy hh:mm:ss.zzzz:Exception raised
831 SQLCODE: -999
832 Engine Code: 335544569
833 Dynamic SQL Error
834 -SQL error code = -204
835 -Table unknown
836 -BAD
837 -At line 1, column 22 When Executing: Select count(*) from BAD
838 @dd-mm-yy hh:mm:ss.zzzz:Setup Function return_info
839 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
840 Package Name =
841 Name = UDRINFO
842 Entry Point = fbudrtests!return_info!Hello World (fbudrtests,return_info,Hello World)
843 Body =
844 Input Metadata:
845 Field Count = 0
846 Alignment = 2
847 Aligned Length = 0
848
849 Output Metadata:
850 Field Count = 1
851 Alignment = 2
852 Aligned Length = 36
853 Field No. 0
854 Field Name =
855 Relation Name =
856 Alias Name =
857 SQLType = SQL_VARYING
858 IsNullable = yes
859 SubType = 0
860 Length = 31
861 Scale = 0
862 Offset = 0
863 Null Offset = 34
864 Message Length = 31
865
866 @dd-mm-yy hh:mm:ss.zzzz:Function return_info created
867 @dd-mm-yy hh:mm:ss.zzzz:Package Name =
868 Name = UDRINFO
869 Entry Point = fbudrtests!return_info!Hello World (fbudrtests,return_info,Hello World)
870 Body =
871 Input Metadata:
872 Field Count = 0
873 Alignment = 2
874 Aligned Length = 0
875
876 Output Metadata:
877 Field Count = 1
878 Alignment = 2
879 Aligned Length = 36
880 Field No. 0
881 Field Name =
882 Relation Name =
883 Alias Name =
884 SQLType = SQL_VARYING
885 IsNullable = yes
886 SubType = 0
887 Length = 31
888 Scale = 0
889 Offset = 0
890 Null Offset = 34
891 Message Length = 31
892
893 @dd-mm-yy hh:mm:ss.zzzz:Execute Function return_info
894 @dd-mm-yy hh:mm:ss.zzzz:External Context:
895 Attachment ID = 1374
896 Transaction ID = 4964
897 User Name = SYSDBA
898 Database Name = /opt/firebird4.0.1/examples/empbuild/employee.fdb
899 Client Character Set = NONE
900
901 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
902
903 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters with data
904 Column 0
905 Field Name =
906 SQLType = SQL_VARYING
907 sub type = 0
908 Scale = 0
909 Charset = NONE
910 Nullable
911 Size = 31
912 Value = Hello World
913
914 @dd-mm-yy hh:mm:ss.zzzz:Function return_info: dispose called
915 @dd-mm-yy hh:mm:ss.zzzz:Function row_count: dispose called
916 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure test_proc
917 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
918 Package Name =
919 Name = MYTESTPROC
920 Entry Point = fbudrtests!test_proc (fbudrtests,test_proc,)
921 Body =
922 Input Metadata:
923 Field Count = 1
924 Alignment = 2
925 Aligned Length = 4
926 Field No. 0
927 Field Name = EMP_NO
928 Relation Name =
929 Alias Name =
930 SQLType = SQL_SHORT
931 IsNullable = yes
932 SubType = 0
933 Length = 2
934 Scale = 0
935 Offset = 0
936 Null Offset = 2
937 Message Length = 2
938
939 Output Metadata:
940 Field Count = 2
941 Alignment = 8
942 Aligned Length = 56
943 Field No. 0
944 Field Name = SALARY
945 Relation Name =
946 Alias Name =
947 SQLType = SQL_INT64
948 IsNullable = yes
949 SubType = 1
950 Length = 8
951 Scale = -2
952 Offset = 0
953 Null Offset = 8
954 Message Length = 8
955 Field No. 1
956 Field Name = FULLNAME
957 Relation Name =
958 Alias Name =
959 SQLType = SQL_VARYING
960 IsNullable = yes
961 SubType = 0
962 Length = 36
963 Scale = 0
964 Offset = 10
965 Null Offset = 48
966 Message Length = 36
967
968 @dd-mm-yy hh:mm:ss.zzzz:Open Execute Procedure test_proc
969 @dd-mm-yy hh:mm:ss.zzzz:External Context:
970 Attachment ID = 1377
971 Transaction ID = 4976
972 User Name = SYSDBA
973 Database Name = /opt/firebird4.0.1/examples/empbuild/employee.fdb
974 Client Character Set = NONE
975
976 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
977 Parameter 0:
978 Field Name = EMP_NO
979 Alias Name =
980 SQLType = SQL_SHORT
981 sub type = 0
982 Scale = 0
983 Charset = NONE
984 Nullable
985 Size = 2
986 Value = 24
987
988 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
989 Column 0
990 Field Name = SALARY
991 SQLType = SQL_INT64
992 sub type = 0
993 Scale = -2
994 Charset = NONE
995 Nullable
996 Size = 8
997 Value = NULL
998 Column 1
999 Field Name = FULLNAME
1000 SQLType = SQL_VARYING
1001 sub type = 0
1002 Scale = 0
1003 Charset = NONE
1004 Nullable
1005 Size = 36
1006 Value = NULL
1007
1008 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters with data
1009 Column 0
1010 Field Name = SALARY
1011 SQLType = SQL_INT64
1012 sub type = 0
1013 Scale = -2
1014 Charset = NONE
1015 Nullable
1016 Size = 8
1017 Value = 81810.19
1018 Column 1
1019 Field Name = FULLNAME
1020 SQLType = SQL_VARYING
1021 sub type = 0
1022 Scale = 0
1023 Charset = NONE
1024 Nullable
1025 Size = 36
1026 Value = Fisher, Pete
1027
1028 @dd-mm-yy hh:mm:ss.zzzz:Procedure test_proc: dispose called with refcount = 2
1029 @dd-mm-yy hh:mm:ss.zzzz:Procedure test_proc: dispose called with refcount = 1
1030 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure select_proc
1031 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
1032 Package Name =
1033 Name = MYSELECTPROC
1034 Entry Point = fbudrtests!select_proc (fbudrtests,select_proc,)
1035 Body =
1036 Input Metadata:
1037 Field Count = 0
1038 Alignment = 2
1039 Aligned Length = 0
1040
1041 Output Metadata:
1042 Field Count = 3
1043 Alignment = 8
1044 Aligned Length = 72
1045 Field No. 0
1046 Field Name = FULLNAME
1047 Relation Name =
1048 Alias Name =
1049 SQLType = SQL_VARYING
1050 IsNullable = yes
1051 SubType = 0
1052 Length = 36
1053 Scale = 0
1054 Offset = 0
1055 Null Offset = 38
1056 Message Length = 36
1057 Field No. 1
1058 Field Name = SALARY
1059 Relation Name =
1060 Alias Name =
1061 SQLType = SQL_INT64
1062 IsNullable = yes
1063 SubType = 1
1064 Length = 8
1065 Scale = -2
1066 Offset = 40
1067 Null Offset = 48
1068 Message Length = 8
1069 Field No. 2
1070 Field Name = ACCSALARY
1071 Relation Name =
1072 Alias Name =
1073 SQLType = SQL_INT64
1074 IsNullable = yes
1075 SubType = 1
1076 Length = 8
1077 Scale = -2
1078 Offset = 56
1079 Null Offset = 64
1080 Message Length = 8
1081
1082 @dd-mm-yy hh:mm:ss.zzzz:Open Select Procedure select_proc
1083 @dd-mm-yy hh:mm:ss.zzzz:External Context:
1084 Attachment ID = 1380
1085 Transaction ID = 4983
1086 User Name = SYSDBA
1087 Database Name = /opt/firebird4.0.1/examples/empbuild/employee.fdb
1088 Client Character Set = NONE
1089
1090 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
1091
1092 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
1093 Column 0
1094 Field Name = FULLNAME
1095 SQLType = SQL_VARYING
1096 sub type = 0
1097 Scale = 0
1098 Charset = NONE
1099 Nullable
1100 Size = 36
1101 Value = NULL
1102 Column 1
1103 Field Name = SALARY
1104 SQLType = SQL_INT64
1105 sub type = 0
1106 Scale = -2
1107 Charset = NONE
1108 Nullable
1109 Size = 8
1110 Value = NULL
1111 Column 2
1112 Field Name = ACCSALARY
1113 SQLType = SQL_INT64
1114 sub type = 0
1115 Scale = -2
1116 Charset = NONE
1117 Nullable
1118 Size = 8
1119 Value = NULL
1120
1121 @dd-mm-yy hh:mm:ss.zzzz:Procedure select_proc: dispose called with refcount = 2
1122 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure read_txt
1123 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
1124 Package Name =
1125 Name = MYREADTEXT
1126 Entry Point = fbudrtests!read_txt (fbudrtests,read_txt,)
1127 Body =
1128 Input Metadata:
1129 Field Count = 1
1130 Alignment = 2
1131 Aligned Length = 204
1132 Field No. 0
1133 Field Name = PATH
1134 Relation Name =
1135 Alias Name =
1136 SQLType = SQL_VARYING
1137 IsNullable = no
1138 SubType = 0
1139 Length = 200
1140 Scale = 0
1141 Offset = 0
1142 Null Offset = 202
1143 Message Length = 200
1144
1145 Output Metadata:
1146 Field Count = 1
1147 Alignment = 2
1148 Aligned Length = 104
1149 Field No. 0
1150 Field Name = TEXT
1151 Relation Name =
1152 Alias Name =
1153 SQLType = SQL_VARYING
1154 IsNullable = no
1155 SubType = 0
1156 Length = 100
1157 Scale = 0
1158 Offset = 0
1159 Null Offset = 102
1160 Message Length = 100
1161
1162 @dd-mm-yy hh:mm:ss.zzzz:Open Select Procedure read_txt
1163 @dd-mm-yy hh:mm:ss.zzzz:External Context:
1164 Attachment ID = 1380
1165 Transaction ID = 4983
1166 User Name = SYSDBA
1167 Database Name = /opt/firebird4.0.1/examples/empbuild/employee.fdb
1168 Client Character Set = NONE
1169
1170 @dd-mm-yy hh:mm:ss.zzzz:Input Parameters
1171 Parameter 0:
1172 Field Name = PATH
1173 Alias Name =
1174 SQLType = SQL_VARYING
1175 sub type = 0
1176 Scale = 0
1177 Charset = NONE
1178 Not Nullable
1179 Size = 200
1180 Value = /home/tony/lazarus/2.2/otherComponents/fbintf/udr/testsuite/udrlib/testtext.txt
1181
1182 @dd-mm-yy hh:mm:ss.zzzz:Read Text called in directory /tmp
1183 @dd-mm-yy hh:mm:ss.zzzz:Reading from /home/tony/lazarus/2.2/otherComponents/fbintf/udr/testsuite/udrlib/testtext.txt
1184 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters
1185 Column 0
1186 Field Name = TEXT
1187 SQLType = SQL_VARYING
1188 sub type = 0
1189 Scale = 0
1190 Charset = NONE
1191 Not Nullable
1192 Size = 100
1193 Value =
1194
1195 @dd-mm-yy hh:mm:ss.zzzz:Procedure read_txt: dispose called with refcount = 2
1196 @dd-mm-yy hh:mm:ss.zzzz:Procedure select_proc: dispose called with refcount = 1
1197 @dd-mm-yy hh:mm:ss.zzzz:Procedure read_txt: dispose called with refcount = 1
1198 @dd-mm-yy hh:mm:ss.zzzz:Setup Trigger my_employee_update
1199 @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata
1200 Package Name =
1201 Name = MYEMPLOYEEUPDATE
1202 Entry Point = fbudrtests!my_employee_update (fbudrtests,my_employee_update,)
1203 Body =
1204 Input Metadata:
1205 (nil)
1206 Output Metadata:
1207 (nil)Trigger Metadata:
1208 Field Count = 12
1209 Alignment = 0
1210 Aligned Length = 0
1211 Field No. 0
1212 Field Name = EMP_NO
1213 Relation Name =
1214 Alias Name =
1215 SQLType = SQL_SHORT
1216 IsNullable = no
1217 SubType = 0
1218 Length = 2
1219 Scale = 0
1220 Offset = 0
1221 Null Offset = 0
1222 Message Length = 2
1223 Field No. 1
1224 Field Name = FIRST_NAME
1225 Relation Name =
1226 Alias Name =
1227 SQLType = SQL_VARYING
1228 IsNullable = no
1229 SubType = 0
1230 Length = 15
1231 Scale = 0
1232 Offset = 0
1233 Null Offset = 0
1234 Message Length = 15
1235 Field No. 2
1236 Field Name = LAST_NAME
1237 Relation Name =
1238 Alias Name =
1239 SQLType = SQL_VARYING
1240 IsNullable = no
1241 SubType = 0
1242 Length = 20
1243 Scale = 0
1244 Offset = 0
1245 Null Offset = 0
1246 Message Length = 20
1247 Field No. 3
1248 Field Name = PHONE_EXT
1249 Relation Name =
1250 Alias Name =
1251 SQLType = SQL_VARYING
1252 IsNullable = yes
1253 SubType = 0
1254 Length = 4
1255 Scale = 0
1256 Offset = 0
1257 Null Offset = 0
1258 Message Length = 4
1259 Field No. 4
1260 Field Name = HIRE_DATE
1261 Relation Name =
1262 Alias Name =
1263 SQLType = SQL_TIMESTAMP
1264 IsNullable = no
1265 SubType = 0
1266 Length = 8
1267 Scale = 0
1268 Offset = 0
1269 Null Offset = 0
1270 Message Length = 8
1271 Field No. 5
1272 Field Name = DEPT_NO
1273 Relation Name =
1274 Alias Name =
1275 SQLType = SQL_TEXT
1276 IsNullable = no
1277 SubType = 0
1278 Length = 3
1279 Scale = 0
1280 Offset = 0
1281 Null Offset = 0
1282 Message Length = 3
1283 Field No. 6
1284 Field Name = JOB_CODE
1285 Relation Name =
1286 Alias Name =
1287 SQLType = SQL_VARYING
1288 IsNullable = no
1289 SubType = 0
1290 Length = 5
1291 Scale = 0
1292 Offset = 0
1293 Null Offset = 0
1294 Message Length = 5
1295 Field No. 7
1296 Field Name = JOB_GRADE
1297 Relation Name =
1298 Alias Name =
1299 SQLType = SQL_SHORT
1300 IsNullable = no
1301 SubType = 0
1302 Length = 2
1303 Scale = 0
1304 Offset = 0
1305 Null Offset = 0
1306 Message Length = 2
1307 Field No. 8
1308 Field Name = JOB_COUNTRY
1309 Relation Name =
1310 Alias Name =
1311 SQLType = SQL_VARYING
1312 IsNullable = no
1313 SubType = 0
1314 Length = 15
1315 Scale = 0
1316 Offset = 0
1317 Null Offset = 0
1318 Message Length = 15
1319 Field No. 9
1320 Field Name = SALARY
1321 Relation Name =
1322 Alias Name =
1323 SQLType = SQL_INT64
1324 IsNullable = no
1325 SubType = 1
1326 Length = 8
1327 Scale = -2
1328 Offset = 0
1329 Null Offset = 0
1330 Message Length = 8
1331 Field No. 10
1332 Field Name = FULL_NAME
1333 Relation Name =
1334 Alias Name =
1335 SQLType = SQL_VARYING
1336 IsNullable = yes
1337 SubType = 0
1338 Length = 37
1339 Scale = 0
1340 Offset = 0
1341 Null Offset = 0
1342 Message Length = 37
1343 Field No. 11
1344 Field Name = PREVIOUS_PHONE_EXT
1345 Relation Name =
1346 Alias Name =
1347 SQLType = SQL_VARYING
1348 IsNullable = yes
1349 SubType = 0
1350 Length = 4
1351 Scale = 0
1352 Offset = 0
1353 Null Offset = 0
1354 Message Length = 4
1355 Trigger Table = EMPLOYEE
1356 Trigger Type = Before
1357
1358 @dd-mm-yy hh:mm:ss.zzzz:Execute Trigger my_employee_update
1359 @dd-mm-yy hh:mm:ss.zzzz:Old Field Values:
1360 Parameter 0:
1361 Field Name = EMP_NO
1362 Alias Name =
1363 SQLType = SQL_SHORT
1364 sub type = 0
1365 Scale = 0
1366 Charset = NONE
1367 Not Nullable
1368 Size = 2
1369 Value = 2
1370 Parameter 1:
1371 Field Name = FIRST_NAME
1372 Alias Name =
1373 SQLType = SQL_VARYING
1374 sub type = 0
1375 Scale = 0
1376 Charset = NONE
1377 Not Nullable
1378 Size = 15
1379 Value = Robert
1380 Parameter 2:
1381 Field Name = LAST_NAME
1382 Alias Name =
1383 SQLType = SQL_VARYING
1384 sub type = 0
1385 Scale = 0
1386 Charset = NONE
1387 Not Nullable
1388 Size = 20
1389 Value = Nelson
1390 Parameter 3:
1391 Field Name = PHONE_EXT
1392 Alias Name =
1393 SQLType = SQL_VARYING
1394 sub type = 0
1395 Scale = 0
1396 Charset = NONE
1397 Nullable
1398 Size = 4
1399 Value = 250
1400 Parameter 4:
1401 Field Name = HIRE_DATE
1402 Alias Name =
1403 SQLType = SQL_TIMESTAMP
1404 sub type = 0
1405 Scale = 0
1406 Charset = NONE
1407 Not Nullable
1408 Size = 8
1409 Value = dd-mm-yy hh:mm:ss.zzzz
1410 Parameter 5:
1411 Field Name = DEPT_NO
1412 Alias Name =
1413 SQLType = SQL_TEXT
1414 sub type = 0
1415 Scale = 0
1416 Charset = NONE
1417 Not Nullable
1418 Size = 3
1419 Value = 600
1420 Parameter 6:
1421 Field Name = JOB_CODE
1422 Alias Name =
1423 SQLType = SQL_VARYING
1424 sub type = 0
1425 Scale = 0
1426 Charset = NONE
1427 Not Nullable
1428 Size = 5
1429 Value = VP
1430 Parameter 7:
1431 Field Name = JOB_GRADE
1432 Alias Name =
1433 SQLType = SQL_SHORT
1434 sub type = 0
1435 Scale = 0
1436 Charset = NONE
1437 Not Nullable
1438 Size = 2
1439 Value = 2
1440 Parameter 8:
1441 Field Name = JOB_COUNTRY
1442 Alias Name =
1443 SQLType = SQL_VARYING
1444 sub type = 0
1445 Scale = 0
1446 Charset = NONE
1447 Not Nullable
1448 Size = 15
1449 Value = USA
1450 Parameter 9:
1451 Field Name = SALARY
1452 Alias Name =
1453 SQLType = SQL_INT64
1454 sub type = 0
1455 Scale = -2
1456 Charset = NONE
1457 Not Nullable
1458 Size = 8
1459 Value = 105900
1460 Parameter 10:
1461 Field Name = FULL_NAME
1462 Alias Name =
1463 SQLType = SQL_VARYING
1464 sub type = 0
1465 Scale = 0
1466 Charset = NONE
1467 Nullable
1468 Size = 37
1469 Value = Nelson, Robert
1470 Parameter 11:
1471 Field Name = PREVIOUS_PHONE_EXT
1472 Alias Name =
1473 SQLType = SQL_VARYING
1474 sub type = 0
1475 Scale = 0
1476 Charset = NONE
1477 Nullable
1478 Size = 4
1479 Value = NULL
1480
1481 @dd-mm-yy hh:mm:ss.zzzz:New Field Values:
1482 Column 0
1483 Field Name = EMP_NO
1484 SQLType = SQL_SHORT
1485 sub type = 0
1486 Scale = 0
1487 Charset = NONE
1488 Not Nullable
1489 Size = 2
1490 Value = 2
1491 Column 1
1492 Field Name = FIRST_NAME
1493 SQLType = SQL_VARYING
1494 sub type = 0
1495 Scale = 0
1496 Charset = NONE
1497 Not Nullable
1498 Size = 15
1499 Value = Robert
1500 Column 2
1501 Field Name = LAST_NAME
1502 SQLType = SQL_VARYING
1503 sub type = 0
1504 Scale = 0
1505 Charset = NONE
1506 Not Nullable
1507 Size = 20
1508 Value = Nelson
1509 Column 3
1510 Field Name = PHONE_EXT
1511 SQLType = SQL_VARYING
1512 sub type = 0
1513 Scale = 0
1514 Charset = NONE
1515 Nullable
1516 Size = 4
1517 Value = 999
1518 Column 4
1519 Field Name = HIRE_DATE
1520 SQLType = SQL_TIMESTAMP
1521 sub type = 0
1522 Scale = 0
1523 Charset = NONE
1524 Not Nullable
1525 Size = 8
1526 Value = dd-mm-yy hh:mm:ss.zzzz
1527 Column 5
1528 Field Name = DEPT_NO
1529 SQLType = SQL_TEXT
1530 sub type = 0
1531 Scale = 0
1532 Charset = NONE
1533 Not Nullable
1534 Size = 3
1535 Value = 600
1536 Column 6
1537 Field Name = JOB_CODE
1538 SQLType = SQL_VARYING
1539 sub type = 0
1540 Scale = 0
1541 Charset = NONE
1542 Not Nullable
1543 Size = 5
1544 Value = VP
1545 Column 7
1546 Field Name = JOB_GRADE
1547 SQLType = SQL_SHORT
1548 sub type = 0
1549 Scale = 0
1550 Charset = NONE
1551 Not Nullable
1552 Size = 2
1553 Value = 2
1554 Column 8
1555 Field Name = JOB_COUNTRY
1556 SQLType = SQL_VARYING
1557 sub type = 0
1558 Scale = 0
1559 Charset = NONE
1560 Not Nullable
1561 Size = 15
1562 Value = USA
1563 Column 9
1564 Field Name = SALARY
1565 SQLType = SQL_INT64
1566 sub type = 0
1567 Scale = -2
1568 Charset = NONE
1569 Not Nullable
1570 Size = 8
1571 Value = 105900
1572 Column 10
1573 Field Name = FULL_NAME
1574 SQLType = SQL_VARYING
1575 sub type = 0
1576 Scale = 0
1577 Charset = NONE
1578 Nullable
1579 Size = 37
1580 Value = Nelson, Robert
1581 Column 11
1582 Field Name = PREVIOUS_PHONE_EXT
1583 SQLType = SQL_VARYING
1584 sub type = 0
1585 Scale = 0
1586 Charset = NONE
1587 Nullable
1588 Size = 4
1589 Value = NULL
1590
1591 @dd-mm-yy hh:mm:ss.zzzz:New Field Values after trigger execution
1592 Column 0
1593 Field Name = EMP_NO
1594 SQLType = SQL_SHORT
1595 sub type = 0
1596 Scale = 0
1597 Charset = NONE
1598 Not Nullable
1599 Size = 2
1600 Value = 2
1601 Column 1
1602 Field Name = FIRST_NAME
1603 SQLType = SQL_VARYING
1604 sub type = 0
1605 Scale = 0
1606 Charset = NONE
1607 Not Nullable
1608 Size = 15
1609 Value = Robert
1610 Column 2
1611 Field Name = LAST_NAME
1612 SQLType = SQL_VARYING
1613 sub type = 0
1614 Scale = 0
1615 Charset = NONE
1616 Not Nullable
1617 Size = 20
1618 Value = Nelson
1619 Column 3
1620 Field Name = PHONE_EXT
1621 SQLType = SQL_VARYING
1622 sub type = 0
1623 Scale = 0
1624 Charset = NONE
1625 Nullable
1626 Size = 4
1627 Value = 999
1628 Column 4
1629 Field Name = HIRE_DATE
1630 SQLType = SQL_TIMESTAMP
1631 sub type = 0
1632 Scale = 0
1633 Charset = NONE
1634 Not Nullable
1635 Size = 8
1636 Value = dd-mm-yy hh:mm:ss.zzzz
1637 Column 5
1638 Field Name = DEPT_NO
1639 SQLType = SQL_TEXT
1640 sub type = 0
1641 Scale = 0
1642 Charset = NONE
1643 Not Nullable
1644 Size = 3
1645 Value = 600
1646 Column 6
1647 Field Name = JOB_CODE
1648 SQLType = SQL_VARYING
1649 sub type = 0
1650 Scale = 0
1651 Charset = NONE
1652 Not Nullable
1653 Size = 5
1654 Value = VP
1655 Column 7
1656 Field Name = JOB_GRADE
1657 SQLType = SQL_SHORT
1658 sub type = 0
1659 Scale = 0
1660 Charset = NONE
1661 Not Nullable
1662 Size = 2
1663 Value = 2
1664 Column 8
1665 Field Name = JOB_COUNTRY
1666 SQLType = SQL_VARYING
1667 sub type = 0
1668 Scale = 0
1669 Charset = NONE
1670 Not Nullable
1671 Size = 15
1672 Value = USA
1673 Column 9
1674 Field Name = SALARY
1675 SQLType = SQL_INT64
1676 sub type = 0
1677 Scale = -2
1678 Charset = NONE
1679 Not Nullable
1680 Size = 8
1681 Value = 105900
1682 Column 10
1683 Field Name = FULL_NAME
1684 SQLType = SQL_VARYING
1685 sub type = 0
1686 Scale = 0
1687 Charset = NONE
1688 Nullable
1689 Size = 37
1690 Value = Nelson, Robert
1691 Column 11
1692 Field Name = PREVIOUS_PHONE_EXT
1693 SQLType = SQL_VARYING
1694 sub type = 0
1695 Scale = 0
1696 Charset = NONE
1697 Nullable
1698 Size = 4
1699 Value = 250
1700
1701 @dd-mm-yy hh:mm:ss.zzzz:Execute Trigger my_employee_update
1702 @dd-mm-yy hh:mm:ss.zzzz:Old Field Values:
1703 Parameter 0:
1704 Field Name = EMP_NO
1705 Alias Name =
1706 SQLType = SQL_SHORT
1707 sub type = 0
1708 Scale = 0
1709 Charset = NONE
1710 Not Nullable
1711 Size = 2
1712 Value = 2
1713 Parameter 1:
1714 Field Name = FIRST_NAME
1715 Alias Name =
1716 SQLType = SQL_VARYING
1717 sub type = 0
1718 Scale = 0
1719 Charset = NONE
1720 Not Nullable
1721 Size = 15
1722 Value = Robert
1723 Parameter 2:
1724 Field Name = LAST_NAME
1725 Alias Name =
1726 SQLType = SQL_VARYING
1727 sub type = 0
1728 Scale = 0
1729 Charset = NONE
1730 Not Nullable
1731 Size = 20
1732 Value = Nelson
1733 Parameter 3:
1734 Field Name = PHONE_EXT
1735 Alias Name =
1736 SQLType = SQL_VARYING
1737 sub type = 0
1738 Scale = 0
1739 Charset = NONE
1740 Nullable
1741 Size = 4
1742 Value = 999
1743 Parameter 4:
1744 Field Name = HIRE_DATE
1745 Alias Name =
1746 SQLType = SQL_TIMESTAMP
1747 sub type = 0
1748 Scale = 0
1749 Charset = NONE
1750 Not Nullable
1751 Size = 8
1752 Value = dd-mm-yy hh:mm:ss.zzzz
1753 Parameter 5:
1754 Field Name = DEPT_NO
1755 Alias Name =
1756 SQLType = SQL_TEXT
1757 sub type = 0
1758 Scale = 0
1759 Charset = NONE
1760 Not Nullable
1761 Size = 3
1762 Value = 600
1763 Parameter 6:
1764 Field Name = JOB_CODE
1765 Alias Name =
1766 SQLType = SQL_VARYING
1767 sub type = 0
1768 Scale = 0
1769 Charset = NONE
1770 Not Nullable
1771 Size = 5
1772 Value = VP
1773 Parameter 7:
1774 Field Name = JOB_GRADE
1775 Alias Name =
1776 SQLType = SQL_SHORT
1777 sub type = 0
1778 Scale = 0
1779 Charset = NONE
1780 Not Nullable
1781 Size = 2
1782 Value = 2
1783 Parameter 8:
1784 Field Name = JOB_COUNTRY
1785 Alias Name =
1786 SQLType = SQL_VARYING
1787 sub type = 0
1788 Scale = 0
1789 Charset = NONE
1790 Not Nullable
1791 Size = 15
1792 Value = USA
1793 Parameter 9:
1794 Field Name = SALARY
1795 Alias Name =
1796 SQLType = SQL_INT64
1797 sub type = 0
1798 Scale = -2
1799 Charset = NONE
1800 Not Nullable
1801 Size = 8
1802 Value = 105900
1803 Parameter 10:
1804 Field Name = FULL_NAME
1805 Alias Name =
1806 SQLType = SQL_VARYING
1807 sub type = 0
1808 Scale = 0
1809 Charset = NONE
1810 Nullable
1811 Size = 37
1812 Value = Nelson, Robert
1813 Parameter 11:
1814 Field Name = PREVIOUS_PHONE_EXT
1815 Alias Name =
1816 SQLType = SQL_VARYING
1817 sub type = 0
1818 Scale = 0
1819 Charset = NONE
1820 Nullable
1821 Size = 4
1822 Value = 250
1823
1824 @dd-mm-yy hh:mm:ss.zzzz:New Field Values:
1825 Column 0
1826 Field Name = EMP_NO
1827 SQLType = SQL_SHORT
1828 sub type = 0
1829 Scale = 0
1830 Charset = NONE
1831 Not Nullable
1832 Size = 2
1833 Value = 2
1834 Column 1
1835 Field Name = FIRST_NAME
1836 SQLType = SQL_VARYING
1837 sub type = 0
1838 Scale = 0
1839 Charset = NONE
1840 Not Nullable
1841 Size = 15
1842 Value = Robert
1843 Column 2
1844 Field Name = LAST_NAME
1845 SQLType = SQL_VARYING
1846 sub type = 0
1847 Scale = 0
1848 Charset = NONE
1849 Not Nullable
1850 Size = 20
1851 Value = Nelson
1852 Column 3
1853 Field Name = PHONE_EXT
1854 SQLType = SQL_VARYING
1855 sub type = 0
1856 Scale = 0
1857 Charset = NONE
1858 Nullable
1859 Size = 4
1860 Value = 250
1861 Column 4
1862 Field Name = HIRE_DATE
1863 SQLType = SQL_TIMESTAMP
1864 sub type = 0
1865 Scale = 0
1866 Charset = NONE
1867 Not Nullable
1868 Size = 8
1869 Value = dd-mm-yy hh:mm:ss.zzzz
1870 Column 5
1871 Field Name = DEPT_NO
1872 SQLType = SQL_TEXT
1873 sub type = 0
1874 Scale = 0
1875 Charset = NONE
1876 Not Nullable
1877 Size = 3
1878 Value = 600
1879 Column 6
1880 Field Name = JOB_CODE
1881 SQLType = SQL_VARYING
1882 sub type = 0
1883 Scale = 0
1884 Charset = NONE
1885 Not Nullable
1886 Size = 5
1887 Value = VP
1888 Column 7
1889 Field Name = JOB_GRADE
1890 SQLType = SQL_SHORT
1891 sub type = 0
1892 Scale = 0
1893 Charset = NONE
1894 Not Nullable
1895 Size = 2
1896 Value = 2
1897 Column 8
1898 Field Name = JOB_COUNTRY
1899 SQLType = SQL_VARYING
1900 sub type = 0
1901 Scale = 0
1902 Charset = NONE
1903 Not Nullable
1904 Size = 15
1905 Value = USA
1906 Column 9
1907 Field Name = SALARY
1908 SQLType = SQL_INT64
1909 sub type = 0
1910 Scale = -2
1911 Charset = NONE
1912 Not Nullable
1913 Size = 8
1914 Value = 105900
1915 Column 10
1916 Field Name = FULL_NAME
1917 SQLType = SQL_VARYING
1918 sub type = 0
1919 Scale = 0
1920 Charset = NONE
1921 Nullable
1922 Size = 37
1923 Value = Nelson, Robert
1924 Column 11
1925 Field Name = PREVIOUS_PHONE_EXT
1926 SQLType = SQL_VARYING
1927 sub type = 0
1928 Scale = 0
1929 Charset = NONE
1930 Nullable
1931 Size = 4
1932 Value = 250
1933
1934 @dd-mm-yy hh:mm:ss.zzzz:New Field Values after trigger execution
1935 Column 0
1936 Field Name = EMP_NO
1937 SQLType = SQL_SHORT
1938 sub type = 0
1939 Scale = 0
1940 Charset = NONE
1941 Not Nullable
1942 Size = 2
1943 Value = 2
1944 Column 1
1945 Field Name = FIRST_NAME
1946 SQLType = SQL_VARYING
1947 sub type = 0
1948 Scale = 0
1949 Charset = NONE
1950 Not Nullable
1951 Size = 15
1952 Value = Robert
1953 Column 2
1954 Field Name = LAST_NAME
1955 SQLType = SQL_VARYING
1956 sub type = 0
1957 Scale = 0
1958 Charset = NONE
1959 Not Nullable
1960 Size = 20
1961 Value = Nelson
1962 Column 3
1963 Field Name = PHONE_EXT
1964 SQLType = SQL_VARYING
1965 sub type = 0
1966 Scale = 0
1967 Charset = NONE
1968 Nullable
1969 Size = 4
1970 Value = 250
1971 Column 4
1972 Field Name = HIRE_DATE
1973 SQLType = SQL_TIMESTAMP
1974 sub type = 0
1975 Scale = 0
1976 Charset = NONE
1977 Not Nullable
1978 Size = 8
1979 Value = dd-mm-yy hh:mm:ss.zzzz
1980 Column 5
1981 Field Name = DEPT_NO
1982 SQLType = SQL_TEXT
1983 sub type = 0
1984 Scale = 0
1985 Charset = NONE
1986 Not Nullable
1987 Size = 3
1988 Value = 600
1989 Column 6
1990 Field Name = JOB_CODE
1991 SQLType = SQL_VARYING
1992 sub type = 0
1993 Scale = 0
1994 Charset = NONE
1995 Not Nullable
1996 Size = 5
1997 Value = VP
1998 Column 7
1999 Field Name = JOB_GRADE
2000 SQLType = SQL_SHORT
2001 sub type = 0
2002 Scale = 0
2003 Charset = NONE
2004 Not Nullable
2005 Size = 2
2006 Value = 2
2007 Column 8
2008 Field Name = JOB_COUNTRY
2009 SQLType = SQL_VARYING
2010 sub type = 0
2011 Scale = 0
2012 Charset = NONE
2013 Not Nullable
2014 Size = 15
2015 Value = USA
2016 Column 9
2017 Field Name = SALARY
2018 SQLType = SQL_INT64
2019 sub type = 0
2020 Scale = -2
2021 Charset = NONE
2022 Not Nullable
2023 Size = 8
2024 Value = 105900
2025 Column 10
2026 Field Name = FULL_NAME
2027 SQLType = SQL_VARYING
2028 sub type = 0
2029 Scale = 0
2030 Charset = NONE
2031 Nullable
2032 Size = 37
2033 Value = Nelson, Robert
2034 Column 11
2035 Field Name = PREVIOUS_PHONE_EXT
2036 SQLType = SQL_VARYING
2037 sub type = 0
2038 Scale = 0
2039 Charset = NONE
2040 Nullable
2041 Size = 4
2042 Value = 999
2043
2044 @dd-mm-yy hh:mm:ss.zzzz:Trigger my_employee_update: dispose called

Properties

Name Value
svn:eol-style native