Any clue what would cause this?
PRMILLNBR is getting passed twice as you can see, so there are 10 values when 9 are needed.
This results in error:
SQL0313N: The number of host variables in the EXECUTE or OPEN statement is not equal to the number of values required.
************************** DEBUG INFO ***********************
Command #: 1
Timestamp: 2008-01-10 18:12:12.559
General Command Settings
Command Type: Text
Object Type: DDTek.DB2.DB2Command
Connection String: Database=S1094B1B;User ID=QSECOFR;Server=192.168.42.100:446
Transaction: False
Command Settings
CommandText: INSERT INTO "SIGMA"."INSTYPRPF" ("PRMILLNBR", "PRSTYLNBR", "PRUNITMEAS", "PRSIZECODE", "PRCUTCOST", "PRROLLCOST", "PRCUTRETL", "PRROLLRETL", "PRROWVERSION") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Command Parameters
P0: '1' [DbType: Decimal | Size: 0 | Direction: Input | SourceColumn: PRMILLNBR | SourceVersion: Current]
P1: '2' [DbType: Decimal | Size: 0 | Direction: Input | SourceColumn: PRSTYLNBR | SourceVersion: Current]
P2: '' [DbType: StringFixedLength | Size: 3 | Direction: Input | SourceColumn: PRUNITMEAS | SourceVersion: Current]
P3: '' [DbType: StringFixedLength | Size: 3 | Direction: Input | SourceColumn: PRSIZECODE | SourceVersion: Current]
P4: '1' [DbType: Decimal | Size: 0 | Direction: Input | SourceColumn: PRCUTCOST | SourceVersion: Current]
P5: '0' [DbType: Decimal | Size: 0 | Direction: Input | SourceColumn: PRROLLCOST | SourceVersion: Current]
P6: '2' [DbType: Decimal | Size: 0 | Direction: Input | SourceColumn: PRCUTRETL | SourceVersion: Current]
P7: '0' [DbType: Decimal | Size: 0 | Direction: Input | SourceColumn: PRROLLRETL | SourceVersion: Current]
P8: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: PRROWVERSION | SourceVersion: Current]
P9: '1' [DbType: Decimal | Size: 0 | Direction: Input | SourceColumn: PRMILLNBR | SourceVersion: Current]
Keith Chisarik