Converting mrc-PS Dictionary to m-Power

Converting mrc-Productivity Series Dictionaries to m-Power Dictionaries

With the October 2008 MRCCH, mrc-Productivity Series customers have the option to convert mrc-Productivity Series Data Dictionaries to function within m-Power.

While most customers will most likely choose to start with a clean Data Dictionary, some might be tempted to:

  • Replicate all tables, fields, & synonyms defined within the old Data Dictionary to their new m-Power Data Dictionary
  • Replicate all tables, fields, & synonyms as well as all Application Specifications.

(Note: No changes made to the HTML/XML Presentation layer will be converted. They will have to be copied manually)

While we allow you to convert your old Data Dictionary, we stress that it is optional. If you notice that many of the applications that exist are no longer being used, there is no benefit to copying them. It would be better to avoid the clutter of dormant applications and simply create a new m-Power Data Dictionary from the Data Dictionary tab.

Note: The conversion process is per Data Dictionary. For example, if you have three Data Dictionaries you wish to convert, you will need to run the command three separate times.

Note: The old converted Data Dictionary will still exist on your system. In fact, if you so desired, you could continue to build Character based application if necessary within the old Data Dictionary.

Note: If you have not yet compiled any Web 2.0 applications on your AS400 version of mrc-Productivity Series you will need to configure the Web 2.0 JDBC connection. This Web 2.0 connection allows the conversion program to connect to your database to allow the conversion process to occur. The simplest way to create this JDBC connection is to create a Web 2.0 application. This process will automatically configure your JDBC connection for you.

Case 1: I do not want to convert my old Dictionary; I would just like to create a clean m-Power Dictionary. I will add my own tables.

    1. Click the Admin Tab, then click the “Create New Data Dictionary” link.
    2. Specify the name you wish your new Data Dictionary to be (10 characters or less, must start with a letter). Click Accept.

  1. Now that the Dictionary has been added, click “Manage User Profiles” to add the Dictionary to your list.
  2. Click “Manage Dictionaries” for your profile.
  3. Click “Add a Data Dictionary”.
  4. Find the newly created Data Dictionary from the list and click “Accept”.
  5. Congratulations – you have just created a new a Data Dictionary and assigned it to your User Profile.

Case 2: I don’t use most of my applications anymore, but I still use the same tables. I also have a lot of synonyms predefined, what should I do to just copy over tables, fields, and synonyms?

    1. Before we can begin converting an mrc-Productivity Series Data Dictionary to an m-Power Data Dictionary, we must first create a new m-Power Data Dictionary. Please complete Step 1 above, then return to this list.
    2. Go to your AS400 command line, and type MRC. From here, get to a Command line and type MRC2MPOWER.

Note: This command will overlay all existing table/field/synonym information in the new m-Power Data Dictionary.

  1. Specify the name of your mrc-Productivity Series Dictionary on the first line, specify the name of your new m-Power Dictionary (in our case it happens to be TRUCKING), and lastly specify *TABDEF as this will just copy table, header, and synonym information.
  2. Press Enter.
  3. Congratulations – you have successfully copied over Table, Field, & Synonym information from your mrc-Productivity Series Database to your m-Power Database. Your changes will be immediately viewable within the m-Power interface.

Case 3: I need to copy my entire Data Dictionary, including all my application specifications and tables/fields/synonyms. What do I do? (I know that any m-Painter changes will not copy)

    1. Before we can begin converting an mrc-Productivity Series Data Dictionary to an m-Power Data Dictionary, we must first create a new m-Power Data Dictionary. Please complete Step 1 from CASE 1 (above), then return to this list.
    2. Go to your AS400 command line, and type MRC. From here, go to a Command line and type MRC2MPOWER.

Note: This command will overlay all existing information in the new m-Power Data Dictionary.

    1. Specify the name of your mrc-Productivity Series Dictionary on the first line, specify the name of your new m-Power Dictionary (in our case it happens to be TRUCKING), and lastly specify *ALL as this will copy all information from the old Data Dictionary.
    2. Press Enter
      You will be brought to a screen that resembles this when it is completed:

    1. Simply Press Enter to exit this display.
    2. Congratulations – you have successfully copied over all table/field/synonym information, as well as Application specifications from your mrc-Productivity Series Database to your m-Power Database.

Note: Changes made via m-Painter will not be copied. These will need to be done manually.

Note:If you had the External Object Tables in your mrc-PS dictionary, you can copy those to your m-Power dictionary manually, if you like. You would use the CPYF command on files MRCOBJ01, MRCOBJ02, and MRCOBJ03.

Note:If you had the Menu and Application Level Security Tables in your mrc-PS dictionary, you can copy those to your m-Power dictionary manually, if you like. You would use the CPYF command on files MRCSEC1, MRCSEC2, MRCSEC3, and MRCSEC4.

Related Posts:

  • No Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *