Create Table New As Select From Old Where 1 2 Maximo Database Configuration

You are searching about Create Table New As Select From Old Where 1 2, today we will share with you article about Create Table New As Select From Old Where 1 2 was compiled and edited by our team from many sources on the internet. Hope this article on the topic Create Table New As Select From Old Where 1 2 is useful to you.

Maximo Database Configuration

ADD

1) Link the fields to the Domain (predefined lists)

2) Bind fields to conditional expressions (to change attributes depending on the state/status of the object)

3) Link fields to Coding (to do cool stuff!)

4) Copy values ​​from other documents (i.e. get values ​​on PO invoice)

Added attribute in database configuration

Database configuration is used to make changes to the underlying database directly from Maximo. The app includes features for:

1) Create new Maximo objects and modify existing objects that could be mapped into database tables

2) Administer attributes within these objects that could be mapped into database attributes

3) Administer database indexes

4) Administer relationships with other Maximo objects

Changes to this application may have adverse effects on the system and should therefore be tried in a test environment before replicating in a live system.

The following steps describe how to add an attribute to an existing object:

1) From the Go To menu, select System Setup > Platform Setup > Database Setup

2) In the List tab, find and select the object to which you want to add an attribute. Object names always match objects that exist in the database

3) Select the Attributes tab

4) Click on the New line button

5) Add the following details:

a. Attribute – the internal name to use for the new field

b. Description – used to describe the use of the field to users and will appear in the context sensitive help screen

vs. Type – the type of the field which can include:

I. ALN – Alphanumeric

ii. UPPERCASE – Uppercase

iii. YORN – Boolean Yes/No

iv. DATE – Date value

v. DATETIME – Date and time value

vi. INT – Integer

D. Length – the length of the field

e. Required – if the field can be left blank by users

F. Title – the description of the field to use on screen

g. Domain – a link to an existing list of values ​​from which the user can select

h. Default value – the value to add to the field when a new instance is created, this can be changed later by the user

6) Save the recording

Once the record is saved, Maximo knows that the new zone is pending configuration, but this change will not be mapped to the database until the database configuration routine has been run.

Enter administrative mode

To be able to run the configuration routine directly from the Maximo application, the system must be switched to administrative mode. Administrative mode means that only specific users will be allowed into the system, usually those who are part of the administrator groups, and disconnects all other users and does not offer any remote connectivity (therefore it will only allow than the connection via the server).

Enabling administrator mode will log all users out of the system and should therefore be used with caution.

Administrative mode also suspends all running cron jobs and listeners.

Administrative mode can be enabled from the Database Configuration application. To activate it:

1) Click on the List tab of the Database Configuration application

2) From the Select Action menu, select Manage Admin Mode

3) Click Enable Admin Mode. Depending on your system settings, you may be prompted for your password and the reason for it.

4) Periodically click the Refresh Status button. When the system is in Admin mode, you will receive a message indicating this.

The system must be set to administrator mode with the user who has access to the system when it is in administrator mode, otherwise the user will be logged out.

Database Setup

When the system has been successfully configured in Admin mode, the next step is to configure the database. The database configuration routine maps changes made in the Maximo Database Configuration application to the database.

Warning: Before proceeding with this step, make sure to perform a database backup. This can be used to revert to the previous state in case of problems with the database configuration.

This can be done by:

1) Click on the List tab of the Database Configuration application

2) Make sure the message “Do you have a current backup?” the box is checked

3) Click the Start database configuration button. Depending on your system settings, you may be prompted for your password and the reason for it.

4) Periodically click the Refresh Status button. This will retrieve the current state of the process and display it on the screen. Once the process is complete, you will receive a message indicating this.

Adding the attribute to the application

At this point, the attribute has been added to the database, but it is not yet available for users to interact with. For users to use the new field, it must be added to the appropriate application. This can be done through the Application Designer application in Maximo. This can be done by following these steps:

1) From the Go To menu, select System Setup > Platform Setup > Application Designer

2) In the List tab, find and select the app you want to edit

