Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  How to Run PL/Sql Using DBC in maximo

    Posted 06/03/21 07:36 AM
    Hi All,

    Is there any way to run PL/SQL using dbc in maximo.


    Regards,
    Sahil

    #Maximo
    #AssetandFacilitiesManagement


  • 2.  RE: How to Run PL/Sql Using DBC in maximo

    Posted 06/04/21 09:40 AM
    Edited by System Admin 03/22/23 11:46 AM
    You can use the 'freeform' tag to run sql from a dbc file.
    <freeform description="your description">
      <sql target="all">
        sql statement1;
        sql statement2;
      </sql>
    </freeform>

    Here is the relevant section from the dbc dtd file:
    <!ELEMENT freeform (sql+) >
    <!ATTLIST freeform
        description CDATA #REQUIRED
    >
    <!ELEMENT sql (#PCDATA)>
    <!ATTLIST sql
        target (oracle|sqlserver|db2|all|not_oracle|not_sqlserver|not_db2) "all"
    >

    edit: I doubt you would be able to execute PL/sql from the freeform tag, but you could always give it a try.
    ------------------------------
    Donovan Smith
    ------------------------------



  • 3.  RE: How to Run PL/Sql Using DBC in maximo

    Posted 06/04/21 03:49 PM
    What do you mean by "dbc"?

    Thanks.


  • 4.  RE: How to Run PL/Sql Using DBC in maximo

    Posted 06/07/21 11:08 AM
    A DBC file is how IBM applies changes during patches. Each product (such as Maximo, Service Provider, etc.) has a dedicated folder of files. These files are a combination of DBC files (which are XML documents), SQL files (though rare), java classes (for more complicated processing that can't be done via DBC file alone), and MSG/MXS (messages and the delta of application screen changes) that get executed in a defined order to apply a patch.

    Some business partners (such as ourselves) use this same framework to migrate changes because it gives us a solid framework that we know IBM will continue to support and works well across Maximo versions and customer implementations. For example, if you need to perform an insert and a customer adds required fields to that object, the framework will handle setting the default values for those. If you make a length change to an attribute and that attribute has sameas settings defined, this will go through and adjust all those same as attributes as well.

    The biggest downside is that these are intended to be done while the application is down. So migrating some changes will require an outage that would not necessarily be required if doing it through the front end. But it's a great way to package up a solution to provide to other users.

    ------------------------------
    Steven Shull
    Director of Development
    Projetech Inc
    Cincinnati OH
    ------------------------------

    Original Message


  • 5.  RE: How to Run PL/Sql Using DBC in maximo

    Posted 06/08/21 08:52 AM
    Recently the wiki was shut down and the very nice IBM documentation on using dbc's was lost. Can somone retrieve a copy and make it available either here or another IBM link?

    ------------------------------
    jeffk 2BC7
    interloc solutions
    grand rapids MI
    ------------------------------

    Original Message


Related Content