Re: How do I track the field number from a SQL script?

Glen

You asked.

-----
Insert into kbm_ada.db2_LND_MasterItem
(

-- 1
DSN ,
-- 2
ORG_ID ,
-- 3
ITEM_NUMBER ,
-- 4
KEYDESCRIPTION1,
-- 5
KEY1 ,
-- 6
KEYDESCRIPTION2 ,
-- 7
KEY2 ,
-- 8
KEYDESCRIPTION3 ,
-- 9
KEY3 ,
-- 10
ITEM_ORGANIZATION_CODE,
-- 11
INVENTORY_ITEM_NUMBER ,
-- 12
ITEM_ID ,
-- 13
ITEM_NAME ,
-- 14
DESCRIPTION ,
-- 15
PRIMARY_UOM_CODE ,
-- 16
ITEM_TYPE_CODE ,
-- 17
CONSUMPTION_UOM_CODE ,
-- 18
STORAGE_UOM_CODE ,
-- 19
LAST_COUNT_DATE ,
-- 20
LAST_FIXED_COST_ROLLUP_DATE,
-- 21
LAST_CURRENT_COST_ROLLUP_DATE,
-- 22
LAST_CURRENT_TO_FIXED_ROLLOVER,
-- 23
FAMILY_PART_NUMBER ,
-- 24
LOW_LEVEL_NUMBER ,
-- 25
REVISION ,
-- 26
LONG_DESCRIPTION ,
-- 27
MASTER_ORGANIZATION ,
-- 28
PLANNING_MAKE_BUY_CODE ,
-- 29
TEMPLATE_NAME ,
-- 30
PLANNER_CODE ,
-- 31
HAZARD_CLASS ,
-- 32
WEIGHT_UOM_CODE ,
-- 33
UNIT_WEIGHT ,
-- 34
VOLUME_UOM_CODE ,
-- 35
UNIT_VOLUME ,
-- 36
DIMENSION_UOM_CODE ,
-- 37
UNIT_HEIGHT ,
-- 38
UNIT_LENGTH ,
-- 39
UNIT_WIDTH ,
-- 40
ENG_DRAWING_NUMBER ,
-- 41
SYSTEM_OF_RECORD ,
-- 42
TRANSACTION_TYPE ,
-- 43
WINDCHILL_CONTEXT ,
-- 44
INVENTORY_ITEM_STATUS_CODE ,
-- 45
ATO_NUMBER ,
-- 46
CREATION_DATE ,
-- 47
AUTO_CREATED_CONFIG_FLAG ,
-- 48
BASE_ITEM_ID ,
-- 49
FIXED_DAYS_SUPPLY ,
-- 50
FIXED_LOT_MULTIPLIER ,
-- 51
FIXED_ORDER_QUANTITY ,
-- 52
INVENTORY_PLANNING_CODE ,
-- 53
SOURCE_ORGANIZATION_CODE ,
-- 54
MAX_MINMAX_QUANTITY ,
-- 55
MAXIMUM_ORDER_QUANTITY ,
-- 56
MIN_MINMAX_QUANTITY ,
-- 57
MINIMUM_ORDER_QUANTITY ,
-- 58
MRP_SAFETY_STOCK_CODE ,
-- 59
MRP_SAFETY_STOCK_PERCENT ,
-- 60
ORDER_COST ,
-- 61
SAFETY_STOCK_BUCKET_DAYS ,
-- 62
SOURCE_SUBINVENTORY ,
-- 63
SOURCE_TYPE ,
-- 64
AUTO_SERIAL_ALPHA_PREFIX ,
-- 65
BULK_PICKED_FLAG ,
-- 66
SERIAL_NUMBER_CONTROL_CODE ,
-- 67
SHELF_LIFE_CODE ,
-- 68
SHELF_LIFE_DAYS ,
-- 69
START_AUTO_SERIAL_NUMBER ,
-- 70
CUM_MANUFACTURING_LEAD_TIME,
-- 71
CUMULATIVE_TOTAL_LEAD_TIME ,
-- 72
FIXED_LEAD_TIME ,
-- 73
FULL_LEAD_TIME ,
-- 74
LEAD_TIME_LOT_SIZE ,
-- 75
POSTPROCESSING_LEAD_TIME ,
-- 76
PREPROCESSING_LEAD_TIME ,
-- 77
VARIABLE_LEAD_TIME ,
-- 78
ATO_FORECAST_CONTROL ,
-- 79
AUTO_REDUCE_MPS ,
-- 80
CREATE_SUPPLY_FLAG ,
-- 81
CRITICAL_COMPONENT_FLAG ,
-- 82
DEMAND_TIME_FENCE_CODE ,
-- 83
DEMAND_TIME_FENCE_DAYS ,
-- 84
END_ASSEMBLY_PEGGING_FLAG ,
-- 85
MRP_CALCULATE_ATP_FLAG ,
-- 86
MRP_PLANNING_CODE ,
-- 87
PLANNING_EXCEPTION_SET ,
-- 88
PLANNING_TIME_FENCE_CODE ,
-- 89
PLANNING_TIME_FENCE_DAYS ,
-- 90
RELEASE_TIME_FENCE_CODE ,
-- 91
RELEASE_TIME_FENCE_DAYS ,
-- 92
REPETITIVE_PLANNING_FLAG ,
-- 93
ATP_COMPONENTS_FLAG ,
-- 94
ATP_FLAG ,
-- 95
ATP_RULE_ID ,
-- 96
DEFAULT_SHIPPING_ORG ,
-- 97
PICKING_RULE ,
-- 98
ATP_RULE_NAME ,
-- 99
PICKING_RULE_ID ,
-- 100
RETURNABLE_FLAG ,
-- 101
CONTAINER_ITEM_FLAG ,
-- 102
CONTAINER_TYPE_CODE ,
-- 103
ALLOW_ITEM_DESC_UPDATE_FLAG,
-- 104
INSPECTION_REQUIRED_FLAG ,
-- 105
BUYER_NAME ,
-- 106
UN_NUMBER ,
-- 107
OUTSIDE_OPERATION_FLAG ,
-- 108
OUTSIDE_OPERATION_UOM_TYPE ,
-- 109
RECEIPT_REQUIRED_FLAG ,
-- 110
RECV_ROUTING ,
-- 111
RECEIVING_ROUTING_ID ,
-- 112
ASSET_CREATION_CODE ,
-- 113
COMMS_NL_TRACKABLE_FLAG ,
-- 114
MATERIAL_BILLABLE_FLAG ,
-- 115
SERV_BILLING_ENABLED_FLAG ,
-- 116
WIP_SUPPLY_LOCATOR ,
-- 117
WIP_SUPPLY_LOCATOR_ID ,
-- 118
WIP_SUPPLY_SUBINVENTORY ,
-- 119
WIP_SUPPLY_TYPE ,
-- 120
ENG_ITEM_FLAG ,
-- 121
ASN_AUTOEXPIRE_FLAG ,
-- 122
CARRYING_COST ,
-- 123
CONSIGNED_FLAG ,
-- 124
FORECAST_HORIZON ,
-- 125
SO_AUTHORIZATION_FLAG ,
-- 126
SUBCONTRACTING_COMPONENT ,
-- 127
VMI_FIXED_ORDER_QUANTITY ,
-- 128
VMI_FORECAST_TYPE ,
-- 129
VMI_MAXIMUM_DAYS ,
-- 130
VMI_MAXIMUM_UNITS ,
-- 131
VMI_MINIMUM_DAYS ,
-- 132
VMI_MINIMUM_UNITS ,
-- 133
AUTO_LOT_ALPHA_PREFIX ,
-- 134
CHECK_SHORTAGES_FLAG ,
-- 135
CHILD_LOT_FLAG ,
-- 136
CHILD_LOT_PREFIX ,
-- 137
CHILD_LOT_STARTING_NUMBER ,
-- 138
CHILD_LOT_VALIDATION_FLAG ,
-- 139
COPY_LOT_ATTRIBUTE_FLAG ,
-- 140
DEFAULT_GRADE ,
-- 141
DEFAULT_LOT_STATUS ,
-- 142
DEFAULT_SERIAL_STATUS ,
-- 143
EXPIRATION_ACTION_CODE ,
-- 144
EXPIRATION_ACTION_INTERVAL ,
-- 145
GRADE_CONTROL_FLAG ,
-- 146
HOLD_DAYS ,
-- 147
LOCATION_CONTROL_CODE ,
-- 148
LOT_CONTROL_CODE ,
-- 149
LOT_DIVISIBLE_FLAG ,
-- 150
LOT_MERGE_ENABLED ,
-- 151
LOT_SPLIT_ENABLED ,
-- 152
LOT_STATUS_ENABLED ,
-- 153
LOT_SUBSTITUTION_ENABLED ,
-- 154
LOT_TRANSLATE_ENABLED ,
-- 155
STANDARD_COST_LOT_SIZE ,
-- 156
CURRENT_COST_LOT_SIZE ,
-- 157
PLANNED_COST_LOT_SIZE ,
-- 158
MATURITY_DAYS ,
-- 159
NEGATIVE_MEASUREMENT_ERROR ,
-- 160
PARENT_CHILD_GENERATION_FLAG,
-- 161
POSITIVE_MEASUREMENT_ERROR ,
-- 162
RESERVABLE_TYPE ,
-- 163
RESTRICT_LOCATORS_CODE ,
-- 164
RESTRICT_SUBINVENTORIES_CODE ,
-- 165
RETEST_INTERVAL ,
-- 166
REVISION_QTY_CONTROL_CODE ,
-- 167
SERIAL_STATUS_ENABLED ,
-- 168
START_AUTO_LOT_NUMBER ,
-- 169
PAYMENT_TERMS ,
-- 170
PAYMENT_TERMS_ID ,
-- 171
TAX_CODE ,
-- 172
ALLOWED_UNITS_LOOKUP_CODE ,
-- 173
DUAL_UOM_DEVIATION_HIGH ,
-- 174
DUAL_UOM_DEVIATION_LOW ,
-- 175
ONT_PRICING_QTY_SOURCE ,
-- 176
SECONDARY_DEFAULT_IND ,
-- 177
SECONDARY_UOM_CODE ,
-- 178
TRACKING_QUANTITY_IND ,
-- 179
ACCEPTABLE_EARLY_DAYS ,
-- 180
ACCEPTABLE_RATE_DECREASE ,
-- 181
ACCEPTABLE_RATE_INCREASE ,
-- 182
CONTINOUS_TRANSFER ,
-- 183
CONVERGENCE ,
-- 184
DAYS_MAX_INV_SUPPLY ,
-- 185
DAYS_MAX_INV_WINDOW ,
-- 186
DAYS_TGT_INV_SUPPLY ,
-- 187
DAYS_TGT_INV_WINDOW ,
-- 188
DIVERGENCE ,
-- 189
DRP_PLANNED_FLAG ,
-- 190
EXCLUDE_FROM_BUDGET_FLAG ,
-- 191
OVERRUN_PERCENTAGE ,
-- 192
PLANNED_INV_POINT_FLAG ,
-- 193
PREPOSITION_POINT ,
-- 194
REPAIR_LEADTIME ,
-- 195
REPAIR_PROGRAM ,
-- 196
REPAIR_YIELD ,
-- 197
SHRINKAGE_RATE ,
-- 198
SUBSTITUTION_WINDOW_CODE ,
-- 199
SUBSTITUTION_WINDOW_DAYS ,
-- 200
CATALOG_STATUS_FLAG ,
-- 201
CURRENT_PHASE_ID ,
-- 202
EXPENSE_BILLABLE_FLAG ,
-- 203
GDSN_OUTBOUND_ENABLED_FLAG ,
-- 204
GLOBAL_TRADE_ITEM_NUMBER ,
-- 205
GTIN_DESCRIPTION ,
-- 206
ITEM_CATALOG_GROUP_NAME ,
-- 207
LIFECYCLE_ID ,
-- 208
REQUEST_ID ,
-- 209
REVISION_IMPORT_POLICY ,
-- 210
SERV_IMPORTANCE_LEVEL ,
-- 211
STYLE_ITEM_FLAG ,
-- 212
STYLE_ITEM_NUMBER ,
-- 213
SUBSCRIPTION_DEPEND_FLAG ,
-- 214
TIME_BILLABLE_FLAG ,
-- 215
TRADE_ITEM_DESCRIPTOR ,
-- 216
WH_UPDATE_DATE ,
-- 217
CHARGE_PERIODICITY_CODE ,
-- 218
COMMS_ACTIVATION_REQD_FLAG ,
-- 219
COUPON_EXEMPT_FLAG ,
-- 220
FINANCING_ALLOWED_FLAG ,
-- 221
OVER_RETURN_TOLERANCE ,
-- 222
OVER_SHIPMENT_TOLERANCE ,
-- 223
UNDER_RETURN_TOLERANCE ,
-- 224
UNDER_SHIPMENT_TOLERANCE ,
-- 225
VOL_DISCOUNT_EXEMPT_FLAG ,
-- 226
COLLATERAL_FLAG ,
-- 227
DOWNLOADABLE_FLAG ,
-- 228
ELECTRONIC_FLAG ,
-- 229
EQUIPMENT_TYPE_FLAG ,
-- 230
EVENT_FLAG ,
-- 231
INDIVISIBLE_FLAG ,
-- 232
INTERNAL_VOLUME ,
-- 233
MAXIMUM_LOAD_WEIGHT ,
-- 234
MINIMUM_FILL_PERCENT ,
-- 235
VEHICLE_ITEM_FLAG ,
-- 236
CAS_NUMBER ,
-- 237
HAZARDOUS_MATERIAL_FLAG ,
-- 238
PROCESS_COSTING_ENABLED_FLAG ,
-- 239
PROCESS_EXECUTION_ENABLED_FLAG,
-- 240
PROCESS_QUALITY_ENABLED_FLAG ,
-- 241
PROCESS_SUPPLY_LOCATOR_ID ,
-- 242
PROCESS_SUPPLY_SUBINVENTORY ,
-- 243
PROCESS_YIELD_LOCATOR_ID ,
-- 244
PROCESS_YIELD_SUBINVENTORY ,
-- 245
RECIPE_ENABLED_FLAG ,
-- 246
ASSET_CATEGORY_ID ,
-- 247
ENCUMBRANCE_ACCOUNT ,
-- 248
INVOICE_CLOSE_TOLERANCE ,
-- 249
ITEM_COST ,
-- 250
MARKET_PRICE ,
-- 251
OUTSOURCED_ASSEMBLY ,
-- 252
PURCHASING_TAX_CODE ,
-- 253
RECEIVE_CLOSE_TOLERANCE ,
-- 254
ROUNDING_FACTOR ,
-- 255
UN_NUMBER_ID ,
-- 256
UNIT_OF_ISSUE ,
-- 257
ENFORCE_SHIP_TO_LOCATION_CODE ,
-- 258
CONTRACT_ITEM_TYPE_CODE ,
-- 259
COVERAGE_SCHEDULE_ID ,
-- 260
DEFECT_TRACKING_ON_FLAG ,
-- 261
IB_ITEM_INSTANCE_CLASS ,
-- 262
MAX_WARRANTY_AMOUNT ,
-- 263
PREVENTIVE_MAINTENANCE_FLAG ,
-- 264
PRORATE_SERVICE_FLAG ,
-- 265
RECOVERED_PART_DISP_CODE ,
-- 266
RESPONSE_TIME_PERIOD_CODE ,
-- 267
RESPONSE_TIME_VALUE ,
-- 268
SERV_REQ_ENABLED_CODE ,
-- 269
SERVICE_DURATION ,
-- 270
SERVICE_DURATION_PERIOD_CODE ,
-- 271
SERVICE_STARTING_DELAY ,
-- 272
SERVICEABLE_PRODUCT_FLAG ,
-- 273
WARRANTY_VENDOR_ID ,
-- 274
BASE_WARRANTY_SERVICE_ID ,
-- 275
NEW_REVISION_CODE ,
-- 276
PRIMARY_SPECIALIST_ID ,
-- 277
SECONDARY_SPECIALIST_ID ,
-- 278
SERVICEABLE_COMPONENT_FLAG ,
-- 279
SERVICEABLE_ITEM_CLASS_ID ,
-- 280
MINIMUM_LICENSE_QUANTITY ,
-- 281
INVENTORY_CARRY_PENALTY ,
-- 282
OPERATION_SLACK_PENALTY ,
-- 283
UNSPSC_CODE ,
-- 284
ABC_CLASS_NAME ,
-- 285
CATALOG_GROUP ,
-- 286
COMPILE_NAME ,
-- 287
DESCRIPTIVE_ELE_NAME ,
-- 288
DESCRIPTIVE_ELE_VALUE ,
-- 289
DESCRIPTION_DEFAULT_FLAG ,
-- 290
CATEGORY_SET ,
-- 291
CATEGORY_NAME ,
-- 292
CATEGORY_CODE_DESCRIPTION ,
-- 293
DISABLE_DATE ,
-- 294
SUPPLIER_ENABLED_FLAG ,
-- 295
COMODITY_CODE ,
-- 296
BRAND_CATEGORY_SET ,
-- 297
COMMERCIAL_ABC_CATEGORY_SET ,
-- 298
CONTRACT_CATEGORY ,
-- 299
FLD299 ,
-- 300
FLD300 ,
-- 301
FISCAL_CLASSIFICATION ,
-- 302
GPC_CATALOG_CATEGORY_DESC ,
-- 303
INTENDED_USE ,
-- 304
BE_ISTORE_CATEGORY1 ,
-- 305
BE_ISTORE_CATEGORY2 ,
-- 306
BE_ISTORE_CATEGORY3 ,
-- 307
BE_ISTORE_CATEGORY4 ,
-- 308
BE_ISTORE_CATEGORY5 ,
-- 309
BE_ISTORE_CATEGORY6 ,
-- 310
BE_ISTORE_CATEGORY7 ,
-- 311
BE_ISTORE_CATEGORY8 ,
-- 312
BE_ISTORE_CATEGORY9 ,
-- 313
BE_ISTORE_CATEGORY10 ,
-- 314
PLN_SIOP_CATEGORY1 ,
-- 315
PLN_SIOP_CATEGORY2 ,
-- 316
PLN_SIOP_CATEGORY3 ,
-- 317
PLN_SIOP_CATEGORY4 ,
-- 318
PLN_SIOP_CATEGORY5 ,
-- 319
PLN_SIOP_CATEGORY6 ,
-- 320
INVENTORY_PRODUCT ,
-- 321
PLANNING_ABC_CATEGORY_CODE ,
-- 322
PO_ITEM_CATEGORY_SEGMENT ,
-- 323
PO_ITEM_CATEGORY_FAMILY ,
-- 324
PO_ITEM_CATEGORY_CLASS ,
-- 325
PO_ITEM_CATEGORY_COMMODITY ,
-- 326
PO_ITEM_CATEGORY_FUNCTION ,
-- 327
PRICE_ON_AVAIL_FLAG ,
-- 328
PRICING_VALUE_1 ,
-- 329
PRICING_VALUE_2 ,
-- 330
PRICING_VALUE_3 ,
-- 331
PRICING_VALUE_4 ,
-- 332
STATISTICAL_CODE ,
-- 333
FLD333 ,
-- 334
FLD334 ,
-- 335
FLD335 ,
-- 336
SOURCING_CATEGORY_CODE ,
-- 337
WINE_CIGARRETE_CATEGORY_CODE ,
-- 338
COO_CATEGORY_COUNTRY ,
-- 339
FLD339 ,
-- 340
ECCN_REGION_CODE ,
-- 341
ECCN_CODE ,
-- 342
EU_PREFERENTIAL_ITEM ,
-- 343
FLOW_CLEAR_TO_BUILD ,
-- 344
HTS_CATEGORY_COUNTRY ,
-- 345
HTS_CATEGORY_CODE ,
-- 346
INV_ARTICLE_NUMBERS ,
-- 347
INV_PART_TYPE ,
-- 348
NSS_CATEGORY ,
-- 349
CUSTOMER_VIEWABLE ,
-- 350
PASSPORT_CATEGORY ,
-- 351
TAVANT_CATEGORYPRODUCT_TYPE ,
-- 352
TAVANT_CATEGORY_MODEL_CODE ,
-- 353
TAVANT_CATEGORY_DIVISION_CODE,
-- 354
H_CREATE_DATE ,
-- 355
H_CREATED_BY ,
-- 356
H_UPDATE_DATE ,
-- 357
H_UPDATED_BY ,
-- 358
UFD1 ,
-- 359
UF1 ,
-- 360
UFD2 ,
-- 361
UF2 ,
-- 362
UFD3 ,
-- 363
UF3 ,
-- 364
UFD4 ,
-- 365
UF4 ,
-- 366
UFD5 ,
-- 367
UF5 ,
-- 368
UFD6 ,
-- 369
UF6 ,
-- 370
UFD7 ,
-- 371
UF7 ,
-- 372
UFD8 ,
-- 373
UF8 ,
-- 374
UFD9 ,
-- 375
UF9 ,
-- 376
UFD10 ,
-- 377
UF10 ,
-- 378
UFD11 ,
-- 379
UF11 ,
-- 380
UFD12 ,
-- 381
UF12 ,
-- 382
UFD13 ,
-- 383
UF13 ,
-- 384
UFD14 ,
-- 385
UF14 ,
-- 386
UFD15 ,
-- 387
UF15 ,
-- 388
UFD16 ,
-- 389
UF16 ,
-- 390
UFD17 ,
-- 391
UF17 ,
-- 392
UFD18 ,
-- 393
UF18 ,
-- 394
UFD19 ,
-- 395
UF19 ,
-- 396
UFD20 ,
-- 397
UF20 ,
-- 398
UFD21 ,
-- 399
UF21 ,
-- 400
UFD22 ,
-- 401
UF22 ,
-- 402
UFD23 ,
-- 403
UF23 ,
-- 404
UFD24 ,
-- 405
UF24 ,
-- 406
UFD25 ,
-- 407
UF25 ,
-- 408
UFD26 ,
-- 409
UF26 ,
-- 410
UFD27 ,
-- 411
UF27 ,
-- 412
UFD28 ,
-- 413
UF28 ,
-- 414
UFD29 ,
-- 415
UF29 ,
-- 416
UFD30 ,
-- 417
UF30


)
(
Select

-- 1 DSN
'KBM-IND',
-- 2 ORG_ID
IMCO,
-- 3 ITEM_NUMBER
IMPN,
-- 4 KEYDESCRIPTION1
'N/A',
-- 5 KEY1
'N/A',
-- 6 KEYDESCRIPTION2
'N/A',
-- 7 KEY2
'N/A',
-- 8 KEYDESCRIPTION3
'N/A',
-- 9 KEY3
'N/A',
-- 10 ITEM_ORGANIZATION_CODE
'',
-- 11 INVENTORY_ITEM_NUMBER
'',
-- 12 ITEM_ID
IMPN,
-- 13 ITEM_NAME
IMDSC,
-- 14 DESCRIPTION
IMDSC,
-- 15 PRIMARY_UOM_CODE
IMUTMS,
-- 16 ITEM_TYPE_CODE
'',
-- 17 CONSUMPTION_UOM_CODE
IMUTMS,
-- 18 STORAGE_UOM_CODE
IMUTMS,
-- 19 LAST_COUNT_DATE
case when IMDNCC <> 0 then
SUBSTR(DIGITS(IMDNCC),1,2) || '/' ||
SUBSTR(DIGITS(IMDNCC),3,2) || '/20' ||
SUBSTR(DIGITS(IMDNCC),5,2)
else
'01/01/1901'
end
,
-- 20 LAST_FIXED_COST_ROLLUP_DATE
case when month(IMDSTR) between 1 and 12 then
substr(char(IMDSTR),6,2 ) || '/' ||
substr(char(IMDSTR),9,2 ) || '/' ||
substr(char(IMDSTR),1,4 )
else
'01/02/1901'
end
,
-- 21 LAST_CURRENT_COST_ROLLUP_DATE
case when month(IMDSTR) between 1 and 12 then
substr(char(IMDSTR),6,2) || '/' ||
substr(char(IMDSTR),9,2) || '/' ||
substr(char(IMDSTR),1,4)
else
'01/03/1901'
end
,
-- 22 LAST_CURRENT_TO_FIXED_ROLLOVER
'',
-- 23 FAMILY_PART_NUMBER
'',
-- 24 LOW_LEVEL_NUMBER
'',
-- 25 REVISION
'',
-- 26 LONG_DESCRIPTION
'',
-- 27 MASTER_ORGANIZATION
'',
-- 28 PLANNING_MAKE_BUY_CODE
'',
-- 29 TEMPLATE_NAME
'',
-- 30 PLANNER_CODE
'',
-- 31 HAZARD_CLASS
'',
-- 32 WEIGHT_UOM_CODE
'',
-- 33 UNIT_WEIGHT
'',
-- 34 VOLUME_UOM_CODE
'',
-- 35 UNIT_VOLUME
'',
-- 36 DIMENSION_UOM_CODE
'',
-- 37 UNIT_HEIGHT
'',
-- 38 UNIT_LENGTH
'',
-- 39 UNIT_WIDTH
'',
-- 40 ENG_DRAWING_NUMBER
'',
-- 41 SYSTEM_OF_RECORD
'',
-- 42 TRANSACTION_TYPE
'',
-- 43 WINDCHILL_CONTEXT
'',
-- 44 INVENTORY_ITEM_STATUS_CODE
'',
-- 45 ATO_NUMBER
'',
-- 46 CREATION_DATE
'01/01/1901',
-- 47 AUTO_CREATED_CONFIG_FLAG
'',
-- 48 BASE_ITEM_ID
'',
-- 49 FIXED_DAYS_SUPPLY
'',
-- 50 FIXED_LOT_MULTIPLIER
'',
-- 51 FIXED_ORDER_QUANTITY
'',
-- 52 INVENTORY_PLANNING_CODE
'',
-- 53 SOURCE_ORGANIZATION_CODE
'',
-- 54 MAX_MINMAX_QUANTITY
'',
-- 55 MAXIMUM_ORDER_QUANTITY
'',
-- 56 MIN_MINMAX_QUANTITY
'',
-- 57 MINIMUM_ORDER_QUANTITY
'',
-- 58 MRP_SAFETY_STOCK_CODE
'',
-- 59 MRP_SAFETY_STOCK_PERCENT
'',
-- 60 ORDER_COST
'',
-- 61 SAFETY_STOCK_BUCKET_DAYS
'',
-- 62 SOURCE_SUBINVENTORY
'',
-- 63 SOURCE_TYPE
'',
-- 64 AUTO_SERIAL_ALPHA_PREFIX
'',
-- 65 BULK_PICKED_FLAG
'',
-- 66 SERIAL_NUMBER_CONTROL_CODE
'',
-- 67 SHELF_LIFE_CODE
'',
-- 68 SHELF_LIFE_DAYS
'',
-- 69 START_AUTO_SERIAL_NUMBER
'',
-- 70 CUM_MANUFACTURING_LEAD_TIME
'',
-- 71 CUMULATIVE_TOTAL_LEAD_TIME
'',
-- 72 FIXED_LEAD_TIME
'',
-- 73 FULL_LEAD_TIME
'',
-- 74 LEAD_TIME_LOT_SIZE
'',
-- 75 POSTPROCESSING_LEAD_TIME
'',
-- 76 PREPROCESSING_LEAD_TIME
'',
-- 77 VARIABLE_LEAD_TIME
'',
-- 78 ATO_FORECAST_CONTROL
'',
-- 79 AUTO_REDUCE_MPS
'',
-- 80 CREATE_SUPPLY_FLAG
'',
-- 81 CRITICAL_COMPONENT_FLAG
'',
-- 82 DEMAND_TIME_FENCE_CODE
'',
-- 83 DEMAND_TIME_FENCE_DAYS
'',
-- 84 END_ASSEMBLY_PEGGING_FLAG
'',
-- 85 MRP_CALCULATE_ATP_FLAG
'',
-- 86 MRP_PLANNING_CODE
'',
-- 87 PLANNING_EXCEPTION_SET
'',
-- 88 PLANNING_TIME_FENCE_CODE
'',
-- 89 PLANNING_TIME_FENCE_DAYS
'',
-- 90 RELEASE_TIME_FENCE_CODE
'',
-- 91 RELEASE_TIME_FENCE_DAYS
'',
-- 92 REPETITIVE_PLANNING_FLAG
'',
-- 93 ATP_COMPONENTS_FLAG
'',
-- 94 ATP_FLAG
'',
-- 95 ATP_RULE_ID
'',
-- 96 DEFAULT_SHIPPING_ORG
'',
-- 97 PICKING_RULE
'',
-- 98 ATP_RULE_NAME
'',
-- 99 PICKING_RULE_ID
'',
-- 100 RETURNABLE_FLAG
'',
-- 101 CONTAINER_ITEM_FLAG
'',
-- 102 CONTAINER_TYPE_CODE
'',
-- 103 ALLOW_ITEM_DESC_UPDATE_FLAG
'',
-- 104 INSPECTION_REQUIRED_FLAG
'',
-- 105 BUYER_NAME
'',
-- 106 UN_NUMBER
'',
-- 107 OUTSIDE_OPERATION_FLAG
'',
-- 108 OUTSIDE_OPERATION_UOM_TYPE
'',
-- 109 RECEIPT_REQUIRED_FLAG
'',
-- 110 RECV_ROUTING
'',
-- 111 RECEIVING_ROUTING_ID
'',
-- 112 ASSET_CREATION_CODE
'',
-- 113 COMMS_NL_TRACKABLE_FLAG
'',
-- 114 MATERIAL_BILLABLE_FLAG
'',
-- 115 SERV_BILLING_ENABLED_FLAG
'',
-- 116 WIP_SUPPLY_LOCATOR
'',
-- 117 WIP_SUPPLY_LOCATOR_ID
'',
-- 118 WIP_SUPPLY_SUBINVENTORY
'',
-- 119 WIP_SUPPLY_TYPE
'',
-- 120 ENG_ITEM_FLAG
'',
-- 121 ASN_AUTOEXPIRE_FLAG
'',
-- 122 CARRYING_COST
'',
-- 123 CONSIGNED_FLAG
'',
-- 124 FORECAST_HORIZON
'',
-- 125 SO_AUTHORIZATION_FLAG
'',
-- 126 SUBCONTRACTING_COMPONENT
'',
-- 127 VMI_FIXED_ORDER_QUANTITY
'',
-- 128 VMI_FORECAST_TYPE
'',
-- 129 VMI_MAXIMUM_DAYS
'',
-- 130 VMI_MAXIMUM_UNITS
'',
-- 131 VMI_MINIMUM_DAYS
'',
-- 132 VMI_MINIMUM_UNITS
'',
-- 133 AUTO_LOT_ALPHA_PREFIX
'',
-- 134 CHECK_SHORTAGES_FLAG
'',
-- 135 CHILD_LOT_FLAG
'',
-- 136 CHILD_LOT_PREFIX
'',
-- 137 CHILD_LOT_STARTING_NUMBER
'',
-- 138 CHILD_LOT_VALIDATION_FLAG
'',
-- 139 COPY_LOT_ATTRIBUTE_FLAG
'',
-- 140 DEFAULT_GRADE
'',
-- 141 DEFAULT_LOT_STATUS
'',
-- 142 DEFAULT_SERIAL_STATUS
'',
-- 143 EXPIRATION_ACTION_CODE
'',
-- 144 EXPIRATION_ACTION_INTERVAL
'',
-- 145 GRADE_CONTROL_FLAG
'',
-- 146 HOLD_DAYS
'',
-- 147 LOCATION_CONTROL_CODE
'',
-- 148 LOT_CONTROL_CODE
'',
-- 149 LOT_DIVISIBLE_FLAG
'',
-- 150 LOT_MERGE_ENABLED
'',
-- 151 LOT_SPLIT_ENABLED
'',
-- 152 LOT_STATUS_ENABLED
'',
-- 153 LOT_SUBSTITUTION_ENABLED
'',
-- 154 LOT_TRANSLATE_ENABLED
'',
-- 155 STANDARD_COST_LOT_SIZE
'',
-- 156 CURRENT_COST_LOT_SIZE
'',
-- 157 PLANNED_COST_LOT_SIZE
'',
-- 158 MATURITY_DAYS
'',
-- 159 NEGATIVE_MEASUREMENT_ERROR
'',
-- 160 PARENT_CHILD_GENERATION_FLAG
'',
-- 161 POSITIVE_MEASUREMENT_ERROR
'',
-- 162 RESERVABLE_TYPE
'',
-- 163 RESTRICT_LOCATORS_CODE
'',
-- 164 RESTRICT_SUBINVENTORIES_CODE
'',
-- 165 RETEST_INTERVAL
'',
-- 166 REVISION_QTY_CONTROL_CODE
'',
-- 167 SERIAL_STATUS_ENABLED
'',
-- 168 START_AUTO_LOT_NUMBER
'',
-- 169 PAYMENT_TERMS
'',
-- 170 PAYMENT_TERMS_ID
'',
-- 171 TAX_CODE
'',
-- 172 ALLOWED_UNITS_LOOKUP_CODE
'',
-- 173 DUAL_UOM_DEVIATION_HIGH
'',
-- 174 DUAL_UOM_DEVIATION_LOW
'',
-- 175 ONT_PRICING_QTY_SOURCE
'',
-- 176 SECONDARY_DEFAULT_IND
'',
-- 177 SECONDARY_UOM_CODE
'',
-- 178 TRACKING_QUANTITY_IND
'',
-- 179 ACCEPTABLE_EARLY_DAYS
'',
-- 180 ACCEPTABLE_RATE_DECREASE
'',
-- 181 ACCEPTABLE_RATE_INCREASE
'',
-- 182 CONTINOUS_TRANSFER
'',
-- 183 CONVERGENCE
'',
-- 184 DAYS_MAX_INV_SUPPLY
'',
-- 185 DAYS_MAX_INV_WINDOW
'',
-- 186 DAYS_TGT_INV_SUPPLY
'',
-- 187 DAYS_TGT_INV_WINDOW
'',
-- 188 DIVERGENCE
'',
-- 189 DRP_PLANNED_FLAG
'',
-- 190 EXCLUDE_FROM_BUDGET_FLAG
'',
-- 191 OVERRUN_PERCENTAGE
'',
-- 192 PLANNED_INV_POINT_FLAG
'',
-- 193 PREPOSITION_POINT
'',
-- 194 REPAIR_LEADTIME
'',
-- 195 REPAIR_PROGRAM
'',
-- 196 REPAIR_YIELD
'',
-- 197 SHRINKAGE_RATE
'',
-- 198 SUBSTITUTION_WINDOW_CODE
'',
-- 199 SUBSTITUTION_WINDOW_DAYS
'',
-- 200 CATALOG_STATUS_FLAG
'',
-- 201 CURRENT_PHASE_ID
'',
-- 202 EXPENSE_BILLABLE_FLAG
'',
-- 203 GDSN_OUTBOUND_ENABLED_FLAG
'',
-- 204 GLOBAL_TRADE_ITEM_NUMBER
'',
-- 205 GTIN_DESCRIPTION
'',
-- 206 ITEM_CATALOG_GROUP_NAME
'',
-- 207 LIFECYCLE_ID
'',
-- 208 REQUEST_ID
'',
-- 209 REVISION_IMPORT_POLICY
'',
-- 210 SERV_IMPORTANCE_LEVEL
'',
-- 211 STYLE_ITEM_FLAG
'',
-- 212 STYLE_ITEM_NUMBER
'',
-- 213 SUBSCRIPTION_DEPEND_FLAG
'',
-- 214 TIME_BILLABLE_FLAG
'',
-- 215 TRADE_ITEM_DESCRIPTOR
'',
-- 216 WH_UPDATE_DATE
'',
-- 217 CHARGE_PERIODICITY_CODE
'',
-- 218 COMMS_ACTIVATION_REQD_FLAG
'',
-- 219 COUPON_EXEMPT_FLAG
'',
-- 220 FINANCING_ALLOWED_FLAG
'',
-- 221 OVER_RETURN_TOLERANCE
'',
-- 222 OVER_SHIPMENT_TOLERANCE
'',
-- 223 UNDER_RETURN_TOLERANCE
'',
-- 224 UNDER_SHIPMENT_TOLERANCE
'',
-- 225 VOL_DISCOUNT_EXEMPT_FLAG
'',
-- 226 COLLATERAL_FLAG
'',
-- 227 DOWNLOADABLE_FLAG
'',
-- 228 ELECTRONIC_FLAG
'',
-- 229 EQUIPMENT_TYPE_FLAG
'',
-- 230 EVENT_FLAG
'',
-- 231 INDIVISIBLE_FLAG
'',
-- 232 INTERNAL_VOLUME
'',
-- 233 MAXIMUM_LOAD_WEIGHT
'',
-- 234 MINIMUM_FILL_PERCENT
'',
-- 235 VEHICLE_ITEM_FLAG
'',
-- 236 CAS_NUMBER
'',
-- 237 HAZARDOUS_MATERIAL_FLAG
'',
-- 238 PROCESS_COSTING_ENABLED_FLAG
'',
-- 239 PROCESS_EXECUTION_ENABLED_FLAG
'',
-- 240 PROCESS_QUALITY_ENABLED_FLAG
'',
-- 241 PROCESS_SUPPLY_LOCATOR_ID
'',
-- 242 PROCESS_SUPPLY_SUBINVENTORY
'',
-- 243 PROCESS_YIELD_LOCATOR_ID
'',
-- 244 PROCESS_YIELD_SUBINVENTORY
'',
-- 245 RECIPE_ENABLED_FLAG
'',
-- 246 ASSET_CATEGORY_ID
'',
-- 247 ENCUMBRANCE_ACCOUNT
'',
-- 248 INVOICE_CLOSE_TOLERANCE
'',
-- 249 ITEM_COST
'',
-- 250 MARKET_PRICE
'',
-- 251 OUTSOURCED_ASSEMBLY
'',
-- 252 PURCHASING_TAX_CODE
'',
-- 253 RECEIVE_CLOSE_TOLERANCE
'',
-- 254 ROUNDING_FACTOR
'',
-- 255 UN_NUMBER_ID
'',
-- 256 UNIT_OF_ISSUE
'',
-- 257 ENFORCE_SHIP_TO_LOCATION_CODE
'',
-- 258 CONTRACT_ITEM_TYPE_CODE
'',
-- 259 COVERAGE_SCHEDULE_ID
'',
-- 260 DEFECT_TRACKING_ON_FLAG
'',
-- 261 IB_ITEM_INSTANCE_CLASS
'',
-- 262 MAX_WARRANTY_AMOUNT
'',
-- 263 PREVENTIVE_MAINTENANCE_FLAG
'',
-- 264 PRORATE_SERVICE_FLAG
'',
-- 265 RECOVERED_PART_DISP_CODE
'',
-- 266 RESPONSE_TIME_PERIOD_CODE
'',
-- 267 RESPONSE_TIME_VALUE
'',
-- 268 SERV_REQ_ENABLED_CODE
'',
-- 269 SERVICE_DURATION
'',
-- 270 SERVICE_DURATION_PERIOD_CODE
'',
-- 271 SERVICE_STARTING_DELAY
'',
-- 272 SERVICEABLE_PRODUCT_FLAG
'',
-- 273 WARRANTY_VENDOR_ID
'',
-- 274 BASE_WARRANTY_SERVICE_ID
'',
-- 275 NEW_REVISION_CODE
'',
-- 276 PRIMARY_SPECIALIST_ID
'',
-- 277 SECONDARY_SPECIALIST_ID
'',
-- 278 SERVICEABLE_COMPONENT_FLAG
'',
-- 279 SERVICEABLE_ITEM_CLASS_ID
'',
-- 280 MINIMUM_LICENSE_QUANTITY
'',
-- 281 INVENTORY_CARRY_PENALTY
'',
-- 282 OPERATION_SLACK_PENALTY
'',
-- 283 UNSPSC_CODE
'',
-- 284 ABC_CLASS_NAME
'',
-- 285 CATALOG_GROUP
'',
-- 286 COMPILE_NAME
'',
-- 287 DESCRIPTIVE_ELE_NAME
'',
-- 288 DESCRIPTIVE_ELE_VALUE
'',
-- 289 DESCRIPTION_DEFAULT_FLAG
'',
-- 290 CATEGORY_SET
'',
-- 291 CATEGORY_NAME
'',
-- 292 CATEGORY_CODE_DESCRIPTION
'',
-- 293 DISABLE_DATE
'',
-- 294 SUPPLIER_ENABLED_FLAG
'',
-- 295 COMODITY_CODE
'',
-- 296 BRAND_CATEGORY_SET
'',
-- 297 COMMERCIAL_ABC_CATEGORY_SET
'',
-- 298 CONTRACT_CATEGORY
'',
-- 299 FLD299
'',
-- 300 FLD300
'',
-- 301 FISCAL_CLASSIFICATION
'',
-- 302 GPC_CATALOG_CATEGORY_DESC
'',
-- 303 INTENDED_USE
'',
-- 304 BE_ISTORE_CATEGORY1
'',
-- 305 BE_ISTORE_CATEGORY2
'',
-- 306 BE_ISTORE_CATEGORY3
'',
-- 307 BE_ISTORE_CATEGORY4
'',
-- 308 BE_ISTORE_CATEGORY5
'',
-- 309 BE_ISTORE_CATEGORY6
'',
-- 310 BE_ISTORE_CATEGORY7
'',
-- 311 BE_ISTORE_CATEGORY8
'',
-- 312 BE_ISTORE_CATEGORY9
'',
-- 313 BE_ISTORE_CATEGORY10
'',
-- 314 PLN_SIOP_CATEGORY1
'',
-- 315 PLN_SIOP_CATEGORY2
'',
-- 316 PLN_SIOP_CATEGORY3
'',
-- 317 PLN_SIOP_CATEGORY4
'',
-- 318 PLN_SIOP_CATEGORY5
'',
-- 319 PLN_SIOP_CATEGORY6
'',
-- 320 INVENTORY_PRODUCT
'',
-- 321 PLANNING_ABC_CATEGORY_CODE
'',
-- 322 PO_ITEM_CATEGORY_SEGMENT
'',
-- 323 PO_ITEM_CATEGORY_FAMILY
'',
-- 324 PO_ITEM_CATEGORY_CLASS
'',
-- 325 PO_ITEM_CATEGORY_COMMODITY
'',
-- 326 PO_ITEM_CATEGORY_FUNCTION
'',
-- 327 PRICE_ON_AVAIL_FLAG
'',
-- 328 PRICING_VALUE_1
0,
-- 329 PRICING_VALUE_2
0,
-- 330 PRICING_VALUE_3
0,
-- 331 PRICING_VALUE_4
0,
-- 332 STATISTICAL_CODE
'',
-- 333 FLD333
'',
-- 334 FLD334
'',
-- 335 FLD335
'',
-- 336 SOURCING_CATEGORY_CODE
'',
-- 337 WINE_CIGARRETE_CATEGORY_CODE
'',
-- 338 COO_CATEGORY_COUNTRY
'',
-- 339 FLD339
'',
-- 340 ECCN_REGION_CODE
'',
-- 341 ECCN_CODE
'',
-- 342 EU_PREFERENTIAL_ITEM
'',
-- 343 FLOW_CLEAR_TO_BUILD
'',
-- 344 HTS_CATEGORY_COUNTRY
'',
-- 345 HTS_CATEGORY_CODE
'',
-- 346 INV_ARTICLE_NUMBERS
'',
-- 347 INV_PART_TYPE
'',
-- 348 NSS_CATEGORY
'',
-- 349 CUSTOMER_VIEWABLE
'',
-- 350 PASSPORT_CATEGORY
'',
-- 351 TAVANT_CATEGORYPRODUCT_TYPE
'',
-- 352 TAVANT_CATEGORY_MODEL_CODE
'',
-- 353 TAVANT_CATEGORY_DIVISION_CODE
'',
-- 354 H_CREATE_DATE
'',
-- 355 H_CREATED_BY
'',
-- 356 H_UPDATE_DATE
'',
-- 357 H_UPDATED_BY
'',
-- 358 UFD1
'',
-- 359 UF1
'',
-- 360 UFD2
'',
-- 361 UF2
'',
-- 362 UFD3
'',
-- 363 UF3
'',
-- 364 UFD4
'',
-- 365 UF4
'',
-- 366 UFD5
'',
-- 367 UF5
'',
-- 368 UFD6
'',
-- 369 UF6
'',
-- 370 UFD7
'',
-- 371 UF7
'',
-- 372 UFD8
'',
-- 373 UF8
'',
-- 374 UFD9
'',
-- 375 UF9
'',
-- 376 UFD10
'',
-- 377 UF10
'',
-- 378 UFD11
'',
-- 379 UF11
'',
-- 380 UFD12
'',
-- 381 UF12
'',
-- 382 UFD13
'',
-- 383 UF13
'',
-- 384 UFD14
'',
-- 385 UF14
'',
-- 386 UFD15
'',
-- 387 UF15
'',
-- 388 UFD16
'',
-- 389 UF16
'',
-- 390 UFD17
'',
-- 391 UF17
'',
-- 392 UFD18
'',
-- 393 UF18
'',
-- 394 UFD19
'',
-- 395 UF19
'',
-- 396 UFD20
'',
-- 397 UF20
'',
-- 398 UFD21
'',
-- 399 UF21
'',
-- 400 UFD22
'',
-- 401 UF22
'',
-- 402 UFD23
'',
-- 403 UF23
'',
-- 404 UFD24
'',
-- 405 UF24
'',
-- 406 UFD25
'',
-- 407 UF25
'',
-- 408 UFD26
'',
-- 409 UF26
'',
-- 410 UFD27
'',
-- 411 UF27
'',
-- 412 UFD28
'',
-- 413 UF28
'',
-- 414 UFD29
'',
-- 415 UF29
'',
-- 416 UFD30
'',
-- 417 UF30
''
from kbm400mfg.fkitmstr

)
;
-----

