[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::rdb_60

Title:Oracle Rdb - Still a strategic database for DEC on Alpha AXP!
Notice:RDB_60 is archived, please use RDB_70..
Moderator:NOVA::SMITHISON
Created:Fri Mar 18 1994
Last Modified:Fri May 30 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:5118
Total number of notes:28246

5096.0. "Incorrect query results in 6.0A ECO 6" by BROKE::BASTINE () Mon Mar 03 1997 14:12

I have a customer with a "query returning incorrect results".  He is running
6.0A ECO 6, but claims ECO 5 broke something.

He has a very complex system where many queries run after other queries.  When
this one query began returning incorrect results with his SQLMOD programs, 
I asked for a "small reproducible case" that we could use for engineering.
He created a small section of his code that queries the effected table, but
it all works fine.  It only breaks when run in the context of the whole system
and it worked when running on ECO 4.  As soon as they upgraded to ECO 5, it
stopped working.

Given his system is too complex to replicate here, I have asked for some
BLR output of the query that breaks and the BLR of the small example that
works.  Not sure if it will help at all, but I will post them here.  Given it
is almost impossible to reproduce without his system, is there any other DEBUG
output that might be helpful?  I have also asked him to test using 6.1A, but
that is not possible just yet.

Thanks,
Renee
T.RTitleUserPersonal
Name		DateLines
5096.1Broken BLRBROKE::BASTINEMon Mar 03 1997 14:131138
Here is the BLR debug from the query that fails.




The query below is executed as part of a number of queries. The "B" flag
output below is the complete output from the program run. The query
execution should be near the end. There is a matching record, but "EOS"
is returned.
-----------------------------------
PROCEDURE db_check_negative_check
    SQLCODE
    ,:amount            INTEGER
    ,:bank_routing_id   CHAR(12)
    ,:bank_account_id   CHAR(18)
    ;
    
    SELECT COUNT(*) 
    INTO   :amount
    FROM   negative_check
    WHERE  bank_routing_id = :bank_routing_id
    AND    account_id = :bank_account_id
    ;
-------------------------------------------------------------------
0000 (00000) BLR$K_VERSION4
0001 (00001) | BLR$K_BEGIN
0002 (00002) |   BLR$K_MESSAGE 1 29
0006 (00006) |   | DSC$K_DTYPE_L 0
0008 (00008) |   | DSC$K_DTYPE_L 0
000A (00010) |   | DSC$K_DTYPE_L 0
000C (00012) |   | DSC$K_DTYPE_CHAR 12 (sub-type: 0)
0011 (00017) |   | DSC$K_DTYPE_L 0
0013 (00019) |   | DSC$K_DTYPE_L 0
0015 (00021) |   | DSC$K_DTYPE_VCHAR 50 (sub-type: 0)
001A (00026) |   | DSC$K_DTYPE_L 0
001C (00028) |   | DSC$K_DTYPE_L 0
001E (00030) |   | DSC$K_DTYPE_VCHAR 50 (sub-type: 0)
0023 (00035) |   | DSC$K_DTYPE_L 0
0025 (00037) |   | DSC$K_DTYPE_L 0
0027 (00039) |   | DSC$K_DTYPE_VCHAR 50 (sub-type: 0)
002C (00044) |   | DSC$K_DTYPE_L 0
002E (00046) |   | DSC$K_DTYPE_L 0
0030 (00048) |   | DSC$K_DTYPE_VCHAR 50 (sub-type: 0)
0035 (00053) |   | DSC$K_DTYPE_L 0
0037 (00055) |   | DSC$K_DTYPE_L 0
0039 (00057) |   | DSC$K_DTYPE_VCHAR 50 (sub-type: 0)
003E (00062) |   | DSC$K_DTYPE_L 0
0040 (00064) |   | DSC$K_DTYPE_L 0
0042 (00066) |   | DSC$K_DTYPE_VCHAR 50 (sub-type: 0)
0047 (00071) |   | DSC$K_DTYPE_L 0
0049 (00073) |   | DSC$K_DTYPE_L 0
004B (00075) |   | DSC$K_DTYPE_VCHAR 50 (sub-type: 0)
0050 (00080) |   | DSC$K_DTYPE_L 0
0052 (00082) |   | DSC$K_DTYPE_L -2
0054 (00084) |   | DSC$K_DTYPE_L 0
0056 (00086) |   | DSC$K_DTYPE_L -2
0058 (00088) |   BLR$K_MESSAGE 2 0
005C (00092) |   BLR$K_MESSAGE 3 12
0060 (00096) |   | DSC$K_DTYPE_CHAR 1 (sub-type: 0)
0065 (00101) |   | DSC$K_DTYPE_CHAR 40 (sub-type: 0)
006A (00106) |   | DSC$K_DTYPE_CHAR 40 (sub-type: 0)
006F (00111) |   | DSC$K_DTYPE_CHAR 40 (sub-type: 0)
0074 (00116) |   | DSC$K_DTYPE_CHAR 40 (sub-type: 0)
0079 (00121) |   | DSC$K_DTYPE_CHAR 40 (sub-type: 0)
007E (00126) |   | DSC$K_DTYPE_CHAR 40 (sub-type: 0)
0083 (00131) |   | DSC$K_DTYPE_CHAR 40 (sub-type: 0)
0088 (00136) |   | DSC$K_DTYPE_F
0089 (00137) |   | DSC$K_DTYPE_F
008A (00138) |   | DSC$K_DTYPE_L 0
008C (00140) |   | DSC$K_DTYPE_L 0
008E (00142) |   BLR$K_RECEIVE  3
0090 (00144) |   | BLR$K_BEGIN
0091 (00145) |   |   BLR$K_SEND  1
0093 (00147) |   |   | BLR$K_BEGIN
0094 (00148) |   |   |   BLR$K_ASSIGNMENT
0095 (00149) |   |   |   | BLR$K_LITERAL
0096 (00150) |   |   |   |   DSC$K_DTYPE_L 0  "100"
009C (00156) |   |   |   | BLR$K_PARAMETER 1 0
00A0 (00160) |   |   |   BLR$K_FOR
00A1 (00161) |   |   |   | BLR$K_RSE  1
00A3 (00163) |   |   |   |   BLR$K_RELATION TERMINAL 1
00AE (00174) |   |   |   |   BLR$K_FIRST
00AF (00175) |   |   |   |   | BLR$K_LITERAL
00B0 (00176) |   |   |   |   |   DSC$K_DTYPE_W 0  "2"
00B4 (00180) |   |   |   |   BLR$K_BOOLEAN
00B5 (00181) |   |   |   |   | BLR$K_EQL
00B6 (00182) |   |   |   |   |   BLR$K_FIELD 1 TERMINAL_ID
00C4 (00196) |   |   |   |   |   BLR$K_PARAMETER 3 11
00C8 (00200) |   |   |   | BLR$K_END
00C9 (00201) |   |   |   | BLR$K_BEGIN
00CA (00202) |   |   |   |   BLR$K_IF
00CB (00203) |   |   |   |   | BLR$K_EQL
00CC (00204) |   |   |   |   |   BLR$K_LITERAL
00CD (00205) |   |   |   |   |   | DSC$K_DTYPE_L 0  "100"
00D3 (00211) |   |   |   |   |   BLR$K_PARAMETER 1 0
00D7 (00215) |   |   |   |   | BLR$K_BEGIN
00D8 (00216) |   |   |   |   |   BLR$K_ASSIGNMENT
00D9 (00217) |   |   |   |   |   | BLR$K_FIELD 1 STATION_FIRST_DIG_NUM
00F3 (00243) |   |   |   |   |   | BLR$K_PARAMETER3 1 3 1 2
00F9 (00249) |   |   |   |   |   BLR$K_ASSIGNMENT
00FA (00250) |   |   |   |   |   | BLR$K_FIELD 1 RECEIPT_HEADER_LINE1
0113 (00275) |   |   |   |   |   | BLR$K_PARAMETER3 1 6 4 5
0119 (00281) |   |   |   |   |   BLR$K_ASSIGNMENT
011A (00282) |   |   |   |   |   | BLR$K_FIELD 1 RECEIPT_HEADER_LINE2
0133 (00307) |   |   |   |   |   | BLR$K_PARAMETER3 1 9 7 8
0139 (00313) |   |   |   |   |   BLR$K_ASSIGNMENT
013A (00314) |   |   |   |   |   | BLR$K_FIELD 1 RECEIPT_HEADER_LINE3
0153 (00339) |   |   |   |   |   | BLR$K_PARAMETER3 1 12 10 11
0159 (00345) |   |   |   |   |   BLR$K_ASSIGNMENT
015A (00346) |   |   |   |   |   | BLR$K_FIELD 1 RECEIPT_HEADER_LINE4
0173 (00371) |   |   |   |   |   | BLR$K_PARAMETER3 1 15 13 14
0179 (00377) |   |   |   |   |   BLR$K_ASSIGNMENT
017A (00378) |   |   |   |   |   | BLR$K_FIELD 1 RECEIPT_HEADER_LINE5
0193 (00403) |   |   |   |   |   | BLR$K_PARAMETER3 1 18 16 17
0199 (00409) |   |   |   |   |   BLR$K_ASSIGNMENT
019A (00410) |   |   |   |   |   | BLR$K_FIELD 1 RECEIPT_FOOTER_LINE1
01B3 (00435) |   |   |   |   |   | BLR$K_PARAMETER3 1 21 19 20
01B9 (00441) |   |   |   |   |   BLR$K_ASSIGNMENT
01BA (00442) |   |   |   |   |   | BLR$K_FIELD 1 RECEIPT_FOOTER_LINE2
01D3 (00467) |   |   |   |   |   | BLR$K_PARAMETER3 1 24 22 23
01D9 (00473) |   |   |   |   |   BLR$K_ASSIGNMENT
01DA (00474) |   |   |   |   |   | BLR$K_FIELD 1
CASH_PICKUP_WARNING_AMOUNT
01F7 (00503) |   |   |   |   |   | BLR$K_PARAMETER2 1 26 25
01FD (00509) |   |   |   |   |   BLR$K_ASSIGNMENT
01FE (00510) |   |   |   |   |   | BLR$K_FIELD 1
CASH_PICKUP_LIMIT_AMOUNT
0219 (00537) |   |   |   |   |   | BLR$K_PARAMETER2 1 28 27
021F (00543) |   |   |   |   |   BLR$K_ASSIGNMENT
0220 (00544) |   |   |   |   |   | BLR$K_LITERAL
0221 (00545) |   |   |   |   |   |   DSC$K_DTYPE_L 0  "0"
0227 (00551) |   |   |   |   |   | BLR$K_PARAMETER 1 0
022B (00555) |   |   |   |   | BLR$K_END
022C (00556) |   |   |   |   | BLR$K_BEGIN
022D (00557) |   |   |   |   |   BLR$K_ASSIGNMENT
022E (00558) |   |   |   |   |   | BLR$K_LITERAL
022F (00559) |   |   |   |   |   |   DSC$K_DTYPE_L 0  "-811"
0235 (00565) |   |   |   |   |   | BLR$K_PARAMETER 1 0
0239 (00569) |   |   |   |   | BLR$K_END
023A (00570) |   |   |   | BLR$K_END
023B (00571) |   |   | BLR$K_END
023C (00572) |   | BLR$K_END
023D (00573) | BLR$K_END
023E (00574) BLR$K_EOC
0000 (00000) BLR$K_VERSION4
0001 (00001) | BLR$K_BEGIN
0002 (00002) |   BLR$K_MESSAGE 1 12
0006 (00006) |   | DSC$K_DTYPE_L 0
0008 (00008) |   | DSC$K_DTYPE_L 0
000A (00010) |   | DSC$K_DTYPE_L 0
000C (00012) |   | DSC$K_DTYPE_L 0
000E (00014) |   | DSC$K_DTYPE_L 0
0010 (00016) |   | DSC$K_DTYPE_CHAR 12 (sub-type: 0)
0015 (00021) |   | DSC$K_DTYPE_L 0
0017 (00023) |   | DSC$K_DTYPE_L 0
0019 (00025) |   | DSC$K_DTYPE_CHAR 2 (sub-type: 0)
001E (00030) |   | DSC$K_DTYPE_L 0
0020 (00032) |   | DSC$K_DTYPE_L 0
0022 (00034) |   | DSC$K_DTYPE_CHAR 50 (sub-type: 0)
0027 (00039) |   BLR$K_FOR
0028 (00040) |   | BLR$K_RSE  1
002A (00042) |   |   BLR$K_RELATION SALES_KEYBOARD 1
003B (00059) |   | BLR$K_END
003C (00060) |   | BLR$K_BEGIN
003D (00061) |   |   BLR$K_SEND  1
003F (00063) |   |   | BLR$K_HANDLER
0040 (00064) |   |   |   BLR$K_BEGIN
0041 (00065) |   |   |   | BLR$K_ASSIGNMENT
0042 (00066) |   |   |   |   BLR$K_FIELD 1 KEY_CODE
004D (00077) |   |   |   |   BLR$K_PARAMETER2 1 2 1
0053 (00083) |   |   |   | BLR$K_ASSIGNMENT
0054 (00084) |   |   |   |   BLR$K_FIELD 1 KEY_FUNCTION_CLASS
006B (00107) |   |   |   |   BLR$K_PARAMETER3 1 5 3 4
0071 (00113) |   |   |   | BLR$K_ASSIGNMENT
0072 (00114) |   |   |   |   BLR$K_CAST
0073 (00115) |   |   |   |   | BLR$K_DESCRIPTOR
0074 (00116) |   |   |   |   |   DSC$K_DTYPE_CHAR 2 (sub-type: 0)
0079 (00121) |   |   |   |   | BLR$K_FIELD 1 KEY_FUNCTION_VALUE
0090 (00144) |   |   |   |   BLR$K_PARAMETER3 1 8 6 7
0096 (00150) |   |   |   | BLR$K_ASSIGNMENT
0097 (00151) |   |   |   |   BLR$K_CAST
0098 (00152) |   |   |   |   | BLR$K_DESCRIPTOR
0099 (00153) |   |   |   |   |   DSC$K_DTYPE_CHAR 50 (sub-type: 0)
009E (00158) |   |   |   |   | BLR$K_FIELD 1 KEY_DESCRIPTION
00B2 (00178) |   |   |   |   BLR$K_PARAMETER3 1 11 9 10
00B8 (00184) |   |   |   | BLR$K_ASSIGNMENT
00B9 (00185) |   |   |   |   BLR$K_LITERAL
00BA (00186) |   |   |   |   | DSC$K_DTYPE_L 0  "0"
00C0 (00192) |   |   |   |   BLR$K_PARAMETER 1 0
00C4 (00196) |   |   |   BLR$K_END
00C5 (00197) |   | BLR$K_END
00C6 (00198) |   BLR$K_SEND  1
00C8 (00200) |   | BLR$K_HANDLER
00C9 (00201) |   |   BLR$K_BEGIN
00CA (00202) |   |   | BLR$K_ASSIGNMENT
00CB (00203) |   |   |   BLR$K_LITERAL
00CC (00204) |   |   |   | DSC$K_DTYPE_L 0  "100"
00D2 (00210) |   |   |   BLR$K_PARAMETER 1 0
00D6 (00214) |   |   BLR$K_END
00D7 (00215) | BLR$K_END
00D8 (00216) BLR$K_EOC
0000 (00000) BLR$K_VERSION4
0001 (00001) | BLR$K_BEGIN
0002 (00002) |   BLR$K_MESSAGE 1 24
0006 (00006) |   | DSC$K_DTYPE_L 0
0008 (00008) |   | DSC$K_DTYPE_L 0
000A (00010) |   | DSC$K_DTYPE_L 0
000C (00012) |   | DSC$K_DTYPE_CHAR 22 (sub-type: 0)
0011 (00017) |   | DSC$K_DTYPE_L 0
0013 (00019) |   | DSC$K_DTYPE_L 0
0015 (00021) |   | DSC$K_DTYPE_CHAR 22 (sub-type: 0)
001A (00026) |   | DSC$K_DTYPE_L 0
001C (00028) |   | DSC$K_DTYPE_L 0
001E (00030) |   | DSC$K_DTYPE_VCHAR 50 (sub-type: 0)
0023 (00035) |   | DSC$K_DTYPE_L 0
0025 (00037) |   | DSC$K_DTYPE_L 0
0027 (00039) |   | DSC$K_DTYPE_L 0
0029 (00041) |   | DSC$K_DTYPE_L 0
002B (00043) |   | DSC$K_DTYPE_CHAR 22 (sub-type: 0)
0030 (00048) |   | DSC$K_DTYPE_L 0
0032 (00050) |   | DSC$K_DTYPE_L 0
0034 (00052) |   | DSC$K_DTYPE_CHAR 12 (sub-type: 0)
0039 (00057) |   | DSC$K_DTYPE_L 0
003B (00059) |   | DSC$K_DTYPE_L 0
003D (00061) |   | DSC$K_DTYPE_VCHAR 50 (sub-type: 0)
0042 (00066) |   | DSC$K_DTYPE_L 0
0044 (00068) |   | DSC$K_DTYPE_L 0
0046 (00070) |   | DSC$K_DTYPE_CHAR 1 (sub-type: 0)
004B (00075) |   BLR$K_MESSAGE 2 0
004F (00079) |   BLR$K_MESSAGE 3 12
0053 (00083) |   | DSC$K_DTYPE_CHAR 22 (sub-type: 0)
0058 (00088) |   | DSC$K_DTYPE_CHAR 22 (sub-type: 0)
005D (00093) |   | DSC$K_DTYPE_CHAR 50 (sub-type: 0)
0062 (00098) |   | DSC$K_DTYPE_L 0
0064 (00100) |   | DSC$K_DTYPE_CHAR 22 (sub-type: 0)
0069 (00105) |   | DSC$K_DTYPE_CHAR 12 (sub-type: 0)
006E (00110) |   | DSC$K_DTYPE_CHAR 50 (sub-type: 0)
0073 (00115) |   | DSC$K_DTYPE_CHAR 1 (sub-type: 0)
0078 (00120) |   | DSC$K_DTYPE_L 0
007A (00122) |   | DSC$K_DTYPE_L 0
007C (00124) |   | DSC$K_DTYPE_CHAR 10 (sub-type: 0)
0081 (00129) |   | DSC$K_DTYPE_CHAR 10 (sub-type: 0)
0086 (00134) |   BLR$K_RECEIVE  3
0088 (00136) |   | BLR$K_BEGIN
0089 (00137) |   |   BLR$K_SEND  1
008B (00139) |   |   | BLR$K_BEGIN
008C (00140) |   |   |   BLR$K_ASSIGNMENT
008D (00141) |   |   |   | BLR$K_LITERAL
008E (00142) |   |   |   |   DSC$K_DTYPE_L 0  "100"
0094 (00148) |   |   |   | BLR$K_PARAMETER 1 0
0098 (00152) |   |   |   BLR$K_FOR
0099 (00153) |   |   |   | BLR$K_RSE  1
009B (00155) |   |   |   |   BLR$K_RELATION TERMINAL_SALES_DATE 1
00B1 (00177) |   |   |   |   BLR$K_FIRST
00B2 (00178) |   |   |   |   | BLR$K_LITERAL
00B3 (00179) |   |   |   |   |   DSC$K_DTYPE_W 0  "2"
00B7 (00183) |   |   |   |   BLR$K_BOOLEAN
00B8 (00184) |   |   |   |   | BLR$K_AND
00B9 (00185) |   |   |   |   |   BLR$K_EQL
00BA (00186) |   |   |   |   |   | BLR$K_FIELD 1 TERMINAL_ID
00C8 (00200) |   |   |   |   |   | BLR$K_PARAMETER 3 9
00CC (00204) |   |   |   |   |   BLR$K_EQL
00CD (00205) |   |   |   |   |   | BLR$K_FIELD 1 SALES_DATE
00DA (00218) |   |   |   |   |   | BLR$K_CAST
00DB (00219) |   |   |   |   |   |   BLR$K_DESCRIPTOR
00DC (00220) |   |   |   |   |   |   | DSC$K_DTYPE_DATETIME (s: 7, p: 0,
f: 0)
                                       Date
00E1 (00225) |   |   |   |   |   |   BLR$K_PARAMETER 3 11
00E5 (00229) |   |   |   | BLR$K_END
00E6 (00230) |   |   |   | BLR$K_BEGIN
00E7 (00231) |   |   |   |   BLR$K_IF
00E8 (00232) |   |   |   |   | BLR$K_EQL
00E9 (00233) |   |   |   |   |   BLR$K_LITERAL
00EA (00234) |   |   |   |   |   | DSC$K_DTYPE_L 0  "100"
00F0 (00240) |   |   |   |   |   BLR$K_PARAMETER 1 0
00F4 (00244) |   |   |   |   | BLR$K_BEGIN
00F5 (00245) |   |   |   |   |   BLR$K_ASSIGNMENT
00F6 (00246) |   |   |   |   |   | BLR$K_CAST
00F7 (00247) |   |   |   |   |   |   BLR$K_DESCRIPTOR
00F8 (00248) |   |   |   |   |   |   | DSC$K_DTYPE_CHAR 22 (sub-type: 0)
00FD (00253) |   |   |   |   |   |   BLR$K_FIELD 1
SALES_DATE_START_DATE_TIME
011C (00284) |   |   |   |   |   | BLR$K_PARAMETER3 1 3 1 2
0122 (00290) |   |   |   |   |   BLR$K_ASSIGNMENT
0123 (00291) |   |   |   |   |   | BLR$K_CAST
0124 (00292) |   |   |   |   |   |   BLR$K_DESCRIPTOR
0125 (00293) |   |   |   |   |   |   | DSC$K_DTYPE_CHAR 22 (sub-type: 0)
012A (00298) |   |   |   |   |   |   BLR$K_FIELD 1
SALES_DATE_END_DATE_TIME
0147 (00327) |   |   |   |   |   | BLR$K_PARAMETER3 1 6 4 5
014D (00333) |   |   |   |   |   BLR$K_ASSIGNMENT
014E (00334) |   |   |   |   |   | BLR$K_FIELD 1 AGENT_DESCRIPTION
0164 (00356) |   |   |   |   |   | BLR$K_PARAMETER3 1 9 7 8
016A (00362) |   |   |   |   |   BLR$K_ASSIGNMENT
016B (00363) |   |   |   |   |   | BLR$K_FIELD 1 AGENT_SESSION_ID
017E (00382) |   |   |   |   |   | BLR$K_PARAMETER2 1 11 10
0184 (00388) |   |   |   |   |   BLR$K_ASSIGNMENT
0185 (00389) |   |   |   |   |   | BLR$K_CAST
0186 (00390) |   |   |   |   |   |   BLR$K_DESCRIPTOR
0187 (00391) |   |   |   |   |   |   | DSC$K_DTYPE_CHAR 22 (sub-type: 0)
018C (00396) |   |   |   |   |   |   BLR$K_FIELD 1
AGENT_DECLARE_DATE_TIME
01A8 (00424) |   |   |   |   |   | BLR$K_PARAMETER3 1 14 12 13
01AE (00430) |   |   |   |   |   BLR$K_ASSIGNMENT
01AF (00431) |   |   |   |   |   | BLR$K_FIELD 1 BAG_NUMBER
01BE (00446) |   |   |   |   |   | BLR$K_PARAMETER3 1 17 15 16
01C4 (00452) |   |   |   |   |   BLR$K_ASSIGNMENT
01C5 (00453) |   |   |   |   |   | BLR$K_FIELD 1 REMARKS
01D1 (00465) |   |   |   |   |   | BLR$K_PARAMETER3 1 20 18 19
01D7 (00471) |   |   |   |   |   BLR$K_ASSIGNMENT
01D8 (00472) |   |   |   |   |   | BLR$K_FIELD 1 CLOSE_FLAG
01E7 (00487) |   |   |   |   |   | BLR$K_PARAMETER3 1 23 21 22
01ED (00493) |   |   |   |   |   BLR$K_ASSIGNMENT
01EE (00494) |   |   |   |   |   | BLR$K_LITERAL
01EF (00495) |   |   |   |   |   |   DSC$K_DTYPE_L 0  "0"
01F5 (00501) |   |   |   |   |   | BLR$K_PARAMETER 1 0
01F9 (00505) |   |   |   |   | BLR$K_END
01FA (00506) |   |   |   |   | BLR$K_BEGIN
01FB (00507) |   |   |   |   |   BLR$K_ASSIGNMENT
01FC (00508) |   |   |   |   |   | BLR$K_LITERAL
01FD (00509) |   |   |   |   |   |   DSC$K_DTYPE_L 0  "-811"
0203 (00515) |   |   |   |   |   | BLR$K_PARAMETER 1 0
0207 (00519) |   |   |   |   | BLR$K_END
0208 (00520) |   |   |   | BLR$K_END
0209 (00521) |   |   | BLR$K_END
020A (00522) |   | BLR$K_END
020B (00523) | BLR$K_END
020C (00524) BLR$K_EOC
0000 (00000) BLR$K_VERSION4
0001 (00001) | BLR$K_BEGIN
0002 (00002) |   BLR$K_MESSAGE 1 3
0006 (00006) |   | DSC$K_DTYPE_L 0
0008 (00008) |   | DSC$K_DTYPE_L 0
000A (00010) |   | DSC$K_DTYPE_L 0
000C (00012) |   BLR$K_MESSAGE 2 0
0010 (00016) |   BLR$K_MESSAGE 3 5
0014 (00020) |   | DSC$K_DTYPE_L 0
0016 (00022) |   | DSC$K_DTYPE_CHAR 4 (sub-type: 0)
001B (00027) |   | DSC$K_DTYPE_CHAR 4 (sub-type: 0)
0020 (00032) |   | DSC$K_DTYPE_CHAR 10 (sub-type: 0)
0025 (00037) |   | DSC$K_DTYPE_CHAR 10 (sub-type: 0)
002A (00042) |   BLR$K_RECEIVE  3
002C (00044) |   | BLR$K_BEGIN
002D (00045) |   |   BLR$K_SEND  1
002F (00047) |   |   | BLR$K_BEGIN
0030 (00048) |   |   |   BLR$K_ASSIGNMENT
0031 (00049) |   |   |   | BLR$K_LITERAL
0032 (00050) |   |   |   |   DSC$K_DTYPE_L 0  "100"
0038 (00056) |   |   |   | BLR$K_PARAMETER 1 0
003C (00060) |   |   |   BLR$K_FOR
003D (00061) |   |   |   | BLR$K_RSE  1
003F (00063) |   |   |   |   BLR$K_RELATION SHIFT 1
0047 (00071) |   |   |   |   BLR$K_FIRST
0048 (00072) |   |   |   |   | BLR$K_LITERAL
0049 (00073) |   |   |   |   |   DSC$K_DTYPE_W 0  "1"
004D (00077) |   |   |   |   BLR$K_BOOLEAN
004E (00078) |   |   |   |   | BLR$K_AND
004F (00079) |   |   |   |   |   BLR$K_AND
0050 (00080) |   |   |   |   |   | BLR$K_EQL
0051 (00081) |   |   |   |   |   |   BLR$K_FIELD 1 STATION_ID
005E (00094) |   |   |   |   |   |   BLR$K_PARAMETER 3 2
0062 (00098) |   |   |   |   |   | BLR$K_MISSING
0063 (00099) |   |   |   |   |   |   BLR$K_FIELD 1
FINAL_DECLARE_DATE_TIME
007D (00125) |   |   |   |   |   BLR$K_EQL
007E (00126) |   |   |   |   |   | BLR$K_FIELD 1 SALES_DATE
008B (00139) |   |   |   |   |   | BLR$K_CAST
008C (00140) |   |   |   |   |   |   BLR$K_DESCRIPTOR
008D (00141) |   |   |   |   |   |   | DSC$K_DTYPE_DATETIME (s: 7, p: 0,
f: 0)
                                       Date
0092 (00146) |   |   |   |   |   |   BLR$K_PARAMETER 3 4
0096 (00150) |   |   |   | BLR$K_END
0097 (00151) |   |   |   | BLR$K_BEGIN
0098 (00152) |   |   |   |   BLR$K_IF
0099 (00153) |   |   |   |   | BLR$K_EQL
009A (00154) |   |   |   |   |   BLR$K_LITERAL
009B (00155) |   |   |   |   |   | DSC$K_DTYPE_L 0  "100"
00A1 (00161) |   |   |   |   |   BLR$K_PARAMETER 1 0
00A5 (00165) |   |   |   |   | BLR$K_BEGIN
00A6 (00166) |   |   |   |   |   BLR$K_ASSIGNMENT
00A7 (00167) |   |   |   |   |   | BLR$K_FIELD 1 SHIFT_ID
00B2 (00178) |   |   |   |   |   | BLR$K_PARAMETER2 1 2 1
00B8 (00184) |   |   |   |   |   BLR$K_ASSIGNMENT
00B9 (00185) |   |   |   |   |   | BLR$K_LITERAL
00BA (00186) |   |   |   |   |   |   DSC$K_DTYPE_L 0  "0"
00C0 (00192) |   |   |   |   |   | BLR$K_PARAMETER 1 0
00C4 (00196) |   |   |   |   | BLR$K_END
00C5 (00197) |   |   |   |   | BLR$K_BEGIN
00C6 (00198) |   |   |   |   |   BLR$K_ASSIGNMENT
00C7 (00199) |   |   |   |   |   | BLR$K_LITERAL
00C8 (00200) |   |   |   |   |   |   DSC$K_DTYPE_L 0  "-811"
00CE (00206) |   |   |   |   |   | BLR$K_PARAMETER 1 0
00D2 (00210) |   |   |   |   | BLR$K_END
00D3 (00211) |   |   |   | BLR$K_END
00D4 (00212) |   |   | BLR$K_END
00D5 (00213) |   | BLR$K_END
00D6 (00214) | BLR$K_END
00D7 (00215) BLR$K_EOC
0000 (00000) BLR$K_VERSION4
0001 (00001) | BLR$K_BEGIN
0002 (00002) |   BLR$K_MESSAGE 1 3
0006 (00006) |   | DSC$K_DTYPE_L 0
0008 (00008) |   | DSC$K_DTYPE_L 0
000A (00010) |   | DSC$K_DTYPE_Q -2
000C (00012) |   BLR$K_MESSAGE 2 0
0010 (00016) |   BLR$K_MESSAGE 3 1
0014 (00020) |   | DSC$K_DTYPE_L 0
0016 (00022) |   BLR$K_RECEIVE  3
0018 (00024) |   | BLR$K_BEGIN
0019 (00025) |   |   BLR$K_SEND  1
001B (00027) |   |   | BLR$K_BEGIN
001C (00028) |   |   |   BLR$K_ASSIGNMENT
001D (00029) |   |   |   | BLR$K_LITERAL
001E (00030) |   |   |   |   DSC$K_DTYPE_L 0  "100"
0024 (00036) |   |   |   | BLR$K_PARAMETER 1 0
0028 (00040) |   |   |   BLR$K_FOR
0029 (00041) |   |   |   | BLR$K_RSE  1
002B (00043) |   |   |   |   BLR$K_RELATION CASH_ON_HAND 1
003A (00058) |   |   |   |   BLR$K_FIRST
003B (00059) |   |   |   |   | BLR$K_LITERAL
003C (00060) |   |   |   |   |   DSC$K_DTYPE_W 0  "2"
0040 (00064) |   |   |   |   BLR$K_BOOLEAN
0041 (00065) |   |   |   |   | BLR$K_EQL
0042 (00066) |   |   |   |   |   BLR$K_FIELD 1 SHIFT_ID
004D (00077) |   |   |   |   |   BLR$K_PARAMETER 3 0
0051 (00081) |   |   |   | BLR$K_END
0052 (00082) |   |   |   | BLR$K_BEGIN
0053 (00083) |   |   |   |   BLR$K_IF
0054 (00084) |   |   |   |   | BLR$K_EQL
0055 (00085) |   |   |   |   |   BLR$K_LITERAL
0056 (00086) |   |   |   |   |   | DSC$K_DTYPE_L 0  "100"
005C (00092) |   |   |   |   |   BLR$K_PARAMETER 1 0
0060 (00096) |   |   |   |   | BLR$K_BEGIN
0061 (00097) |   |   |   |   |   BLR$K_ASSIGNMENT
0062 (00098) |   |   |   |   |   | BLR$K_FIELD 1 PAYMENT_SUM
0070 (00112) |   |   |   |   |   | BLR$K_PARAMETER2 1 2 1
0076 (00118) |   |   |   |   |   BLR$K_ASSIGNMENT
0077 (00119) |   |   |   |   |   | BLR$K_LITERAL
0078 (00120) |   |   |   |   |   |   DSC$K_DTYPE_L 0  "0"
007E (00126) |   |   |   |   |   | BLR$K_PARAMETER 1 0
0082 (00130) |   |   |   |   | BLR$K_END
0083 (00131) |   |   |   |   | BLR$K_BEGIN
0084 (00132) |   |   |   |   |   BLR$K_ASSIGNMENT
0085 (00133) |   |   |   |   |   | BLR$K_LITERAL
0086 (00134) |   |   |   |   |   |   DSC$K_DTYPE_L 0  "-811"
008C (00140) |   |   |   |   |   | BLR$K_PARAMETER 1 0
0090 (00144) |   |   |   |   | BLR$K_END
0091 (00145) |   |   |   | BLR$K_END
0092 (00146) |   |   | BLR$K_END
0093 (00147) |   | BLR$K_END
0094 (00148) | BLR$K_END
0095 (00149) BLR$K_EOC
0000 (00000) BLR$K_VERSION4
0001 (00001) | BLR$K_BEGIN
0002 (00002) |   BLR$K_MESSAGE 1 3
0006 (00006) |   | DSC$K_DTYPE_L 0
0008 (00008) |   | DSC$K_DTYPE_L 0
000A (00010) |   | DSC$K_DTYPE_Q -2
000C (00012) |   BLR$K_MESSAGE 2 0
0010 (00016) |   BLR$K_MESSAGE 3 3
0014 (00020) |   | DSC$K_DTYPE_F
0015 (00021) |   | DSC$K_DTYPE_L 0
0017 (00023) |   | DSC$K_DTYPE_L 0
0019 (00025) |   BLR$K_RECEIVE  3
001B (00027) |   | BLR$K_BEGIN
001C (00028) |   |   BLR$K_SEND  1
001E (00030) |   |   | BLR$K_BEGIN
001F (00031) |   |   |   BLR$K_ASSIGNMENT
0020 (00032) |   |   |   | BLR$K_LITERAL
0021 (00033) |   |   |   |   DSC$K_DTYPE_L 0  "100"
0027 (00039) |   |   |   | BLR$K_PARAMETER 1 0
002B (00043) |   |   |   BLR$K_FOR
002C (00044) |   |   |   | BLR$K_RSE  1
002E (00046) |   |   |   |   BLR$K_AGGREGATE 1
0030 (00048) |   |   |   |   | BLR$K_RSE  1
0032 (00050) |   |   |   |   |   BLR$K_RELATION CASH_PICKUP 2
0040 (00064) |   |   |   |   |   BLR$K_BOOLEAN
0041 (00065) |   |   |   |   |   | BLR$K_EQL
0042 (00066) |   |   |   |   |   |   BLR$K_FIELD 2 SHIFT_ID
004D (00077) |   |   |   |   |   |   BLR$K_PARAMETER 3 2
0051 (00081) |   |   |   |   | BLR$K_END
0052 (00082) |   |   |   |   | BLR$K_MAP  1
0054 (00084) |   |   |   |   |   0
0056 (00086) |   |   |   |   |   BLR$K_AGG_TOTAL
0057 (00087) |   |   |   |   |   | BLR$K_CONTROL_BITS  1
0059 (00089) |   |   |   |   |   | BLR$K_FIELD 2 CASH_PICKUP_AMOUNT
006E (00110) |   |   |   |   |   BLR$K_END
006F (00111) |   |   |   |   BLR$K_FIRST
0070 (00112) |   |   |   |   | BLR$K_LITERAL
0071 (00113) |   |   |   |   |   DSC$K_DTYPE_W 0  "2"
0075 (00117) |   |   |   | BLR$K_END
0076 (00118) |   |   |   | BLR$K_BEGIN
0077 (00119) |   |   |   |   BLR$K_IF
0078 (00120) |   |   |   |   | BLR$K_EQL
0079 (00121) |   |   |   |   |   BLR$K_LITERAL
007A (00122) |   |   |   |   |   | DSC$K_DTYPE_L 0  "100"
0080 (00128) |   |   |   |   |   BLR$K_PARAMETER 1 0
0084 (00132) |   |   |   |   | BLR$K_BEGIN
0085 (00133) |   |   |   |   |   BLR$K_ASSIGNMENT
0086 (00134) |   |   |   |   |   | BLR$K_FIELD_ID 1 0
008A (00138) |   |   |   |   |   | BLR$K_PARAMETER2 1 2 1
0090 (00144) |   |   |   |   |   BLR$K_ASSIGNMENT
0091 (00145) |   |   |   |   |   | BLR$K_LITERAL
0092 (00146) |   |   |   |   |   |   DSC$K_DTYPE_L 0  "0"
0098 (00152) |   |   |   |   |   | BLR$K_PARAMETER 1 0
009C (00156) |   |   |   |   | BLR$K_END
009D (00157) |   |   |   |   | BLR$K_BEGIN
009E (00158) |   |   |   |   |   BLR$K_ASSIGNMENT
009F (00159) |   |   |   |   |   | BLR$K_LITERAL
00A0 (00160) |   |   |   |   |   |   DSC$K_DTYPE_L 0  "-811"
00A6 (00166) |   |   |   |   |   | BLR$K_PARAMETER 1 0
00AA (00170) |   |   |   |   | BLR$K_END
00AB (00171) |   |   |   | BLR$K_END
00AC (00172) |   |   | BLR$K_END
00AD (00173) |   | BLR$K_END
00AE (00174) | BLR$K_END
00AF (00175) BLR$K_EOC
0000 (00000) BLR$K_VERSION4
0001 (00001) | BLR$K_BEGIN
0002 (00002) |   BLR$K_MESSAGE 1 16
0006 (00006) |   | DSC$K_DTYPE_L 0
0008 (00008) |   | DSC$K_DTYPE_L 0
000A (00010) |   | DSC$K_DTYPE_L 0
000C (00012) |   | DSC$K_DTYPE_VCHAR 50 (sub-type: 0)
0011 (00017) |   | DSC$K_DTYPE_L 0
0013 (00019) |   | DSC$K_DTYPE_L 0
0015 (00021) |   | DSC$K_DTYPE_L 0
0017 (00023) |   | DSC$K_DTYPE_L 0
0019 (00025) |   | DSC$K_DTYPE_L 0
001B (00027) |   | DSC$K_DTYPE_L 0
001D (00029) |   | DSC$K_DTYPE_L 0
001F (00031) |   | DSC$K_DTYPE_L 0
0021 (00033) |   | DSC$K_DTYPE_CHAR 5 (sub-type: 0)
0026 (00038) |   | DSC$K_DTYPE_L 0
0028 (00040) |   | DSC$K_DTYPE_L 0
002A (00042) |   | DSC$K_DTYPE_CHAR 5 (sub-type: 0)
002F (00047) |   BLR$K_MESSAGE 2 2
0033 (00051) |   | DSC$K_DTYPE_L 0
0035 (00053) |   | DSC$K_DTYPE_CHAR 10 (sub-type: 0)
003A (00058) |   BLR$K_RECEIVE  2
003C (00060) |   | BLR$K_BEGIN
003D (00061) |   |   BLR$K_FOR
003E (00062) |   |   | BLR$K_RSE  5
0040 (00064) |   |   |   BLR$K_RELATION ROUTE 1
0048 (00072) |   |   |   BLR$K_RELATION TERMINAL_ROUTE 2
0059 (00089) |   |   |   BLR$K_RELATION SAILING_SCHEDULE 3
006C (00108) |   |   |   BLR$K_RELATION SALES_DATE 4
0079 (00121) |   |   |   BLR$K_RELATION SCHEDULE_DAY_TYPE 5
008D (00141) |   |   |   BLR$K_BOOLEAN
008E (00142) |   |   |   | BLR$K_AND
008F (00143) |   |   |   |   BLR$K_AND
0090 (00144) |   |   |   |   | BLR$K_AND
0091 (00145) |   |   |   |   |   BLR$K_AND
0092 (00146) |   |   |   |   |   | BLR$K_AND
0093 (00147) |   |   |   |   |   |   BLR$K_EQL
0094 (00148) |   |   |   |   |   |   | BLR$K_FIELD 2
LOCATION_TERMINAL_ID
00AB (00171) |   |   |   |   |   |   | BLR$K_PARAMETER 2 0
00AF (00175) |   |   |   |   |   |   BLR$K_EQL
00B0 (00176) |   |   |   |   |   |   | BLR$K_FIELD 1 ROUTE_ID
00BB (00187) |   |   |   |   |   |   | BLR$K_FIELD 2 ROUTE_ID
00C6 (00198) |   |   |   |   |   | BLR$K_AND
00C7 (00199) |   |   |   |   |   |   BLR$K_EQL
00C8 (00200) |   |   |   |   |   |   | BLR$K_FIELD 2
LOCATION_TERMINAL_ID
00DF (00223) |   |   |   |   |   |   | BLR$K_FIELD 3
LOCATION_TERMINAL_ID
00F6 (00246) |   |   |   |   |   |   BLR$K_EQL
00F7 (00247) |   |   |   |   |   |   | BLR$K_FIELD 2 ROUTE_ID
0102 (00258) |   |   |   |   |   |   | BLR$K_FIELD 3 ROUTE_ID
010D (00269) |   |   |   |   |   BLR$K_EQL
010E (00270) |   |   |   |   |   | BLR$K_FIELD 4 SALES_DATE
011B (00283) |   |   |   |   |   | BLR$K_CAST
011C (00284) |   |   |   |   |   |   BLR$K_DESCRIPTOR
011D (00285) |   |   |   |   |   |   | DSC$K_DTYPE_DATETIME (s: 7, p: 0,
f: 0)
                                       Date
0122 (00290) |   |   |   |   |   |   BLR$K_PARAMETER 2 1
0126 (00294) |   |   |   |   | BLR$K_EQL
0127 (00295) |   |   |   |   |   BLR$K_FIELD 4 SCHEDULE_DAY_TYPE_ID
013E (00318) |   |   |   |   |   BLR$K_FIELD 5 SCHEDULE_DAY_TYPE_ID
0155 (00341) |   |   |   |   BLR$K_EQL
0156 (00342) |   |   |   |   | BLR$K_FIELD 5 SCHEDULE_DAY_TYPE_ID
016D (00365) |   |   |   |   | BLR$K_FIELD 3 SCHEDULE_DAY_TYPE_ID
0184 (00388) |   |   |   BLR$K_SORT  3
0186 (00390) |   |   |   BLR$K_ASCENDING
0187 (00391) |   |   |   | BLR$K_FIELD 1 ROUTE_ID
0192 (00402) |   |   |   BLR$K_ASCENDING
0193 (00403) |   |   |   | BLR$K_FIELD 3 EARLY_OR_LATE_ID
01A6 (00422) |   |   |   BLR$K_ASCENDING
01A7 (00423) |   |   |   | BLR$K_FIELD 3 SCHEDULED_DEPARTURE_TIME
01C2 (00450) |   |   | BLR$K_END
01C3 (00451) |   |   | BLR$K_BEGIN
01C4 (00452) |   |   |   BLR$K_SEND  1
01C6 (00454) |   |   |   | BLR$K_HANDLER
01C7 (00455) |   |   |   |   BLR$K_BEGIN
01C8 (00456) |   |   |   |   | BLR$K_ASSIGNMENT
01C9 (00457) |   |   |   |   |   BLR$K_FIELD 2 TERMINAL_ROUTE
01DC (00476) |   |   |   |   |   BLR$K_PARAMETER3 1 3 1 2
01E2 (00482) |   |   |   |   | BLR$K_ASSIGNMENT
01E3 (00483) |   |   |   |   |   BLR$K_FIELD 1 ROUTE_ID
01EE (00494) |   |   |   |   |   BLR$K_PARAMETER2 1 5 4
01F4 (00500) |   |   |   |   | BLR$K_ASSIGNMENT
01F5 (00501) |   |   |   |   |   BLR$K_FIELD 2 KEY_FUNCTION_VALUE
020A (00522) |   |   |   |   |   BLR$K_PARAMETER2 1 7 6
0210 (00528) |   |   |   |   | BLR$K_ASSIGNMENT
0211 (00529) |   |   |   |   |   BLR$K_FIELD 3 EARLY_OR_LATE_ID
0224 (00548) |   |   |   |   |   BLR$K_PARAMETER2 1 9 8
022A (00554) |   |   |   |   | BLR$K_ASSIGNMENT
022B (00555) |   |   |   |   |   BLR$K_CAST
022C (00556) |   |   |   |   |   | BLR$K_DESCRIPTOR
022D (00557) |   |   |   |   |   |   DSC$K_DTYPE_CHAR 5 (sub-type: 0)
0232 (00562) |   |   |   |   |   | BLR$K_FIELD 3
SCHEDULED_DEPARTURE_TIME
024F (00591) |   |   |   |   |   BLR$K_PARAMETER3 1 12 10 11
0255 (00597) |   |   |   |   | BLR$K_ASSIGNMENT
0256 (00598) |   |   |   |   |   BLR$K_CAST
0257 (00599) |   |   |   |   |   | BLR$K_DESCRIPTOR
0258 (00600) |   |   |   |   |   |   DSC$K_DTYPE_CHAR 5 (sub-type: 0)
025D (00605) |   |   |   |   |   | BLR$K_FIELD 3 SCHEDULED_ARRIVAL_TIME
0278 (00632) |   |   |   |   |   BLR$K_PARAMETER3 1 15 13 14
027E (00638) |   |   |   |   | BLR$K_ASSIGNMENT
027F (00639) |   |   |   |   |   BLR$K_LITERAL
0280 (00640) |   |   |   |   |   | DSC$K_DTYPE_L 0  "0"
0286 (00646) |   |   |   |   |   BLR$K_PARAMETER 1 0
028A (00650) |   |   |   |   BLR$K_END
028B (00651) |   |   | BLR$K_END
028C (00652) |   | BLR$K_END
028D (00653) |   BLR$K_SEND  1
028F (00655) |   | BLR$K_HANDLER
0290 (00656) |   |   BLR$K_BEGIN
0291 (00657) |   |   | BLR$K_ASSIGNMENT
0292 (00658) |   |   |   BLR$K_LITERAL
0293 (00659) |   |   |   | DSC$K_DTYPE_L 0  "100"
0299 (00665) |   |   |   BLR$K_PARAMETER 1 0
029D (00669) |   |   BLR$K_END
029E (00670) | BLR$K_END
029F (00671) BLR$K_EOC
0000 (00000) BLR$K_VERSION4
0001 (00001) | BLR$K_BEGIN
0002 (00002) |   BLR$K_MESSAGE 1 26
0006 (00006) |   | DSC$K_DTYPE_L 0
0008 (00008) |   | DSC$K_DTYPE_L 0
000A (00010) |   | DSC$K_DTYPE_L 0
000C (00012) |   | DSC$K_DTYPE_L 0
000E (00014) |   | DSC$K_DTYPE_L 0
0010 (00016) |   | DSC$K_DTYPE_L 0
0012 (00018) |   | DSC$K_DTYPE_L 0
0014 (00020) |   | DSC$K_DTYPE_L 0
0016 (00022) |   | DSC$K_DTYPE_L 0
0018 (00024) |   | DSC$K_DTYPE_L 0
001A (00026) |   | DSC$K_DTYPE_L 0
001C (00028) |   | DSC$K_DTYPE_VCHAR 50 (sub-type: 0)
0021 (00033) |   | DSC$K_DTYPE_L 0
0023 (00035) |   | DSC$K_DTYPE_F
0024 (00036) |   | DSC$K_DTYPE_L 0
0026 (00038) |   | DSC$K_DTYPE_L 0
0028 (00040) |   | DSC$K_DTYPE_CHAR 1 (sub-type: 0)
002D (00045) |   | DSC$K_DTYPE_L 0
002F (00047) |   | DSC$K_DTYPE_L 0
0031 (00049) |   | DSC$K_DTYPE_CHAR 1 (sub-type: 0)
0036 (00054) |   | DSC$K_DTYPE_L 0
0038 (00056) |   | DSC$K_DTYPE_L 0
003A (00058) |   | DSC$K_DTYPE_CHAR 1 (sub-type: 0)
003F (00063) |   | DSC$K_DTYPE_L 0
0041 (00065) |   | DSC$K_DTYPE_L 0
0043 (00067) |   | DSC$K_DTYPE_CHAR 1 (sub-type: 0)
0048 (00072) |   BLR$K_MESSAGE 2 1
004C (00076) |   | DSC$K_DTYPE_L 0
004E (00078) |   BLR$K_RECEIVE  2
0050 (00080) |   | BLR$K_BEGIN
0051 (00081) |   |   BLR$K_FOR
0052 (00082) |   |   | BLR$K_RSE  3
0054 (00084) |   |   |   BLR$K_RELATION FARE_TYPE 1
0060 (00096) |   |   |   BLR$K_RELATION TERMINAL_ROUTE_FARE 2
0076 (00118) |   |   |   BLR$K_RELATION TERMINAL_ROUTE 3
0087 (00135) |   |   |   BLR$K_BOOLEAN
0088 (00136) |   |   |   | BLR$K_AND
0089 (00137) |   |   |   |   BLR$K_AND
008A (00138) |   |   |   |   | BLR$K_AND
008B (00139) |   |   |   |   |   BLR$K_EQL
008C (00140) |   |   |   |   |   | BLR$K_FIELD 2 LOCATION_TERMINAL_ID
00A3 (00163) |   |   |   |   |   | BLR$K_PARAMETER 2 0
00A7 (00167) |   |   |   |   |   BLR$K_EQL
00A8 (00168) |   |   |   |   |   | BLR$K_FIELD 1 FARE_TYPE_ID
00B7 (00183) |   |   |   |   |   | BLR$K_FIELD 2 FARE_TYPE_ID
00C6 (00198) |   |   |   |   | BLR$K_EQL
00C7 (00199) |   |   |   |   |   BLR$K_FIELD 2 LOCATION_TERMINAL_ID
00DE (00222) |   |   |   |   |   BLR$K_FIELD 3 LOCATION_TERMINAL_ID
00F5 (00245) |   |   |   |   BLR$K_EQL
00F6 (00246) |   |   |   |   | BLR$K_FIELD 2 ROUTE_ID
0101 (00257) |   |   |   |   | BLR$K_FIELD 3 ROUTE_ID
010C (00268) |   |   |   BLR$K_SORT  2
010E (00270) |   |   |   BLR$K_ASCENDING
010F (00271) |   |   |   | BLR$K_FIELD 3 KEY_FUNCTION_VALUE
0124 (00292) |   |   |   BLR$K_ASCENDING
0125 (00293) |   |   |   | BLR$K_FIELD 1 KEY_FUNCTION_VALUE
013A (00314) |   |   | BLR$K_END
013B (00315) |   |   | BLR$K_BEGIN
013C (00316) |   |   |   BLR$K_SEND  1
013E (00318) |   |   |   | BLR$K_HANDLER
013F (00319) |   |   |   |   BLR$K_BEGIN
0140 (00320) |   |   |   |   | BLR$K_ASSIGNMENT
0141 (00321) |   |   |   |   |   BLR$K_FIELD 3 KEY_FUNCTION_VALUE
0156 (00342) |   |   |   |   |   BLR$K_PARAMETER2 1 2 1
015C (00348) |   |   |   |   | BLR$K_ASSIGNMENT
015D (00349) |   |   |   |   |   BLR$K_FIELD 1 KEY_FUNCTION_VALUE
0172 (00370) |   |   |   |   |   BLR$K_PARAMETER2 1 4 3
0178 (00376) |   |   |   |   | BLR$K_ASSIGNMENT
0179 (00377) |   |   |   |   |   BLR$K_FIELD 2 TERMINAL_ROUTE_FARE_ID
0192 (00402) |   |   |   |   |   BLR$K_PARAMETER2 1 6 5
0198 (00408) |   |   |   |   | BLR$K_ASSIGNMENT
0199 (00409) |   |   |   |   |   BLR$K_FIELD 2 INVENTORY_TYPE_ID
01AD (00429) |   |   |   |   |   BLR$K_PARAMETER2 1 8 7
01B3 (00435) |   |   |   |   | BLR$K_ASSIGNMENT
01B4 (00436) |   |   |   |   |   BLR$K_FIELD 1 FARE_TYPE
01C2 (00450) |   |   |   |   |   BLR$K_PARAMETER3 1 11 9 10
01C8 (00456) |   |   |   |   | BLR$K_ASSIGNMENT
01C9 (00457) |   |   |   |   |   BLR$K_CAST
01CA (00458) |   |   |   |   |   | BLR$K_DESCRIPTOR
01CB (00459) |   |   |   |   |   |   DSC$K_DTYPE_F
01CC (00460) |   |   |   |   |   | BLR$K_FIELD 2 UNIT_PRICE_AMOUNT
01E0 (00480) |   |   |   |   |   BLR$K_PARAMETER2 1 13 12
01E6 (00486) |   |   |   |   | BLR$K_ASSIGNMENT
01E7 (00487) |   |   |   |   |   BLR$K_FIELD 1 PREPAID_FARE_FLAG
01FD (00509) |   |   |   |   |   BLR$K_PARAMETER3 1 16 14 15
0203 (00515) |   |   |   |   | BLR$K_ASSIGNMENT
0204 (00516) |   |   |   |   |   BLR$K_FIELD 1 OVERRIDE_PRICE_FLAG
021C (00540) |   |   |   |   |   BLR$K_PARAMETER3 1 19 17 18
0222 (00546) |   |   |   |   | BLR$K_ASSIGNMENT
0223 (00547) |   |   |   |   |   BLR$K_FIELD 1 PARTIAL_REFUND_FLAG
023B (00571) |   |   |   |   |   BLR$K_PARAMETER3 1 22 20 21
0241 (00577) |   |   |   |   | BLR$K_ASSIGNMENT
0242 (00578) |   |   |   |   |   BLR$K_FIELD 1 REFUND_FLAG
0252 (00594) |   |   |   |   |   BLR$K_PARAMETER3 1 25 23 24
0258 (00600) |   |   |   |   | BLR$K_ASSIGNMENT
0259 (00601) |   |   |   |   |   BLR$K_LITERAL
025A (00602) |   |   |   |   |   | DSC$K_DTYPE_L 0  "0"
0260 (00608) |   |   |   |   |   BLR$K_PARAMETER 1 0
0264 (00612) |   |   |   |   BLR$K_END
0265 (00613) |   |   | BLR$K_END
0266 (00614) |   | BLR$K_END
0267 (00615) |   BLR$K_SEND  1
0269 (00617) |   | BLR$K_HANDLER
026A (00618) |   |   BLR$K_BEGIN
026B (00619) |   |   | BLR$K_ASSIGNMENT
026C (00620) |   |   |   BLR$K_LITERAL
026D (00621) |   |   |   | DSC$K_DTYPE_L 0  "100"
0273 (00627) |   |   |   BLR$K_PARAMETER 1 0
0277 (00631) |   |   BLR$K_END
0278 (00632) | BLR$K_END
0279 (00633) BLR$K_EOC
0000 (00000) BLR$K_VERSION4
0001 (00001) | BLR$K_BEGIN
0002 (00002) |   BLR$K_MESSAGE 1 3
0006 (00006) |   | DSC$K_DTYPE_L 0
0008 (00008) |   | DSC$K_DTYPE_L 0
000A (00010) |   | DSC$K_DTYPE_F
000B (00011) |   BLR$K_MESSAGE 2 0
000F (00015) |   BLR$K_SEND  1
0011 (00017) |   | BLR$K_BEGIN
0012 (00018) |   |   BLR$K_ASSIGNMENT
0013 (00019) |   |   | BLR$K_LITERAL
0014 (00020) |   |   |   DSC$K_DTYPE_L 0  "100"
001A (00026) |   |   | BLR$K_PARAMETER 1 0
001E (00030) |   |   BLR$K_FOR
001F (00031) |   |   | BLR$K_RSE  1
0021 (00033) |   |   |   BLR$K_RELATION SYSTEM_WIDE 1
002F (00047) |   |   |   BLR$K_FIRST
0030 (00048) |   |   |   | BLR$K_LITERAL
0031 (00049) |   |   |   |   DSC$K_DTYPE_W 0  "1"
0035 (00053) |   |   | BLR$K_END
0036 (00054) |   |   | BLR$K_BEGIN
0037 (00055) |   |   |   BLR$K_IF
0038 (00056) |   |   |   | BLR$K_EQL
0039 (00057) |   |   |   |   BLR$K_LITERAL
003A (00058) |   |   |   |   | DSC$K_DTYPE_L 0  "100"
0040 (00064) |   |   |   |   BLR$K_PARAMETER 1 0
0044 (00068) |   |   |   | BLR$K_BEGIN
0045 (00069) |   |   |   |   BLR$K_ASSIGNMENT
0046 (00070) |   |   |   |   | BLR$K_CAST
0047 (00071) |   |   |   |   |   BLR$K_DESCRIPTOR
0048 (00072) |   |   |   |   |   | DSC$K_DTYPE_F
0049 (00073) |   |   |   |   |   BLR$K_FIELD 1 CANADIAN_EXCHANGE_RATE
0062 (00098) |   |   |   |   | BLR$K_PARAMETER2 1 2 1
0068 (00104) |   |   |   |   BLR$K_ASSIGNMENT
0069 (00105) |   |   |   |   | BLR$K_LITERAL
006A (00106) |   |   |   |   |   DSC$K_DTYPE_L 0  "0"
0070 (00112) |   |   |   |   | BLR$K_PARAMETER 1 0
0074 (00116) |   |   |   | BLR$K_END
0075 (00117) |   |   |   | BLR$K_BEGIN
0076 (00118) |   |   |   |   BLR$K_ASSIGNMENT
0077 (00119) |   |   |   |   | BLR$K_LITERAL
0078 (00120) |   |   |   |   |   DSC$K_DTYPE_L 0  "-811"
007E (00126) |   |   |   |   | BLR$K_PARAMETER 1 0
0082 (00130) |   |   |   | BLR$K_END
0083 (00131) |   |   | BLR$K_END
0084 (00132) |   | BLR$K_END
0085 (00133) | BLR$K_END
0086 (00134) BLR$K_EOC
0000 (00000) BLR$K_VERSION4
0001 (00001) | BLR$K_BEGIN
0002 (00002) |   BLR$K_MESSAGE 1 3
0006 (00006) |   | DSC$K_DTYPE_L 0
0008 (00008) |   | DSC$K_DTYPE_L 0
000A (00010) |   | DSC$K_DTYPE_Q 0
000C (00012) |   BLR$K_MESSAGE 2 0
0010 (00016) |   BLR$K_MESSAGE 3 1
0014 (00020) |   | DSC$K_DTYPE_Q 0
0016 (00022) |   BLR$K_RECEIVE  3
0018 (00024) |   | BLR$K_BEGIN
0019 (00025) |   |   BLR$K_SEND  1
001B (00027) |   |   | BLR$K_BEGIN
001C (00028) |   |   |   BLR$K_ASSIGNMENT
001D (00029) |   |   |   | BLR$K_LITERAL
001E (00030) |   |   |   |   DSC$K_DTYPE_L 0  "100"
0024 (00036) |   |   |   | BLR$K_PARAMETER 1 0
0028 (00040) |   |   |   BLR$K_FOR
0029 (00041) |   |   |   | BLR$K_RSE  1
002B (00043) |   |   |   |   BLR$K_RELATION SALES_TRANSACTION_CONTROL 1
0047 (00071) |   |   |   |   BLR$K_FIRST
0048 (00072) |   |   |   |   | BLR$K_LITERAL
0049 (00073) |   |   |   |   |   DSC$K_DTYPE_W 0  "1"
004D (00077) |   |   |   | BLR$K_END
004E (00078) |   |   |   | BLR$K_BEGIN
004F (00079) |   |   |   |   BLR$K_IF
0050 (00080) |   |   |   |   | BLR$K_EQL
0051 (00081) |   |   |   |   |   BLR$K_LITERAL
0052 (00082) |   |   |   |   |   | DSC$K_DTYPE_L 0  "100"
0058 (00088) |   |   |   |   |   BLR$K_PARAMETER 1 0
005C (00092) |   |   |   |   | BLR$K_BEGIN
005D (00093) |   |   |   |   |   BLR$K_ASSIGNMENT
005E (00094) |   |   |   |   |   | BLR$K_FIELD 1
LAST_SALES_TRANSACTION_COUNT
007D (00125) |   |   |   |   |   | BLR$K_PARAMETER2 1 2 1
0083 (00131) |   |   |   |   |   BLR$K_ASSIGNMENT
0084 (00132) |   |   |   |   |   | BLR$K_LITERAL
0085 (00133) |   |   |   |   |   |   DSC$K_DTYPE_L 0  "0"
008B (00139) |   |   |   |   |   | BLR$K_PARAMETER 1 0
008F (00143) |   |   |   |   | BLR$K_END
0090 (00144) |   |   |   |   | BLR$K_BEGIN
0091 (00145) |   |   |   |   |   BLR$K_ASSIGNMENT
0092 (00146) |   |   |   |   |   | BLR$K_LITERAL
0093 (00147) |   |   |   |   |   |   DSC$K_DTYPE_L 0  "-811"
0099 (00153) |   |   |   |   |   | BLR$K_PARAMETER 1 0
009D (00157) |   |   |   |   | BLR$K_END
009E (00158) |   |   |   | BLR$K_END
009F (00159) |   |   | BLR$K_END
00A0 (00160) |   | BLR$K_END
00A1 (00161) | BLR$K_END
00A2 (00162) BLR$K_EOC
0000 (00000) BLR$K_VERSION4
0001 (00001) | BLR$K_BEGIN
0002 (00002) |   BLR$K_MESSAGE 1 2
0006 (00006) |   | DSC$K_DTYPE_L 0
0008 (00008) |   | DSC$K_DTYPE_Q 0
000A (00010) |   BLR$K_MESSAGE 2 1
000E (00014) |   | DSC$K_DTYPE_L 0
0010 (00016) |   BLR$K_BEGIN
0011 (00017) |   | BLR$K_DCL_VARIABLE 2
0014 (00020) |   |   DSC$K_DTYPE_L 0
0016 (00022) |   | BLR$K_ASSIGNMENT
0017 (00023) |   |   BLR$K_LITERAL
0018 (00024) |   |   | DSC$K_DTYPE_L 0  "0"
001E (00030) |   |   BLR$K_VARIABLE 2
0021 (00033) |   | BLR$K_RECEIVE  1
0023 (00035) |   |   BLR$K_BEGIN
0024 (00036) |   |   | BLR$K_FOR
0025 (00037) |   |   |   BLR$K_CONTROL_BITS  8
0027 (00039) |   |   |   BLR$K_RSE  1
0029 (00041) |   |   |   | BLR$K_RELATION SALES_TRANSACTION_CONTROL 1
0045 (00069) |   |   |   BLR$K_END
0046 (00070) |   |   |   BLR$K_BEGIN
0047 (00071) |   |   |   | BLR$K_ASSIGNMENT
0048 (00072) |   |   |   |   BLR$K_LITERAL
0049 (00073) |   |   |   |   | DSC$K_DTYPE_L 0  "1"
004F (00079) |   |   |   |   BLR$K_VARIABLE 2
0052 (00082) |   |   |   | BLR$K_MODIFY 1 2
0055 (00085) |   |   |   |   BLR$K_BEGIN
0056 (00086) |   |   |   |   | BLR$K_ASSIGNMENT
0057 (00087) |   |   |   |   |   BLR$K_PARAMETER2 1 1 0
005D (00093) |   |   |   |   |   BLR$K_FIELD 2
LAST_SALES_TRANSACTION_COUNT
007C (00124) |   |   |   |   BLR$K_END
007D (00125) |   |   |   BLR$K_END
007E (00126) |   |   BLR$K_END
007F (00127) |   | BLR$K_SEND  2
0081 (00129) |   |   BLR$K_BEGIN
0082 (00130) |   |   | BLR$K_IF
0083 (00131) |   |   |   BLR$K_EQL
0084 (00132) |   |   |   | BLR$K_LITERAL
0085 (00133) |   |   |   |   DSC$K_DTYPE_L 0  "0"
008B (00139) |   |   |   | BLR$K_VARIABLE 2
008E (00142) |   |   |   BLR$K_ASSIGNMENT
008F (00143) |   |   |   | BLR$K_LITERAL
0090 (00144) |   |   |   |   DSC$K_DTYPE_L 0  "100"
0096 (00150) |   |   |   | BLR$K_PARAMETER 2 0
009A (00154) |   |   |   BLR$K_ASSIGNMENT
009B (00155) |   |   |   | BLR$K_LITERAL
009C (00156) |   |   |   |   DSC$K_DTYPE_L 0  "0"
00A2 (00162) |   |   |   | BLR$K_PARAMETER 2 0
00A6 (00166) |   |   BLR$K_END
00A7 (00167) |   BLR$K_END
00A8 (00168) | BLR$K_END
00A9 (00169) BLR$K_EOC
0000 (00000) BLR$K_VERSION4
0001 (00001) | BLR$K_BEGIN
0002 (00002) |   BLR$K_MESSAGE 1 3
0006 (00006) |   | DSC$K_DTYPE_L 0
0008 (00008) |   | DSC$K_DTYPE_L 0
000A (00010) |   | DSC$K_DTYPE_L 0
000C (00012) |   BLR$K_MESSAGE 2 0
0010 (00016) |   BLR$K_MESSAGE 3 3
0014 (00020) |   | DSC$K_DTYPE_CHAR 12 (sub-type: 0)
0019 (00025) |   | DSC$K_DTYPE_CHAR 12 (sub-type: 0)
001E (00030) |   | DSC$K_DTYPE_CHAR 18 (sub-type: 0)
0023 (00035) |   BLR$K_RECEIVE  3
0025 (00037) |   | BLR$K_BEGIN
0026 (00038) |   |   BLR$K_SEND  1
0028 (00040) |   |   | BLR$K_BEGIN
0029 (00041) |   |   |   BLR$K_ASSIGNMENT
002A (00042) |   |   |   | BLR$K_LITERAL
002B (00043) |   |   |   |   DSC$K_DTYPE_L 0  "100"
0031 (00049) |   |   |   | BLR$K_PARAMETER 1 0
0035 (00053) |   |   |   BLR$K_FOR
0036 (00054) |   |   |   | BLR$K_RSE  1
0038 (00056) |   |   |   |   BLR$K_AGGREGATE 1
003A (00058) |   |   |   |   | BLR$K_RSE  1
003C (00060) |   |   |   |   |   BLR$K_RELATION NEGATIVE_CHECK 2
004D (00077) |   |   |   |   |   BLR$K_BOOLEAN
004E (00078) |   |   |   |   |   | BLR$K_AND
004F (00079) |   |   |   |   |   |   BLR$K_EQL
0050 (00080) |   |   |   |   |   |   | BLR$K_FIELD 2 BANK_ROUTING_ID
0062 (00098) |   |   |   |   |   |   | BLR$K_PARAMETER 3 1
0066 (00102) |   |   |   |   |   |   BLR$K_EQL
0067 (00103) |   |   |   |   |   |   | BLR$K_FIELD 2 ACCOUNT_ID
0074 (00116) |   |   |   |   |   |   | BLR$K_PARAMETER 3 2
0078 (00120) |   |   |   |   | BLR$K_END
0079 (00121) |   |   |   |   | BLR$K_MAP  1
007B (00123) |   |   |   |   |   0
007D (00125) |   |   |   |   |   BLR$K_AGG_COUNT
007E (00126) |   |   |   |   |   BLR$K_END
007F (00127) |   |   |   |   BLR$K_FIRST
0080 (00128) |   |   |   |   | BLR$K_LITERAL
0081 (00129) |   |   |   |   |   DSC$K_DTYPE_W 0  "2"
0085 (00133) |   |   |   | BLR$K_END
0086 (00134) |   |   |   | BLR$K_BEGIN
0087 (00135) |   |   |   |   BLR$K_IF
0088 (00136) |   |   |   |   | BLR$K_EQL
0089 (00137) |   |   |   |   |   BLR$K_LITERAL
008A (00138) |   |   |   |   |   | DSC$K_DTYPE_L 0  "100"
0090 (00144) |   |   |   |   |   BLR$K_PARAMETER 1 0
0094 (00148) |   |   |   |   | BLR$K_BEGIN
0095 (00149) |   |   |   |   |   BLR$K_ASSIGNMENT
0096 (00150) |   |   |   |   |   | BLR$K_FIELD_ID 1 0
009A (00154) |   |   |   |   |   | BLR$K_PARAMETER2 1 2 1
00A0 (00160) |   |   |   |   |   BLR$K_ASSIGNMENT
00A1 (00161) |   |   |   |   |   | BLR$K_LITERAL
00A2 (00162) |   |   |   |   |   |   DSC$K_DTYPE_L 0  "0"
00A8 (00168) |   |   |   |   |   | BLR$K_PARAMETER 1 0
00AC (00172) |   |   |   |   | BLR$K_END
00AD (00173) |   |   |   |   | BLR$K_BEGIN
00AE (00174) |   |   |   |   |   BLR$K_ASSIGNMENT
00AF (00175) |   |   |   |   |   | BLR$K_LITERAL
00B0 (00176) |   |   |   |   |   |   DSC$K_DTYPE_L 0  "-811"
00B6 (00182) |   |   |   |   |   | BLR$K_PARAMETER 1 0
00BA (00186) |   |   |   |   | BLR$K_END
00BB (00187) |   |   |   | BLR$K_END
00BC (00188) |   |   | BLR$K_END
00BD (00189) |   | BLR$K_END
00BE (00190) | BLR$K_END
00BF (00191) BLR$K_EOC
0000 (00000) BLR$K_VERSION4
0001 (00001) | BLR$K_BEGIN
0002 (00002) |   BLR$K_MESSAGE 1 6
0006 (00006) |   | DSC$K_DTYPE_L 0
0008 (00008) |   | DSC$K_DTYPE_Q 0
000A (00010) |   | DSC$K_DTYPE_L 0
000C (00012) |   | DSC$K_DTYPE_CHAR 22 (sub-type: 0)
0011 (00017) |   | DSC$K_DTYPE_L 0
0013 (00019) |   | DSC$K_DTYPE_L 0
0015 (00021) |   BLR$K_RECEIVE  1
0017 (00023) |   | BLR$K_STORE
0018 (00024) |   |   BLR$K_RELATION SALES_TRANSACTION 1
002C (00044) |   |   BLR$K_BEGIN
002D (00045) |   |   | BLR$K_ASSIGNMENT
002E (00046) |   |   |   BLR$K_PARAMETER2 1 1 0
0034 (00052) |   |   |   BLR$K_FIELD 1 SALES_TRANSACTION_ID
004B (00075) |   |   | BLR$K_ASSIGNMENT
004C (00076) |   |   |   BLR$K_PARAMETER2 1 2 0
0052 (00082) |   |   |   BLR$K_FIELD 1 SESSION_ID
005F (00095) |   |   | BLR$K_ASSIGNMENT
0060 (00096) |   |   |   BLR$K_CAST
0061 (00097) |   |   |   | BLR$K_DESCRIPTOR
0062 (00098) |   |   |   |   DSC$K_DTYPE_DATETIME (s: 63, p: 0, f: -2)
                             Timestamp
0067 (00103) |   |   |   | BLR$K_PARAMETER 1 3
006B (00107) |   |   |   BLR$K_FIELD 1 SALE_START_DATE_TIME
0082 (00130) |   |   | BLR$K_ASSIGNMENT
0083 (00131) |   |   |   BLR$K_CURRENT_TIMESTAMP
0084 (00132) |   |   |   | BLR$K_DESCRIPTOR
0085 (00133) |   |   |   |   DSC$K_DTYPE_DATETIME (s: 63, p: 0, f: -2)
                             Timestamp
008A (00138) |   |   |   BLR$K_FIELD 1 SALE_END_DATE_TIME
009F (00159) |   |   | BLR$K_ASSIGNMENT
00A0 (00160) |   |   |   BLR$K_PARAMETER2 1 4 0
00A6 (00166) |   |   |   BLR$K_FIELD 1 SALES_TRANSACTION_TYPE_ID
00C2 (00194) |   |   | BLR$K_ASSIGNMENT
00C3 (00195) |   |   |   BLR$K_PARAMETER2 1 5 0
00C9 (00201) |   |   |   BLR$K_FIELD 1 SHIFT_ID
00D4 (00212) |   |   BLR$K_END
00D5 (00213) | BLR$K_END
00D6 (00214) BLR$K_EOC
0000 (00000) BLR$K_VERSION4
0001 (00001) | BLR$K_BEGIN
0002 (00002) |   BLR$K_MESSAGE 1 10
0006 (00006) |   | DSC$K_DTYPE_L 0
0008 (00008) |   | DSC$K_DTYPE_L 0
000A (00010) |   | DSC$K_DTYPE_Q 0000C (00012) |   | DSC$K_DTYPE_CHAR 22
(sub-type: 0)
0011 (00017) |   | DSC$K_DTYPE_L 0
0013 (00019) |   | DSC$K_DTYPE_L 0
0015 (00021) |   | DSC$K_DTYPE_CHAR 11 (sub-type: 0)
001A (00026) |   | DSC$K_DTYPE_F
001B (00027) |   | DSC$K_DTYPE_L 0
001D (00029) |   | DSC$K_DTYPE_Q 0
001F (00031) |   BLR$K_RECEIVE  1
0021 (00033) |   | BLR$K_STORE
0022 (00034) |   |   BLR$K_RELATION TICKET_LOG 1
002F (00047) |   |   BLR$K_BEGIN
0030 (00048) |   |   | BLR$K_ASSIGNMENT
0031 (00049) |   |   |   BLR$K_PARAMETER2 1 2 0
0037 (00055) |   |   |   BLR$K_FIELD 1 SALES_TRANSACTION_ID
004E (00078) |   |   | BLR$K_ASSIGNMENT
004F (00079) |   |   |   BLR$K_CAST
0050 (00080) |   |   |   | BLR$K_DESCRIPTOR
0051 (00081) |   |   |   |   DSC$K_DTYPE_DATETIME (s: 63, p: 0, f: -2)
                             Timestamp
0056 (00086) |   |   |   | BLR$K_PARAMETER 1 3
005A (00090) |   |   |   BLR$K_FIELD 1 TICKET_DATE_TIME
006D (00109) |   |   | BLR$K_ASSIGNMENT
006E (00110) |   |   |   BLR$K_PARAMETER2 1 4 0
0074 (00116) |   |   |   BLR$K_FIELD 1 TERMINAL_ROUTE_FARE_ID
008D (00141) |   |   | BLR$K_ASSIGNMENT
008E (00142) |   |   |   BLR$K_PARAMETER2 1 5 0
0094 (00148) |   |   |   BLR$K_FIELD 1 TICKET_COUNT
00A3 (00163) |   |   | BLR$K_ASSIGNMENT
00A4 (00164) |   |   |   BLR$K_CAST
00A5 (00165) |   |   |   | BLR$K_DESCRIPTOR
00A6 (00166) |   |   |   |   DSC$K_DTYPE_DATETIME (s: 56, p: 0, f: -2)
                             Time
00AB (00171) |   |   |   | BLR$K_PARAMETER 1 6
00AF (00175) |   |   |   BLR$K_FIELD 1 SCHEDULED_DEPARTURE_TIME
00CA (00202) |   |   | BLR$K_ASSIGNMENT
00CB (00203) |   |   |   BLR$K_PARAMETER2 1 7 0
00D1 (00209) |   |   |   BLR$K_FIELD 1 ACTUAL_PRICE_AMOUNT
00E7 (00231) |   |   | BLR$K_ASSIGNMENT
00E8 (00232) |   |   |   BLR$K_PARAMETER2 1 8 0
00EE (00238) |   |   |   BLR$K_FIELD 1 SERIAL_NUMBER
00FE (00254) |   |   | BLR$K_ASSIGNMENT
00FF (00255) |   |   |   BLR$K_PARAMETER2 1 9 1
0105 (00261) |   |   |   BLR$K_FIELD 1 REFERENCE_NUMBER
0118 (00280) |   |   BLR$K_END
0119 (00281) | BLR$K_END
011A (00282) BLR$K_EOC
0000 (00000) BLR$K_VERSION4
0001 (00001) | BLR$K_BEGIN
0002 (00002) |   BLR$K_MESSAGE 1 5
0006 (00006) |   | DSC$K_DTYPE_L 0
0008 (00008) |   | DSC$K_DTYPE_Q 0
000A (00010) |   | DSC$K_DTYPE_CHAR 22 (sub-type: 0)
000F (00015) |   | DSC$K_DTYPE_L 0
0011 (00017) |   | DSC$K_DTYPE_F
0012 (00018) |   BLR$K_RECEIVE  1
0014 (00020) |   | BLR$K_STORE
0015 (00021) |   |   BLR$K_RELATION PAYMENT_LOG 1
0023 (00035) |   |   BLR$K_BEGIN
0024 (00036) |   |   | BLR$K_ASSIGNMENT
0025 (00037) |   |   |   BLR$K_PARAMETER2 1 1 0
002B (00043) |   |   |   BLR$K_FIELD 1 SALES_TRANSACTION_ID
0042 (00066) |   |   | BLR$K_ASSIGNMENT
0043 (00067) |   |   |   BLR$K_CAST
0044 (00068) |   |   |   | BLR$K_DESCRIPTOR
0045 (00069) |   |   |   |   DSC$K_DTYPE_DATETIME (s: 63, p: 0, f: -2)
                             Timestamp
004A (00074) |   |   |   | BLR$K_PARAMETER 1 2
004E (00078) |   |   |   BLR$K_FIELD 1 PAYMENT_DATE_TIME
0062 (00098) |   |   | BLR$K_ASSIGNMENT
0063 (00099) |   |   |   BLR$K_PARAMETER2 1 3 0
0069 (00105) |   |   |   BLR$K_FIELD 1 MEDIA_TYPE_ID
0079 (00121) |   |   | BLR$K_ASSIGNMENT
007A (00122) |   |   |   BLR$K_PARAMETER2 1 4 0
0080 (00128) |   |   |   BLR$K_FIELD 1 PAYMENT_AMOUNT
0091 (00145) |   |   BLR$K_END
0092 (00146) | BLR$K_END
0093 (00147) BLR$K_EOC
0000 (00000) BLR$K_VERSION4
0001 (00001) | BLR$K_BEGIN
0002 (00002) |   BLR$K_MESSAGE 1 6
0006 (00006) |   | DSC$K_DTYPE_L 0
0008 (00008) |   | DSC$K_DTYPE_Q 0
000A (00010) |   | DSC$K_DTYPE_CHAR 22 (sub-type: 0)
000F (00015) |   | DSC$K_DTYPE_CHAR 12 (sub-type: 0)
0014 (00020) |   | DSC$K_DTYPE_CHAR 18 (sub-type: 0)
0019 (00025) |   | DSC$K_DTYPE_CHAR 7 (sub-type: 0)
001E (00030) |   BLR$K_RECEIVE  1
0020 (00032) |   | BLR$K_STORE
0021 (00033) |   |   BLR$K_RELATION CHECK_LOG 1
002D (00045) |   |   BLR$K_BEGIN
002E (00046) |   |   | BLR$K_ASSIGNMENT
002F (00047) |   |   |   BLR$K_PARAMETER2 1 1 0
0035 (00053) |   |   |   BLR$K_FIELD 1 SALES_TRANSACTION_ID
004C (00076) |   |   | BLR$K_ASSIGNMENT
004D (00077) |   |   |   BLR$K_CAST
004E (00078) |   |   |   | BLR$K_DESCRIPTOR
004F (00079) |   |   |   |   DSC$K_DTYPE_DATETIME (s: 63, p: 0, f: -2)
                             Timestamp
0054 (00084) |   |   |   | BLR$K_PARAMETER 1 2
0058 (00088) |   |   |   BLR$K_FIELD 1 PAYMENT_DATE_TIME
006C (00108) |   |   | BLR$K_ASSIGNMENT
006D (00109) |   |   |   BLR$K_PARAMETER2 1 3 0
0073 (00115) |   |   |   BLR$K_FIELD 1 BANK_ROUTING_ID
0085 (00133) |   |   | BLR$K_ASSIGNMENT
0086 (00134) |   |   |   BLR$K_PARAMETER2 1 4 0
008C (00140) |   |   |   BLR$K_FIELD 1 ACCOUNT_ID
0099 (00153) |   |   | BLR$K_ASSIGNMENT
009A (00154) |   |   |   BLR$K_PARAMETER2 1 5 0
00A0 (00160) |   |   |   BLR$K_FIELD 1 CHECK_NUMBER
00AF (00175) |   |   BLR$K_END
00B0 (00176) | BLR$K_END
00B1 (00177) BLR$K_EOC



---- End of Message ----
5096.2The code/query created to re-create, but didn't workBROKE::BASTINEMon Mar 03 1997 14:15320
This file demonstrates the code and successful execution. The query was
executed with interactive SQL. The correct information was returned. The
query is shown below. This is the same query that is executed in the
context of a full program with many other queries when it fails. The "B"
flag output for that failure will be in my next email message to you. 

====================================================================
-- This is the query that should show the negative_check bug.
------------------------------------------------------------------------
-------
-- check negative check account
--
attach 'filename posdb';
declare :amount integer;
declare :bank_routing_id char(12);
declare :bank_account_id char(18);
begin
set :amount = -1;
set :bank_routing_id = '011000015';
set :bank_account_id = '0037427';
end;

--PROCEDURE db_check_negative_check
--    SQLCODE
--    ,:amount            INTEGER
--    ,:bank_routing_id   CHAR(12)
--    ,:bank_account_id   CHAR(18)
--    ;
    
    SELECT COUNT(*) 
    INTO   :amount
    FROM   negative_check
    WHERE  bank_routing_id = :bank_routing_id
    AND    account_id = :bank_account_id
    ;

print 'If :amount = -1, then bug is demonstrated.';
print 'If :amount = 1, then bug failes to show itself.';
print 'Amount = ', :amount;
------------------------------------------------------------------------
------------------------------------
-- "B" debug flags output



0000 (00000) BLR$K_VERSION4
0001 (00001) | BLR$K_BEGIN
0002 (00002) |   BLR$K_MESSAGE 1 4
0006 (00006) |   | DSC$K_DTYPE_L 0
0008 (00008) |   | DSC$K_DTYPE_CHAR 12 (sub-type: 0)
000D (00013) |   | DSC$K_DTYPE_CHAR 18 (sub-type: 0)
0012 (00018) |   | DSC$K_DTYPE_L 0
0014 (00020) |   BLR$K_RECEIVE  1
0016 (00022) |   | BLR$K_SEND  1
0018 (00024) |   |   BLR$K_BEGIN
0019 (00025) |   |   | BLR$K_STATEMENT
001A (00026) |   |   |   BLR$K_BEGIN
001B (00027) |   |   |   | BLR$K_ASSIGNMENT
001C (00028) |   |   |   |   BLR$K_LITERAL
001D (00029) |   |   |   |   | DSC$K_DTYPE_L 0  "-1"
0023 (00035) |   |   |   |   BLR$K_PARAMETER 1 0
0027 (00039) |   |   |   BLR$K_END
0028 (00040) |   |   | BLR$K_STATEMENT
0029 (00041) |   |   |   BLR$K_BEGIN
002A (00042) |   |   |   | BLR$K_ASSIGNMENT
002B (00043) |   |   |   |   BLR$K_LITERAL
002C (00044) |   |   |   |   | DSC$K_DTYPE_CHAR 9 (sub-type: 0)
                                "011000015"
003A (00058) |   |   |   |   BLR$K_PARAMETER 1 1
003E (00062) |   |   |   BLR$K_END
003F (00063) |   |   | BLR$K_STATEMENT
0040 (00064) |   |   |   BLR$K_BEGIN
0041 (00065) |   |   |   | BLR$K_ASSIGNMENT
0042 (00066) |   |   |   |   BLR$K_LITERAL
0043 (00067) |   |   |   |   | DSC$K_DTYPE_CHAR 7 (sub-type: 0)
                                "0037427"
004F (00079) |   |   |   |   BLR$K_PARAMETER 1 2
0053 (00083) |   |   |   BLR$K_END
0054 (00084) |   |   | BLR$K_ASSIGNMENT
0055 (00085) |   |   |   BLR$K_GET_INFO (1) RDB$K_INF_SQLCODE
0058 (00088) |   |   |   BLR$K_PARAMETER 1 3
005C (00092) |   |   BLR$K_END
005D (00093) | BLR$K_END
005E (00094) BLR$K_EOC
0000 (00000) BLR$K_VERSION4
0001 (00001) | BLR$K_BEGIN
0002 (00002) |   BLR$K_MESSAGE 1 5
0006 (00006) |   | DSC$K_DTYPE_T 1
0009 (00009) |   | DSC$K_DTYPE_L 0
000B (00011) |   | DSC$K_DTYPE_L 0
000D (00013) |   | DSC$K_DTYPE_Q 0
000F (00015) |   | DSC$K_DTYPE_L 0
0011 (00017) |   BLR$K_MESSAGE 2 0
0015 (00021) |   BLR$K_MESSAGE 3 1
0019 (00025) |   | DSC$K_DTYPE_T 31
001C (00028) |   BLR$K_RECEIVE  3
001E (00030) |   | BLR$K_BEGIN
001F (00031) |   |   BLR$K_FOR
0020 (00032) |   |   | BLR$K_RSE  1
0022 (00034) |   |   |   BLR$K_RELATION RDB$RELATIONS 1
0032 (00050) |   |   |   BLR$K_BOOLEAN
0033 (00051) |   |   |   | BLR$K_EQL
0034 (00052) |   |   |   |   BLR$K_FIELD 1 RDB$RELATION_NAME
0048 (00072) |   |   |   |   BLR$K_PARAMETER 3 0
004C (00076) |   |   | BLR$K_END
004D (00077) |   |   | BLR$K_BEGIN
004E (00078) |   |   |   BLR$K_SEND  1
0050 (00080) |   |   |   | BLR$K_BEGIN
0051 (00081) |   |   |   |   BLR$K_ASSIGNMENT
0052 (00082) |   |   |   |   | BLR$K_LITERAL
0053 (00083) |   |   |   |   |   DSC$K_DTYPE_T 1  "N"
0057 (00087) |   |   |   |   | BLR$K_PARAMETER 1 0
005B (00091) |   |   |   |   BLR$K_ASSIGNMENT
005C (00092) |   |   |   |   | BLR$K_FIELD 1 RDB$DBKEY_LENGTH
006F (00111) |   |   |   |   | BLR$K_PARAMETER 1 1
0073 (00115) |   |   |   |   BLR$K_ASSIGNMENT
0074 (00116) |   |   |   |   | BLR$K_FIELD 1 RDB$RELATION_ID
0086 (00134) |   |   |   |   | BLR$K_PARAMETER 1 2
008A (00138) |   |   |   |   BLR$K_ASSIGNMENT
008B (00139) |   |   |   |   | BLR$K_FIELD 1 RDB$VIEW_BLR
009A (00154) |   |   |   |   | BLR$K_PARAMETER 1 3
009E (00158) |   |   |   |   BLR$K_ASSIGNMENT
009F (00159) |   |   |   |   | BLR$K_FIELD 1 RDB$SYSTEM_FLAG
00B1 (00177) |   |   |   |   | BLR$K_PARAMETER 1 4
00B5 (00181) |   |   |   | BLR$K_END
00B6 (00182) |   |   | BLR$K_END
00B7 (00183) |   | BLR$K_END
00B8 (00184) |   BLR$K_SEND  1
00BA (00186) |   | BLR$K_BEGIN
00BB (00187) |   |   BLR$K_ASSIGNMENT
00BC (00188) |   |   | BLR$K_LITERAL
00BD (00189) |   |   |   DSC$K_DTYPE_T 1  "Y"
00C1 (00193) |   |   | BLR$K_PARAMETER 1 0
00C5 (00197) |   | BLR$K_END
00C6 (00198) | BLR$K_END
00C7 (00199) BLR$K_EOC
0000 (00000) BLR$K_VERSION4
0001 (00001) | BLR$K_BEGIN
0002 (00002) |   BLR$K_MESSAGE 1 18
0006 (00006) |   | DSC$K_DTYPE_T 1
0009 (00009) |   | DSC$K_DTYPE_T 31
000C (00012) |   | DSC$K_DTYPE_L 0
000E (00014) |   | DSC$K_DTYPE_L 0
0010 (00016) |   | DSC$K_DTYPE_Q 0
0012 (00018) |   | DSC$K_DTYPE_Q 0
0014 (00020) |   | DSC$K_DTYPE_VT 255
0017 (00023) |   | DSC$K_DTYPE_VT 255
001A (00026) |   | DSC$K_DTYPE_L 0
001C (00028) |   | DSC$K_DTYPE_L 0
001E (00030) |   | DSC$K_DTYPE_L 0
0020 (00032) |   | DSC$K_DTYPE_Q 0
0022 (00034) |   | DSC$K_DTYPE_L 0
0024 (00036) |   | DSC$K_DTYPE_L 0
0026 (00038) |   | DSC$K_DTYPE_T 31
0029 (00041) |   | DSC$K_DTYPE_T 31
002C (00044) |   | DSC$K_DTYPE_Q 0
002E (00046) |   | DSC$K_DTYPE_Q 0
0030 (00048) |   BLR$K_MESSAGE 2 0
0034 (00052) |   BLR$K_MESSAGE 3 1
0038 (00056) |   | DSC$K_DTYPE_T 31
003B (00059) |   BLR$K_RECEIVE  3
003D (00061) |   | BLR$K_BEGIN
003E (00062) |   |   BLR$K_FOR
003F (00063) |   |   | BLR$K_RSE  2
0041 (00065) |   |   |   BLR$K_RELATION RDB$RELATION_FIELDS 1
0057 (00087) |   |   |   BLR$K_RELATION RDB$FIELDS 2
0064 (00100) |   |   |   BLR$K_BOOLEAN
0065 (00101) |   |   |   | BLR$K_AND
0066 (00102) |   |   |   |   BLR$K_EQL
0067 (00103) |   |   |   |   | BLR$K_FIELD 2 RDB$FIELD_NAME
0078 (00120) |   |   |   |   | BLR$K_FIELD 1 RDB$FIELD_SOURCE
008B (00139) |   |   |   |   BLR$K_EQL
008C (00140) |   |   |   |   | BLR$K_FIELD 1 RDB$RELATION_NAME
00A0 (00160) |   |   |   |   | BLR$K_PARAMETER 3 0
00A4 (00164) |   |   |   BLR$K_SORT  1
00A6 (00166) |   |   |   BLR$K_ASCENDING
00A7 (00167) |   |   |   | BLR$K_FIELD 1 RDB$FIELD_POSITION
00BC (00188) |   |   | BLR$K_END
00BD (00189) |   |   | BLR$K_BEGIN
00BE (00190) |   |   |   BLR$K_SEND  1
00C0 (00192) |   |   |   | BLR$K_BEGIN
00C1 (00193) |   |   |   |   BLR$K_ASSIGNMENT
00C2 (00194) |   |   |   |   | BLR$K_LITERAL
00C3 (00195) |   |   |   |   |   DSC$K_DTYPE_T 1  "N"
00C7 (00199) |   |   |   |   | BLR$K_PARAMETER 1 0
00CB (00203) |   |   |   |   BLR$K_ASSIGNMENT
00CC (00204) |   |   |   |   | BLR$K_FIELD 1 RDB$FIELD_NAME
00DD (00221) |   |   |   |   | BLR$K_PARAMETER 1 1
00E1 (00225) |   |   |   |   BLR$K_ASSIGNMENT
00E2 (00226) |   |   |   |   | BLR$K_FIELD 1 RDB$FIELD_POSITION
00F7 (00247) |   |   |   |   | BLR$K_PARAMETER 1 2
00FB (00251) |   |   |   |   BLR$K_ASSIGNMENT
00FC (00252) |   |   |   |   | BLR$K_FIELD 1 RDB$FIELD_ID
010B (00267) |   |   |   |   | BLR$K_PARAMETER 1 3
010F (00271) |   |   |   |   BLR$K_ASSIGNMENT
0110 (00272) |   |   |   |   | BLR$K_FIELD 1 RDB$QUERY_HEADER
0123 (00291) |   |   |   |   | BLR$K_PARAMETER 1 4
0127 (00295) |   |   |   |   BLR$K_ASSIGNMENT
0128 (00296) |   |   |   |   | BLR$K_FIELD 2 RDB$QUERY_HEADER
013B (00315) |   |   |   |   | BLR$K_PARAMETER 1 5
013F (00319) |   |   |   |   BLR$K_ASSIGNMENT
0140 (00320) |   |   |   |   | BLR$K_FIELD 1 RDB$EDIT_STRING
0152 (00338) |   |   |   |   | BLR$K_PARAMETER 1 6
0156 (00342) |   |   |   |   BLR$K_ASSIGNMENT
0157 (00343) |   |   |   |   | BLR$K_FIELD 2 RDB$EDIT_STRING
0169 (00361) |   |   |   |   | BLR$K_PARAMETER 1 7
016D (00365) |   |   |   |   BLR$K_ASSIGNMENT
016E (00366) |   |   |   |   | BLR$K_FIELD 2 RDB$FIELD_TYPE
017F (00383) |   |   |   |   | BLR$K_PARAMETER 1 8
0183 (00387) |   |   |   |   BLR$K_ASSIGNMENT
0184 (00388) |   |   |   |   | BLR$K_FIELD 2 RDB$FIELD_LENGTH
0197 (00407) |   |   |   |   | BLR$K_PARAMETER 1 9
019B (00411) |   |   |   |   BLR$K_ASSIGNMENT
019C (00412) |   |   |   |   | BLR$K_FIELD 2 RDB$FIELD_SCALE
01AE (00430) |   |   |   |   | BLR$K_PARAMETER 1 10
01B2 (00434) |   |   |   |   BLR$K_ASSIGNMENT
01B3 (00435) |   |   |   |   | BLR$K_FIELD 2 RDB$COMPUTED_BLR
01C6 (00454) |   |   |   |   | BLR$K_PARAMETER 1 11
01CA (00458) |   |   |   |   BLR$K_ASSIGNMENT
01CB (00459) |   |   |   |   | BLR$K_FIELD 2 RDB$SEGMENT_LENGTH
01E0 (00480) |   |   |   |   | BLR$K_PARAMETER 1 12
01E4 (00484) |   |   |   |   BLR$K_ASSIGNMENT
01E5 (00485) |   |   |   |   | BLR$K_FIELD 2 RDB$FIELD_SUB_TYPE
01FA (00506) |   |   |   |   | BLR$K_PARAMETER 1 13
01FE (00510) |   |   |   |   BLR$K_ASSIGNMENT
01FF (00511) |   |   |   |   | BLR$K_FIELD 1 RDB$QUERY_NAME
0210 (00528) |   |   |   |   | BLR$K_PARAMETER 1 14
0214 (00532) |   |   |   |   BLR$K_ASSIGNMENT
0215 (00533) |   |   |   |   | BLR$K_FIELD 2 RDB$QUERY_NAME
0226 (00550) |   |   |   |   | BLR$K_PARAMETER 1 15
022A (00554) |   |   |   |   BLR$K_ASSIGNMENT
022B (00555) |   |   |   |   | BLR$K_FIELD 1 RDB$DEFAULT_VALUE
023F (00575) |   |   |   |   | BLR$K_PARAMETER 1 16
0243 (00579) |   |   |   |   BLR$K_ASSIGNMENT
0244 (00580) |   |   |   |   | BLR$K_FIELD 2 RDB$DEFAULT_VALUE
0258 (00600) |   |   |   |   | BLR$K_PARAMETER 1 17
025C (00604) |   |   |   | BLR$K_END
025D (00605) |   |   | BLR$K_END
025E (00606) |   | BLR$K_END
025F (00607) |   BLR$K_SEND  1
0261 (00609) |   | BLR$K_BEGIN
0262 (00610) |   |   BLR$K_ASSIGNMENT
0263 (00611) |   |   | BLR$K_LITERAL
0264 (00612) |   |   |   DSC$K_DTYPE_T 1  "Y"
0268 (00616) |   |   | BLR$K_PARAMETER 1 0
026C (00620) |   | BLR$K_END
026D (00621) | BLR$K_END
026E (00622) BLR$K_EOC
0000 (00000) BLR$K_VERSION4
0001 (00001) | BLR$K_BEGIN
0002 (00002) |   BLR$K_MESSAGE 1 3
0006 (00006) |   | DSC$K_DTYPE_L 0
0008 (00008) |   | DSC$K_DTYPE_L 0
000A (00010) |   | DSC$K_DTYPE_L 0
000C (00012) |   BLR$K_MESSAGE 2 0
0010 (00016) |   BLR$K_MESSAGE 3 2
0014 (00020) |   | DSC$K_DTYPE_CHAR 12 (sub-type: 0)
0019 (00025) |   | DSC$K_DTYPE_CHAR 18 (sub-type: 0)
001E (00030) |   BLR$K_RECEIVE  3
0020 (00032) |   | BLR$K_BEGIN
0021 (00033) |   |   BLR$K_SEND  1
0023 (00035) |   |   | BLR$K_BEGIN
0024 (00036) |   |   |   BLR$K_ASSIGNMENT
0025 (00037) |   |   |   | BLR$K_LITERAL
0026 (00038) |   |   |   |   DSC$K_DTYPE_L 0  "100"
002C (00044) |   |   |   | BLR$K_PARAMETER 1 0
0030 (00048) |   |   |   BLR$K_FOR
0031 (00049) |   |   |   | BLR$K_RSE  1
0033 (00051) |   |   |   |   BLR$K_AGGREGATE 1
0035 (00053) |   |   |   |   | BLR$K_RSE  1
0037 (00055) |   |   |   |   |   BLR$K_RELATION NEGATIVE_CHECK 2
0048 (00072) |   |   |   |   |   BLR$K_BOOLEAN
0049 (00073) |   |   |   |   |   | BLR$K_AND
004A (00074) |   |   |   |   |   |   BLR$K_EQL
004B (00075) |   |   |   |   |   |   | BLR$K_FIELD 2 BANK_ROUTING_ID
005D (00093) |   |   |   |   |   |   | BLR$K_PARAMETER 3 0
0061 (00097) |   |   |   |   |   |   BLR$K_EQL
0062 (00098) |   |   |   |   |   |   | BLR$K_FIELD 2 ACCOUNT_ID
006F (00111) |   |   |   |   |   |   | BLR$K_PARAMETER 3 1
0073 (00115) |   |   |   |   | BLR$K_END
0074 (00116) |   |   |   |   | BLR$K_MAP  1
0076 (00118) |   |   |   |   |   0
0078 (00120) |   |   |   |   |   BLR$K_AGG_COUNT
0079 (00121) |   |   |   |   |   BLR$K_END
007A (00122) |   |   |   |   BLR$K_FIRST
007B (00123) |   |   |   |   | BLR$K_LITERAL
007C (00124) |   |   |   |   |   DSC$K_DTYPE_W 0  "2"
0080 (00128) |   |   |   | BLR$K_END
0081 (00129) |   |   |   | BLR$K_BEGIN
0082 (00130) |   |   |   |   BLR$K_IF
0083 (00131) |   |   |   |   | BLR$K_EQL
0084 (00132) |   |   |   |   |   BLR$K_LITERAL
0085 (00133) |   |   |   |   |   | DSC$K_DTYPE_L 0  "100"
008B (00139) |   |   |   |   |   BLR$K_PARAMETER 1 0
008F (00143) |   |   |   |   | BLR$K_BEGIN
0090 (00144) |   |   |   |   |   BLR$K_ASSIGNMENT
0091 (00145) |   |   |   |   |   | BLR$K_FIELD_ID 1 0
0095 (00149) |   |   |   |   |   | BLR$K_PARAMETER2 1 2 1
009B (00155) |   |   |   |   |   BLR$K_ASSIGNMENT
009C (00156) |   |   |   |   |   | BLR$K_LITERAL
009D (00157) |   |   |   |   |   |   DSC$K_DTYPE_L 0  "0"
00A3 (00163) |   |   |   |   |   | BLR$K_PARAMETER 1 0
00A7 (00167) |   |   |   |   | BLR$K_END
00A8 (00168) |   |   |   |   | BLR$K_BEGIN
00A9 (00169) |   |   |   |   |   BLR$K_ASSIGNMENT
00AA (00170) |   |   |   |   |   | BLR$K_LITERAL
00AB (00171) |   |   |   |   |   |   DSC$K_DTYPE_L 0  "-811"
00B1 (00177) |   |   |   |   |   | BLR$K_PARAMETER 1 0
00B5 (00181) |   |   |   |   | BLR$K_END
00B6 (00182) |   |   |   | BLR$K_END
00B7 (00183) |   |   | BLR$K_END
00B8 (00184) |   | BLR$K_END
00B9 (00185) | BLR$K_END
00BA (00186) BLR$K_EOC



---- End of Message ----
5096.3M5::LWILCOXChocolate in January!!Mon Mar 03 1997 14:488
Renee, one thing that's generally good to check in cases like this is the 
strategy of the failing query.  For example, if it fails using index retrieval
does it succeed with sequential?  That might make it "easier" for the customer
to reproduce.  If it uses a given index, does it help if the index is dropped
and debuilt?

Naturally if he happens to have the "before" strategy...but that would make
it too easy, wouldn't it?
5096.4index retrieval is the same in both instances.BROKE::BASTINEFri Mar 07 1997 10:0712
Hi Liz... thanks for the suggestion.

I had him send me debugs with "SO" and both the query as part of the whole
system that fails and the query he wrote to reproduce the problem but works,
both do an 

Index only retrieval of relation, using the same index with [2:2]
(Direct lookup)... no differences at all.

Any other places to try and track this down?

Renee
5096.5SORE output... any other suggestions??BROKE::BASTINEMon Mar 17 1997 12:58192
Someone suggested I ask for SORE debug output and I did.. I still don't see
anything that might help here.

What I know is it worked in 6.0A Eco 4, as soon as he upgraded to 6.0A Eco 5
it broke.

I'm not well versed in reading this debug output, but I didn't see anything
that might help... anyone else?  Here is the debug output of SORE of the
run that works... I will post the broken run in the next reply.

All suggestions welcome!

Thanks,
Renee


This file demonstrates the code and successful execution. The query was 
executed with interactive SQL. The correct information was returned. The 
query is shown below. This is the same query that is executed in the 
context of a full program with many other queries when it fails. The "SORE"
flag output for that failure will be in my next email message to you.

====================================================================
 -- This is the query that should show the negative_check bug.
 ---------------------------------------------------------------------------  
 ----
 -- check negative check account
 --
attach 'filename posdb';
declare :amount integer;
declare :bank_routing_id char(12);
declare :bank_account_id char(18);
begin
set :amount = -1;
set :bank_routing_id = '011000015';
set :bank_account_id = '0037427';
end;

 --PROCEDURE db_check_negative_check
 --    SQLCODE
 --    ,:amount            INTEGER
 --    ,:bank_routing_id   CHAR(12)
 --    ,:bank_account_id   CHAR(18)
 --    ;
    
    SELECT COUNT(*)
    INTO   :amount
    FROM   negative_check
    WHERE  bank_routing_id = :bank_routing_id
    AND    account_id = :bank_account_id
    ;

print 'If :amount = -1, then bug is demonstrated.';
print 'If :amount = 1, then bug failed to show itself.';
print 'Amount = ', :amount;
 ---------------------------------------------------------------------------  
 ---------------------------------
 -- "SORE" debug flags output

Solutions tried 3
Solutions blocks created 1
Created solutions pruned 0
Cost of the chosen solution      3.6720483E+00
Cardinality of chosen solution   4.3588991E+00
~S#0001
Leaf#01 FFirst RDB$RELATIONS Card=19
  BgrNdx1 RDB$REL_REL_NAME_NDX [1:1] Fan=8
~E#0001.01(1) BgrNdx1 EofData  DBKeys=1  Fetches=0+0  RecsOut=1 #Bufs=1
~E#0001.01(1) FgrNdx  FFirst   DBKeys=1  Fetches=0+1  RecsOut=1`ABA
~E#0001.01(1) Fin     Buf      DBKeys=1  Fetches=0+0  RecsOut=1
Solutions tried 18
Solutions blocks created 4
Created solutions pruned 0
Cost of the chosen solution      2.9052200E+02
Cardinality of chosen solution   2.2250000E+01
~S#0002
Sort
SortId# 1., # Keys 2
  Item# 1, Dtype: 2, Order: 0, Off: 0, Len: 1
  Item# 2, Dtype: 8, Order: 0, Off: 1, Len: 4
  LRL: 824, NoDups:0, Blks:197, EqlKey:0, WkFls: 2
Cross block of 2 entries
  Cross block entry 1
    Leaf#01 BgrOnly RDB$RELATION_FIELDS Card=712
      BgrNdx1 RDB$RFR_REL_NAME_FLD_ID_NDX [1:1] Fan=8
  Cross block entry 2
    Get     Retrieval by index of relation RDB$FIELDS
      Index name  RDB$FIELDS_NAME_NDX [1:1]  Direct lookup
~E#0002.01(1) BgrNdx1 EofData  DBKeys=2  Fetches=3+1  RecsOut=0 #Bufs=1
~E#0002.01(1) Fin     Buf      DBKeys=2  Fetches=0+1  RecsOut=2

SORT(1) SortId# 1, --------------------- Version: V5-000
  Records Input: 2      Sorted: 2       Output: 0
LogRecLen Input: 824    Intern: 826     Output: 824
Nodes in SoTree: 244    Init Dispersion Runs: 0
Max Merge Order: 0      Numb.of Merge passes: 0
Work File Alloc: 0
MBC for Input: 0        MBC for Output: 0
MBF for Input: 0        MBF for Output: 0
Big Allocated Chunk: 204288 busy
Solutions tried 3
Solutions blocks created 2
Created solutions pruned 0
Cost of the chosen solution      2.8349783E+00
Cardinality of chosen solution   1.0000000E+00
~S#0003
Firstn  Aggregate       Index only retrieval of relation NEGATIVE_CHECK
  Index name  NEGATIVE_CHECK_PK [2:2]    Direct lookup


The following binary file has been uuencoded to ensure successful
transmission.  Use UUDECODE to extract.

begin 600 winmail.dat
M>)\^(BH2`0:0"``$```````!``$``0>0!@`(````Y`0```````#H``$)@`$`
M(0```$,Y-S<Q,CA"1#`Y0D0P,3$Y141&,#`X,#5&1#1&0S=#`%('`06``P`.
M````S0<#``X`"@`W``4`!0`P`0$-@`0``@````(``@`!"(`'`!@```!)4$TN
M36EC<F]S;V9T($UA:6PN3F]T90`Q"`$$@`$`.````%1A<B`Y.#DV.3DT+C4@
M(E-/4D4B(&9L86=S(&]U='!U=#H@<W5C8V5S<V9U;"!E>&5C=71I;VX`61(!
M!)`&``@!```!````"````!X`(#H!````$````"=/<F%C;&4Z(%)E;F5E)P`+
M`$`Z``````,`%0P!````'@`!,`$````0````)T]R86-L93H@4F5N964G`!X`
M`S`!````%P```')B87-T:6YE0'5S+F]R86-L92YC;VT``!X``C`!````!0``
M`%--5%```````@$+,`$````<````4TU44#I20D%35$E.14!54RY/4D%#3$4N
M0T]-``(!_P\!````2P``````````8)1D8$&X`0@`*RN**0```````&0`&@`T
M`!<````4`"=/<F%C;&4Z(%)E;F5E)P!R8F%S=&EN94!U<RYO<F%C;&4N8V]M
M``"/,0$#D`8`?`H``!D````"`0LP`0```!````#)=Q*+T)O0$9[?`(!?U/Q\
M'@!P``$````G````(D(B(&9L86=S(&]U='!U=#H@<W5C8V5S<V9U;"!E>&5C
M=71I;VX```(!<0`!````(`````&\)_*U\4?]R@B3V1'0H.H`8(QHN*$`EOZR
MD@&6CU)#`P`N``````!``#D`T%(:.ZDPO`$#`/$_"00```(!1P`!````+P``
M`&,]55,[[email protected]`]5T$N1T]6.VP]34%$4D].02TY-S`S,30Q.#4U,#5:+3(V
M-S,```(!^3\!````20````````#<IT#(P$(0&K2Y"``K+^&"`0`````````O
M3SU702Y'3U8O3U4]5U-$3U0O0TX]4D5#25!)14Y44R]#3CU35$5"0DE.4P``
M```>`/@_`0````X```!3=&5B8FEN<R!'87)Y`````@'[/P$```!)````````
M`-RG0,C`0A`:M+D(`"LOX8(!`````````"]//5=!+D=/5B]/53U74T1/5"]#
M3CU214-)4$E%3E13+T-./5-414)"24Y3`````!X`^C\!````#@```%-T96)B
M:6YS($=A<GD```!```<P8--<&JDPO`%```@P`-H;.ZDPO`$+`",```````L`
M*0```````P`7``$````#`#8``````!X`&@`!````"0```$E032Y.3U1%````
M``(!"1`!````A0<``($'``"N$```3%I&=;YAYJW_``H!#P(5`J0#Y`7K`H,`
M4!,#5`(`8V@*P'-E=.XR!@`&PP*#,@/&!Q,"@Q(S$P]F-`]Z:&5LT0,@1&QG
M`H!]"H`(S\4)V3L7GS(U-0*`"H&##;$+8&YG,3`S%"#7"PH4(@P!<`-@=`60
M!4`V4@GP">`L"H4*A51HR00`(&8#$&4@#;`$8+$`@'1R81QP!"!T%B`6(`6@
M#;`@`'!D('.(=6-C!Y!S9G4#($1E>`60=71I`B`N"QWQ'H!Q"E!R>2!W7F$$
M("#T"8`B,&D?<"!/"X`<<!\0')!I=AZ`4_Q13"&$!:$7H!R1"X`"$-YR`,`A
M0B(S%Z!T"'`<X(9D(8H>(7-H;W<#H'YB%C`GP"&"'B$>(1]R<_YA!X`AU1]P
M'R`G8B*'"X#+'V4C<7@%0&]F'_`>0/\@P`,@'$$)P"E`(P0#@2(@OQQ@%B`%
MP"'B")`$('<6($\#H",@'D`+<&QS(80BO%-/"T82\@'0!_!%&U]M'&0B'D`+
M8&<KT"$P</\A,!Y`!;$IXR\""'`>@`/P]Q9!*``JXFTB(!S@*[$>L!\O$2U`
M(($RH!Z`=&\@3GD(8"&`'2PM9PK`>?HM"H4].)\YKSJ_.\XW5OXM*&LIB2>A
M(,`@(2>Q'V.W'.`WT"/27Q&P!9!K)_#X=6<N/-=!GT*O0[]$SW]%9SS80'0_
MYD<%`-`%H'4_`C`\UPJ%'R`!D!&P("<%'E)N*4)P;W-D8KPG.PJ%!8$+8#0A
M.BE`5TB2(U,V,')+3V(`<&O.7P-@(3$:H%]I("`1LO`H,3(I33].0TAE3PCV
M.$^W*`!G"X`*A1'Q3#=Z/3>P,4_&4Y-.3E10)\PP,1K`5L$Q-4LW51B'42E6
M8AK0-S0R-TLW#0GP9$_&/-=04D]#6$5$53#0'I!B0&1?#S_L/-A>$20A0T]$
M10U=BRQ,1F`924Y413A'15)>S4Y.7A!#2/Q!4D^"84]0_&,V4C!=BP=/QEX2
M9TE314Q%0Q)48T!/56#@*"HINV?J8-%/7A%,16=)1EN`SDU>$5RO9W972&$@
M6_"/)_!5?V(N9TE!3D1>$G]86V2^9TE:;1Q`(V%*,$G[*_!3VBP?8B?A0.`G
M8AZI_R:@2S=U#U1!=EHO`B+A-F&G/U,C(!'P;&9X#T%3]OXG=F!,14_&16]_
MOX#/@=__@N^#_T8>+[\PSS'9#;!Z8W\RD00@,M0=+`K[AL0<-U/?!O`A,Q]1
M"($@(#.*=8RHW0)@;T"@!"`%`&5WPGG0]8IU0X]%<XRW'$!(H"+A_PIV"%`>
M\"O2'W,GL!'P`Z`CD+9@%#,N-@'!-#CX,T4K5L"/Q@L1"X`'0`\C("V!*_"3
M#R`T+C-`[email protected]^K%,C5M**=4R/4&:9`#(Q:]!&:1'@'*%$0@(DAS!,
M051)3TZC!?"5DCTQ.6='0@G`6$YD>)H@FK5?G5)."$%-19W`1%@@6S`Q.C%=
M:]``<#TX]9AV19D#+E:03X!I@)R6.D4KX$0?("P0%F!"2_AE>7.;T&O!$@!`
M<:'`CC"4\%X0',!C<T\A,/&AT2-"=0/0F]"?'Z`B_D:<HVO!FE2A7Z)CH>&B
MY_!@04)!H_^E`RKQ7A+_HY%@%*9?HHV-OXU$4B"L_WV.S32/SY#?D>^6?V`3
M,J`N.3`U,@'0,)3AOC*5+Y8_D\2U(+5P-5;"_Y3AH^>8\[7FC*``(!V&NI+H
M260C>=`N=F"[L*L2:[409T=)''!MN[%V8$2QMO!P93JU$'9@3PL@>P20O@`P
MOC$-T+ZCF<!NW[X`C[:]!KXAO;4XOC]V44>_<["&7A!,4DS!03("-'9@3F]$
M=7!S,CJ^P4)LCP">@#DW,79@17%LJQ'$HE=K_D8O,+X!L)=*\*]U*](2(/\)
M\(U"!"!G1\<:R"(B()H@QV=)F<:<D4]N;"(@FKJH7T9):+!$FW4W3Y`O9TF<
M?6O@G8A&S2!?2;_08)XOR,_)UA(@9TE'4Z'W7A(<P(U"=@=`)_`G42`0_R#P
M*](7H`M@):.:LLSTS>O^2=6#2I/6B9W.%F":8!R"^1<P;VO$<!V&GX2U(*`/
M]Z$;$B"KAS.GBH<0HX_;^9^I[]V_IVRUYJZ&3U)I4)_<<;M7=F"$;^;B(%8$
MD,<`D`(@O@!6-2U6P6='^Z+A!;!D!"#8`#,!O@%@%/^ZD@F`ZE>^0#+COJ&9
M5BR@_Z+AOW'I]L/QU\0C@;^1P_#^-NN;P_&*=<1`#;`HH0.@[8R@5`G1O@$T
M[A4NT=IP?G.]X.@C!_!(H,9A"G9->F&ED$T$D#8QOE9@%$[Z=0;0+BOA]"2*
MH`00!Y"][$A7!;!`L)I0'G%!%D#SCN#S24)#,S/J!?3U7A#W^-;K[OC01OD/
M^A3[].ONG$)I,K#WXX]C0VA(H#9KO@&4H#*7X$#!<WG_KH^-3Z\OCV/&F+$O
MLC^S3_NT793`-,5`E,^VKY-JG^&?#&28/P)&FE.3X4%G%_'_0`'8D=>Y'M#+
M\28QU-75VG9.80";(5:>`&-0:-!+1[R8V!D1_%]02]#@,KPZ,MI!VE\=.QH1
M`!?0`````P`&$,)88"L#``<010H``!X`"!`!````90```%)%3D5%+%1(25-&
M24Q%1$5-3TY35%)!5$535$A%0T]$14%.1%-50T-%4U-&54Q%6$5#551)3TY4
M2$51545265=!4T5814-55$5$5TE42$E.5$5204-4259%4U%,5$A%0T]24D4`
M`````P`0$``````#`!$0`````!X`-P`!````.````%1A<B`Y.#DV.3DT+C4@
L(E-/4D4B(&9L86=S(&]U='!U=#H@<W5C8V5S<V9U;"!E>&5C=71I;VX`L[`@
`
end


---- End of Message ----
5096.6Debug output of broken runBROKE::BASTINEMon Mar 17 1997 12:59274
The query in question is executed as part of a number of queries. The
>"SORE" flag output below is the complete output from the program run. The
>query execution should be near the end. There is a matching record, but "EOS"
>is returned.
>-----------------------------------
>PROCEDURE db_check_negative_check
>    SQLCODE
>    ,:amount            INTEGER
>    ,:bank_routing_id   CHAR(12)
>    ,:bank_account_id   CHAR(18)
>    ;
>    
>    SELECT COUNT(*) 
>    INTO   :amount
>    FROM   negative_check
>    WHERE  bank_routing_id = :bank_routing_id
>    AND    account_id = :bank_account_id
>    ;
>-------------------------------------------------------------------
>Solutions tried 2
>Solutions blocks created 1
>Created solutions pruned 0
>Cost of the chosen solution      2.0434957E+00
>Cardinality of chosen solution   1.0000000E+00
>~S#0001
>Firstn  Get     Retrieval by index of relation TERMINAL
>  Index name  TERMINAL_PK [1:1]  Direct lookup 
>Solutions tried 2
>Solutions blocks created 2
>Created solutions pruned 1
>Cost of the chosen solution      1.7226965E+01
>Cardinality of chosen solution   1.5500000E+02
>~S#0002
>Get     Retrieval sequentially of relation SALES_KEYBOARD 
>Solutions tried 2
>Solutions blocks created 1
>Created solutions pruned 0
>Cost of the chosen solution      2.5591097E+00
>Cardinality of chosen solution   5.0781250E-01
>~S#0003
>Firstn  Get     Retrieval by index of relation TERMINAL_SALES_DATE
>  Index name  TERMINAL_SALES_DATE_PK [2:2]       Direct lookup 
>Solutions tried 3
>Solutions blocks created 1
>Created solutions pruned 0
>Cost of the chosen solution      1.2797029E+01
>Cardinality of chosen solution   5.4394532E-02
>~S#0004
>Firstn 
>Leaf#01 FFirst SHIFT Card=557
>  BgrNdx1 SHIFT_AK [2:2] Fan=8
>~E#0004.01(1) BgrNdx1 Termin*  DBKeys=1  Fetches=3+0  RecsOut=1`CUT
>~E#0004.01(1) FgrNdx  FFirst   DBKeys=1  Fetches=0+1  RecsOut=1`CUT`ABA
>Solutions tried 30
>Solutions blocks created 8
>Created solutions pruned 3
>Cost of the chosen solution      3.5745415E+01
>Cardinality of chosen solution   2.1928826E-01
>~S#0005
>Firstn  Conjunct        Aggregate 
>Cross block of 2 entries 
>  Cross block entry 1 
>    Conjunct        Index only retrieval of relation SALES_TRANSACTION
>      Index name  SALES_TRANSACTION_AK2 [1:1]
>  Cross block entry 2 
>    Leaf#01 BgrOnly PAYMENT_LOG Card=41293
>      BgrNdx1 PAYMENT_LOG_AK1 [2:2] Fan=13
>~E#0005.01(1) BgrNdx1 EofData  DBKeys=0  Fetches=3+0  RecsOut=0 #Bufs=0
>Solutions tried 3
>Solutions blocks created 2
>Created solutions pruned 0
>Cost of the chosen solution      6.7560358E+00
>Cardinality of chosen solution   1.0000000E+00
>~S#0006
>Firstn  Aggregate 
>Leaf#01 BgrOnly CASH_PICKUP Card=224
>  BgrNdx1 CASH_PICKUP_PK [1:1] Fan=13
>~E#0006.01(1) BgrNdx1 EofData  DBKeys=0  Fetches=2+0  RecsOut=0 #Bufs=0
>Solutions tried 1824
>Solutions blocks created 141
>Created solutions pruned 76
>Cost of the chosen solution      2.1744009E+02
>Cardinality of chosen solution   1.7187501E-01
>~S#0007
>Sort 
>SortId# 1., # Keys 6
>  Item# 1, Dtype: 2, Order: 0, Off: 0, Len: 1
>  Item# 2, Dtype: 8, Order: 0, Off: 1, Len: 4
>  Item# 3, Dtype: 2, Order: 0, Off: 5, Len: 1
>  Item# 4, Dtype: 8, Order: 0, Off: 6, Len: 4
>  Item# 5, Dtype: 2, Order: 0, Off: 10, Len: 1
>  Item# 6, Dtype: 35, Order: 0, Off: 11, Len: 8
>  LRL: 224, NoDups:0, Blks:44, EqlKey:0, WkFls: 2
>Cross block of 5 entries 
>  Cross block entry 1 
>    Leaf#01 BgrOnly TERMINAL_ROUTE Card=22
>      BgrNdx1 TERMINAL_ROUTE_PK [1:1] Fan=14
>  Cross block entry 2 
>    Index only retrieval of relation ROUTE
>      Index name  ROUTE_PK [1:1]     Direct lookup 
>  Cross block entry 3 
>    Get     Retrieval by index of relation SALES_DATE
>      Index name  SALES_DATE_PK [1:1]        Direct lookup 
>  Cross block entry 4 
>    Conjunct 
>    Leaf#02 BgrOnly SAILING_SCHEDULE Card=1523
>      BgrNdx1 SAILING_SCHEDULE_AK [3:3] Bool Fan=9
>  Cross block entry 5 
>    Conjunct        Index only retrieval of relation SCHEDULE_DAY_TYPE
>      Index name  SCHEDULE_DAY_TYPE_PK [1:1]         Direct lookup 
>~E#0007.01(1) BgrNdx1 EofData  DBKeys=4  Fetches=1+0  RecsOut=0 #Bufs=1
>~E#0007.02(1) BgrNdx1 EofData  DBKeys=14  Fetches=2+0  RecsOut=0 #Bufs=2
>~E#0007.02(1) Fin     Buf      DBKeys=14  Fetches=0+3  RecsOut=14
>~E#0007.02(2) BgrNdx1 EofData  DBKeys=4  Fetches=0+0  RecsOut=0 #Bufs=3
>~E#0007.02(2) Fin     Buf      DBKeys=4  Fetches=0+2  RecsOut=4
>~E#0007.02(3) BgrNdx1 EofData  DBKeys=8  Fetches=1+0  RecsOut=0 #Bufs=1
>~E#0007.02(3) Fin     Buf      DBKeys=8  Fetches=0+0  RecsOut=8
>~E#0007.02(4) BgrNdx1 EofData  DBKeys=24  Fetches=0+0  RecsOut=0 #Bufs=1
>~E#0007.02(4) Fin     Buf      DBKeys=24  Fetches=0+1  RecsOut=24
>~E#0007.01(1) Fin     Buf      DBKeys=4  Fetches=0+1  RecsOut=4
>
>SORT(1) SortId# 1, --------------------- Version: V5-000
>  Records Input: 50     Sorted: 50      Output: 0
>LogRecLen Input: 224    Intern: 226     Output: 224
>Nodes in SoTree: 186    Init Dispersion Runs: 0
>Max Merge Order: 0      Numb.of Merge passes: 0
>Work File Alloc: 0
>MBC for Input: 0        MBC for Output: 0
>MBF for Input: 0        MBF for Output: 0
>Big Allocated Chunk: 0 idle
>Solutions tried 340
>Solutions blocks created 35
>Created solutions pruned 24
>Cost of the chosen solution      2.1629607E+02
>Cardinality of chosen solution   6.8750000E-01
>~S#0008
>Sort 
>SortId# 2., # Keys 4
>  Item# 1, Dtype: 2, Order: 0, Off: 0, Len: 1
>  Item# 2, Dtype: 8, Order: 0, Off: 1, Len: 4
>  Item# 3, Dtype: 2, Order: 0, Off: 5, Len: 1
>  Item# 4, Dtype: 8, Order: 0, Off: 6, Len: 4
>  LRL: 176, NoDups:0, Blks:35, EqlKey:0, WkFls: 2
>Cross block of 3 entries 
>  Cross block entry 1 
>    Leaf#01 BgrOnly TERMINAL_ROUTE Card=22
>      BgrNdx1 TERMINAL_ROUTE_PK [1:1] Fan=14
>  Cross block entry 2 
>    Conjunct        Conjunct 
>    Leaf#02 BgrOnly TERMINAL_ROUTE_FARE Card=1308
>      BgrNdx1 TERMINAL_ROUTE_FARE_AK1 [2:2] Bool Fan=12
>  Cross block entry 3 
>    Get     Retrieval by index of relation FARE_TYPE
>      Index name  FARE_TYPE_PK [1:1]         Direct lookup 
>~E#0008.01(1) BgrNdx1 EofData  DBKeys=4  Fetches=0+0  RecsOut=0 #Bufs=1
>~E#0008.02(1) BgrNdx1 EofData  DBKeys=66  Fetches=2+0  RecsOut=0 #Bufs=4
>~E#0008.02(1) Fin     Buf      DBKeys=66  Fetches=0+3  RecsOut=66
>~E#0008.02(2) BgrNdx1 EofData  DBKeys=29  Fetches=0+0  RecsOut=0 #Bufs=2
>~E#0008.02(2) Fin     Buf      DBKeys=29  Fetches=0+1  RecsOut=29
>~E#0008.02(3) BgrNdx1 EofData  DBKeys=29  Fetches=0+1  RecsOut=0 #Bufs=2
>~E#0008.02(3) Fin     Buf      DBKeys=29  Fetches=0+1  RecsOut=29
>~E#0008.02(4) BgrNdx1 EofData  DBKeys=66  Fetches=0+0  RecsOut=0 #Bufs=4
>~E#0008.02(4) Fin     Buf      DBKeys=66  Fetches=0+0  RecsOut=66
>~E#0008.01(1) Fin     Buf      DBKeys=4  Fetches=0+0  RecsOut=4
>
>SORT(2) SortId# 2, --------------------- Version: V5-000
>  Records Input: 190    Sorted: 190     Output: 0
>LogRecLen Input: 176    Intern: 178     Output: 176
>Nodes in SoTree: 192    Init Dispersion Runs: 0
>Max Merge Order: 0      Numb.of Merge passes: 0
>Work File Alloc: 0
>MBC for Input: 0        MBC for Output: 0
>MBF for Input: 0        MBF for Output: 0
>Big Allocated Chunk: 0 idle
>Solutions tried 1
>Solutions blocks created 1
>Created solutions pruned 0
>Cost of the chosen solution      3.0000000E+00
>Cardinality of chosen solution   1.0000000E+00
>~S#0009
>Firstn  Get     Retrieval sequentially of relation SYSTEM_WIDE 
>Solutions tried 1
>Solutions blocks created 1
>Created solutions pruned 0
>Cost of the chosen solution      3.0000000E+00
>Cardinality of chosen solution   1.0000000E+00
>~S#0010
>Firstn  Get     Retrieval sequentially of relation SALES_TRANSACTION_CONTROL 
>Solutions tried 1
>Solutions blocks created 1
>Created solutions pruned 0
>Cost of the chosen solution      3.0000000E+00
>Cardinality of chosen solution   1.0000000E+00
>~S#0011
>Get     Retrieval sequentially of relation SALES_TRANSACTION_CONTROL 
>~S#0012
>Conjunct        Firstn  Get 
>Retrieval by DBK of relation SALES_TRANSACTION_CONTROL 
>Solutions tried 3
>Solutions blocks created 2
>Created solutions pruned 0
>Cost of the chosen solution      2.8349783E+00
>Cardinality of chosen solution   1.0000000E+00
>~S#0013
>Firstn  Aggregate       Index only retrieval of relation NEGATIVE_CHECK
>  Index name  NEGATIVE_CHECK_PK [2:2]    Direct lookup 
>~S#0014
>Conjunct        Firstn  Get     Retrieval by DBK of relation
>SALES_TRANSACTION 
>~S#0015
>Conjunct        Firstn  Get     Retrieval by DBK of relation
>SALES_TRANSACTION 
>~S#0016
>Conjunct        Firstn  Get     Retrieval by DBK of relation
>SALES_TRANSACTION 
>~S#0017
>Conjunct        Firstn  Get     Retrieval by DBK of relation
>SALES_TRANSACTION 
>~S#0018
>Conjunct        Firstn  Get     Retrieval by DBK of relation
>SALES_TRANSACTION 
>~S#0019
>Conjunct        Firstn  Get     Retrieval by DBK of relation
>SALES_TRANSACTION 
>~S#0020
>Conjunct        Firstn  Get     Retrieval by DBK of relation
>SALES_TRANSACTION 
>~S#0021
>Conjunct        Firstn  Get     Retrieval by DBK of relation
>SALES_TRANSACTION 
>~S#0022
>Conjunct        Firstn  Get     Retrieval by DBK of relation TICKET_LOG 
>~S#0023
>Conjunct        Firstn  Get     Retrieval by DBK of relation TICKET_LOG 
>~S#0024
>Conjunct        Firstn  Get     Retrieval by DBK of relation TICKET_LOG 
>~S#0025
>Conjunct        Firstn  Get     Retrieval by DBK of relation TICKET_LOG 
>~S#0026
>Conjunct        Firstn  Get     Retrieval by DBK of relation TICKET_LOG 
>~S#0027
>Conjunct        Firstn  Get     Retrieval by DBK of relation TICKET_LOG 
>~S#0028
>Conjunct        Firstn  Get     Retrieval by DBK of relation TICKET_LOG 
>~S#0029
>Conjunct        Firstn  Get     Retrieval by DBK of relation TICKET_LOG 
>~S#0030
>Conjunct        Firstn  Get     Retrieval by DBK of relation PAYMENT_LOG 
>~S#0031
>Conjunct        Firstn  Get     Retrieval by DBK of relation PAYMENT_LOG 
>~S#0032
>Conjunct        Firstn  Get     Retrieval by DBK of relation PAYMENT_LOG 
>~S#0033
>Conjunct        Firstn  Get     Retrieval by DBK of relation PAYMENT_LOG 
>~S#0034
>Conjunct        Firstn  Get     Retrieval by DBK of relation PAYMENT_LOG 
>~S#0035
>Conjunct        Firstn  Get     Retrieval by DBK of relation PAYMENT_LOG 
>~S#0036
>Conjunct        Firstn  Get     Retrieval by DBK of relation CHECK_LOG 
>~S#0037
>Conjunct        Firstn  Get     Retrieval by DBK of relation CHECK_LOG 
>~S#0038
>Conjunct        Firstn  Get     Retrieval by DBK of relation CHECK_LOG 
>~S#0039
>Conjunct        Firstn  Get     Retrieval by DBK of relation CHECK_LOG 
>~S#0040
>Conjunct        Firstn  Get     Retrieval by DBK of relation CHECK_LOG 
>~S#0041
>Conjunct        Firstn  Get     Retrieval by DBK of relation CHECK_LOG 
>~S#0042
>Conjunct        Firstn  Get     Retrieval by DBK of relation CHECK_LOG 
>
5096.7NOVA::SMITHIDon&#039;t understate or underestimate Rdb!Mon Mar 17 1997 15:589
I have no idea why you get so much output from a simple SELECT statement.

Can you not isolate the query and execute it without all the rest of the log? 
I have no idea what to look at.

Are they saying that SELECT COUNT (*) INTO is not modifying the output
parameter?  If so please provide a simpler example.

Ian
5096.8Just trying to pinpoint possibilities... BROKE::BASTINEMon Mar 17 1997 19:4927
I'm sorry Ian.  They are saying that this same procedure produces the 
wrong number of rows when run as part of a program that runs many other
things.  He took the procedure out of the "environment" and it produces the
correct result.  There is something that occurs when this is run along with
all their other queries that messes things up to produce inaccurate results.

The thing is, this code always worked until they upgraded to Eco 5.  

From what I gather, the logs I have posted all lead up to the search on
index NEGATIVE_CHECK_PK.  It appears that in both the run where it produces
the correct results and the run where it produces an inaccurate result both
choose the same lookup path for that index.  The bigger log is the run that 
produces inaccurate results, but keep in mind, what precedes it are other 
queries that run as part of their "system".  The customer is well aware that 
we can't do anything without a reproducible case and also knows he can't
send us his system.  He tried to create a reproducible case by running the
failing procedure alone, and it doesn't fail alone.  Right now I am looking
for clues on how we can help him determine where the problem might lie so
that we can get a small reproducible case for you.

Nothing I tried so far has helped us pinpoint what might be causing the 
procedure to fail in his environment when it works alone, and USED to work
prior to ECO 5.

Thanks!

Renee