10 #line 2 "fpro_hrly.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 "fpro_hrly.ec"
121 #line 4 "fpro_hrly.ec"
122 #line 5 "fpro_hrly.ec"
194 #line 76 "fpro_hrly.ec"
231 int i,jtotal,
k,atime,iclear;
242 #line 120 "fpro_hrly.ec"
243 #line 121 "fpro_hrly.ec"
247 int fyear, fmonth, fday, fhour, fminute, ftime;
259 #line 134 "fpro_hrly.ec"
283 etime=end_date.
hour*10000+
289 btime=begin_date.
hour*10000+
301 ftime=fhour*10000+fminute*100;
329 #line 183 "fpro_hrly.ec"
331 #line 200 "fpro_hrly.ec"
332 static const char *sqlcmdtxt[] =
333 #line 200 "fpro_hrly.ec"
335 #line 200 "fpro_hrly.ec"
336 "select * from fprohrly where id = ? and pe1 = ? and pe2 = ? and dur = ? and t = ? and s = ? and e = ? and p = ? and vcal_yr = ? and vmon = ? and vzday = ? and ccal_yr = ? and cmon = ? and czday = ? and cztime = ?",
339 #line 200 "fpro_hrly.ec"
340 static ifx_cursor_t _SQ0 = {0};
341 static ifx_sqlvar_t _sqibind[] =
343 { 100, 6, 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 { 102,
sizeof(
year), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
352 { 102,
sizeof(
month), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
353 { 102,
sizeof(
day), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
354 { 102,
sizeof(fyear), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
355 { 102,
sizeof(fmonth), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
356 { 102,
sizeof(fday), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
357 { 102,
sizeof(ftime), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
358 #line 200 "fpro_hrly.ec"
360 static ifx_sqlvar_t _sqobind[] =
362 { 100, 6, 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 { 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 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
369 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
370 { 102,
sizeof((
fhrly_rec).vcal_yr), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
371 { 102,
sizeof((
fhrly_rec).vmon), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
372 { 102,
sizeof((
fhrly_rec).vzday), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
373 { 102,
sizeof((
fhrly_rec).ccal_yr), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
374 { 102,
sizeof((
fhrly_rec).cmon), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
375 { 102,
sizeof((
fhrly_rec).czday), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
376 { 102,
sizeof((
fhrly_rec).cztime), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
377 { 105,
sizeof((
fhrly_rec).zhr00), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
378 { 105,
sizeof((
fhrly_rec).zhr01), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
379 { 105,
sizeof((
fhrly_rec).zhr02), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
380 { 105,
sizeof((
fhrly_rec).zhr03), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
381 { 105,
sizeof((
fhrly_rec).zhr04), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
382 { 105,
sizeof((
fhrly_rec).zhr05), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
383 { 105,
sizeof((
fhrly_rec).zhr06), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
384 { 105,
sizeof((
fhrly_rec).zhr07), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
385 { 105,
sizeof((
fhrly_rec).zhr08), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
386 { 105,
sizeof((
fhrly_rec).zhr09), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
387 { 105,
sizeof((
fhrly_rec).zhr10), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
388 { 105,
sizeof((
fhrly_rec).zhr11), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
389 { 105,
sizeof((
fhrly_rec).zhr12), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
390 { 105,
sizeof((
fhrly_rec).zhr13), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
391 { 105,
sizeof((
fhrly_rec).zhr14), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
392 { 105,
sizeof((
fhrly_rec).zhr15), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
393 { 105,
sizeof((
fhrly_rec).zhr16), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
394 { 105,
sizeof((
fhrly_rec).zhr17), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
395 { 105,
sizeof((
fhrly_rec).zhr18), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
396 { 105,
sizeof((
fhrly_rec).zhr19), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
397 { 105,
sizeof((
fhrly_rec).zhr20), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
398 { 105,
sizeof((
fhrly_rec).zhr21), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
399 { 105,
sizeof((
fhrly_rec).zhr22), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
400 { 105,
sizeof((
fhrly_rec).zhr23), 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 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
418 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
419 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
420 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
421 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
422 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
423 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
424 { 100, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 },
425 #line 200 "fpro_hrly.ec"
427 #line 200 "fpro_hrly.ec"
428 _sqibind[0].sqldata = shb5;
429 #line 200 "fpro_hrly.ec"
430 _sqibind[1].sqldata = pe1;
431 #line 200 "fpro_hrly.ec"
432 _sqibind[2].sqldata = pe2;
433 #line 200 "fpro_hrly.ec"
434 _sqibind[3].sqldata = dur;
435 #line 200 "fpro_hrly.ec"
436 _sqibind[4].sqldata = t;
437 #line 200 "fpro_hrly.ec"
438 _sqibind[5].sqldata = s;
439 #line 200 "fpro_hrly.ec"
440 _sqibind[6].sqldata = e;
441 #line 200 "fpro_hrly.ec"
442 _sqibind[7].sqldata = p;
443 #line 200 "fpro_hrly.ec"
444 _sqibind[8].sqldata = (
char *) &
year;
445 #line 200 "fpro_hrly.ec"
446 _sqibind[9].sqldata = (
char *) &
month;
447 #line 200 "fpro_hrly.ec"
448 _sqibind[10].sqldata = (
char *) &
day;
449 #line 200 "fpro_hrly.ec"
450 _sqibind[11].sqldata = (
char *) &fyear;
451 #line 200 "fpro_hrly.ec"
452 _sqibind[12].sqldata = (
char *) &fmonth;
453 #line 200 "fpro_hrly.ec"
454 _sqibind[13].sqldata = (
char *) &fday;
455 #line 200 "fpro_hrly.ec"
456 _sqibind[14].sqldata = (
char *) &ftime;
457 #line 200 "fpro_hrly.ec"
459 #line 200 "fpro_hrly.ec"
461 #line 200 "fpro_hrly.ec"
463 #line 200 "fpro_hrly.ec"
465 #line 200 "fpro_hrly.ec"
467 #line 200 "fpro_hrly.ec"
469 #line 200 "fpro_hrly.ec"
471 #line 200 "fpro_hrly.ec"
473 #line 200 "fpro_hrly.ec"
474 _sqobind[8].sqldata = (
char *) &(
fhrly_rec).vcal_yr;
475 #line 200 "fpro_hrly.ec"
476 _sqobind[9].sqldata = (
char *) &(
fhrly_rec).vmon;
477 #line 200 "fpro_hrly.ec"
478 _sqobind[10].sqldata = (
char *) &(
fhrly_rec).vzday;
479 #line 200 "fpro_hrly.ec"
480 _sqobind[11].sqldata = (
char *) &(
fhrly_rec).ccal_yr;
481 #line 200 "fpro_hrly.ec"
482 _sqobind[12].sqldata = (
char *) &(
fhrly_rec).cmon;
483 #line 200 "fpro_hrly.ec"
484 _sqobind[13].sqldata = (
char *) &(
fhrly_rec).czday;
485 #line 200 "fpro_hrly.ec"
486 _sqobind[14].sqldata = (
char *) &(
fhrly_rec).cztime;
487 #line 200 "fpro_hrly.ec"
488 _sqobind[15].sqldata = (
char *) &(
fhrly_rec).zhr00;
489 #line 200 "fpro_hrly.ec"
490 _sqobind[16].sqldata = (
char *) &(
fhrly_rec).zhr01;
491 #line 200 "fpro_hrly.ec"
492 _sqobind[17].sqldata = (
char *) &(
fhrly_rec).zhr02;
493 #line 200 "fpro_hrly.ec"
494 _sqobind[18].sqldata = (
char *) &(
fhrly_rec).zhr03;
495 #line 200 "fpro_hrly.ec"
496 _sqobind[19].sqldata = (
char *) &(
fhrly_rec).zhr04;
497 #line 200 "fpro_hrly.ec"
498 _sqobind[20].sqldata = (
char *) &(
fhrly_rec).zhr05;
499 #line 200 "fpro_hrly.ec"
500 _sqobind[21].sqldata = (
char *) &(
fhrly_rec).zhr06;
501 #line 200 "fpro_hrly.ec"
502 _sqobind[22].sqldata = (
char *) &(
fhrly_rec).zhr07;
503 #line 200 "fpro_hrly.ec"
504 _sqobind[23].sqldata = (
char *) &(
fhrly_rec).zhr08;
505 #line 200 "fpro_hrly.ec"
506 _sqobind[24].sqldata = (
char *) &(
fhrly_rec).zhr09;
507 #line 200 "fpro_hrly.ec"
508 _sqobind[25].sqldata = (
char *) &(
fhrly_rec).zhr10;
509 #line 200 "fpro_hrly.ec"
510 _sqobind[26].sqldata = (
char *) &(
fhrly_rec).zhr11;
511 #line 200 "fpro_hrly.ec"
512 _sqobind[27].sqldata = (
char *) &(
fhrly_rec).zhr12;
513 #line 200 "fpro_hrly.ec"
514 _sqobind[28].sqldata = (
char *) &(
fhrly_rec).zhr13;
515 #line 200 "fpro_hrly.ec"
516 _sqobind[29].sqldata = (
char *) &(
fhrly_rec).zhr14;
517 #line 200 "fpro_hrly.ec"
518 _sqobind[30].sqldata = (
char *) &(
fhrly_rec).zhr15;
519 #line 200 "fpro_hrly.ec"
520 _sqobind[31].sqldata = (
char *) &(
fhrly_rec).zhr16;
521 #line 200 "fpro_hrly.ec"
522 _sqobind[32].sqldata = (
char *) &(
fhrly_rec).zhr17;
523 #line 200 "fpro_hrly.ec"
524 _sqobind[33].sqldata = (
char *) &(
fhrly_rec).zhr18;
525 #line 200 "fpro_hrly.ec"
526 _sqobind[34].sqldata = (
char *) &(
fhrly_rec).zhr19;
527 #line 200 "fpro_hrly.ec"
528 _sqobind[35].sqldata = (
char *) &(
fhrly_rec).zhr20;
529 #line 200 "fpro_hrly.ec"
530 _sqobind[36].sqldata = (
char *) &(
fhrly_rec).zhr21;
531 #line 200 "fpro_hrly.ec"
532 _sqobind[37].sqldata = (
char *) &(
fhrly_rec).zhr22;
533 #line 200 "fpro_hrly.ec"
534 _sqobind[38].sqldata = (
char *) &(
fhrly_rec).zhr23;
535 #line 200 "fpro_hrly.ec"
536 _sqobind[39].sqldata = (
fhrly_rec).qzhr00;
537 #line 200 "fpro_hrly.ec"
538 _sqobind[40].sqldata = (
fhrly_rec).qzhr01;
539 #line 200 "fpro_hrly.ec"
540 _sqobind[41].sqldata = (
fhrly_rec).qzhr02;
541 #line 200 "fpro_hrly.ec"
542 _sqobind[42].sqldata = (
fhrly_rec).qzhr03;
543 #line 200 "fpro_hrly.ec"
544 _sqobind[43].sqldata = (
fhrly_rec).qzhr04;
545 #line 200 "fpro_hrly.ec"
546 _sqobind[44].sqldata = (
fhrly_rec).qzhr05;
547 #line 200 "fpro_hrly.ec"
548 _sqobind[45].sqldata = (
fhrly_rec).qzhr06;
549 #line 200 "fpro_hrly.ec"
550 _sqobind[46].sqldata = (
fhrly_rec).qzhr07;
551 #line 200 "fpro_hrly.ec"
552 _sqobind[47].sqldata = (
fhrly_rec).qzhr08;
553 #line 200 "fpro_hrly.ec"
554 _sqobind[48].sqldata = (
fhrly_rec).qzhr09;
555 #line 200 "fpro_hrly.ec"
556 _sqobind[49].sqldata = (
fhrly_rec).qzhr10;
557 #line 200 "fpro_hrly.ec"
558 _sqobind[50].sqldata = (
fhrly_rec).qzhr11;
559 #line 200 "fpro_hrly.ec"
560 _sqobind[51].sqldata = (
fhrly_rec).qzhr12;
561 #line 200 "fpro_hrly.ec"
562 _sqobind[52].sqldata = (
fhrly_rec).qzhr13;
563 #line 200 "fpro_hrly.ec"
564 _sqobind[53].sqldata = (
fhrly_rec).qzhr14;
565 #line 200 "fpro_hrly.ec"
566 _sqobind[54].sqldata = (
fhrly_rec).qzhr15;
567 #line 200 "fpro_hrly.ec"
568 _sqobind[55].sqldata = (
fhrly_rec).qzhr16;
569 #line 200 "fpro_hrly.ec"
570 _sqobind[56].sqldata = (
fhrly_rec).qzhr17;
571 #line 200 "fpro_hrly.ec"
572 _sqobind[57].sqldata = (
fhrly_rec).qzhr18;
573 #line 200 "fpro_hrly.ec"
574 _sqobind[58].sqldata = (
fhrly_rec).qzhr19;
575 #line 200 "fpro_hrly.ec"
576 _sqobind[59].sqldata = (
fhrly_rec).qzhr20;
577 #line 200 "fpro_hrly.ec"
578 _sqobind[60].sqldata = (
fhrly_rec).qzhr21;
579 #line 200 "fpro_hrly.ec"
580 _sqobind[61].sqldata = (
fhrly_rec).qzhr22;
581 #line 200 "fpro_hrly.ec"
582 _sqobind[62].sqldata = (
fhrly_rec).qzhr23;
583 #line 200 "fpro_hrly.ec"
584 sqli_slct(ESQLINTVERSION, &_SQ0,sqlcmdtxt,15,_sqibind,63,_sqobind,0,(ifx_literal_t *)0,(ifx_namelist_t *)0,0);
585 #line 200 "fpro_hrly.ec"
603 ftime=fhour*10000+fminute*100;
806 printf(
"ztime is %d\n",*ztime);
850 #line 462 "fpro_hrly.ec"
struct data_rec data_record
struct fpro_hrly_rec fhrly_rec
struct sqlca_s ifx_sqlca_t
int fpro_hrly(char *hb5, 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