Add an attribute to maximo table from backend.

Hi,

You can use simple script below to add attribute to maximo table from backend. Follow the steps below.

1. Make sure you have write permission to the maximo database.
2. Connect to maximo database using utility like SQL Developer or TOAD
3. Execute two SQL statements below

insert into maxattributecfg (OBJECTNAME,ATTRIBUTENAME,ALIAS,AUTOKEYNAME,ATTRIBUTENO,CANAUTONUM,CLASSNAME,COLUMNNAME,DEFAULTVALUE,DOMAINID,EAUDITENABLED,ENTITYNAME,ESIGENABLED,ISLDOWNER,ISPOSITIVE,LENGTH,MAXTYPE,MUSTBE,REQUIRED,PERSISTENT,PRIMARYKEYCOLSEQ,REMARKS,SAMEASATTRIBUTE,SAMEASOBJECT,SCALE,TITLE,USERDEFINED,CHANGED,SEARCHTYPE,MLSUPPORTED,MLINUSE,HANDLECOLUMNNAME,MAXATTRIBUTEID,RESTRICTED,LOCALIZABLE,TEXTDIRECTION,COMPLEXEXPRESSION)
values ('MAXSESSION', 'XUNIT', 'XUNIT', null, 19, 0, null,'XUNIT', null, null, 0, 'MAXSESSION',0,0,0,20,'UPPER',0,0,1,null,'Unit of the current session',null,null,0,'Session Unit',1,'I','NONE',0,0,null,MAXATTRIBUTECFGSEQ.NEXTVAL,0,0,null,null);

update maxobjectcfg set changed = 'A' where objectname = 'MAXSESSION';

4. Commit changes.
5. Run configDB from database configuration application or stop application server and run it from command prompt. (configdb.bat)
6. Done