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, 3 months ago) by tony
File size: 44754 byte(s)
Log Message: 
set line ending property

File Contents

# User Rev Content
1 tony 374 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