Darryl

On Tue, Sep 6, 2016 at 10:03 PM, Glenn Gundermann <
glenn.gundermann@xxxxxxxxx> wrote:

It would help to see your SQL statement.


Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Cell: (416) 317-3144


On 6 September 2016 at 21:57, Darryl Freinkel <dhfreinkel@xxxxxxxxx>
wrote:

I am reading 1 table and writing to another.
I have a bunch of date fields in the record and 1 of them is in error.
The error message points to field 25.
Field 25 is not the 25th field starting on the left to the right. The

25th

field is a char field.

How is the system determining the field number?

-------
Message ID . . . . . . : SQL0180 Severity . . . . . . . : 30

Message type . . . . . : Diagnostic

Date sent . . . . . . : 09/06/16 Time sent . . . . . . :
21:51:47


Message . . . . : Syntax of date, time, or timestamp value not valid.

Cause . . . . . : The string representation of a date, time, or
timestamp
value does not conform to the syntax for the specified or implied data
type
and format. *N is either the character string constant that is not

valid

or
the column or host variable that contained the string. If the name is
*N,
then the value is an expression specified in the statement. If the
string
was found in a host variable, the host variable number is 25.

Recovery . . . : Ensure that the date, time, or timestamp value
conforms to
the syntax for the data type it represents. Try the request again.



--------

TIA

--
Darryl Freinkel
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.