|
SQL Update Jobs States Columns Required
|   |
|
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:
|
|
Field |
Type |
Comment |
|
1. |
OrderNumber |
VarChar(25) |
Required unique. 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:
|
|
Field |
Type |
Comment |
|
1. |
OrderNumber |
VarChar2(25) |
Required unique. 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. |