Turboimage error 101 is 'missing chainhead' path 1.
> -----Original Message-----
> From: Stoney Ratliff [mailto:[log in to unmask]]
> Sent: Wednesday, December 06, 2000 8:52 AM
> To: [log in to unmask]
> Subject: ODBC insert to Image/Sql error 154
>
>
> 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
>
|