3) This will take you to the workspace tab which will display a WYSIWYG copy of the application which can be edited using the toolbar menu selections

The functions circled from left to right are:

i) Control Palette – used to add new controls to the application including text boxes, sections and tables

ii) Control properties – used to modify the properties of the currently active control

4) Open the control palette by clicking on the first button circled above.

5) Drag the text box to the place in the application where you want to add the newly created field

6) Once added in the right place, use the Control Properties dialog to define the details of the new field

7) In the dialog box, here are the most important fields:

I. Label – the value to display next to the field, when not using the default

ii. Attribute – the name of the attribute created in the database application

iii. Lookup – any lookup to assign to the field (use DATELOOKUP for date fields and VALUELIST for fields related to Maximo domains)

iv. Input mode – specifies whether the field is read-only or required

8) When finished, save the application and test it directly in Maximo.

Warning: Modifying an application must be done when no user is using this application. If someone is using the application, the user may be logged out of the system without warning, resulting in loss of work.

Before making any changes to an app, be sure to take feedback from the app. This can be done through the Application Designer app by following these steps:

1) From the Go To menu, select System Setup > Platform Setup > Application Designer

2) In the List tab, find and select the app you want to backup

3) On the Workspace tab, click Export Application Definition.

This will export the selected app to an XML format which should be saved and kept safe in case you need to revert to an older version of the app.

Remember: Disable admin mode after all changes are made to allow users to re-enter the system.

Video about Create Table New As Select From Old Where 1 2

You can see more content about Create Table New As Select From Old Where 1 2 on our youtube channel: Click Here

Question about Create Table New As Select From Old Where 1 2

If you have any questions about Create Table New As Select From Old Where 1 2, please let us know, all your questions or suggestions will help us improve in the following articles!

The article Create Table New As Select From Old Where 1 2 was compiled by me and my team from many sources. If you find the article Create Table New As Select From Old Where 1 2 helpful to you, please support the team Like or Share!

Rate Articles Create Table New As Select From Old Where 1 2

Rate: 4-5 stars
Ratings: 6267
Views: 13448471

Search keywords Create Table New As Select From Old Where 1 2

Create Table New As Select From Old Where 1 2
way Create Table New As Select From Old Where 1 2
tutorial Create Table New As Select From Old Where 1 2
Create Table New As Select From Old Where 1 2 free
#Maximo #Database #Configuration

Source: https://ezinearticles.com/?Maximo-Database-Configuration&id=7314243

Related Posts

default-image-feature

Things To Do With A 1 Year Old Near Me A Life Of Anxiety And The World Around You

You are searching about Things To Do With A 1 Year Old Near Me, today we will share with you article about Things To Do With A…

default-image-feature

Crafts To Do With A 1 Year Old On Pintrest The Main Reasons Why One Should Start Scrapbooking Today

You are searching about Crafts To Do With A 1 Year Old On Pintrest, today we will share with you article about Crafts To Do With A…

default-image-feature

How Often Should A 1 Month Old Breastfeed At Night Ways to Stop Breastfeeding Your Baby

You are searching about How Often Should A 1 Month Old Breastfeed At Night, today we will share with you article about How Often Should A 1…

default-image-feature

Crafts To Do With A 1 1 2 Year Old Worldwide Hop Shortage – Will Homebrewer’s Get Hopping Mad Or Smile Over The Brew Kettle?

You are searching about Crafts To Do With A 1 1 2 Year Old, today we will share with you article about Crafts To Do With A…

default-image-feature

Places To Take 1 Year Old For Fun Near Me 4 Years Later… It’s Still Mind Blowing! – Assassin’s Creed Origins Memphis Side Quests Part 1

You are searching about Places To Take 1 Year Old For Fun Near Me, today we will share with you article about Places To Take 1 Year…

default-image-feature

How Old Were The Kids In Stranger Things Season 1 How Are You Supposed to Feel When a 29 Year Old Man Dies in Your Arms?

You are searching about How Old Were The Kids In Stranger Things Season 1, today we will share with you article about How Old Were The Kids…