StatementCallback; SQL [SELECT T01."FIITMN", T01."FIPCKI", T01."FISZEI", T01."FIBRDN", T02."FJVINB", T01."FIIDE1", T01."FIIDE2", T01."FIUPCN", T01."FIUPCC", T01."FIUPCP", T01."FIUPCU", T01."FISVPC", T01."FIUNMC", T02."FJTXIT", T02."FJBCCD", T02."FJBCUP", T02."FJITMS", T02."FJCLSN", T04."FBSDSC", T02."FJPBHN", T03."EBPNME", T02."FJQOHH", T02."FJQOBC", T02."FJWTQC", T01."FICMPN", T03."EBCMPN" FROM HSDATA."FIITMAP" T01 left outer join HSDATA."FJITMBP" T02 ON T01."FICMPN"=T02."FJCMPN" AND T01."FIITMN"=T02."FJITMN" left outer join HSDATA."EBPBHAP" T03 ON T02."FJPBHN"=T03."EBPBHN" left outer join HSDATA."FBCLSAP" T04 ON T02."FJCLSN"=T04."FBCLSN" AND T01."FICMPN"=T04."FBCMPN" WHERE (T01."FIITMN"='369520') ORDER BY T01."FIITMN" ASC fetch first 2 rows only]; Communication link failure. (Connection was dropped unexpectedly.); nested exception is java.sql.SQLException: Communication link failure. (Connection was dropped unexpectedly.)
FB Item # |
|
Pack |
|
Size |
|
Item brand |
|
Vendor item # |
|
Item description |
|
Item description-more |
|
Upc number - item |
|
Upc number - case |
|
Upc number - package |
|
Upc number - unit |
|
Servings per case |
|
Servings per case unit |
|
Taxable item code |
|
Split case code |
|
Split case upcharge prct |
|
Subsitute FB Item # |
|
Class code |
|
Class description |
|
PBH # |
|
Price book description |
|
Case qty on hand |
|
B/case qty on hand |
|
C/wgt on hand |
|