OPEN_QUERY (7 in 4 files)

Filename Line # Column # Match Text
./abl/checkout.p 00083 00001
open [OPEN_QUERY] @83:1
   q-checkout [QUERY] @83:12
   for [KW_FOR] @84:4
      each [KW_EACH] @84:8
      record phrase [RECORD_PHRASE] @0:0
         checkout [TABLE] @84:13
         no-lock [KW_NO_LOCK] @84:22
      each [KW_EACH] @85:8
      record phrase [RECORD_PHRASE] @0:0
         reservation [TABLE] @85:13
         where [KW_WHERE] @86:10
            expression [EXPRESSION] @0:0
               and [KW_AND] @86:69
                  = [EQUALS] @86:43
                     reservation.reservation-id [FIELD_INT] @86:16
                     checkout.reservation-id [FIELD_INT] @86:45
                  ( [LPARENS] @88:17
                     or [KW_OR] @88:39
                        = [EQUALS] @88:33
                           checkout.state [FIELD_CHAR] @88:18
                           'I' [STRING] @88:35
                        = [EQUALS] @88:57
                           checkout.state [FIELD_CHAR] @88:42
                           "O" [STRING] @88:59
         no-lock [KW_NO_LOCK] @88:64
         use-index [KW_USE_IDX] @88:72
            idx-r-id [INDEX] @88:82
./abl/checkout.p 00093 00004
open [OPEN_QUERY] @93:4
   q-room [QUERY] @93:15
   for [KW_FOR] @94:7
      each [KW_EACH] @94:11
      record phrase [RECORD_PHRASE] @0:0
         checkout-room [TABLE] @94:16
         where [KW_WHERE] @95:10
            expression [EXPRESSION] @0:0
               = [EQUALS] @95:45
                  checkout-room.reservation-id [FIELD_INT] @95:16
                  checkout.reservation-id [FIELD_INT] @95:47
         no-lock [KW_NO_LOCK] @95:71
         use-index [KW_USE_IDX] @95:79
            idx-rc-room [INDEX] @95:89
./abl/guests.p 00085 00001
open [OPEN_QUERY] @85:1
   q-guest [QUERY] @85:12
   for [KW_FOR] @85:20
      each [KW_EACH] @85:24
      record phrase [RECORD_PHRASE] @0:0
         guest [TABLE] @85:29
         use-index [KW_USE_IDX] @85:35
            idx-g-id [INDEX] @85:45
./abl/rates.p 00100 00004
open [OPEN_QUERY] @100:4
   q-room [QUERY] @100:15
   for [KW_FOR] @101:7
      each [KW_EACH] @101:11
      record phrase [RECORD_PHRASE] @0:0
         t-floor [TEMP_TABLE] @101:16
         where [KW_WHERE] @101:24
            expression [EXPRESSION] @0:0
               ( [LPARENS] @101:30
                  if [FUNC_POLY] @101:31
                     = [EQUALS] @101:51
                        current-floor-no [VAR_INT] @101:34
                        ? [UNKNOWN_VAL] @101:53
                     true [BOOL_TRUE] @101:60
                     = [EQUALS] @101:84
                        t-floor.floor [FIELD_INT] @101:70
                        current-floor-no [VAR_INT] @101:86
      each [KW_EACH] @102:10
      record phrase [RECORD_PHRASE] @0:0
         t-room-type [TEMP_TABLE] @102:15
         where [KW_WHERE] @102:27
            expression [EXPRESSION] @0:0
               ( [LPARENS] @102:33
                  if [FUNC_POLY] @102:34
                     = [EQUALS] @102:55
                        current-room-type [VAR_INT] @102:37
                        ? [UNKNOWN_VAL] @102:57
                     true [BOOL_TRUE] @102:64
                     = [EQUALS] @102:91
                        t-room-type.type [FIELD_INT] @102:74
                        current-room-type [VAR_INT] @102:93
      each [KW_EACH] @103:10
      record phrase [RECORD_PHRASE] @0:0
         rate [TABLE] @103:15
         where [KW_WHERE] @103:20
            expression [EXPRESSION] @0:0
               and [KW_AND] @103:53
                  = [EQUALS] @103:37
                     rate.floor [FIELD_INT] @103:26
                     t-floor.floor [FIELD_INT] @103:39
                  = [EQUALS] @104:44
                     rate.type-of-room [FIELD_INT] @104:26
                     t-room-type.type [FIELD_INT] @104:46
         outer-join [KW_OUT_JOIN] @105:20
         use-index [KW_USE_IDX] @106:20
            idx-rate-e-date [INDEX] @106:30
./abl/reservations.p 00088 00001
open [OPEN_QUERY] @88:1
   q-res [QUERY] @88:12
   for [KW_FOR] @88:18
      each [KW_EACH] @88:22
      record phrase [RECORD_PHRASE] @0:0
         reservation [TABLE] @88:27
         where [KW_WHERE] @89:4
            expression [EXPRESSION] @0:0
               <> [NOT_EQ] @89:67
                  reservation.state [FIELD_CHAR] @89:49
                  'C' [STRING] @89:70
         no-lock [KW_NO_LOCK] @89:74
         use-index [KW_USE_IDX] @89:82
            idx-r-checkin [INDEX] @89:92
./abl/reservations.p 00206 00010
open [OPEN_QUERY] @206:10
   q-guest [QUERY] @206:21
   for [KW_FOR] @206:29
      each [KW_EACH] @206:33
      record phrase [RECORD_PHRASE] @0:0
         b-guest [BUFFER] @206:38
         where [KW_WHERE] @207:13
            expression [EXPRESSION] @0:0
               and [KW_AND] @208:98
                  and [KW_AND] @207:102
                     ( [LPARENS] @207:19
                        if [FUNC_POLY] @207:20
                           or [KW_OR] @207:33
                              = [EQUALS] @207:29
                                 g-f-n [VAR_CHAR] @207:23
                                 ? [UNKNOWN_VAL] @207:31
                              = [EQUALS] @207:42
                                 g-f-n [VAR_CHAR] @207:36
                                 "" [STRING] @207:44
                           true [BOOL_TRUE] @207:52
                           matches [KW_MATCHES] @207:81
                              b-guest.first-name [FIELD_CHAR] @207:62
                              + [PLUS] @207:95
                                 g-f-n [VAR_CHAR] @207:89
                                 "*" [STRING] @207:97
                     ( [LPARENS] @208:16
                        if [FUNC_POLY] @208:17
                           or [KW_OR] @208:30
                              = [EQUALS] @208:26
                                 g-l-n [VAR_CHAR] @208:20
                                 ? [UNKNOWN_VAL] @208:28
                              = [EQUALS] @208:39
                                 g-l-n [VAR_CHAR] @208:33
                                 "" [STRING] @208:41
                           true [BOOL_TRUE] @208:49
                           matches [KW_MATCHES] @208:77
                              b-guest.last-name [FIELD_CHAR] @208:59
                              + [PLUS] @208:91
                                 g-l-n [VAR_CHAR] @208:85
                                 "*" [STRING] @208:93
                  ( [LPARENS] @209:16
                     if [FUNC_POLY] @209:17
                        = [EQUALS] @209:26
                           g-dob [VAR_DATE] @209:20
                           ? [UNKNOWN_VAL] @209:28
                        true [BOOL_TRUE] @209:35
                        = [EQUALS] @209:67
                           b-guest.date-of-birth [FIELD_DATE] @209:45
                           g-dob [VAR_DATE] @209:69
./abl/reservations.p 00601 00019
open [OPEN_QUERY] @601:19
   q-rs-room [QUERY] @601:30
   for [KW_FOR] @602:22
      each [KW_EACH] @602:26
      record phrase [RECORD_PHRASE] @0:0
         b-room [BUFFER] @602:31
         where [KW_WHERE] @602:38
            expression [EXPRESSION] @0:0
               = [EQUALS] @602:64
                  b-room.type-of-room [FIELD_INT] @602:44
                  b-res-room.type-of-room [FIELD_INT] @602:66

Conditions matched: [ evalLib("static_record_retrieval", this) ]


Please see the Source File Index for the list of report inputs. Generated at 03/31/2017 21:16:32 EEST.