Daily_QC
init_candidate.c
Go to the documentation of this file.
1 #include <sqlhdr.h>
2 #include <sqliapi.h>
3 static const char *_Cn4 = "sensorcursor";
4 static const char *_Cn3 = "selectsensor";
5 static const char *_Cn2 = "stncursor";
6 static const char *_Cn1 = "selectstn";
7 #line 1 "init_candidate.ec"
8 
9 void init_candidate()
10 
11 {
12 
13 
14 /*
15  * EXEC SQL database fastetc;
16  */
17 #line 7 "init_candidate.ec"
18  {
19 #line 7 "init_candidate.ec"
20  sqli_db_open("fastetc", 0);
21 #line 7 "init_candidate.ec"
22  }
23 /*
24  * EXEC SQL set lock mode to wait;
25  */
26 #line 8 "init_candidate.ec"
27  {
28 #line 8 "init_candidate.ec"
29  static const char *sqlcmdtxt[] =
30 #line 8 "init_candidate.ec"
31  {
32 #line 8 "init_candidate.ec"
33  " set lock mode to wait",
34  0
35  };
36 #line 8 "init_candidate.ec"
37  static ifx_statement_t _SQ0 = {0};
38 #line 8 "init_candidate.ec"
39  sqli_stmt(ESQLINTVERSION, &_SQ0, (char **) sqlcmdtxt, 0, (ifx_sqlvar_t *) 0, (struct value *) 0, (ifx_literal_t *) 0, (ifx_namelist_t *) 0, (ifx_cursor_t *) 0, -1, 0, 0);
40 #line 8 "init_candidate.ec"
41  }
42 /*
43  * exec sql set isolation to dirty read;
44  */
45 #line 9 "init_candidate.ec"
46  {
47 #line 9 "init_candidate.ec"
48  static const char *sqlcmdtxt[] =
49 #line 9 "init_candidate.ec"
50  {
51 #line 9 "init_candidate.ec"
52  " set isolation to dirty read",
53  0
54  };
55 #line 9 "init_candidate.ec"
56  static ifx_statement_t _SQ0 = {0};
57 #line 9 "init_candidate.ec"
58  sqli_stmt(ESQLINTVERSION, &_SQ0, (char **) sqlcmdtxt, 0, (ifx_sqlvar_t *) 0, (struct value *) 0, (ifx_literal_t *) 0, (ifx_namelist_t *) 0, (ifx_cursor_t *) 0, -1, 0, 0);
59 #line 9 "init_candidate.ec"
60  }
61 
62 
63 if(sqlca.sqlcode < 0){
64 
65  printf("informix error %d\n",sqlca.sqlcode);
66  exit(1);
67 
68  }
69 
70 if(sqlca.sqlcode != 0){
71 
72  printf("informix error %d\n",sqlca.sqlcode);
73  exit(1);
74 
75  }
76 
77 /*
78  * EXEC SQL prepare selectstn from
79  * "select *
80  * from stn
81  * where stat='AZ' or stat='NM' or stat='CA' or stat='NV'
82  * or stat='CO' or stat='WY' or stat='UT' or stat='ID'
83  * or stat='OR'
84  * order by id";
85  */
86 #line 26 "init_candidate.ec"
87  {
88 #line 32 "init_candidate.ec"
89 #line 32 "init_candidate.ec"
90 #line 32 "init_candidate.ec"
91  sqli_prep(ESQLINTVERSION, (char *) _Cn1, "select * from stn where stat='AZ' or stat='NM' or stat='CA' or stat='NV' or stat='CO' or stat='WY' or stat='UT' or stat='ID' or stat='OR' order by id",(ifx_literal_t *) 0, (ifx_namelist_t *) 0, 2, 0,0 );
92 #line 32 "init_candidate.ec"
93  }
94  /*
95 EXEC SQL prepare selectstn from
96  "select *
97  from stn
98  where stat='NV'
99  order by id";
100 */
101 if(sqlca.sqlcode < 0){
102 
103  printf("informix error %d\n",sqlca.sqlcode);
104  exit(1);
105 
106  }
107 
108 /*
109  * EXEC SQL declare stncursor cursor for selectstn;
110  */
111 #line 47 "init_candidate.ec"
112  {
113 #line 47 "init_candidate.ec"
114 #line 47 "init_candidate.ec"
115  sqli_curs_decl_dynm(ESQLINTVERSION, sqli_curs_locate(ESQLINTVERSION, (char *) _Cn2, 512), (char *) _Cn2, sqli_curs_locate(ESQLINTVERSION, (char *) _Cn1, 513), 0, 0);
116 #line 47 "init_candidate.ec"
117  }
118 
119 if(sqlca.sqlcode < 0){
120 
121  printf("informix error %d\n",sqlca.sqlcode);
122  exit(1);
123 
124  }
125 
126 /*
127  * EXEC SQL prepare selectsensor from
128  * "select *
129  * from sens where
130  * id = ?";
131  */
132 #line 56 "init_candidate.ec"
133  {
134 #line 59 "init_candidate.ec"
135 #line 59 "init_candidate.ec"
136 #line 59 "init_candidate.ec"
137  sqli_prep(ESQLINTVERSION, (char *) _Cn3, "select * from sens where id = ?",(ifx_literal_t *) 0, (ifx_namelist_t *) 0, 2, 0,0 );
138 #line 59 "init_candidate.ec"
139  }
140 
141 if(sqlca.sqlcode < 0){
142 
143  printf("informix error %d\n",sqlca.sqlcode);
144  exit(1);
145 
146  }
147 
148 /*
149  * EXEC SQL declare sensorcursor cursor for selectsensor;
150  */
151 #line 68 "init_candidate.ec"
152  {
153 #line 68 "init_candidate.ec"
154 #line 68 "init_candidate.ec"
155  sqli_curs_decl_dynm(ESQLINTVERSION, sqli_curs_locate(ESQLINTVERSION, (char *) _Cn4, 512), (char *) _Cn4, sqli_curs_locate(ESQLINTVERSION, (char *) _Cn3, 513), 0, 0);
156 #line 68 "init_candidate.ec"
157  }
158 
159 if(sqlca.sqlcode < 0){
160 
161  printf("informix error %d\n",sqlca.sqlcode);
162  exit(1);
163 
164  }
165 
166 }
167 
168 
169 
170 
171 #line 80 "init_candidate.ec"
sqlca
struct sqlca_s sqlca
_Cn3
static const char * _Cn3
Definition: init_candidate.c:4
_Cn4
static const char * _Cn4
Definition: init_candidate.c:3
_Cn1
static const char * _Cn1
Definition: init_candidate.c:6
init_candidate
void init_candidate()
Definition: init_candidate.c:9
_Cn2
static const char * _Cn2
Definition: init_candidate.c:5
printf
printf("pcp %d\n", pcp_in_use[103])
exit
exit(1)
sqlca_s::sqlcode
long sqlcode
Definition: build_list.c:47
Generated by doxygen 1.9.1