DumpLoad creates RECNUM column for Standard table
DumpLoad for MSSQL creates a recnum column in the FMT file.
Code:
7.0
19
1 SQLCHAR 0 8 "\0" 1 "Recnum"
2 SQLCHAR 0 20 "\0" 2 "PONUM"
3 SQLCHAR 0 6 "\0" 3 "VENDNO"
4 SQLCHAR 0 23 "\0" 4 "CREATE_DATE"
5 SQLCHAR 0 23 "\0" 5 "XFER_DATE"
6 SQLCHAR 0 6 "\0" 6 "MAXLI"
7 SQLCHAR 0 15 "\0" 7 "TERMS"
8 SQLCHAR 0 15 "\0" 8 "SHIP_VIA"
9 SQLCHAR 0 10 "\0" 9 "SHIPDATE"
10 SQLCHAR 0 3 "\0" 10 "BUYER"
11 SQLCHAR 0 11 "\0" 11 "TOTQTY"
12 SQLCHAR 0 9 "\0" 12 "TOTCUBES"
13 SQLCHAR 0 9 "\0" 13 "TOTWGT"
14 SQLCHAR 0 11 "\0" 14 "TOTPRICE"
15 SQLCHAR 0 15 "\0" 15 "STATUS"
16 SQLCHAR 0 1 "\0" 16 "BOSTATUS"
17 SQLCHAR 0 23 "\0" 17 "LAST_UPDATE"
18 SQLCHAR 0 20 "\0" 18 "UPDATED_BY"
19 SQLCHAR 0 16384 "\0" 19 "NOTES"
Running BCP generates the following error
SQLState = S1002, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Invalid Descriptor Index
I think this error is telling me the columns do not match the data.
VDF 16.1
CK 5.1.0.83
Chuck Atkinson
"No matter how confounding the case, Bob Worsley always finds the quaesitum."