3 #line 1 "calfma_qtrly.ec"
8 #line 2 "calfma_qtrly.ec"
10 #line 2 "calfma_qtrly.ec"
11 #line 1 "/opt/informix/incl/esql/sqlca.h"
85 #define SQLNOTFOUND 100
89 #define sqlca ifmxsqlca
101 extern int4 * ifx_sqlcode(
void);
102 extern struct sqlca_s * ifx_sqlca(
void);
104 #define SQLCODE (*(ifx_sqlcode()))
105 #define SQLSTATE ((char *)(ifx_sqlstate()))
106 #define sqlca (*(ifx_sqlca()))
115 #line 103 "/opt/informix/incl/esql/sqlca.h"
116 #line 3 "calfma_qtrly.ec"
121 #line 4 "calfma_qtrly.ec"
122 #line 5 "calfma_qtrly.ec"
157 #line 39 "calfma_qtrly.ec"
194 int i,jtotal,
k,atime,iclear;
206 #line 84 "calfma_qtrly.ec"
207 #line 85 "calfma_qtrly.ec"
211 int fyear, fmonth, fday, fhour, fminute, ftime;
220 char drain[2], pos[2], cgroup[2];
224 #line 99 "calfma_qtrly.ec"
248 etime=end_date.
hour*10000+
254 btime=begin_date.
hour*10000+
266 ftime=fhour*10000+fminute*100;
306 #line 157 "calfma_qtrly.ec"
308 #line 177 "calfma_qtrly.ec"
309 static const char *sqlcmdtxt[] =
310 #line 177 "calfma_qtrly.ec"
312 #line 177 "calfma_qtrly.ec"
313 "select * from calfmaqtrly where id = ? and pe1 = ? and pe2 = ? and dur = ? and t = ? and s = ? and e = ? and p = ? and drain = ? and pos = ? and cgroup = ? and vcal_yr = ? and vmon = ? and vzday = ? and ccal_yr = ? and cmon = ? and czday = ? and ctime = ?",
316 #line 177 "calfma_qtrly.ec"
317 static ifx_cursor_t _SQ0 = {0};
318 static ifx_sqlvar_t _sqibind[] =
320 { 100, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
321 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
322 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
323 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
324 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
325 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
326 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
327 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
328 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
329 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
330 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
331 { 102,
sizeof(
year), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
332 { 102,
sizeof(
month), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
333 { 102,
sizeof(
day), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
334 { 102,
sizeof(fyear), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
335 { 102,
sizeof(fmonth), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
336 { 102,
sizeof(fday), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
337 { 102,
sizeof(ftime), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
338 #line 177 "calfma_qtrly.ec"
340 static ifx_sqlvar_t _sqobind[] =
342 { 100, 6, 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 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
349 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
350 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
351 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
352 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
353 { 102,
sizeof((
fma_qtrly_rec).vcal_yr), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
354 { 102,
sizeof((
fma_qtrly_rec).vmon), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
355 { 102,
sizeof((
fma_qtrly_rec).vzday), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
356 { 102,
sizeof((
fma_qtrly_rec).ccal_yr), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
357 { 102,
sizeof((
fma_qtrly_rec).cmon), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
358 { 102,
sizeof((
fma_qtrly_rec).czday), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
359 { 102,
sizeof((
fma_qtrly_rec).ctime), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
360 { 105,
sizeof((
fma_qtrly_rec).z00), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
361 { 105,
sizeof((
fma_qtrly_rec).z06), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
362 { 105,
sizeof((
fma_qtrly_rec).z12), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
363 { 105,
sizeof((
fma_qtrly_rec).z18), 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 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
367 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
368 #line 177 "calfma_qtrly.ec"
370 #line 177 "calfma_qtrly.ec"
371 _sqibind[0].sqldata = shb5;
372 #line 177 "calfma_qtrly.ec"
373 _sqibind[1].sqldata = pe1;
374 #line 177 "calfma_qtrly.ec"
375 _sqibind[2].sqldata = pe2;
376 #line 177 "calfma_qtrly.ec"
377 _sqibind[3].sqldata = dur;
378 #line 177 "calfma_qtrly.ec"
379 _sqibind[4].sqldata = t;
380 #line 177 "calfma_qtrly.ec"
381 _sqibind[5].sqldata = s;
382 #line 177 "calfma_qtrly.ec"
383 _sqibind[6].sqldata = e;
384 #line 177 "calfma_qtrly.ec"
385 _sqibind[7].sqldata = p;
386 #line 177 "calfma_qtrly.ec"
387 _sqibind[8].sqldata = drain;
388 #line 177 "calfma_qtrly.ec"
389 _sqibind[9].sqldata = pos;
390 #line 177 "calfma_qtrly.ec"
391 _sqibind[10].sqldata = cgroup;
392 #line 177 "calfma_qtrly.ec"
393 _sqibind[11].sqldata = (
char *) &
year;
394 #line 177 "calfma_qtrly.ec"
395 _sqibind[12].sqldata = (
char *) &
month;
396 #line 177 "calfma_qtrly.ec"
397 _sqibind[13].sqldata = (
char *) &
day;
398 #line 177 "calfma_qtrly.ec"
399 _sqibind[14].sqldata = (
char *) &fyear;
400 #line 177 "calfma_qtrly.ec"
401 _sqibind[15].sqldata = (
char *) &fmonth;
402 #line 177 "calfma_qtrly.ec"
403 _sqibind[16].sqldata = (
char *) &fday;
404 #line 177 "calfma_qtrly.ec"
405 _sqibind[17].sqldata = (
char *) &ftime;
406 #line 177 "calfma_qtrly.ec"
408 #line 177 "calfma_qtrly.ec"
410 #line 177 "calfma_qtrly.ec"
412 #line 177 "calfma_qtrly.ec"
414 #line 177 "calfma_qtrly.ec"
416 #line 177 "calfma_qtrly.ec"
418 #line 177 "calfma_qtrly.ec"
420 #line 177 "calfma_qtrly.ec"
422 #line 177 "calfma_qtrly.ec"
424 #line 177 "calfma_qtrly.ec"
426 #line 177 "calfma_qtrly.ec"
428 #line 177 "calfma_qtrly.ec"
430 #line 177 "calfma_qtrly.ec"
432 #line 177 "calfma_qtrly.ec"
434 #line 177 "calfma_qtrly.ec"
436 #line 177 "calfma_qtrly.ec"
438 #line 177 "calfma_qtrly.ec"
440 #line 177 "calfma_qtrly.ec"
442 #line 177 "calfma_qtrly.ec"
444 #line 177 "calfma_qtrly.ec"
446 #line 177 "calfma_qtrly.ec"
448 #line 177 "calfma_qtrly.ec"
450 #line 177 "calfma_qtrly.ec"
452 #line 177 "calfma_qtrly.ec"
454 #line 177 "calfma_qtrly.ec"
456 #line 177 "calfma_qtrly.ec"
458 #line 177 "calfma_qtrly.ec"
459 sqli_slct(ESQLINTVERSION, &_SQ0,sqlcmdtxt,18,_sqibind,26,_sqobind,0,(ifx_literal_t *)0,(ifx_namelist_t *)0,0);
460 #line 177 "calfma_qtrly.ec"
483 ftime=fhour*10000+fminute*100;
676 #line 390 "calfma_qtrly.ec"
struct data_rec data_record
struct fma_qrtly_rec fma_qtrly_rec
struct sqlca_s ifx_sqlca_t
int calfma_qtrly(char *hb5, char *dparm, char *parm, struct stim begin_date, struct stim end_date, struct stim q_date, struct stn_values *stn_values)
printf("fbuf is %s\n", fbuf)
struct sqlca_s::sqlcaw_s sqlwarn