Mapper
ma_hrly.c
Go to the documentation of this file.
1 #include <sqlhdr.h>
2 #include <sqliapi.h>
3 #line 1 "ma_hrly.ec"
4 #include "prototypes_new.h"
5 /*
6  * EXEC SQL include sqlca.h;
7  */
8 #line 2 "ma_hrly.ec"
9 
10 #line 2 "ma_hrly.ec"
11 #line 1 "/opt/informix/incl/esql/sqlca.h"
12 /****************************************************************************
13  *
14  * Licensed Material - Property Of IBM
15  *
16  * "Restricted Materials of IBM"
17  *
18  * IBM Informix Client SDK
19  * Copyright IBM Corporation 1997, 2008. All rights reserved.
20  *
21  * Title: sqlca.h
22  * Description: SQL Control Area
23  *
24  ***************************************************************************
25  */
26 
27 #ifndef SQLCA_INCL
28 #define SQLCA_INCL
29 
30 #include "ifxtypes.h"
31 
32 #ifdef __cplusplus
33 extern "C" {
34 #endif
35 
36 typedef struct sqlca_s
37  {
38  int4 sqlcode;
39 #ifdef DB2CLI
40  char sqlerrm[600]; /* error message parameters */
41 #else /* DB2CLI */
42  char sqlerrm[72]; /* error message parameters */
43 #endif /* DB2CLI */
44  char sqlerrp[8];
45  int4 sqlerrd[6];
46  /* 0 - estimated number of rows returned */
47  /* 1 - serial value after insert or ISAM error code */
48  /* 2 - number of rows processed */
49  /* 3 - estimated cost */
50  /* 4 - offset of the error into the SQL statement */
51  /* 5 - rowid after insert */
52 #ifdef _FGL_
53  char sqlawarn[8];
54 #else
55  struct sqlcaw_s
56  {
57  char sqlwarn0; /* = W if any of sqlwarn[1-7] = W */
58  char sqlwarn1; /* = W if any truncation occurred or
59  database has transactions or
60  no privileges revoked */
61  char sqlwarn2; /* = W if a null value returned or
62  ANSI database */
63  char sqlwarn3; /* = W if no. in select list != no. in into list or
64  turbo backend or no privileges granted */
65  char sqlwarn4; /* = W if no where clause on prepared update, delete or
66  incompatible float format */
67  char sqlwarn5; /* = W if non-ANSI statement */
68  char sqlwarn6; /* = W if server is in data replication secondary mode */
69  char sqlwarn7; /* = W if database locale is different from proc_locale
70  = W if backend XPS and if explain avoid_execute is set
71  (for select, insert, delete and update only)
72  */
73  } sqlwarn;
74 #endif
75  } ifx_sqlca_t;
76 
77 /* NOTE: 4gl assumes that the sqlwarn structure can be defined as
78  * sqlawarn -- an 8 character string, because single-char
79  * variables are not recognized in 4gl.
80  *
81  * If this structure should change, the code generated by 4gl compiler
82  * must also change
83  */
84 
85 #define SQLNOTFOUND 100
86 
87 #ifndef IFX_THREAD
88 #ifdef DB2CLI
89 #define sqlca ifmxsqlca
90 extern struct sqlca_s sqlca;
91 #else /* DB2CLI */
92 extern struct sqlca_s sqlca;
93 #endif /* DB2CLI */
94 
95 #ifndef DRDAHELP
96 extern int4 SQLCODE;
97 #endif
98 
99 extern char SQLSTATE[];
100 #else /* IFX_THREAD */
101 extern int4 * ifx_sqlcode(void);
102 extern struct sqlca_s * ifx_sqlca(void);
103 /* ifx_sqlstate() declared in sqlhdr.h */
104 #define SQLCODE (*(ifx_sqlcode()))
105 #define SQLSTATE ((char *)(ifx_sqlstate()))
106 #define sqlca (*(ifx_sqlca()))
107 #endif /* IFX_THREAD */
108 
109 #ifdef __cplusplus
110 }
111 #endif
112 
113 #endif /* SQLCA_INCL */
114 
115 #line 103 "/opt/informix/incl/esql/sqlca.h"
116 #line 3 "ma_hrly.ec"
117 
118 /*
119  * EXEC SQL BEGIN DECLARE SECTION;
120  */
121 #line 4 "ma_hrly.ec"
122 #line 5 "ma_hrly.ec"
123 int eyr, emo, edy;
124 int byr, bmo, bdy;
125 extern struct ma_hrly_rec
126  {
127  char id[6];
128  char drain[2];
129  char pos[2];
130  char cgroup[2];
131  char pe1[2];
132  char pe2[2];
133  char dur[2];
134  char t[2];
135  char s[2];
136  char e[2];
137  char p[2];
138  int cal_yr;
139  int mon;
140  int zday;
141  double zhr00;
142  double zhr01;
143  double zhr02;
144  double zhr03;
145  double zhr04;
146  double zhr05;
147  double zhr06;
148  double zhr07;
149  double zhr08;
150  double zhr09;
151  double zhr10;
152  double zhr11;
153  double zhr12;
154  double zhr13;
155  double zhr14;
156  double zhr15;
157  double zhr16;
158  double zhr17;
159  double zhr18;
160  double zhr19;
161  double zhr20;
162  double zhr21;
163  double zhr22;
164  double zhr23;
165  char qzhr00[2];
166  char qzhr01[2];
167  char qzhr02[2];
168  char qzhr03[2];
169  char qzhr04[2];
170  char qzhr05[2];
171  char qzhr06[2];
172  char qzhr07[2];
173  char qzhr08[2];
174  char qzhr09[2];
175  char qzhr10[2];
176  char qzhr11[2];
177  char qzhr12[2];
178  char qzhr13[2];
179  char qzhr14[2];
180  char qzhr15[2];
181  char qzhr16[2];
182  char qzhr17[2];
183  char qzhr18[2];
184  char qzhr19[2];
185  char qzhr20[2];
186  char qzhr21[2];
187  char qzhr22[2];
188  char qzhr23[2];
189  } ma_hrly_rec;
190 /*
191  * EXEC SQL END DECLARE SECTION;
192  */
193 #line 76 "ma_hrly.ec"
194 
195 
196 extern struct data_rec {
197  char id[9];
198  char source[9];
199  char pe1;
200  char pe2;
201  char dur;
202  char t;
203  char s;
204  char e;
205  char p;
206  int zdate;
207  int ztime;
208  int czdate;
209  int cztime;
210  int idur;
211  double codp;
212  char lwal;
213  int idote;
214  int irev;
215  double value;
216  double values[96];
217  char lwals[96];
218  char pedtsep[8];
219  } data_record;
220 
221 void change_datehm();
222 
223 int ma_hrly(char *hb5,char *parm,char *dpc,struct stim begin_date,struct stim
224 end_date, char *qual, struct stn_values *stn_values)
225 
226 {
227 
228 int i,jtotal,k,atime;
229 int etime,btime;
230 int hour,min;
231 int zdate,hh,qlen;
232 
233 /*
234  * EXEC SQL BEGIN DECLARE SECTION;
235  */
236 #line 115 "ma_hrly.ec"
237 #line 116 "ma_hrly.ec"
238 int edate, bdate;
239 int month, day, year;
240  char drain[2], pos[2], cgroup[2];
241  char sparm[10];
242 struct stat
243  {
244  char hb5[6];
245  char pe1[2];
246  char pe2[2];
247  char dur[2];
248  char t[2];
249  char s[2];
250  char e[2];
251  char p[2];
252  } stat;
253 /*
254  * EXEC SQL END DECLARE SECTION;
255  */
256 #line 133 "ma_hrly.ec"
257 
258 
259 qlen=strlen(qual);
260 
261 stat.pe1[1]=0;
262 stat.pe2[1]=0;
263 stat.dur[1]=0;
264 stat.t[1]=0;
265 stat.s[1]=0;
266 stat.e[1]=0;
267 stat.p[1]=0;
268 drain[1]=0;
269 pos[1]=0;
270 cgroup[1]=0;
271 
272 strcpy(stat.hb5,hb5);
273 stat.pe1[0]=parm[0];
274 stat.pe2[0]=parm[1];
275 stat.dur[0]=parm[2];
276 stat.t[0]=parm[3];
277 stat.s[0]=parm[4];
278 stat.e[0]=parm[5];
279 stat.p[0]=parm[6];
280 drain[0]=dpc[0];
281 pos[0]=dpc[1];
282 cgroup[0]=dpc[2];
283 
284 eyr=end_date.year;
285 emo=end_date.month;
286 edy=end_date.day;
287 etime=end_date.hour*10000+
288  end_date.minute*100;
289 
290 byr=begin_date.year;
291 bmo=begin_date.month;
292 bdy=begin_date.day;
293 btime=begin_date.hour*10000+
294  begin_date.minute*100;
295 
296 year=byr;
297 month=bmo;
298 day=bdy;
299 
300 jtotal=0;
301 
302 for(;;) {
303 
304 /*
305  * EXEC SQL select *
306  * into :ma_hrly_rec
307  * from mahrly
308  * where id=:stat.hb5 and
309  * drain=:drain and
310  * pos=:pos and
311  * cgroup=:cgroup and
312  * pe1=:stat.pe1 and
313  * pe2=:stat.pe2 and
314  * dur=:stat.dur and
315  * t=:stat.t and
316  * s=:stat.s and
317  * e=:stat.e and
318  * p=:stat.p and
319  * cal_yr=:year and
320  * mon=:month and
321  * zday=:day;
322  */
323 #line 180 "ma_hrly.ec"
324  {
325 #line 196 "ma_hrly.ec"
326  static const char *sqlcmdtxt[] =
327 #line 196 "ma_hrly.ec"
328  {
329 #line 196 "ma_hrly.ec"
330  "select * from mahrly where id = ? and drain = ? and pos = ? and cgroup = ? and pe1 = ? and pe2 = ? and dur = ? and t = ? and s = ? and e = ? and p = ? and cal_yr = ? and mon = ? and zday = ?",
331  0
332  };
333 #line 196 "ma_hrly.ec"
334 static ifx_cursor_t _SQ0 = {0};
335  static ifx_sqlvar_t _sqibind[] =
336  {
337  { 100, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
338  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
339  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
340  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
341  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
342  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
343  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
344  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
345  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
346  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
347  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
348  { 102, sizeof(year), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
349  { 102, sizeof(month), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
350  { 102, sizeof(day), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
351 #line 196 "ma_hrly.ec"
352  };
353  static ifx_sqlvar_t _sqobind[] =
354  {
355  { 100, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
356  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
357  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
358  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
359  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
360  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
361  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
362  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
363  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
364  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
365  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
366  { 102, sizeof((ma_hrly_rec).cal_yr), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
367  { 102, sizeof((ma_hrly_rec).mon), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
368  { 102, sizeof((ma_hrly_rec).zday), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
369  { 105, sizeof((ma_hrly_rec).zhr00), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
370  { 105, sizeof((ma_hrly_rec).zhr01), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
371  { 105, sizeof((ma_hrly_rec).zhr02), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
372  { 105, sizeof((ma_hrly_rec).zhr03), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
373  { 105, sizeof((ma_hrly_rec).zhr04), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
374  { 105, sizeof((ma_hrly_rec).zhr05), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
375  { 105, sizeof((ma_hrly_rec).zhr06), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
376  { 105, sizeof((ma_hrly_rec).zhr07), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
377  { 105, sizeof((ma_hrly_rec).zhr08), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
378  { 105, sizeof((ma_hrly_rec).zhr09), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
379  { 105, sizeof((ma_hrly_rec).zhr10), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
380  { 105, sizeof((ma_hrly_rec).zhr11), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
381  { 105, sizeof((ma_hrly_rec).zhr12), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
382  { 105, sizeof((ma_hrly_rec).zhr13), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
383  { 105, sizeof((ma_hrly_rec).zhr14), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
384  { 105, sizeof((ma_hrly_rec).zhr15), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
385  { 105, sizeof((ma_hrly_rec).zhr16), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
386  { 105, sizeof((ma_hrly_rec).zhr17), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
387  { 105, sizeof((ma_hrly_rec).zhr18), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
388  { 105, sizeof((ma_hrly_rec).zhr19), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
389  { 105, sizeof((ma_hrly_rec).zhr20), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
390  { 105, sizeof((ma_hrly_rec).zhr21), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
391  { 105, sizeof((ma_hrly_rec).zhr22), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
392  { 105, sizeof((ma_hrly_rec).zhr23), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
393  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
394  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
395  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
396  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
397  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
398  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
399  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
400  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
401  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
402  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
403  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
404  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
405  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
406  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
407  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
408  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
409  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
410  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
411  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
412  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
413  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
414  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
415  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
416  { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
417 #line 196 "ma_hrly.ec"
418  };
419 #line 196 "ma_hrly.ec"
420  _sqibind[0].sqldata = stat.hb5;
421 #line 196 "ma_hrly.ec"
422  _sqibind[1].sqldata = drain;
423 #line 196 "ma_hrly.ec"
424  _sqibind[2].sqldata = pos;
425 #line 196 "ma_hrly.ec"
426  _sqibind[3].sqldata = cgroup;
427 #line 196 "ma_hrly.ec"
428  _sqibind[4].sqldata = stat.pe1;
429 #line 196 "ma_hrly.ec"
430  _sqibind[5].sqldata = stat.pe2;
431 #line 196 "ma_hrly.ec"
432  _sqibind[6].sqldata = stat.dur;
433 #line 196 "ma_hrly.ec"
434  _sqibind[7].sqldata = stat.t;
435 #line 196 "ma_hrly.ec"
436  _sqibind[8].sqldata = stat.s;
437 #line 196 "ma_hrly.ec"
438  _sqibind[9].sqldata = stat.e;
439 #line 196 "ma_hrly.ec"
440  _sqibind[10].sqldata = stat.p;
441 #line 196 "ma_hrly.ec"
442  _sqibind[11].sqldata = (char *) &year;
443 #line 196 "ma_hrly.ec"
444  _sqibind[12].sqldata = (char *) &month;
445 #line 196 "ma_hrly.ec"
446  _sqibind[13].sqldata = (char *) &day;
447 #line 196 "ma_hrly.ec"
448  _sqobind[0].sqldata = (ma_hrly_rec).id;
449 #line 196 "ma_hrly.ec"
450  _sqobind[1].sqldata = (ma_hrly_rec).drain;
451 #line 196 "ma_hrly.ec"
452  _sqobind[2].sqldata = (ma_hrly_rec).pos;
453 #line 196 "ma_hrly.ec"
454  _sqobind[3].sqldata = (ma_hrly_rec).cgroup;
455 #line 196 "ma_hrly.ec"
456  _sqobind[4].sqldata = (ma_hrly_rec).pe1;
457 #line 196 "ma_hrly.ec"
458  _sqobind[5].sqldata = (ma_hrly_rec).pe2;
459 #line 196 "ma_hrly.ec"
460  _sqobind[6].sqldata = (ma_hrly_rec).dur;
461 #line 196 "ma_hrly.ec"
462  _sqobind[7].sqldata = (ma_hrly_rec).t;
463 #line 196 "ma_hrly.ec"
464  _sqobind[8].sqldata = (ma_hrly_rec).s;
465 #line 196 "ma_hrly.ec"
466  _sqobind[9].sqldata = (ma_hrly_rec).e;
467 #line 196 "ma_hrly.ec"
468  _sqobind[10].sqldata = (ma_hrly_rec).p;
469 #line 196 "ma_hrly.ec"
470  _sqobind[11].sqldata = (char *) &(ma_hrly_rec).cal_yr;
471 #line 196 "ma_hrly.ec"
472  _sqobind[12].sqldata = (char *) &(ma_hrly_rec).mon;
473 #line 196 "ma_hrly.ec"
474  _sqobind[13].sqldata = (char *) &(ma_hrly_rec).zday;
475 #line 196 "ma_hrly.ec"
476  _sqobind[14].sqldata = (char *) &(ma_hrly_rec).zhr00;
477 #line 196 "ma_hrly.ec"
478  _sqobind[15].sqldata = (char *) &(ma_hrly_rec).zhr01;
479 #line 196 "ma_hrly.ec"
480  _sqobind[16].sqldata = (char *) &(ma_hrly_rec).zhr02;
481 #line 196 "ma_hrly.ec"
482  _sqobind[17].sqldata = (char *) &(ma_hrly_rec).zhr03;
483 #line 196 "ma_hrly.ec"
484  _sqobind[18].sqldata = (char *) &(ma_hrly_rec).zhr04;
485 #line 196 "ma_hrly.ec"
486  _sqobind[19].sqldata = (char *) &(ma_hrly_rec).zhr05;
487 #line 196 "ma_hrly.ec"
488  _sqobind[20].sqldata = (char *) &(ma_hrly_rec).zhr06;
489 #line 196 "ma_hrly.ec"
490  _sqobind[21].sqldata = (char *) &(ma_hrly_rec).zhr07;
491 #line 196 "ma_hrly.ec"
492  _sqobind[22].sqldata = (char *) &(ma_hrly_rec).zhr08;
493 #line 196 "ma_hrly.ec"
494  _sqobind[23].sqldata = (char *) &(ma_hrly_rec).zhr09;
495 #line 196 "ma_hrly.ec"
496  _sqobind[24].sqldata = (char *) &(ma_hrly_rec).zhr10;
497 #line 196 "ma_hrly.ec"
498  _sqobind[25].sqldata = (char *) &(ma_hrly_rec).zhr11;
499 #line 196 "ma_hrly.ec"
500  _sqobind[26].sqldata = (char *) &(ma_hrly_rec).zhr12;
501 #line 196 "ma_hrly.ec"
502  _sqobind[27].sqldata = (char *) &(ma_hrly_rec).zhr13;
503 #line 196 "ma_hrly.ec"
504  _sqobind[28].sqldata = (char *) &(ma_hrly_rec).zhr14;
505 #line 196 "ma_hrly.ec"
506  _sqobind[29].sqldata = (char *) &(ma_hrly_rec).zhr15;
507 #line 196 "ma_hrly.ec"
508  _sqobind[30].sqldata = (char *) &(ma_hrly_rec).zhr16;
509 #line 196 "ma_hrly.ec"
510  _sqobind[31].sqldata = (char *) &(ma_hrly_rec).zhr17;
511 #line 196 "ma_hrly.ec"
512  _sqobind[32].sqldata = (char *) &(ma_hrly_rec).zhr18;
513 #line 196 "ma_hrly.ec"
514  _sqobind[33].sqldata = (char *) &(ma_hrly_rec).zhr19;
515 #line 196 "ma_hrly.ec"
516  _sqobind[34].sqldata = (char *) &(ma_hrly_rec).zhr20;
517 #line 196 "ma_hrly.ec"
518  _sqobind[35].sqldata = (char *) &(ma_hrly_rec).zhr21;
519 #line 196 "ma_hrly.ec"
520  _sqobind[36].sqldata = (char *) &(ma_hrly_rec).zhr22;
521 #line 196 "ma_hrly.ec"
522  _sqobind[37].sqldata = (char *) &(ma_hrly_rec).zhr23;
523 #line 196 "ma_hrly.ec"
524  _sqobind[38].sqldata = (ma_hrly_rec).qzhr00;
525 #line 196 "ma_hrly.ec"
526  _sqobind[39].sqldata = (ma_hrly_rec).qzhr01;
527 #line 196 "ma_hrly.ec"
528  _sqobind[40].sqldata = (ma_hrly_rec).qzhr02;
529 #line 196 "ma_hrly.ec"
530  _sqobind[41].sqldata = (ma_hrly_rec).qzhr03;
531 #line 196 "ma_hrly.ec"
532  _sqobind[42].sqldata = (ma_hrly_rec).qzhr04;
533 #line 196 "ma_hrly.ec"
534  _sqobind[43].sqldata = (ma_hrly_rec).qzhr05;
535 #line 196 "ma_hrly.ec"
536  _sqobind[44].sqldata = (ma_hrly_rec).qzhr06;
537 #line 196 "ma_hrly.ec"
538  _sqobind[45].sqldata = (ma_hrly_rec).qzhr07;
539 #line 196 "ma_hrly.ec"
540  _sqobind[46].sqldata = (ma_hrly_rec).qzhr08;
541 #line 196 "ma_hrly.ec"
542  _sqobind[47].sqldata = (ma_hrly_rec).qzhr09;
543 #line 196 "ma_hrly.ec"
544  _sqobind[48].sqldata = (ma_hrly_rec).qzhr10;
545 #line 196 "ma_hrly.ec"
546  _sqobind[49].sqldata = (ma_hrly_rec).qzhr11;
547 #line 196 "ma_hrly.ec"
548  _sqobind[50].sqldata = (ma_hrly_rec).qzhr12;
549 #line 196 "ma_hrly.ec"
550  _sqobind[51].sqldata = (ma_hrly_rec).qzhr13;
551 #line 196 "ma_hrly.ec"
552  _sqobind[52].sqldata = (ma_hrly_rec).qzhr14;
553 #line 196 "ma_hrly.ec"
554  _sqobind[53].sqldata = (ma_hrly_rec).qzhr15;
555 #line 196 "ma_hrly.ec"
556  _sqobind[54].sqldata = (ma_hrly_rec).qzhr16;
557 #line 196 "ma_hrly.ec"
558  _sqobind[55].sqldata = (ma_hrly_rec).qzhr17;
559 #line 196 "ma_hrly.ec"
560  _sqobind[56].sqldata = (ma_hrly_rec).qzhr18;
561 #line 196 "ma_hrly.ec"
562  _sqobind[57].sqldata = (ma_hrly_rec).qzhr19;
563 #line 196 "ma_hrly.ec"
564  _sqobind[58].sqldata = (ma_hrly_rec).qzhr20;
565 #line 196 "ma_hrly.ec"
566  _sqobind[59].sqldata = (ma_hrly_rec).qzhr21;
567 #line 196 "ma_hrly.ec"
568  _sqobind[60].sqldata = (ma_hrly_rec).qzhr22;
569 #line 196 "ma_hrly.ec"
570  _sqobind[61].sqldata = (ma_hrly_rec).qzhr23;
571 #line 196 "ma_hrly.ec"
572  sqli_slct(ESQLINTVERSION, &_SQ0,sqlcmdtxt,14,_sqibind,62,_sqobind,0,(ifx_literal_t *)0,(ifx_namelist_t *)0,0);
573 #line 196 "ma_hrly.ec"
574  }
575 
576  if(sqlca.sqlcode < 0) {
577 
578 
579  return(sqlca.sqlcode);
580 
581  }
582 
583  if(sqlca.sqlcode == 0) {
584 
585  get_valm24_array();
586 
587  for(k=23;k>=0;k--) {
588 
589  hour=k;
590  atime=hour*10000;
591  zdate=ma_hrly_rec.cal_yr*10000+ma_hrly_rec.mon*100+ma_hrly_rec.zday;
592 
593  if(year==eyr && month==emo && day==edy &&
594  atime < etime)
595  break;
596 
597  if(year==byr && month==bmo && day==bdy &&
598  atime > btime)
599  continue;
600 
601  if(data_record.values[k] < -98)
602  continue;
603 
604  if(data_record.lwals[k]=='F')
605  continue;
606 
607 
608  if(*qual != 0) {
609 
610  for(hh=0;hh<qlen;hh++)
611  if(*(qual+hh) == data_record.lwals[k])
612  break;
613 
614  if(hh==qlen)
615  continue;
616 
617  }
618 
619  stn_values[jtotal].value=data_record.values[k];
620  stn_values[jtotal].zdate=zdate;
621  stn_values[jtotal].qual= data_record.lwals[k];
622 
623  stn_values[jtotal++].ztime=atime;
624 
625  }
626 
627 
628  }
629 
630  if(jtotal > 9600)
631  break;
632 
633  if(year==eyr && month==emo && day==edy)
634  break;
635 
636  change_datehm(&year,&month,&day);
637 
638  }
639 
640 return(jtotal);
641 
642 }
643 
644 int get_valm24_array()
645 {
646 
647  data_record.values[0] = ma_hrly_rec.zhr00;
648  data_record.values[1] = ma_hrly_rec.zhr01;
649  data_record.values[2] = ma_hrly_rec.zhr02;
650  data_record.values[3] = ma_hrly_rec.zhr03;
651  data_record.values[4] = ma_hrly_rec.zhr04;
652  data_record.values[5] = ma_hrly_rec.zhr05;
653  data_record.values[6] = ma_hrly_rec.zhr06;
654  data_record.values[7] = ma_hrly_rec.zhr07;
655  data_record.values[8] = ma_hrly_rec.zhr08;
656  data_record.values[9] = ma_hrly_rec.zhr09;
657  data_record.values[10] = ma_hrly_rec.zhr10;
658  data_record.values[11] = ma_hrly_rec.zhr11;
659  data_record.values[12] = ma_hrly_rec.zhr12;
660  data_record.values[13] = ma_hrly_rec.zhr13;
661  data_record.values[14] = ma_hrly_rec.zhr14;
662  data_record.values[15] = ma_hrly_rec.zhr15;
663  data_record.values[16] = ma_hrly_rec.zhr16;
664  data_record.values[17] = ma_hrly_rec.zhr17;
665  data_record.values[18] = ma_hrly_rec.zhr18;
666  data_record.values[19] = ma_hrly_rec.zhr19;
667  data_record.values[20] = ma_hrly_rec.zhr20;
668  data_record.values[21] = ma_hrly_rec.zhr21;
669  data_record.values[22] = ma_hrly_rec.zhr22;
670  data_record.values[23] = ma_hrly_rec.zhr23;
671  data_record.lwals[0] = ma_hrly_rec.qzhr00[0];
672  data_record.lwals[1] = ma_hrly_rec.qzhr01[0];
673  data_record.lwals[2] = ma_hrly_rec.qzhr02[0];
674  data_record.lwals[3] = ma_hrly_rec.qzhr03[0];
675  data_record.lwals[4] = ma_hrly_rec.qzhr04[0];
676  data_record.lwals[5] = ma_hrly_rec.qzhr05[0];
677  data_record.lwals[6] = ma_hrly_rec.qzhr06[0];
678  data_record.lwals[7] = ma_hrly_rec.qzhr07[0];
679  data_record.lwals[8] = ma_hrly_rec.qzhr08[0];
680  data_record.lwals[9] = ma_hrly_rec.qzhr09[0];
681  data_record.lwals[10] = ma_hrly_rec.qzhr10[0];
682  data_record.lwals[11] = ma_hrly_rec.qzhr11[0];
683  data_record.lwals[12] = ma_hrly_rec.qzhr12[0];
684  data_record.lwals[13] = ma_hrly_rec.qzhr13[0];
685  data_record.lwals[14] = ma_hrly_rec.qzhr14[0];
686  data_record.lwals[15] = ma_hrly_rec.qzhr15[0];
687  data_record.lwals[16] = ma_hrly_rec.qzhr16[0];
688  data_record.lwals[17] = ma_hrly_rec.qzhr17[0];
689  data_record.lwals[18] = ma_hrly_rec.qzhr18[0];
690  data_record.lwals[19] = ma_hrly_rec.qzhr19[0];
691  data_record.lwals[20] = ma_hrly_rec.qzhr20[0];
692  data_record.lwals[21] = ma_hrly_rec.qzhr21[0];
693  data_record.lwals[22] = ma_hrly_rec.qzhr22[0];
694  data_record.lwals[23] = ma_hrly_rec.qzhr23[0];
695 
696  return(0);
697 }
698 
699 void change_datehm(int *year,int *month, int*day)
700 
701 {
702 
703 extern int mday[];
704 char buf[10];
705 XmString btn_text;
706 Arg args[10];
707 
708 if (!((*year)%4))
709  mday[1]=29;
710 else
711  mday[1]=28;
712 
713 /*
714 if ((*year)==1972 || (*year)==1976 || (*year)==1980 ||
715  (*year)==1984 || (*year)==1988 || (*year)==1992 ||
716  (*year)==1996 || (*year)==2000 || (*year)==2004 ||
717  (*year)==2008 || (*year)==2012 || (*year)==2016)
718  mday[1]=29;
719 else
720  mday[1]=28;
721 */
722 
723 (*day)--;
724 
725 if(*day <= 0) {
726 
727  (*month)--;
728  if(*month==0) {
729 
730  (*year)--;
731  *month=12;
732 
733  }
734 
735  *day=mday[*month-1];
736 
737  }
738 
739 else if(*day > mday[*month-1]) {
740 
741  *(month)++;
742 
743  if(*month > 12) {
744 
745  (*year)++;
746  *month=1;
747 
748  }
749 
750  *day=1;
751 
752  }
753 
754 
755 }
756 
757 
758 
759 #line 379 "ma_hrly.ec"
i
static int i
Definition: get_apps_defaults.c:110
hour
int hour
Definition: display_data.c:26
day
int day
Definition: display_data.c:26
year
int year
Definition: display_data.c:26
qual
char qual[10]
Definition: subdisplay.c:33
month
int month
Definition: display_data.c:26
mday
int mday[]
Definition: fmap_qtrly.c:519
mon
char * mon[]
Definition: get_isohyet_coord_new.c:3
buf
struct stat buf
Definition: is_file_closed.c:8
ma_hrly_rec
struct ma_hrly_rec ma_hrly_rec
emo
int emo
Definition: ma_hrly.c:123
change_datehm
void change_datehm()
data_record
struct data_rec data_record
bdy
int bdy
Definition: ma_hrly.c:124
get_valm24_array
int get_valm24_array()
Definition: ma_hrly.c:644
eyr
int eyr
Definition: ma_hrly.c:123
edy
int edy
Definition: ma_hrly.c:123
ma_hrly
int ma_hrly(char *hb5, char *parm, char *dpc, struct stim begin_date, struct stim end_date, char *qual, struct stn_values *stn_values)
Definition: ma_hrly.c:223
bmo
int bmo
Definition: ma_hrly.c:124
SQLCODE
int4 SQLCODE
ifx_sqlca_t
struct sqlca_s ifx_sqlca_t
SQLSTATE
char SQLSTATE[]
sqlca
struct sqlca_s sqlca
byr
int byr
Definition: ma_hrly.c:124
k
int k
Definition: mapp2h.h:48
args
Arg args[10]
Definition: plot_qpf_legend.c:23
prototypes_new.h
data_rec
Definition: calfma_qtrly.c:160
data_rec::idote
int idote
Definition: calfma_qtrly.c:177
data_rec::cztime
int cztime
Definition: calfma_qtrly.c:173
data_rec::source
char source[9]
Definition: calfma_qtrly.c:162
data_rec::pe2
char pe2
Definition: calfma_qtrly.c:164
data_rec::t
char t
Definition: calfma_qtrly.c:166
data_rec::s
char s
Definition: calfma_qtrly.c:167
data_rec::irev
int irev
Definition: calfma_qtrly.c:178
data_rec::p
char p
Definition: calfma_qtrly.c:169
data_rec::values
double values[96]
Definition: calfma_qtrly.c:180
data_rec::lwal
char lwal
Definition: calfma_qtrly.c:176
data_rec::zdate
int zdate
Definition: calfma_qtrly.c:170
data_rec::lwals
char lwals[96]
Definition: calfma_qtrly.c:181
data_rec::idur
int idur
Definition: calfma_qtrly.c:174
data_rec::ztime
int ztime
Definition: calfma_qtrly.c:171
data_rec::pedtsep
char pedtsep[8]
Definition: calfma_qtrly.c:182
data_rec::codp
double codp
Definition: calfma_qtrly.c:175
data_rec::dur
char dur
Definition: calfma_qtrly.c:165
data_rec::pe1
char pe1
Definition: calfma_qtrly.c:163
data_rec::value
double value
Definition: calfma_qtrly.c:179
data_rec::e
char e
Definition: calfma_qtrly.c:168
data_rec::czdate
int czdate
Definition: calfma_qtrly.c:172
ma_hrly_rec
Definition: ma_hrly.c:126
ma_hrly_rec::qzhr15
char qzhr15[2]
Definition: ma_hrly.c:180
ma_hrly_rec::qzhr17
char qzhr17[2]
Definition: ma_hrly.c:182
ma_hrly_rec::qzhr19
char qzhr19[2]
Definition: ma_hrly.c:184
ma_hrly_rec::p
char p[2]
Definition: ma_hrly.c:137
ma_hrly_rec::zhr13
double zhr13
Definition: ma_hrly.c:154
ma_hrly_rec::qzhr01
char qzhr01[2]
Definition: ma_hrly.c:166
ma_hrly_rec::qzhr12
char qzhr12[2]
Definition: ma_hrly.c:177
ma_hrly_rec::cal_yr
int cal_yr
Definition: ma_hrly.c:138
ma_hrly_rec::zhr22
double zhr22
Definition: ma_hrly.c:163
ma_hrly_rec::pos
char pos[2]
Definition: ma_hrly.c:129
ma_hrly_rec::qzhr00
char qzhr00[2]
Definition: ma_hrly.c:165
ma_hrly_rec::qzhr06
char qzhr06[2]
Definition: ma_hrly.c:171
ma_hrly_rec::qzhr04
char qzhr04[2]
Definition: ma_hrly.c:169
ma_hrly_rec::qzhr05
char qzhr05[2]
Definition: ma_hrly.c:170
ma_hrly_rec::qzhr10
char qzhr10[2]
Definition: ma_hrly.c:175
ma_hrly_rec::zhr17
double zhr17
Definition: ma_hrly.c:158
ma_hrly_rec::t
char t[2]
Definition: ma_hrly.c:134
ma_hrly_rec::qzhr03
char qzhr03[2]
Definition: ma_hrly.c:168
ma_hrly_rec::drain
char drain[2]
Definition: ma_hrly.c:128
ma_hrly_rec::qzhr22
char qzhr22[2]
Definition: ma_hrly.c:187
ma_hrly_rec::qzhr14
char qzhr14[2]
Definition: ma_hrly.c:179
ma_hrly_rec::zhr10
double zhr10
Definition: ma_hrly.c:151
ma_hrly_rec::pe1
char pe1[2]
Definition: ma_hrly.c:131
ma_hrly_rec::zhr08
double zhr08
Definition: ma_hrly.c:149
ma_hrly_rec::zhr23
double zhr23
Definition: ma_hrly.c:164
ma_hrly_rec::qzhr21
char qzhr21[2]
Definition: ma_hrly.c:186
ma_hrly_rec::zhr20
double zhr20
Definition: ma_hrly.c:161
ma_hrly_rec::qzhr11
char qzhr11[2]
Definition: ma_hrly.c:176
ma_hrly_rec::qzhr18
char qzhr18[2]
Definition: ma_hrly.c:183
ma_hrly_rec::e
char e[2]
Definition: ma_hrly.c:136
ma_hrly_rec::zhr06
double zhr06
Definition: ma_hrly.c:147
ma_hrly_rec::pe2
char pe2[2]
Definition: ma_hrly.c:132
ma_hrly_rec::zhr21
double zhr21
Definition: ma_hrly.c:162
ma_hrly_rec::qzhr09
char qzhr09[2]
Definition: ma_hrly.c:174
ma_hrly_rec::zhr11
double zhr11
Definition: ma_hrly.c:152
ma_hrly_rec::qzhr08
char qzhr08[2]
Definition: ma_hrly.c:173
ma_hrly_rec::zhr00
double zhr00
Definition: ma_hrly.c:141
ma_hrly_rec::zhr04
double zhr04
Definition: ma_hrly.c:145
ma_hrly_rec::qzhr16
char qzhr16[2]
Definition: ma_hrly.c:181
ma_hrly_rec::dur
char dur[2]
Definition: ma_hrly.c:133
ma_hrly_rec::zhr05
double zhr05
Definition: ma_hrly.c:146
ma_hrly_rec::qzhr13
char qzhr13[2]
Definition: ma_hrly.c:178
ma_hrly_rec::zhr03
double zhr03
Definition: ma_hrly.c:144
ma_hrly_rec::zhr18
double zhr18
Definition: ma_hrly.c:159
ma_hrly_rec::zhr16
double zhr16
Definition: ma_hrly.c:157
ma_hrly_rec::zhr19
double zhr19
Definition: ma_hrly.c:160
ma_hrly_rec::qzhr02
char qzhr02[2]
Definition: ma_hrly.c:167
ma_hrly_rec::zhr07
double zhr07
Definition: ma_hrly.c:148
ma_hrly_rec::qzhr20
char qzhr20[2]
Definition: ma_hrly.c:185
ma_hrly_rec::cgroup
char cgroup[2]
Definition: ma_hrly.c:130
ma_hrly_rec::mon
int mon
Definition: ma_hrly.c:139
ma_hrly_rec::s
char s[2]
Definition: ma_hrly.c:135
ma_hrly_rec::zhr02
double zhr02
Definition: ma_hrly.c:143
ma_hrly_rec::zhr09
double zhr09
Definition: ma_hrly.c:150
ma_hrly_rec::zhr14
double zhr14
Definition: ma_hrly.c:155
ma_hrly_rec::qzhr07
char qzhr07[2]
Definition: ma_hrly.c:172
ma_hrly_rec::zhr12
double zhr12
Definition: ma_hrly.c:153
ma_hrly_rec::zhr01
double zhr01
Definition: ma_hrly.c:142
ma_hrly_rec::zhr15
double zhr15
Definition: ma_hrly.c:156
ma_hrly_rec::zday
int zday
Definition: ma_hrly.c:140
ma_hrly_rec::qzhr23
char qzhr23[2]
Definition: ma_hrly.c:188
sqlca_s::sqlcaw_s::sqlwarn5
char sqlwarn5
Definition: db.c:65
sqlca_s::sqlcaw_s::sqlwarn3
char sqlwarn3
Definition: db.c:61
sqlca_s::sqlcaw_s::sqlwarn4
char sqlwarn4
Definition: db.c:63
sqlca_s::sqlcaw_s::sqlwarn7
char sqlwarn7
Definition: db.c:67
sqlca_s::sqlcaw_s::sqlwarn1
char sqlwarn1
Definition: db.c:57
sqlca_s::sqlcaw_s::sqlwarn6
char sqlwarn6
Definition: db.c:66
sqlca_s::sqlcaw_s::sqlwarn2
char sqlwarn2
Definition: db.c:59
sqlca_s::sqlcaw_s::sqlwarn0
char sqlwarn0
Definition: db.c:56
sqlca_s
Definition: db.c:43
sqlca_s::sqlerrd
long sqlerrd[6]
Definition: db.c:47
sqlca_s::sqlwarn
struct sqlca_s::sqlcaw_s sqlwarn
sqlca_s::sqlcode
long sqlcode
Definition: db.c:44
sqlca_s::sqlerrm
char sqlerrm[72]
Definition: db.c:45
sqlca_s::sqlerrp
char sqlerrp[8]
Definition: db.c:46
stim
Definition: misc.h:93
stim::minute
int minute
Definition: misc.h:99
stim::day
int day
Definition: misc.h:97
stim::year
int year
Definition: misc.h:95
stim::hour
int hour
Definition: misc.h:98
stim::month
int month
Definition: misc.h:96
stn_values
Definition: hydro_data.h:31
stn_values::qual
char qual
Definition: hydro_data.h:36
stn_values::zdate
int zdate
Definition: hydro_data.h:33
stn_values::ztime
int ztime
Definition: hydro_data.h:34
stn_values::value
float value
Definition: hydro_data.h:35
Generated by doxygen 1.9.1