1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
|
-------------------------------------------------------------------------------
-- --
-- Filename : $Source: /cvsroot/gnade/gnade/samples/esql/dynamic.gpq,v $
-- Description : Demonstration lfor dynamic SQL --
-- Author : Michael Erdmann <Michael.Erdmann@snafu.de> --
-- Created On : 22-Dec-2000 --
-- Last Modified By: $Author: persan $
-- Last Modified On: $Date: 2007/09/08 07:31:27 $ --
-- Status : $State: Exp $ --
-- --
-- Copyright (C) 2000-2003 Michael Erdmann --
-- --
-- GNADE is free software; you can redistribute it and/or modify it under --
-- terms of the GNU General Public License as published by the Free Soft- --
-- ware Foundation; either version 2, or (at your option) any later ver- --
-- sion. GNAT is distributed in the hope that it will be useful, but WITH- --
-- OUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY --
-- or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License --
-- for more details. You should have received a copy of the GNU General --
-- Public License distributed with GNAT; see file COPYING. If not, write --
-- to the Free Software Foundation, 59 Temple Place - Suite 330, Boston, --
-- MA 02111-1307, USA. --
-- --
-- As a special exception, if other files instantiate generics from this --
-- unit, or you link this unit with other files to produce an executable, --
-- this unit does not by itself cause the resulting executable to be --
-- covered by the GNU General Public License. This exception does not --
-- however invalidate any other reasons why the executable file might be --
-- covered by the GNU Public License. --
-- --
-- GNADE is implemented to work with GNAT, the GNU Ada compiler. --
-- --
-- Functional Description --
-- ====================== --
-- --
-- --
-- Restrictions --
-- ============ --
-- No Tasking support --
-- --
-- References --
-- ========== --
-- //1// - (Second Informal Review Draft) ISO/IEC 9075:1992, Database --
-- Language SQL- July 30, 1992 --
-- --
-------------------------------------------------------------------------------
with Ada.Text_IO; use Ada.Text_IO;
with SQL_STANDARD; use SQL_STANDARD;
with Ada.Strings.Fixed; use Ada.Strings.Fixed;
with Ada.Strings; use Ada.Strings;
with GNU.DB.SQLCLI; use GNU.DB.SQLCLI;
procedure Dynamic is
General_Error : exception;
EXEC SQL WHENEVER SQLERROR raise General_Error;
package IO is new Ada.Text_IO.Integer_IO (int);
use IO;
EXEC SQL declare DB01 DATABASE ;
procedure Browse_Names (
Query : in String;
Key : in Natural ) is
S : constant String :=
"SELECT EMPNO, NAME FROM EMPLOYEES WHERE " & Query & " ?";
EXEC SQL begin declare SECTION end-EXEC
Name : char (1 .. 40);
Name_Ind : Indicator_Type := 0;
Key_Ind : INDICATOR_TYPE := 0;
Key_Value : int := int (Key);
Empno : int;
Empno_Ind : INDICATOR_TYPE := 0;
EXEC SQL end declare SECTION end-EXEC
EXEC SQL declare Test_Sql STATEMENT ;
begin
EXEC SQL at DB01
PREPARE Test_Sql
FROM S
USING : Key_Value ;
EXEC SQL at DB01
EXECUTE Test_Sql
USING : EMPNO INDICATOR : EMPNO_IND, : NAME : NAME_IND ;
loop
EXEC SQL at DB01
FETCH USING STATEMENT Test_Sql
INTO : EMPNO INDICATOR : EMPNO_IND, : NAME : NAME_IND;
exit when SQLCODE in SQL_STANDARD.NOT_FOUND;
Put ( Empno, Width => 8 );
Put ( " " & To_String ( Name ) );
Put_Line ("");
end loop;
EXEC SQL at DB01
CLOSE Test_Sql FINAL ;
end Browse_Names;
begin
EXEC SQL CONNECT $DBUSER
IDENTIFIED BY $DBPASSWD
BY DB01
TO $DBSOURCE ;
Browse_Names (
Query => "EMPNO >",
Key => 5 );
Put_Line ( "Second query ... DEPTNO > 1003" );
Browse_Names (
Query => "DEPTNO >",
Key => 1003 );
Put_Line ( "End of Program" );
end Dynamic;
|
