Hi
When attempting an insert to a table running ACu4gl against MS SQL Server
we are getting a 9D00 Restricted data type attribute violation
File trace 9 shows
03/26/18 16:03:41 CARRNOTE.DAT: write (thread 1203)
03/26/18 16:03:41 mssql_write, 2414
03/26/18 16:03:41 A46
03/26/18 16:03:41 A47
03/26/18 16:03:41 Stored procedure CARRNOTE_insert was not found in VWFSAUS_USER_JIM_PROD
03/26/18 16:03:41 Preparing SQL on statement 60a3f8 on server 'NSSRVSQL009':
03/26/18 16:03:41 <SQL
03/26/18 16:03:41 insert into VWFSAUS_USER_JIM_PROD.CALMS2CMS_SCHEMA.CARRNOTE (carr_note_key_source,
03/26/18 16:03:41 carr_note_key_num,
03/26/18 16:03:41 carr_note_tran_no,
03/26/18 16:03:41 carr_note_date,
03/26/18 16:03:41 carr_note_time,
03/26/18 16:03:41 carr_note_text)
03/26/18 16:03:41 values
03/26/18 16:03:41 (?, ?, ?, ?, ?, ?)
03/26/18 16:03:41 EndSQL>
03/26/18 16:03:41 bind_parameter_of_field(1, 02048654, 0)
03/26/18 16:03:41 describe_field 0
03/26/18 16:03:41 Leaving: IT:0, VT:1, PT:1, CS:1, D:0, PV:00000000, BL:1, PBL:02048164
03/26/18 16:03:41 Leaving: VT:1, PT:1, CS:1, D:0, PV:00000000, BL:1, PBL:02048164
03/26/18 16:03:41 bind_parameter_of_field(2, 02048654, 1)
03/26/18 16:03:41 describe_field 1
03/26/18 16:03:41 Leaving: IT:0, VT:1, PT:4, CS:10, D:0, PV:020481C4, BL:35, PBL:020481FC
03/26/18 16:03:41 Leaving: VT:1, PT:4, CS:10, D:0, PV:020481C4, BL:35, PBL:020481FC
03/26/18 16:03:41 bind_parameter_of_field(3, 02048654, 2)
03/26/18 16:03:41 describe_field 2
03/26/18 16:03:41 Leaving: IT:0, VT:1, PT:4, CS:10, D:0, PV:0204825C, BL:35, PBL:02048294
03/26/18 16:03:41 Leaving: VT:1, PT:4, CS:10, D:0, PV:0204825C, BL:35, PBL:02048294
03/26/18 16:03:41 bind_parameter_of_field(4, 02048654, 3)
03/26/18 16:03:41 describe_field 3
03/26/18 16:03:41 Leaving: IT:0, VT:93, PT:4, CS:10, D:0, PV:020482F4, BL:35, PBL:0204832C
03/26/18 16:03:41 Leaving: VT:93, PT:4, CS:10, D:0, PV:020482F4, BL:35, PBL:0204832C
03/26/18 16:03:41 report_status called from 9707
03/26/18 16:03:41 [1] 07006 0 - Restricted data type attribute violation
03/26/18 16:03:41 No more messages
03/26/18 16:03:41 Leaving, BindParameter 4
03/26/18 16:03:41 *** File system error value = 0 ***
03/26/18 16:03:41 *** Restricted data type attribute violation ***
03/26/18 16:03:41 >>>file status = 9D
