SQL Update Jobs States Columns Required |
|
Note that you MUST define each DMS SQL column in your script; you cannot leave a column out even if you are not using the column. Each column must have a valid value of the type required. Null values are not permitted.
The SQL Server import columns are:
|
No. |
Field |
Type |
Comment |
|
1. |
OrderNumber |
VarChar(25) |
Required field. Order number of the job to update. |
|
2. |
JobState |
VarChar(20) |
Required field. The Job State is an alphanumeric string value and must match an existing job state that has been defined in DMS. |
The Oracle import columns are:
|
No. |
Field |
Type |
Comment |
|
1. |
OrderNumber |
VarChar2(25) |
Required field. Order number of the job to update. |
|
2. |
JobState |
VarChar2(20) |
Required field. The Job State is an alphanumeric string value and must match an existing job state that has been defined in DMS. |