Attempting to do a SQL insert of a record from SQL7 through ODBC to
Image/SQL database on Hp3000 5.5 pp7 and get the following error. Below the
errors are the HP3000 table definitions. Does anyone have any ideas?
Thanks in advance for any help,
Stoney Ratliff
===========================From PC =======================================
Error: -2147467259.
Desc: [ODBCLINK Host][Allbase]IMAGE/SQL error 154; TurboIMAGE error 101;
TurboIMAGE intrinsic 407, & Auxiliary error 0. (DBERR 13552).
Location: ProcessSQL in modODBCCommunication.
HPSQL string (single quotes replaced with double quotes):
INSERT INTO SDPTRN.DDSTDTRN (TRNSCD, EMPNUM, CREWCD, DPTNUM, LOTNO,
MACHNUM, QUALCD, REASONCD, WSTLOT, DESTIN, PKGTYP, NUMPKG, BGYTAR,
GRWGHT, DTDOFF, NETWGT, TRANDT, TRANTM, TERMNO, DPTLOT, XMITCD)
VALUES (' ', '0111', ' Z', ' 332', '010015', '12 ',
'1 ', '23', '000000',
' 330', '14',
+020, +00100, +00730, '0000', +00604,
'001130', '0820',
'0000', '0332010015', 'AA')
=================from HP3000===========================================
This is the dictionary definition of the dataset
DDSTDTRN DETL
ELEMENT(ALIAS): PROPERTIES: ELEMENT(PRIMARY):
TRNSCD X (1,0,2) TRNSCD
EMPNUM X (4,0,4) EMPNUM
CREWCD X (1,0,2) CREWCD
DPTNUM X (3,0,4) DPTNUM
LOTNO X (6,0,6) LOTNO
MACHNUM 9 (3,0,4) MACHNUM
QUALCD X (1,0,2) QUALCD
REASONCD X (2,0,2) REASONCD
WSTLOT X (6,0,6) WSTLOT
DESTIN X (3,0,4) DESTIN
PKGTYP X (2,0,2) PKGTYP
NUMPKG Z (4,0,4) NUMPKG
BGYTAR Z (6,0,6) BGYTAR
GRWGHT Z (6,0,6) GRWGHT
DTDOFF X (3,0,4) DTDOFF
NETWGT Z (6,0,6) NETWGT
TRANDT 9 (6,0,6) TRANDT
TRANTM 9 (4,0,4) TRANTM
TERMNO X (4,0,4) TERMNO
DPTLOT * X (9,0,10) DPTLOT
CHAIN MASTER SET: !DMSTDLOT
XMITCD X (2,0,2) XMITCD
This is the Image schema for the dataset
SET NAME:
DDSTDTRN,DETAIL
ITEMS:
TRNSCD, X2
EMPNUM, X4
CREWCD, X2
DPTNUM, X4
LOTNO, X6
MACHNUM, X4
QUALCD, X2
REASONCD, X2
WSTLOT, X6
DESTIN, X4
PKGTYP, X2
NUMPKG, Z4
BGYTAR, Z6
GRWGHT, Z6
DTDOFF, X4
NETWGT, Z6
TRANDT, X6
TRANTM, X4
TERMNO, X4
DPTLOT, X10 <<SEARCH ITEM>>
XMITCD, X2
|