MDUPDPROJ - Create/Update Project command
MDCMS is delivered with a command-based API that allows external tools or applications to create and update Projects within MDCMS. This allows a business to continue using its existing Project Management tool, while being able to synchronize the data in the tool with the Project Manager that is embedded in MDCMS.
The MDCMS command is named MDUPDPROJ and is located in library MDCMS. It is not necessary to have the MD libraries in the library list prior to using this command. If you are unable to invoke a command from your Project Management tool, you can also directly call program MDUPDPROJ in library MDCMS. In this case, be certain that the parameters sent to the program exactly match the parameters in command MDUPDPROJ.
All MDUPDPROJ API transactions are logged to file MDCMS/MDDUPRJ.
NOTE: If Location Synchronization is used (MDCMS Settings option 6), the API will only need to be invoked for 1 system. The other partitions or physical systems will automatically be synchronized.
If a parameter value is not provided and the Project already exists, the existing value for the parameter will remain in place.
MDUPDPROJ Parameter Table
| Name | Type | Length | Description |
|---|---|---|---|
| Name | Type | Length | Valid Values and Format |
| Project ID | CHAR | 12 | unique ID |
| Project Type | CHAR | 10 | The Project Type to categorize the Project |
| Primary Appl | CHAR | 6 | The primary Application referenced by this Project |
| Assigned to Group | CHAR | 10 | Valid User Group |
| Assigned to User | CHAR | 10 | Specific User in Group or Valid user in MDSEC when group left blank |
| Priority | INTEGER | 1 | 1 - 5 |
| Expected Completion | INTEGER | 8 | YYYYMMDD |
| Status | CHAR | 1 | Unique ID |
| Project Title | CHAR | 80 | free format |
| Expected Hours | DEC | 9,2 | Number of hours expected to complete project |
| Expected Cost | DEC | 11,2 | Cost expected to complete project |
| Modification User | CHAR | 10 | IBMi USRPRF |
| MDCMS Instance | CHAR | 5 | Specifies the MDCMS environment that should be used for the API. The ID correlates to the suffix of the MDCMS library name. Special values: *DFT - default instance (no suffix) *SAME - the current instance based on the library list |
| Extended Description | CHAR | 4000 |