Job Management Partner 1/Software Distribution Description and Planning Guide
This table stores the result of searching software inventory at a client.
Column name | Oracle | Microsoft SQL Server | Embedded RDB | Description | Key No. | |||
---|---|---|---|---|---|---|---|---|
Data type | Size | Data type | Size | Data type | Size | |||
dm_ppname | VARCHAR2 | 50 | varchar | 50 | MVARCHAR | 50 | Software name | -- |
dm_filename | VARCHAR2 | 255 | varchar | 255 | MVARCHAR | 255 | Names of files constituting the software | 1 |
dm_createdate | CHAR | 19 | char | 19 | CHAR | 19 | Date and time the software was created | 2 |
dm_filesize | VARCHAR2 | 10 | varchar | 10 | VARCHAR | 10 | File size of the software | 3 |
dm_company | VARCHAR2 | 50 | varchar | 50 | MVARCHAR | 50 | Company name of the software | -- |
dm_language | CHAR | 2 | char | 2 | VARCHAR | 2 | Language identifier of the software | -- |
dm_charid | CHAR | 2 | char | 2 | MCHAR | 2 | (Unused) | -- |
dm_sversion | VARCHAR2 | 50 | varchar | 50 | MVARCHAR | 50 | Version of the software | -- |
dm_productname | VARCHAR2 | 50 | varchar | 50 | MVARCHAR | 50 | Product name of the software | -- |
dm_serchdate | CHAR | 19 | char | 19 | CHAR | 19 | Search date of the software | -- |
dm_pflg1 | CHAR | 1 | char | 1 | MCHAR | 1 | Option flag 1 (record status):
|
-- |
dm_pflg2 | CHAR | 1 | char | 1 | MCHAR | 1 | Option flag 2 | -- |
dm_ppno | NUMBER | 10 | int | 4 | INTEGER | -- | Internal information of JP1/Software Distribution (program product number) | -- |
dm_pathname | VARCHAR2 | 255 | varchar | 255 | MVARCHAR | 255 | Path to the software | -- |
dm_fversion | VARCHAR2 | 50 | varchar | 50 | MVARCHAR | 50 | File version | -- |
dm_comment | VARCHAR2 | 50 | varchar | 50 | MVARCHAR | 50 | Comment | -- |
dm_systemtime | CHAR | 19 | char | 19 | CHAR | 19 | Creation date (UTC) | -- |
All Rights Reserved. Copyright (C) 2009, 2013, Hitachi, Ltd.
Copyright, patent, trademark, and other intellectual property rights related to the "TMEng.dll" file are owned exclusively by Trend Micro Incorporated.