java.lang.StringIndexOutOfBoundsException: String index out of range: -991
        at java.lang.String.<init>(String.java:246)
        at java.lang.String.copyValueOf(String.java:2004)
        at org.netbeans.modules.java.gj.V8TreeTranslator.getString(V8TreeTranslator.java:136)
        at org.netbeans.modules.java.gj.V8TreeTranslator._case(V8TreeTranslator.java:491)
        at org.netbeans.lib.javac.v8.tree.Tree$VarDef.visit(Tree.java:475)
        at org.netbeans.modules.java.gj.V8TreeTranslator._case(V8TreeTranslator.java:302)
        at org.netbeans.lib.javac.v8.tree.Tree$ClassDef.visit(Tree.java:389)
        at org.netbeans.modules.java.gj.V8TreeTranslator._case(V8TreeTranslator.java:188)
        at org.netbeans.lib.javac.v8.tree.Tree$TopLevel.visit(Tree.java:326)
        at org.netbeans.modules.java.gj.V8TreeTranslator.process(V8TreeTranslator.java:94)

        at org.netbeans.modules.java.gj.ParserEngine.completeRequest(ParserEngine.java:338)
        at org.netbeans.modules.java.gj.ParserEngine.parseObject(ParserEngine.java:175)
        at org.netbeans.modules.java.gj.JavaParserEngine.process(JavaParserEngine.java:107)
        at org.netbeans.modules.java.parser.ParsingSupport$Processor.process(ParsingSupport.java:635)
        at org.netbeans.modules.java.parser.ParsingSupport$Processor.parseLockModel(ParsingSupport.java:595)
        at org.netbeans.modules.java.parser.ParsingSupport$Processor.run(ParsingSupport.java:535)
        at org.openide.util.Task.run(Task.java:124)
        at org.openide.util.RequestProcessor$ProcessorThread.run(RequestProcessor.java:626)
/* Generated from 'ERModel.nrx' 7 Sep 2001 15:49:04 [v2.02] *//* Options: Crossref Decimal Java Logo Replace Trace1 Verbose3 */package com.abnamro.midms;





















public class ERModel extends com.abnamro.midms.Repository implements com.abnamro.midms.Model{private static final netrexx.lang.Rexx $01=netrexx.lang.Rexx.toRexx(".gzip");private static final netrexx.lang.Rexx $02=netrexx.lang.Rexx.toRexx("of");private static final netrexx.lang.Rexx $03=new netrexx.lang.Rexx(0);private static final netrexx.lang.Rexx $04=netrexx.lang.Rexx.toRexx("ACCESS");private static final netrexx.lang.Rexx $05=netrexx.lang.Rexx.toRexx("MySQL");private static final netrexx.lang.Rexx $06=netrexx.lang.Rexx.toRexx(") ");private static final netrexx.lang.Rexx $07=new netrexx.lang.Rexx(1);private static final netrexx.lang.Rexx $08=netrexx.lang.Rexx.toRexx("Message: ");private static final netrexx.lang.Rexx $09=netrexx.lang.Rexx.toRexx("SQLCode: ");private static final netrexx.lang.Rexx $010=new netrexx.lang.Rexx('\'');private static final netrexx.lang.Rexx $011=netrexx.lang.Rexx.toRexx("ORDER BY 1");private static final netrexx.lang.Rexx $012=netrexx.lang.Rexx.toRexx("SQLState:");private static final netrexx.lang.Rexx $013=netrexx.lang.Rexx.toRexx(")) ");private static final netrexx.lang.Rexx $014=netrexx.lang.Rexx.toRexx("IN (");private static final netrexx.lang.Rexx $015=netrexx.lang.Rexx.toRexx(" OID");private static final netrexx.lang.Rexx $016=netrexx.lang.Rexx.toRexx("_OID");private static final netrexx.lang.Rexx $017=netrexx.lang.Rexx.toRexx("2674");private static final netrexx.lang.Rexx $018=netrexx.lang.Rexx.toRexx("2677");private static final netrexx.lang.Rexx $019=netrexx.lang.Rexx.toRexx("2626");private static final netrexx.lang.Rexx $020=netrexx.lang.Rexx.toRexx("EntityOID:");private static final netrexx.lang.Rexx $021=new netrexx.lang.Rexx(')');private static final netrexx.lang.Rexx $022=netrexx.lang.Rexx.toRexx("EntityID:");private static final netrexx.lang.Rexx $023=netrexx.lang.Rexx.toRexx(")));");private static final netrexx.lang.Rexx $024=netrexx.lang.Rexx.toRexx(" CASE ");private static final java.lang.String $0="ERModel.nrx";private static final netrexx.lang.Rexx $025=netrexx.lang.Rexx.toRexx(" of ");private static final netrexx.lang.Rexx $026=netrexx.lang.Rexx.toRexx(" objects");

/* properties indirect */

private netrexx.lang.Rexx modelname;
private netrexx.lang.Rexx safemodelname;
private netrexx.lang.Rexx commentscopes;
private netrexx.lang.Rexx modelversion;
private int entitycount;
private int attributecount;
private int relationcount;
private int subtypesetcount;
private int subjectareacount;
private int infotypecount;
private java.util.ArrayList modeldata;
private java.util.ArrayList modeldatatypes;
private java.util.TreeMap oidIndexMap;
private java.util.TreeMap cloidIndexMap;
private java.util.ArrayList cl;
private java.util.TreeMap oidHierarchyMap;
private javax.swing.JFrame parentFrame;
private java.sql.Connection con;
private com.abnamro.midms.timeit timer;
private boolean istimedisplayed;

/* properties public */

public javax.swing.ProgressMonitor pMonitor;
public int alreadyread;
public int size;





public ERModel(com.abnamro.midms.Scopable s_,java.sql.Connection con_){super();com.abnamro.midms.RexxComparator rComp=null;
{try{
setParentFrame(s_.getParentFrame());
this.con=con_;
this.commentscopes=s_.getQuotedCommentNames();
rComp=new com.abnamro.midms.RexxComparator();
oidIndexMap=new java.util.TreeMap((java.util.Comparator)rComp);
cloidIndexMap=new java.util.TreeMap((java.util.Comparator)rComp);
oidHierarchyMap=new java.util.TreeMap((java.util.Comparator)rComp);
cl=new java.util.ArrayList(20000);
this.timer=new com.abnamro.midms.timeit();
makeModel(s_.getQuotedNames(),new netrexx.lang.Rexx((byte)0));}
catch (java.io.FileNotFoundException $1){}
catch (java.io.IOException $2){}
catch (java.lang.ClassNotFoundException $3){
}}

return;}





public ERModel(netrexx.lang.Rexx mname,netrexx.lang.Rexx mversion){super();com.abnamro.midms.RexxComparator rComp=null;
{try{
rComp=new com.abnamro.midms.RexxComparator();
oidIndexMap=new java.util.TreeMap((java.util.Comparator)rComp);
cloidIndexMap=new java.util.TreeMap((java.util.Comparator)rComp);
oidHierarchyMap=new java.util.TreeMap((java.util.Comparator)rComp);
cl=new java.util.ArrayList(10000);
this.timer=new com.abnamro.midms.timeit();
makeModel(mname,mversion);}
catch (java.io.FileNotFoundException $4){}
catch (java.io.IOException $5){}
catch (java.lang.ClassNotFoundException $6){
}}

return;}



public void makeModel(netrexx.lang.Rexx mname,netrexx.lang.Rexx mversion) throws java.io.FileNotFoundException,java.io.IOException,java.io.StreamCorruptedException,java.io.OptionalDataException,java.lang.ClassNotFoundException{java.io.File f;int result=0;
this.modeldata=new java.util.ArrayList();
this.modelname=mname;
this.modelversion=mversion;
safemodelname=mname.translate(netrexx.lang.Rexx.toRexx("  +"),netrexx.lang.Rexx.toRexx("/\',")).space(new netrexx.lang.Rexx((byte)0));

f=new java.io.File(netrexx.lang.Rexx.toString((safemodelname.OpCc(null,modelversion)).OpCc(null,$01)));
if (f.exists()) 
{
result=javax.swing.JOptionPane.showConfirmDialog((java.awt.Component)(getParentFrame()),(java.lang.Object)((((netrexx.lang.Rexx.toRexx("<html><P style=\"font-size: 11pt; font-family: Arial;\">Compiled datamodel").OpCcblank(null,safemodelname)).OpCcblank(null,$02)).OpCcblank(null,new netrexx.lang.Rexx(java.lang.String.valueOf(new java.util.Date(f.lastModified()))))).OpCcblank(null,netrexx.lang.Rexx.toRexx("found. Use it?"))),"Compiled datamodel Found",javax.swing.JOptionPane.YES_NO_OPTION);


if (new netrexx.lang.Rexx(result).OpEq(null,$03)) 
{
{try{
readModelData();}
catch (java.io.InvalidClassException $7){
result=javax.swing.JOptionPane.showConfirmDialog((java.awt.Component)(getParentFrame()),(java.lang.Object)((((netrexx.lang.Rexx.toRexx("Compiled datamodel").OpCcblank(null,safemodelname)).OpCcblank(null,$02)).OpCcblank(null,new netrexx.lang.Rexx(java.lang.String.valueOf(new java.util.Date(f.lastModified()))))).OpCcblank(null,netrexx.lang.Rexx.toRexx("Format Changed. It will be recreated."))),"Compiled datamodel Invalid Format",javax.swing.JOptionPane.YES_NO_OPTION);

}}
}
else constructAndSerializeModel();
}
else constructAndSerializeModel();
return;}



public void constructAndSerializeModel() throws java.io.FileNotFoundException,java.io.IOException{java.util.ArrayList v;java.util.ArrayList w;
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.setWaitCursor()));
this.size=6;
this.pMonitor=new javax.swing.ProgressMonitor((java.awt.Component)this.parentFrame,(java.lang.Object)("ERModel\'s Constructor is creating from the repository"),netrexx.lang.Rexx.toString((safemodelname.OpCc(null,modelversion)).OpCc(null,$01)),0,this.size);
this.pMonitor.setProgress(0);
this.pMonitor.setMillisToPopup(0);
this.pMonitor.setMillisToDecideToPopup(0);
this.alreadyread=0;
{try{
LoadJDBCDriver();}
catch (java.lang.Exception $8){
netrexx.lang.RexxIO.Say("no database connection");
return;
}}
v=new java.util.ArrayList((java.util.Collection)(getEntities()));
this.pMonitor.setProgress(1);
this.alreadyread=1;
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.updateCounter()));
v=addAttributesForEntities(v);
this.pMonitor.setProgress(2);
this.alreadyread=2;
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.updateCounter()));
v=addSubTypeSetsForEntities(v);
this.pMonitor.setProgress(3);
this.alreadyread=3;
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.updateCounter()));
v=addRelationsForEntities(v);
this.pMonitor.setProgress(4);
this.alreadyread=4;
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.updateCounter()));
setModeldata(v);
w=getDatatypes();
this.pMonitor.setProgress(5);
this.alreadyread=5;
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.updateCounter()));
setModeldatatypes(w);
makeIndexMap();
cl=selectClassificationsInScope();
makeclIndexMap();
this.pMonitor.setProgress(6);
this.alreadyread=6;
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.updateCounter()));
makeHierarchyMap();
this.pMonitor.setProgress(7);
this.alreadyread=7;
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.updateCounter()));
writeModelData(v,w,this.oidIndexMap,this.oidHierarchyMap,this.cloidIndexMap,this.cl);
this.pMonitor.setProgress(8);
this.alreadyread=8;
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.updateCounter()));
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.setDefaultCursor()));
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.closeMonitor()));
netrexx.lang.RexxIO.Say(new netrexx.lang.Rexx(entitycount).OpCcblank(null,netrexx.lang.Rexx.toRexx("entities selected")));
netrexx.lang.RexxIO.Say(new netrexx.lang.Rexx(attributecount).OpCcblank(null,netrexx.lang.Rexx.toRexx("attributes selected")));
netrexx.lang.RexxIO.Say(new netrexx.lang.Rexx(relationcount).OpCcblank(null,netrexx.lang.Rexx.toRexx("relationships selected")));
netrexx.lang.RexxIO.Say(new netrexx.lang.Rexx(subtypesetcount).OpCcblank(null,netrexx.lang.Rexx.toRexx("subtypes selected")));
netrexx.lang.RexxIO.Say(new netrexx.lang.Rexx(infotypecount).OpCcblank(null,netrexx.lang.Rexx.toRexx("information types selected.")));return;}



public void LoadJDBCDriver() throws java.sql.SQLException{

{
this.dbmeta=this.con.getMetaData();
this.engine=netrexx.lang.Rexx.toRexx(this.dbmeta.getDatabaseProductName());
this.stmt=this.con.createStatement();
if ((this.engine.pos(netrexx.lang.Rexx.toRexx("DB2"))).OpGt(null,$03)) 
this.stmt.executeUpdate("SET CURRENT SQLID = MIS ");

this.stmt2=this.con.createStatement();
this.stmt3=this.con.createStatement();


}return;}










public java.util.ArrayList getEntities(){java.util.ArrayList v;netrexx.lang.Rexx QS=null;netrexx.lang.Rexx shortname=null;netrexx.lang.Rexx shortRoleName=null;com.abnamro.midms.Entity erEnt=null;netrexx.lang.Rexx componentType=null;java.util.ArrayList x=null;netrexx.lang.Rexx definition=null;netrexx.lang.Rexx icomment=null;java.sql.SQLException e2=null;
if (istimedisplayed) netrexx.lang.RexxIO.Say(netrexx.lang.Rexx.toRexx("in getEntities").OpCcblank(null,this.timer.getDiff()));

v=new java.util.ArrayList();
{try{
{/*select*/
if (this.engine.OpEq(null,$04))
{

QS=(netrexx.lang.Rexx.toRexx("SELECT Distinct ENT.CL_NM AS ENT_NM, ENT.CL_DSC AS ENT_DSC, ENT.CL_OID AS ENT_OID, ENT.ABR_NM, 0 AS VERSION, ERM_CMPNT_TP.CL_NM AS ERM_CMPNT_TP_NM FROM (((CL AS SCOP INNER JOIN CL_X_CL AS SCOP_INCL_CL ON SCOP.CL_OID = SCOP_INCL_CL.[SBJ CL_OID]) INNER JOIN CL AS ENT ON SCOP_INCL_CL.OBJ_CL_OID = ENT.CL_OID) INNER JOIN CL_X_CL AS ERM_CMPNT_IMPL_CL ON ENT.CL_OID = ERM_CMPNT_IMPL_CL.OBJ_CL_OID) INNER JOIN CL AS ERM_CMPNT_TP ON ERM_CMPNT_IMPL_CL.[SBJ CL_OID] = ERM_CMPNT_TP.CL_OID WHERE SCOP.CL_NM IN (").OpCc(null,this.modelname)).OpCc(null,netrexx.lang.Rexx.toRexx(") AND 0=0 AND ERM_CMPNT_TP.CL_OID In (2625,2792,2793,10008702,10008926) AND SCOP.PBLSD_SCM_OID=2618 AND SCOP_INCL_CL.[CL X_CL TP_OID]=2637 AND ERM_CMPNT_IMPL_CL.[CL X_CL TP_OID]=2636;"));
}
else if ((this.engine.pos(netrexx.lang.Rexx.toRexx("DB2"))).OpGt(null,$03)||this.engine.OpEq(null,$05))
{
QS=((((((((((((netrexx.lang.Rexx.toRexx("SELECT Distinct ENT.CL_NM AS ENT_NM, ENT.CL_OID AS ENT_OID, ENT.ABR_NM, ").OpCcblank(null,netrexx.lang.Rexx.toRexx("0 AS VERSION, ERM_CMPNT_TP.CL_NM AS ERM_CMPNT_TP_NM "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("FROM (((CL AS SCOP INNER JOIN CL_X_CL AS SCOP_INCL_CL "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("ON SCOP.CL_OID = SCOP_INCL_CL.SBJ_CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL AS ENT ON SCOP_INCL_CL.OBJ_CL_OID = ENT.CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL_X_CL AS ERM_CMPNT_IMPL_CL ON ENT.CL_OID = ERM_CMPNT_IMPL_CL.OBJ_CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL AS ERM_CMPNT_TP ON ERM_CMPNT_IMPL_CL.SBJ_CL_OID = ERM_CMPNT_TP.CL_OID "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("WHERE SCOP.CL_NM IN ("))).OpCc(null,this.modelname)).OpCc(null,$06)).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ERM_CMPNT_TP.CL_OID In (2625,2792,2793,10008702,10008926) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND SCOP.PBLSD_SCM_OID=2618 "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND SCOP_INCL_CL.CL_X_CL_TP_OID=2637 "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ERM_CMPNT_IMPL_CL.CL_X_CL_TP_OID=2636 "));











}
else{}
}
this.rs=this.stmt.executeQuery(netrexx.lang.Rexx.toString(QS));
{for(;;){if(!new netrexx.lang.Rexx(this.rs.next()).OpNotEq(null,$03))break;
shortname=netrexx.lang.Rexx.toRexx("");
shortRoleName=netrexx.lang.Rexx.toRexx("");
erEnt=new com.abnamro.midms.Entity();
erEnt.setName(netrexx.lang.Rexx.toRexx(this.rs.getString("ENT_NM")));
erEnt.setOid(netrexx.lang.Rexx.toRexx(this.rs.getString("ENT_OID")));
shortname=netrexx.lang.Rexx.toRexx(this.rs.getString("ABR_NM"));
componentType=netrexx.lang.Rexx.toRexx(this.rs.getString("ERM_CMPNT_TP_NM"));
erEnt.setAbbreviatedname(shortname);
if (shortRoleName!=null) erEnt.setAbbreviatedrolename(shortRoleName);
if (componentType!=null) 
{
erEnt.setComponenttype(componentType);
}
else erEnt.setComponenttype(netrexx.lang.Rexx.toRexx("UNKNOWN"));

x=new java.util.ArrayList((java.util.Collection)(getScopedComment(erEnt.getOid())));
if (new netrexx.lang.Rexx(x.size()).OpNotEq(null,$03)) erEnt.setCommentslist(x);

definition=getDefinition(erEnt.getOid());
if (definition==null) definition=netrexx.lang.Rexx.toRexx("");
erEnt.setDefinition(definition);

icomment=netrexx.lang.Rexx.toRexx("");
erEnt.setComment(icomment);
v.add((java.lang.Object)erEnt);
entitycount=new netrexx.lang.Rexx(entitycount).OpAdd(null,$07).toint();
}}
return v;}

catch (java.sql.SQLException $9){e2=$9;
netrexx.lang.RexxIO.Say("SQLException(s) caught in getEntities");
{for(;;){if(!((e2!=null)))break;

netrexx.lang.RexxIO.Say($08.OpCcblank(null,netrexx.lang.Rexx.toRexx(e2.getMessage())));
netrexx.lang.RexxIO.Say($09.OpCcblank(null,new netrexx.lang.Rexx(e2.getErrorCode())));
netrexx.lang.RexxIO.Say("");
e2=e2.getNextException();
}}
return v;
}}}









public java.util.ArrayList getSubjectAreas(){java.util.ArrayList v;netrexx.lang.Rexx line=null;java.sql.SQLException e2=null;
v=new java.util.ArrayList();
{try{
this.rs=this.stmt.executeQuery(netrexx.lang.Rexx.toString((((((((netrexx.lang.Rexx.toRexx("SELECT subj_name").OpCcblank(null,netrexx.lang.Rexx.toRexx("FROM subject a, erw_diag b"))).OpCcblank(null,netrexx.lang.Rexx.toRexx("WHERE b.diag_id = a.diag_id"))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND b.diag_name = \'"))).OpCc(null,this.modelname)).OpCc(null,$010)).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND b.version = "))).OpCcblank(null,this.modelversion)).OpCcblank(null,$011)));






subjectareacount=0;
{for(;;){if(!new netrexx.lang.Rexx(this.rs.next()).OpNotEq(null,$03))break;
line=netrexx.lang.Rexx.toRexx(this.rs.getString("subj_name"));
if (line.OpNotEq(null,netrexx.lang.Rexx.toRexx("<Main Subject Area>"))) 
{
v.add((java.lang.Object)line);
subjectareacount=new netrexx.lang.Rexx(subjectareacount).OpAdd(null,$07).toint();
}
}}
return v;}

catch (java.sql.SQLException $10){e2=$10;
netrexx.lang.RexxIO.Say("SQLException(s) caught in getEntitiesForModel");
{for(;;){if(!((e2!=null)))break;
netrexx.lang.RexxIO.Say($012.OpCcblank(null,netrexx.lang.Rexx.toRexx(e2.getSQLState())));
netrexx.lang.RexxIO.Say($08.OpCcblank(null,netrexx.lang.Rexx.toRexx(e2.getMessage())));
netrexx.lang.RexxIO.Say($09.OpCcblank(null,new netrexx.lang.Rexx(e2.getErrorCode())));
netrexx.lang.RexxIO.Say("");
e2=e2.getNextException();
}}
return v;
}}}






public java.util.ArrayList getAttributesForEntity(netrexx.lang.Rexx entityOID){java.util.ArrayList v;netrexx.lang.Rexx QS=null;netrexx.lang.Rexx lname=null;netrexx.lang.Rexx rln=null;netrexx.lang.Rexx histreq=null;netrexx.lang.Rexx ranked=null;netrexx.lang.Rexx abrname=null;netrexx.lang.Rexx lcard=null;netrexx.lang.Rexx tofromcard=null;netrexx.lang.Rexx lkey=null;netrexx.lang.Rexx lcmpnttype=null;netrexx.lang.Rexx infotype=null;netrexx.lang.Rexx attroid=null;netrexx.lang.Rexx shortRoleName=null;netrexx.lang.Rexx Rank=null;netrexx.lang.Rexx ldef=null;netrexx.lang.Rexx idrelation=null;netrexx.lang.Rexx icomment=null;com.abnamro.midms.Attribute erAtt=null;java.util.ArrayList x=null;java.sql.SQLException e2=null;
if (istimedisplayed) netrexx.lang.RexxIO.Say(netrexx.lang.Rexx.toRexx("in getAttributesForEntity").OpCcblank(null,this.timer.getDiff()));
v=new java.util.ArrayList();
{try{
{/*select*/
if (this.engine.OpEq(null,$04))
{
QS=(((((((netrexx.lang.Rexx.toRexx("SELECT DISTINCT RLN.HIST_RQM_IND AS HIST_REQ, RLN.RANK_RLN_IND AS RANKED, RLN.CL_OID AS RLN_OID, SBJ_ENT.CL_OID AS SBJ_OID, SBJ_ENT.CL_NM AS SBJ_NM, SBJ_CRDNL.CL_NM AS SBJ_CRDNL_NM, SBJ_ENT.ABR_NM, RLN.ABR_RL_NM, RLN.X_NM AS Expr1, RLN.[RVRS_X _NM], IIf([ERM_CMPNT_TP].[CL_OID]=2626,Trim([RLN].[RL_NM] & \' \' & [SBJ_ENT].[CL_NM]),Trim([RLN].[RL_NM] & \' \' & [SBJ_ENT].[CL_NM] & \' OID\')) AS ATT_NM, RLN.CL_DSC AS RLN_DSC, OBJ_ENT.CL_OID AS OBJ_OID, OBJ_ENT.CL_NM AS OBJ_NM, OBJ_CRDNL.CL_NM AS OBJ_CRDNL_NM, 0 AS VERSION, RLN.RANK AS RANK, RLN.ID_RLN_IND, IIf([RLN].[ID_RLN_IND]=2671 And ([RLN].[sbj_rln_crdnl_oid]=2631 Or [RLN].[sbj_rln_crdnl_oid]=2633),True,False) AS IS_ID, SBJ_CRDNL.CL_NM, ERM_CMPNT_TP.CL_OID AS ERM_CMPNT_TP_OID FROM CL AS OBJ_CRDNL INNER JOIN (CL AS OBJ_ENT INNER JOIN ((CL AS SBJ_ENT INNER JOIN ((((CL AS SCOP INNER JOIN CL_X_CL AS SCOP_INCL_CL ON SCOP.CL_OID = SCOP_INCL_CL.[SBJ CL_OID]) INNER JOIN CL AS RLN ON SCOP_INCL_CL.OBJ_CL_OID = RLN.CL_OID) INNER JOIN CL_X_CL AS ERM_CMPNT_IMPL_CL ON RLN.CL_OID = ERM_CMPNT_IMPL_CL.OBJ_CL_OID) INNER JOIN CL AS ERM_CMPNT_TP ON ERM_CMPNT_IMPL_CL.[SBJ CL_OID] = ERM_CMPNT_TP.CL_OID) ON SBJ_ENT.CL_OID = RLN.SBJ_CL_OID) INNER JOIN CL AS SBJ_CRDNL ON RLN.SBJ_RLN_CRDNL_OID = SBJ_CRDNL.CL_OID) ON OBJ_ENT.CL_OID = RLN.OBJ_CL_OID) ON OBJ_CRDNL.CL_OID = RLN.OBJ_RLN_CRDNL_OID WHERE (((SCOP.CL_NM) IN (").OpCc(null,this.modelname)).OpCc(null,netrexx.lang.Rexx.toRexx(")) AND ((OBJ_ENT.CL_OID)="))).OpCcblank(null,entityOID)).OpCcblank(null,netrexx.lang.Rexx.toRexx(") AND ((0)=0) AND ((ERM_CMPNT_TP.CL_OID)=2626) AND ((SCOP.PBLSD_SCM_OID)=2618) AND ((SCOP_INCL_CL.[CL X_CL TP_OID])=2637) AND ((ERM_CMPNT_IMPL_CL.[CL X_CL TP_OID])=2636)) OR (((SCOP.CL_NM) IN ("))).OpCc(null,this.modelname)).OpCc(null,netrexx.lang.Rexx.toRexx(")) AND ((OBJ_ENT.CL_OID)="))).OpCcblank(null,entityOID)).OpCcblank(null,netrexx.lang.Rexx.toRexx(") AND ((0)=0) AND ((ERM_CMPNT_TP.CL_OID)=2627) AND ((SCOP.PBLSD_SCM_OID)=2618) AND ((SCOP_INCL_CL.[CL X_CL TP_OID])=2637) AND ((ERM_CMPNT_IMPL_CL.[CL X_CL TP_OID])=2636))"));
}
else if ((this.engine.pos(netrexx.lang.Rexx.toRexx("DB2"))).OpGt(null,$03)||this.engine.OpEq(null,$05))
{
QS=((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((netrexx.lang.Rexx.toRexx("SELECT DISTINCT RLN.HIST_RQM_IND AS HIST_REQ, RLN.RANK_RLN_IND AS RANKED, ").OpCcblank(null,netrexx.lang.Rexx.toRexx("RLN.CL_OID AS RLN_OID, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("SBJ_ENT.CL_OID AS SBJ_OID, SBJ_ENT.CL_NM AS SBJ_NM, SBJ_CRDNL.CL_NM AS SBJ_CRDNL_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("SBJ_ENT.ABR_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("RLN.ABR_RL_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("RLN.RL_NM AS RL_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("CASE WHEN ERM_CMPNT_TP.CL_OID=2626 THEN SBJ_ENT.CL_NM "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("ELSE CONCAT(SBJ_ENT.CL_NM,\' OID\') END AS ATT_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("OBJ_CRDNL.CL_NM AS OBJ_CRDNL_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("RLN.RANK AS RANK, RLN.ID_RLN_IND, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("CASE WHEN RLN.ID_RLN_IND=2671 And RLN.sbj_rln_crdnl_oid=2631 Or RLN.sbj_rln_crdnl_oid=2633 "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("THEN \'True\' ELSE \'False\' END AS IS_ID, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("SBJ_CRDNL.CL_NM, ERM_CMPNT_TP.CL_OID AS ERM_CMPNT_TP_OID "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("FROM CL AS OBJ_CRDNL "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN (CL AS OBJ_ENT "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN ((CL AS SBJ_ENT "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN ((((CL AS SCOP INNER JOIN CL_X_CL AS SCOP_INCL_CL ON SCOP.CL_OID = "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("SCOP_INCL_CL.SBJ_CL_OID) INNER JOIN CL AS RLN ON SCOP_INCL_CL.OBJ_CL_OID = RLN.CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL_X_CL AS ERM_CMPNT_IMPL_CL ON RLN.CL_OID = ERM_CMPNT_IMPL_CL.OBJ_CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL AS ERM_CMPNT_TP ON ERM_CMPNT_IMPL_CL.SBJ_CL_OID = ERM_CMPNT_TP.CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("ON SBJ_ENT.CL_OID = RLN.SBJ_CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL AS SBJ_CRDNL ON RLN.SBJ_RLN_CRDNL_OID = SBJ_CRDNL.CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("ON OBJ_ENT.CL_OID = RLN.OBJ_CL_OID) ON OBJ_CRDNL.CL_OID = RLN.OBJ_RLN_CRDNL_OID "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("WHERE (((SCOP.CL_NM) IN ("))).OpCc(null,this.modelname)).OpCc(null,$013)).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((OBJ_ENT.CL_OID)= "))).OpCcblank(null,entityOID)).OpCcblank(null,$06)).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((0)=0) AND ((ERM_CMPNT_TP.CL_OID)=2626) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((SCOP.PBLSD_SCM_OID)=2618) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((SCOP_INCL_CL.CL_X_CL_TP_OID)=2637) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((ERM_CMPNT_IMPL_CL.CL_X_CL_TP_OID)=2636)) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("UNION ALL  "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("SELECT DISTINCT RLN.HIST_RQM_IND AS HIST_REQ, RLN.RANK_RLN_IND AS RANKED,   "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("RLN.CL_OID AS RLN_OID,   "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("SBJ_ENT.CL_OID AS SBJ_OID, SBJ_ENT.CL_NM AS SBJ_NM, SBJ_CRDNL.CL_NM AS SBJ_CRDNL_NM,   "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("SBJ_ENT.ABR_NM,   "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("RLN.ABR_RL_NM,  "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("RLN.RL_NM AS RL_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("CASE WHEN ERM_CMPNT_TP.CL_OID=2626 THEN SBJ_ENT.CL_NM   "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("ELSE CONCAT(SBJ_ENT.CL_NM,\' OID\') END AS ATT_NM,   "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("OBJ_CRDNL.CL_NM AS OBJ_CRDNL_NM,     "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("RLN.RANK AS RANK, RLN.ID_RLN_IND,   "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("CASE WHEN RLN.ID_RLN_IND=2671 And RLN.sbj_rln_crdnl_oid=2631 Or RLN.sbj_rln_crdnl_oid=2633  "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("THEN \'True\' ELSE \'False\' END AS IS_ID,   "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("SBJ_CRDNL.CL_NM, ERM_CMPNT_TP.CL_OID AS ERM_CMPNT_TP_OID   "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("FROM CL AS OBJ_CRDNL   "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN (CL AS OBJ_ENT  "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN ((CL AS SBJ_ENT   "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN ((((CL AS SCOP INNER JOIN CL_X_CL AS SCOP_INCL_CL ON SCOP.CL_OID =   "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("SCOP_INCL_CL.SBJ_CL_OID) INNER JOIN CL AS RLN ON SCOP_INCL_CL.OBJ_CL_OID = RLN.CL_OID)   "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL_X_CL AS ERM_CMPNT_IMPL_CL ON RLN.CL_OID = ERM_CMPNT_IMPL_CL.OBJ_CL_OID)   "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL AS ERM_CMPNT_TP ON ERM_CMPNT_IMPL_CL.SBJ_CL_OID = ERM_CMPNT_TP.CL_OID)    "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("ON SBJ_ENT.CL_OID = RLN.SBJ_CL_OID)   "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL AS SBJ_CRDNL ON RLN.SBJ_RLN_CRDNL_OID = SBJ_CRDNL.CL_OID)    "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("ON OBJ_ENT.CL_OID = RLN.OBJ_CL_OID) ON OBJ_CRDNL.CL_OID = RLN.OBJ_RLN_CRDNL_OID   "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("WHERE (((SCOP.CL_NM) "))).OpCcblank(null,$014)).OpCc(null,this.modelname)).OpCc(null,$013)).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((OBJ_ENT.CL_OID)="))).OpCcblank(null,entityOID)).OpCcblank(null,$06)).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((ERM_CMPNT_TP.CL_OID)=2627) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((SCOP.PBLSD_SCM_OID)=2618) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((SCOP_INCL_CL.CL_X_CL_TP_OID)=2637) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((ERM_CMPNT_IMPL_CL.CL_X_CL_TP_OID)=2636)) "));



























































}
else{}
}
this.rs=this.stmt.executeQuery(netrexx.lang.Rexx.toString(QS));

{for(;;){if(!new netrexx.lang.Rexx(this.rs.next()).OpNotEq(null,$03))break;
lname=netrexx.lang.Rexx.toRexx(this.rs.getString("ATT_NM"));
if (this.rs.wasNull()) lname=netrexx.lang.Rexx.toRexx("");
if ((this.engine.pos(netrexx.lang.Rexx.toRexx("DB2"))).OpGt(null,$03)||this.engine.OpEq(null,$05)) 
{
rln=netrexx.lang.Rexx.toRexx(this.rs.getString("RL_NM"));
if (this.rs.wasNull()) rln=netrexx.lang.Rexx.toRexx("");
else lname=rln.OpCcblank(null,lname);
}
histreq=netrexx.lang.Rexx.toRexx(this.rs.getString("HIST_REQ"));
ranked=netrexx.lang.Rexx.toRexx(this.rs.getString("RANKED"));
if (lname==null) lname=netrexx.lang.Rexx.toRexx("");
abrname=netrexx.lang.Rexx.toRexx(this.rs.getString("ABR_NM"));
if (abrname==null) abrname=netrexx.lang.Rexx.toRexx("");
if ((lname.right(new netrexx.lang.Rexx((byte)4))).OpEq(null,$015)) abrname=abrname.OpCc(null,$016);
lcard=netrexx.lang.Rexx.toRexx(this.rs.getString("OBJ_CRDNL_NM"));
tofromcard=netrexx.lang.Rexx.toRexx(this.rs.getString("SBJ_CRDNL_NM"));
lkey=netrexx.lang.Rexx.toRexx(this.rs.getString("IS_ID"));
lcmpnttype=netrexx.lang.Rexx.toRexx(this.rs.getString("ERM_CMPNT_TP_OID"));
infotype=netrexx.lang.Rexx.toRexx(this.rs.getString("SBJ_NM"));
attroid=netrexx.lang.Rexx.toRexx(this.rs.getString("RLN_OID"));
shortRoleName=netrexx.lang.Rexx.toRexx(this.rs.getString("ABR_RL_NM"));
Rank=netrexx.lang.Rexx.toRexx(this.rs.getString("RANK"));
{try{

ldef=getDefinition(attroid);}
catch (java.sql.SQLException $11){
;
}}
idrelation=netrexx.lang.Rexx.toRexx(this.rs.getString("ID_RLN_IND"));

icomment=netrexx.lang.Rexx.toRexx("");
erAtt=new com.abnamro.midms.Attribute();
if (lname!=null) erAtt.setName(lname);
if (abrname!=null) erAtt.setAbbreviatedname(abrname);
if (shortRoleName!=null) erAtt.setAbbreviatedrolename(shortRoleName);
if (lcard!=null) erAtt.setCardinality(lcard);
if (tofromcard!=null) erAtt.setTofromcardinality(tofromcard);
if (attroid!=null) erAtt.setOid(attroid);
if (lkey!=null) erAtt.setIskey(lkey);
if (ldef!=null) erAtt.setDefinition(ldef);
if (idrelation!=null) erAtt.setIdrelation(idrelation);
if (infotype!=null) erAtt.setInformationtype(infotype);
if ((histreq!=null)&histreq.OpEq(null,$017)) erAtt.setHistoryRequired(netrexx.lang.Rexx.toRexx("yes"));
else erAtt.setHistoryRequired(netrexx.lang.Rexx.toRexx("no"));
if ((ranked!=null)&ranked.OpEq(null,$018)) erAtt.setRanked(netrexx.lang.Rexx.toRexx("yes"));
else erAtt.setRanked(netrexx.lang.Rexx.toRexx("no"));
if (icomment!=null) erAtt.setComment(icomment);
if (lcmpnttype.OpEq(null,$019)) erAtt.setIsnative(netrexx.lang.Rexx.toRexx("native"));
else erAtt.setIsnative(netrexx.lang.Rexx.toRexx("nonnative"));
x=new java.util.ArrayList((java.util.Collection)(getScopedComment(erAtt.getOid())));
if (new netrexx.lang.Rexx(x.size()).OpNotEq(null,$03)) erAtt.setCommentslist(x);
if (Rank!=null) erAtt.setRank(Rank);
attributecount=new netrexx.lang.Rexx(attributecount).OpAdd(null,$07).toint();
v.add((java.lang.Object)erAtt);
}}
return v;}

catch (java.sql.SQLException $12){e2=$12;
netrexx.lang.RexxIO.Say("SQLException(s) caught in getAttributesForEntity");
{try{for(;;){if(!((e2!=null)))break;
{

netrexx.lang.RexxIO.Say($08.OpCcblank(null,netrexx.lang.Rexx.toRexx(e2.getMessage())));
netrexx.lang.RexxIO.Say((($09.OpCcblank(null,new netrexx.lang.Rexx(e2.getErrorCode()))).OpCcblank(null,$020)).OpCcblank(null,entityOID));
netrexx.lang.RexxIO.Say("");
e2=e2.getNextException();
}
}}catch (java.lang.NullPointerException $13){
;
}}
return v;
}}}







public java.util.ArrayList getParentAttributesForAttributiveEntities(netrexx.lang.Rexx entityID){java.util.ArrayList v;netrexx.lang.Rexx QS=null;netrexx.lang.Rexx lname=null;netrexx.lang.Rexx lcard=null;netrexx.lang.Rexx tofromcard=null;netrexx.lang.Rexx lkey=null;netrexx.lang.Rexx idrelation=null;netrexx.lang.Rexx infotype=null;netrexx.lang.Rexx abrname=null;netrexx.lang.Rexx attroid=null;netrexx.lang.Rexx shortRoleName=null;com.abnamro.midms.Attribute erAtt=null;netrexx.lang.Rexx icomment=null;java.sql.SQLException e2=null;
if (istimedisplayed) netrexx.lang.RexxIO.Say(netrexx.lang.Rexx.toRexx("in getParentAttributesForAttributiveEntities").OpCcblank(null,this.timer.getDiff()));

v=new java.util.ArrayList();
{try{
{/*select*/
if (this.engine.OpEq(null,$04))
{
QS=(((netrexx.lang.Rexx.toRexx("SELECT DISTINCT ENT.CL_OID AS RLN_OID, [SBJ_ENT].ABR_NM, [SBJ_ENT].ABR_RL_NM, ENT.SBJ_CL_OID AS SBJ_OID, SBJ_ENT.CL_NM AS SBJ_NM, SBJ_CRDNL.CL_NM AS SBJ_CRDNL_NM, ENT.X_NM, ENT.[RVRS_X _NM], [SBJ_ENT].[CL_NM] & \' OID\' AS ATT_NM, \'Identifies the parent \' & [SBJ_ENT].[CL_NM] AS RLN_DSC, ENT.CL_OID AS OBJ_OID, ENT.CL_NM AS OBJ_NM, \'1:1\' AS OBJ_CRDNL_NM, 0 AS VERSION, 1 AS RANK, ENT.ID_RLN_IND, False AS IS_ID, 2627 AS ERM_CMPNT_TP_OID, ENT.SBJ_CL_OID AS ATTROID FROM CL AS SBJ_ENT INNER JOIN (CL AS SBJ_CRDNL INNER JOIN ((((CL AS SCOP INNER JOIN CL_X_CL AS SCOP_INCL_CL ON SCOP.CL_OID = SCOP_INCL_CL.[SBJ CL_OID]) INNER JOIN CL AS ENT ON SCOP_INCL_CL.OBJ_CL_OID = ENT.CL_OID) INNER JOIN CL_X_CL AS ERM_CMPNT_IMPL_CL ON ENT.CL_OID = ERM_CMPNT_IMPL_CL.OBJ_CL_OID) INNER JOIN CL AS ERM_CMPNT_TP ON ERM_CMPNT_IMPL_CL.[SBJ CL_OID] = ERM_CMPNT_TP.CL_OID) ON SBJ_CRDNL.CL_OID = ENT.SBJ_RLN_CRDNL_OID) ON SBJ_ENT.CL_OID = ENT.OBJ_CL_OID WHERE (((SCOP.CL_NM)IN (").OpCc(null,this.modelname)).OpCc(null,netrexx.lang.Rexx.toRexx(")) AND ((ENT.CL_OID)="))).OpCcblank(null,entityID)).OpCcblank(null,netrexx.lang.Rexx.toRexx(") AND ((0)=0) AND ((ERM_CMPNT_TP.CL_OID) In (2792)) AND ((SCOP.PBLSD_SCM_OID)=2618) AND ((SCOP_INCL_CL.[CL X_CL TP_OID])=2637) AND ((ERM_CMPNT_IMPL_CL.[CL X_CL TP_OID])=2636));"));
}
else if ((this.engine.pos(netrexx.lang.Rexx.toRexx("DB2"))).OpGt(null,$03)||this.engine.OpEq(null,$05))
{
QS=(((((((((((((((((((((((((netrexx.lang.Rexx.toRexx("SELECT DISTINCT ENT.CL_OID AS RLN_OID, SBJ_ENT.ABR_NM, ").OpCcblank(null,netrexx.lang.Rexx.toRexx("SBJ_ENT.ABR_RL_NM, ENT.SBJ_CL_OID AS SBJ_OID, SBJ_ENT.CL_NM AS SBJ_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("SBJ_CRDNL.CL_NM AS SBJ_CRDNL_NM, ENT.X_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("ENT.RVRS_X_NM, CONCAT(SBJ_ENT.CL_NM,\' OID\') AS ATT_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("ENT.CL_OID AS OBJ_OID, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("ENT.CL_NM AS OBJ_NM, \'1:1\' AS OBJ_CRDNL_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("1 AS RANK, ENT.ID_RLN_IND, \'False\' AS IS_ID, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("2627 AS ERM_CMPNT_TP_OID, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("ENT.SBJ_CL_OID AS ATTROID "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("FROM CL AS SBJ_ENT "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN (CL AS SBJ_CRDNL "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN ((((CL AS SCOP "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL_X_CL AS SCOP_INCL_CL ON SCOP.CL_OID = SCOP_INCL_CL.SBJ_CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL AS ENT ON SCOP_INCL_CL.OBJ_CL_OID = ENT.CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL_X_CL AS ERM_CMPNT_IMPL_CL ON ENT.CL_OID = ERM_CMPNT_IMPL_CL.OBJ_CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL AS ERM_CMPNT_TP ON ERM_CMPNT_IMPL_CL.SBJ_CL_OID = ERM_CMPNT_TP.CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("ON SBJ_CRDNL.CL_OID = ENT.SBJ_RLN_CRDNL_OID) ON SBJ_ENT.CL_OID = ENT.OBJ_CL_OID "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("WHERE (((SCOP.CL_NM) IN ("))).OpCc(null,this.modelname)).OpCc(null,$013)).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((ENT.CL_OID)= "))).OpCcblank(null,entityID)).OpCcblank(null,$021)).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((ERM_CMPNT_TP.CL_OID) In (2792)) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((SCOP.PBLSD_SCM_OID)=2618) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((SCOP_INCL_CL.CL_X_CL_TP_OID)=2637) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((ERM_CMPNT_IMPL_CL.CL_X_CL_TP_OID)=2636)) "));






















}
else{}
}
this.rs=this.stmt.executeQuery(netrexx.lang.Rexx.toString(QS));
{for(;;){if(!new netrexx.lang.Rexx(this.rs.next()).OpNotEq(null,$03))break;

lname=netrexx.lang.Rexx.toRexx(this.rs.getString("ATT_NM"));
lcard=netrexx.lang.Rexx.toRexx(this.rs.getString("OBJ_CRDNL_NM"));
tofromcard=netrexx.lang.Rexx.toRexx(this.rs.getString("SBJ_CRDNL_NM"));
lkey=netrexx.lang.Rexx.toRexx(this.rs.getString("IS_ID"));


idrelation=netrexx.lang.Rexx.toRexx(this.rs.getString("ID_RLN_IND"));
infotype=netrexx.lang.Rexx.toRexx(this.rs.getString("SBJ_NM"));
abrname=netrexx.lang.Rexx.toRexx(this.rs.getString("ABR_NM"));
if ((lname.right(new netrexx.lang.Rexx((byte)4))).OpEq(null,$015)) abrname=abrname.OpCc(null,$016);
attroid=netrexx.lang.Rexx.toRexx(this.rs.getString("RLN_OID"));
shortRoleName=netrexx.lang.Rexx.toRexx(this.rs.getString("ABR_RL_NM"));






erAtt=new com.abnamro.midms.Attribute();
if (lname!=null) erAtt.setName(lname);
if (tofromcard!=null) erAtt.setTofromcardinality(tofromcard);
if (lcard!=null) erAtt.setCardinality(lcard);
if (attroid!=null) erAtt.setOid(attroid);
if (lkey!=null) erAtt.setIskey(lkey);

if (idrelation!=null) erAtt.setIdrelation(idrelation);

if (abrname!=null) erAtt.setAbbreviatedname(abrname);
if (infotype!=null) erAtt.setInformationtype(infotype);
if (shortRoleName!=null) erAtt.setAbbreviatedrolename(shortRoleName);
erAtt.setIsnative(netrexx.lang.Rexx.toRexx("nonnative"));
attributecount=new netrexx.lang.Rexx(attributecount).OpAdd(null,$07).toint();

icomment=netrexx.lang.Rexx.toRexx("");
if (icomment==null) icomment=netrexx.lang.Rexx.toRexx("");
erAtt.setComment(icomment);
v.add((java.lang.Object)erAtt);
}}
return v;}

catch (java.sql.SQLException $14){e2=$14;
netrexx.lang.RexxIO.Say("SQLException(s) caught in getParentAttributesForAttributiveEntities");
{try{for(;;){if(!((e2!=null)))break;
{


netrexx.lang.RexxIO.Say((($09.OpCcblank(null,new netrexx.lang.Rexx(e2.getErrorCode()))).OpCcblank(null,$022)).OpCcblank(null,entityID));
netrexx.lang.RexxIO.Say("");
e2=e2.getNextException();
}
}}catch (java.lang.NullPointerException $15){
;
}}
return v;
}}}





public java.util.ArrayList getChildAttributesForAttributiveEntities(netrexx.lang.Rexx entityID){java.util.ArrayList v;netrexx.lang.Rexx QS=null;com.abnamro.midms.Attribute erAtt=null;netrexx.lang.Rexx rlnm=null;netrexx.lang.Rexx abrname=null;java.sql.SQLException e2=null;
if (istimedisplayed) netrexx.lang.RexxIO.Say(netrexx.lang.Rexx.toRexx("in getChildAttributesForAttributiveEntities").OpCcblank(null,this.timer.getDiff()));

v=new java.util.ArrayList();
{try{
{/*select*/
if (this.engine.OpEq(null,$04))
{
QS=(((netrexx.lang.Rexx.toRexx("SELECT DISTINCT ENT.CL_OID AS RLN_OID, OBJ.ABR_NM, OBJ.ABR_RL_NM, ENT.OBJ_CL_OID AS SBJ_OID, OBJ.CL_NM AS SBJ_NM, SBJ_CRDNL.CL_NM AS SBJ_CRDNL_NM, ENT.X_NM, ENT.[RVRS_X _NM], Trim([ENT].[RL_NM] & \' \' & [OBJ].[CL_NM]) AS ATT_NM, OBJ.CL_DSC AS RLN_DSC, ENT.CL_OID AS OBJ_OID, ENT.CL_NM AS OBJ_NM, \'1:1\' AS OBJ_CRDNL_NM, 0 AS VERSION, 999999 AS RANK, 2672 AS ID_RLN_IND, False AS IS_ID, 2626 AS ERM_CMPNT_TP_OID, ENT.SBJ_CL_OID AS ATTROID FROM CL AS OBJ INNER JOIN (CL AS SBJ_CRDNL INNER JOIN ((((CL AS SCOP INNER JOIN CL_X_CL AS SCOP_INCL_CL ON SCOP.CL_OID = SCOP_INCL_CL.[SBJ CL_OID]) INNER JOIN CL AS ENT ON SCOP_INCL_CL.OBJ_CL_OID = ENT.CL_OID) INNER JOIN CL_X_CL AS ERM_CMPNT_IMPL_CL ON ENT.CL_OID = ERM_CMPNT_IMPL_CL.OBJ_CL_OID) INNER JOIN CL AS ERM_CMPNT_TP ON ERM_CMPNT_IMPL_CL.[SBJ CL_OID] = ERM_CMPNT_TP.CL_OID) ON SBJ_CRDNL.CL_OID = ENT.SBJ_RLN_CRDNL_OID) ON OBJ.CL_OID = ENT.SBJ_CL_OID WHERE (((SCOP.CL_NM) IN (").OpCc(null,this.modelname)).OpCc(null,netrexx.lang.Rexx.toRexx(")) AND ((ENT.CL_OID)= "))).OpCcblank(null,entityID)).OpCcblank(null,netrexx.lang.Rexx.toRexx(") AND ((0)=0) AND ((ERM_CMPNT_TP.CL_OID) In (2792)) AND ((SCOP.PBLSD_SCM_OID)=2618) AND ((SCOP_INCL_CL.[CL X_CL TP_OID])=2637) AND ((ERM_CMPNT_IMPL_CL.[CL X_CL TP_OID])=2636));"));
}
else if ((this.engine.pos(netrexx.lang.Rexx.toRexx("DB2"))).OpGt(null,$03)||this.engine.OpEq(null,$05))
{
QS=(((((((((((((((((((((((((netrexx.lang.Rexx.toRexx("SELECT DISTINCT ENT.CL_OID AS RLN_OID, OBJ.ABR_NM, ").OpCcblank(null,netrexx.lang.Rexx.toRexx("OBJ.ABR_RL_NM, ENT.OBJ_CL_OID AS SBJ_OID, OBJ.CL_NM AS SBJ_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("SBJ_CRDNL.CL_NM AS SBJ_CRDNL_NM, ENT.X_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("ENT.RVRS_X_NM, ENT.RL_NM,OBJ.CL_NM AS ATT_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("ENT.CL_OID AS OBJ_OID, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("ENT.CL_NM AS OBJ_NM, \'1:1\' AS OBJ_CRDNL_NM, 0 AS VERSION, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("999999 AS RANK, 2672 AS ID_RLN_IND, \'False\' AS IS_ID, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("2626 AS ERM_CMPNT_TP_OID, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("ENT.SBJ_CL_OID AS ATTROID "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("FROM CL AS OBJ "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN (CL AS SBJ_CRDNL "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN ((((CL AS SCOP "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL_X_CL AS SCOP_INCL_CL ON SCOP.CL_OID = SCOP_INCL_CL.SBJ_CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL AS ENT ON SCOP_INCL_CL.OBJ_CL_OID = ENT.CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL_X_CL AS ERM_CMPNT_IMPL_CL ON ENT.CL_OID = ERM_CMPNT_IMPL_CL.OBJ_CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL AS ERM_CMPNT_TP ON ERM_CMPNT_IMPL_CL.SBJ_CL_OID = ERM_CMPNT_TP.CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("ON SBJ_CRDNL.CL_OID = ENT.SBJ_RLN_CRDNL_OID) ON OBJ.CL_OID = ENT.SBJ_CL_OID "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("WHERE (((SCOP.CL_NM) IN ("))).OpCc(null,this.modelname)).OpCc(null,$013)).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((ENT.CL_OID)= "))).OpCcblank(null,entityID)).OpCcblank(null,$021)).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((ERM_CMPNT_TP.CL_OID) In (2792)) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((SCOP.PBLSD_SCM_OID)=2618) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((SCOP_INCL_CL.CL_X_CL_TP_OID)=2637) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((ERM_CMPNT_IMPL_CL.CL_X_CL_TP_OID)=2636))"));






















}
else{}
}
this.rs=this.stmt.executeQuery(netrexx.lang.Rexx.toString(QS));
{for(;;){if(!new netrexx.lang.Rexx(this.rs.next()).OpNotEq(null,$03))break;
erAtt=new com.abnamro.midms.Attribute();
erAtt.setName(netrexx.lang.Rexx.toRexx(this.rs.getString("ATT_NM")));
if (this.rs.wasNull()) erAtt.setName(netrexx.lang.Rexx.toRexx(""));
if ((this.engine.pos(netrexx.lang.Rexx.toRexx("DB2"))).OpGt(null,$03)||this.engine.OpEq(null,$05)) 
{
rlnm=netrexx.lang.Rexx.toRexx(this.rs.getString("RL_NM"));
if (rlnm!=null) erAtt.setName(rlnm.OpCc(null,erAtt.getName()));
}
if (this.rs.wasNull()) erAtt.setName(netrexx.lang.Rexx.toRexx(""));
erAtt.setTofromcardinality(netrexx.lang.Rexx.toRexx(this.rs.getString("SBJ_CRDNL_NM")));
if (this.rs.wasNull()) erAtt.setName(netrexx.lang.Rexx.toRexx(""));
erAtt.setCardinality(netrexx.lang.Rexx.toRexx(this.rs.getString("OBJ_CRDNL_NM")));
if (this.rs.wasNull()) erAtt.setCardinality(netrexx.lang.Rexx.toRexx(""));
erAtt.setIskey(netrexx.lang.Rexx.toRexx(this.rs.getString("IS_ID")));
if (this.rs.wasNull()) erAtt.setIskey(netrexx.lang.Rexx.toRexx(""));
erAtt.setIdrelation(netrexx.lang.Rexx.toRexx(this.rs.getString("ID_RLN_IND")));
if (this.rs.wasNull()) erAtt.setIdrelation(netrexx.lang.Rexx.toRexx(""));
abrname=netrexx.lang.Rexx.toRexx(this.rs.getString("ABR_NM"));
if ((erAtt.getName().right(new netrexx.lang.Rexx((byte)4))).OpEq(null,$015)) abrname=abrname.OpCc(null,$016);
if (abrname!=null) erAtt.setAbbreviatedname(abrname);
erAtt.setInformationtype(netrexx.lang.Rexx.toRexx(this.rs.getString("SBJ_NM")));
erAtt.setOid(netrexx.lang.Rexx.toRexx(this.rs.getString("RLN_OID")));
if (this.rs.wasNull()) erAtt.setOid(netrexx.lang.Rexx.toRexx(""));
erAtt.setAbbreviatedrolename(netrexx.lang.Rexx.toRexx(this.rs.getString("ABR_RL_NM")));
if (this.rs.wasNull()) erAtt.setAbbreviatedrolename(netrexx.lang.Rexx.toRexx(""));
erAtt.setIsnative(netrexx.lang.Rexx.toRexx("native"));

attributecount=new netrexx.lang.Rexx(attributecount).OpAdd(null,$07).toint();
v.add((java.lang.Object)erAtt);
}}
return v;}

catch (java.sql.SQLException $16){e2=$16;
netrexx.lang.RexxIO.Say("SQLException(s) caught in getChildAttributesForAttributiveEntities");
{try{for(;;){if(!((e2!=null)))break;
{

netrexx.lang.RexxIO.Say($08.OpCcblank(null,netrexx.lang.Rexx.toRexx(e2.getMessage())));
netrexx.lang.RexxIO.Say((($09.OpCcblank(null,new netrexx.lang.Rexx(e2.getErrorCode()))).OpCcblank(null,$022)).OpCcblank(null,entityID));
netrexx.lang.RexxIO.Say("");
e2=e2.getNextException();
}
}}catch (java.lang.NullPointerException $17){
;
}}
return v;
}}}

public java.util.ArrayList getSubTypesForOIDWithinScope(netrexx.lang.Rexx oid_){java.util.ArrayList v;netrexx.lang.Rexx QS=null;netrexx.lang.Rexx oid__=null;java.sql.SQLException e2=null;
v=new java.util.ArrayList();
{try{
{/*select*/
if (this.engine.OpEq(null,$04))
{
QS=((((((((netrexx.lang.Rexx.toRexx("SELECT DISTINCT Q1.CL_OID ").OpCcblank(null,netrexx.lang.Rexx.toRexx("FROM CL AS Q1, CL_X_CL AS Q2, CL AS Q3, CL AS Q4, CL AS Q5 "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("WHERE (Q2.OBJ_CL_OID = Q1.CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND (Q1.PBLSD_SCM_OID = Q3.CL_OID) AND (Q4.CL_OID = Q2.[SBJ CL_OID]) AND "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("(Q4.CL_NM IN ("))).OpCc(null,this.modelname)).OpCc(null,netrexx.lang.Rexx.toRexx(")) AND (Q2.[CL X_CL TP_OID] =   2637) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND Q5.CL_OID = Q1.PRN_CL_OID "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND Q5.CL_OID = "))).OpCcblank(null,oid_);






}
else if ((this.engine.pos(netrexx.lang.Rexx.toRexx("DB2"))).OpGt(null,$03)||this.engine.OpEq(null,$05))
{
if (istimedisplayed) netrexx.lang.RexxIO.Say(netrexx.lang.Rexx.toRexx("in getSubTypesForOIDWithinScope ").OpCcblank(null,this.timer.getDiff()));
QS=((((((((netrexx.lang.Rexx.toRexx("SELECT DISTINCT Q1.CL_OID ").OpCcblank(null,netrexx.lang.Rexx.toRexx("FROM CL AS Q1, CL_X_CL AS Q2, CL AS Q3, CL AS Q4, CL AS Q5 "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("WHERE (Q2.OBJ_CL_OID = Q1.CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND (Q1.PBLSD_SCM_OID = Q3.CL_OID) AND (Q4.CL_OID = Q2.SBJ_CL_OID) AND "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("(Q4.CL_NM IN ("))).OpCc(null,this.modelname)).OpCc(null,netrexx.lang.Rexx.toRexx(")) AND (Q2.CL_X_CL_TP_OID =   2637) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND Q5.CL_OID = Q1.PRN_CL_OID "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND Q5.CL_OID = "))).OpCcblank(null,oid_);






}
else{}
}
this.rs=this.stmt.executeQuery(netrexx.lang.Rexx.toString(QS));

{for(;;){if(!new netrexx.lang.Rexx(this.rs.next()).OpNotEq(null,$03))break;
oid__=netrexx.lang.Rexx.toRexx(this.rs.getString("CL_OID"));
if (this.rs.wasNull()) oid__=netrexx.lang.Rexx.toRexx("-1");
v.add((java.lang.Object)oid__);
}}
return v;}

catch (java.sql.SQLException $18){e2=$18;
netrexx.lang.RexxIO.Say("SQLException(s) caught in getSubTypesForOIDWithinScope");
netrexx.lang.RexxIO.Say(QS);
{for(;;){if(!((e2!=null)))break;

netrexx.lang.RexxIO.Say($08.OpCcblank(null,netrexx.lang.Rexx.toRexx(e2.getMessage())));
netrexx.lang.RexxIO.Say($09.OpCcblank(null,new netrexx.lang.Rexx(e2.getErrorCode())));
netrexx.lang.RexxIO.Say("");
e2=e2.getNextException();
}}
return v;
}}}


public java.util.ArrayList getSubTypeSetForEntity(netrexx.lang.Rexx entityID){java.util.ArrayList v;netrexx.lang.Rexx QS=null;com.abnamro.midms.SubType s=null;netrexx.lang.Rexx entName=null;netrexx.lang.Rexx sbjName=null;netrexx.lang.Rexx sbtpOid=null;java.sql.SQLException e2=null;
if (istimedisplayed) netrexx.lang.RexxIO.Say(netrexx.lang.Rexx.toRexx("in getSubTypeSetForEntity").OpCcblank(null,this.timer.getDiff()));

v=new java.util.ArrayList();
{try{
{/*select*/
if (this.engine.OpEq(null,$04))
QS=(((netrexx.lang.Rexx.toRexx("SELECT SCOP.CL_NM AS SCOP_NM, RLN.CL_OID AS RLN_OID, SBJ_ENT.CL_OID AS SBJ_OID, SBJ_ENT.CL_NM AS SBJ_NM, RLN.X_NM, RLN.[RVRS_X _NM], RLN.CL_DSC AS RLN_DSC, OBJ_ENT.CL_OID AS OBJ_OID, OBJ_ENT.CL_NM AS OBJ_NM, 0 AS VERSION, SBTP.CL_OID AS SBTP_OID, SBTP.CL_NM AS SBTP_NM, ENT_TP_IMPL_SBTP.[CL X_CL TP_OID], SCOP_INCL_CL.CMNT FROM CL_X_CL AS ENT_TP_IMPL_SBTP INNER JOIN ((CL AS OBJ_ENT INNER JOIN ((CL AS SBJ_ENT INNER JOIN ((((CL AS SCOP INNER JOIN CL_X_CL AS SCOP_INCL_CL ON SCOP.CL_OID = SCOP_INCL_CL.[SBJ CL_OID]) INNER JOIN CL AS RLN ON SCOP_INCL_CL.OBJ_CL_OID = RLN.CL_OID) INNER JOIN CL_X_CL AS ERM_CMPNT_IMPL_CL ON RLN.CL_OID = ERM_CMPNT_IMPL_CL.OBJ_CL_OID) INNER JOIN CL AS ERM_CMPNT_TP ON ERM_CMPNT_IMPL_CL.[SBJ CL_OID] = ERM_CMPNT_TP.CL_OID) ON SBJ_ENT.CL_OID = RLN.SBJ_CL_OID) INNER JOIN CL AS SBTP ON SBJ_ENT.CL_OID = SBTP.PBLSD_SCM_OID) ON OBJ_ENT.CL_OID = SBTP.PRN_CL_OID) INNER JOIN CL_X_CL AS SCOP_INCL_SBTP ON (SCOP_INCL_SBTP.OBJ_CL_OID = SBTP.CL_OID) AND (SCOP.CL_OID = SCOP_INCL_SBTP.[SBJ CL_OID])) ON ENT_TP_IMPL_SBTP.OBJ_CL_OID = SBTP.CL_OID WHERE (((SCOP.CL_NM) IN (").OpCc(null,this.modelname)).OpCc(null,netrexx.lang.Rexx.toRexx(")) AND ((OBJ_ENT.CL_OID)="))).OpCcblank(null,entityID)).OpCcblank(null,netrexx.lang.Rexx.toRexx(") AND ((0)=0) AND ((ENT_TP_IMPL_SBTP.[CL X_CL TP_OID])=2636) AND ((SCOP.PBLSD_SCM_OID)=2618) AND ((SCOP_INCL_CL.[CL X_CL TP_OID])=2637) AND ((ERM_CMPNT_IMPL_CL.[CL X_CL TP_OID])=2636) AND ((ERM_CMPNT_TP.CL_OID)=2628) AND ((SCOP_INCL_SBTP.[CL X_CL TP_OID])=2637) AND ((ENT_TP_IMPL_SBTP.[SBJ CL_OID])=2625));"));
else if ((this.engine.pos(netrexx.lang.Rexx.toRexx("DB2"))).OpGt(null,$03)||this.engine.OpEq(null,$05))
{
QS=(((netrexx.lang.Rexx.toRexx("SELECT SCOP.CL_NM AS SCOP_NM, RLN.CL_OID AS RLN_OID, SBJ_ENT.CL_OID AS SBJ_OID, SBJ_ENT.CL_NM AS SBJ_NM, RLN.X_NM, RLN.RVRS_X_NM, RLN.CL_DSC AS RLN_DSC, OBJ_ENT.CL_OID AS OBJ_OID, OBJ_ENT.CL_NM AS OBJ_NM, 0 AS VERSION, SBTP.CL_OID AS SBTP_OID, SBTP.CL_NM AS SBTP_NM, ENT_TP_IMPL_SBTP.CL_X_CL_TP_OID, SCOP_INCL_CL.CMNT FROM CL_X_CL AS ENT_TP_IMPL_SBTP INNER JOIN ((CL AS OBJ_ENT INNER JOIN ((CL AS SBJ_ENT INNER JOIN ((((CL AS SCOP INNER JOIN CL_X_CL AS SCOP_INCL_CL ON SCOP.CL_OID = SCOP_INCL_CL.SBJ_CL_OID) INNER JOIN CL AS RLN ON SCOP_INCL_CL.OBJ_CL_OID = RLN.CL_OID) INNER JOIN CL_X_CL AS ERM_CMPNT_IMPL_CL ON RLN.CL_OID = ERM_CMPNT_IMPL_CL.OBJ_CL_OID) INNER JOIN CL AS ERM_CMPNT_TP ON ERM_CMPNT_IMPL_CL.SBJ_CL_OID = ERM_CMPNT_TP.CL_OID) ON SBJ_ENT.CL_OID = RLN.SBJ_CL_OID) INNER JOIN CL AS SBTP ON SBJ_ENT.CL_OID = SBTP.PBLSD_SCM_OID) ON OBJ_ENT.CL_OID = SBTP.PRN_CL_OID) INNER JOIN CL_X_CL AS SCOP_INCL_SBTP ON (SCOP_INCL_SBTP.OBJ_CL_OID = SBTP.CL_OID) AND (SCOP.CL_OID = SCOP_INCL_SBTP.SBJ_CL_OID)) ON ENT_TP_IMPL_SBTP.OBJ_CL_OID = SBTP.CL_OID WHERE (((SCOP.CL_NM) IN (").OpCc(null,this.modelname)).OpCc(null,netrexx.lang.Rexx.toRexx(")) AND ((OBJ_ENT.CL_OID)="))).OpCcblank(null,entityID)).OpCcblank(null,netrexx.lang.Rexx.toRexx(") AND ((0)=0) AND ((ENT_TP_IMPL_SBTP.CL_X_CL_TP_OID)=2636) AND ((SCOP.PBLSD_SCM_OID)=2618) AND ((SCOP_INCL_CL.CL_X_CL_TP_OID)=2637) AND ((ERM_CMPNT_IMPL_CL.CL_X_CL_TP_OID)=2636) AND ((ERM_CMPNT_TP.CL_OID)=2628) AND ((SCOP_INCL_SBTP.CL_X_CL_TP_OID)=2637) AND ((ENT_TP_IMPL_SBTP.SBJ_CL_OID)=2625));"));
}
else{
netrexx.lang.RexxIO.Say("getSubTypeSetForEntity not implemented for this DBMS engine");}
}
this.rs=this.stmt.executeQuery(netrexx.lang.Rexx.toString(QS));
{for(;;){if(!new netrexx.lang.Rexx(this.rs.next()).OpNotEq(null,$03))break;
s=new com.abnamro.midms.SubType();
entName=netrexx.lang.Rexx.toRexx(this.rs.getString("SBTP_NM"));
sbjName=netrexx.lang.Rexx.toRexx(this.rs.getString("SBJ_NM"));
sbtpOid=netrexx.lang.Rexx.toRexx(this.rs.getString("RLN_OID"));
s.setName(entName);
s.setSubjectname(sbjName);
s.setOid(sbtpOid);
subtypesetcount=new netrexx.lang.Rexx(subtypesetcount).OpAdd(null,$07).toint();
v.add((java.lang.Object)s);
}}
return v;}

catch (java.sql.SQLException $19){e2=$19;
netrexx.lang.RexxIO.Say("SQLException(s) caught in getSubTypeSetForEntity");
{for(;;){if(!((e2!=null)))break;
netrexx.lang.RexxIO.Say($012.OpCcblank(null,netrexx.lang.Rexx.toRexx(e2.getSQLState())));
netrexx.lang.RexxIO.Say($08.OpCcblank(null,netrexx.lang.Rexx.toRexx(e2.getMessage())));
netrexx.lang.RexxIO.Say($09.OpCcblank(null,new netrexx.lang.Rexx(e2.getErrorCode())));
netrexx.lang.RexxIO.Say("");
e2=e2.getNextException();
}}
return v;
}}}





public java.util.ArrayList getRelationsForEntity(netrexx.lang.Rexx entityID){java.util.ArrayList v;netrexx.lang.Rexx QS=null;com.abnamro.midms.Relation r=null;netrexx.lang.Rexx relnm=null;netrexx.lang.Rexx attnm=null;netrexx.lang.Rexx icomment=null;java.sql.SQLException e2=null;
if (istimedisplayed) netrexx.lang.RexxIO.Say(netrexx.lang.Rexx.toRexx("in getRelationsForEntity").OpCcblank(null,this.timer.getDiff()));

v=new java.util.ArrayList();
{try{

{/*select*/
if (this.engine.OpEq(null,$04))QS=(((netrexx.lang.Rexx.toRexx("SELECT DISTINCT RLN.CL_OID AS RLN_OID, IIf([ERM_CMPNT_TP].[CL_OID]=2792,[OBJ_ENT].[CL_OID],[SBJ_ENT].[CL_OID]) AS SBJ_OID, IIf([ERM_CMPNT_TP].[CL_OID]=2792,[OBJ_ENT].[CL_NM],[SBJ_ENT].[CL_NM]) AS SBJ_NM, SBJ_CRDNL.CL_NM AS SBJ_CRDNL_NM, RLN.X_NM, RLN.[RVRS_X _NM] AS RVRS_XNM, Trim([RLN].[RL_NM] & \' \' & IIf([ERM_CMPNT_TP].[CL_OID]=2792,[OBJ_ENT].[CL_NM],[SBJ_ENT].[CL_NM]) & \' OID\') AS ATT_NM, RLN.CL_DSC AS RLN_DSC, IIf([ERM_CMPNT_TP].[CL_OID]=2792,[RLN].[CL_OID],[OBJ_ENT].[CL_OID]) AS OBJ_OID, IIf([ERM_CMPNT_TP].[CL_OID]=2792,[RLN].[CL_NM],[OBJ_ENT].[CL_NM]) AS OBJ_NM, IIf([ERM_CMPNT_TP].[CL_OID]=2792,\'1:1\',[OBJ_CRDNL].[CL_NM]) AS OBJ_CRDNL_NM, 0 AS VERSION, RLN.RANK, RLN.ID_RLN_IND, IIf([ERM_CMPNT_TP].[CL_OID]=2792,False,[RLN].[ID_RLN_IND]-2672) AS IS_ID, ERM_CMPNT_TP.CL_OID AS ERM_CMPNT_TP_OID FROM CL AS OBJ_CRDNL INNER JOIN (CL AS OBJ_ENT INNER JOIN ((CL AS SBJ_ENT INNER JOIN ((((CL AS SCOP INNER JOIN CL_X_CL AS SCOP_INCL_CL ON SCOP.CL_OID = SCOP_INCL_CL.[SBJ CL_OID]) INNER JOIN CL AS RLN ON SCOP_INCL_CL.OBJ_CL_OID = RLN.CL_OID) INNER JOIN CL_X_CL AS ERM_CMPNT_IMPL_CL ON RLN.CL_OID = ERM_CMPNT_IMPL_CL.OBJ_CL_OID) INNER JOIN CL AS ERM_CMPNT_TP ON ERM_CMPNT_IMPL_CL.[SBJ CL_OID] = ERM_CMPNT_TP.CL_OID) ON SBJ_ENT.CL_OID = RLN.SBJ_CL_OID) INNER JOIN CL AS SBJ_CRDNL ON RLN.SBJ_RLN_CRDNL_OID = SBJ_CRDNL.CL_OID) ON OBJ_ENT.CL_OID = RLN.OBJ_CL_OID) ON OBJ_CRDNL.CL_OID = RLN.OBJ_RLN_CRDNL_OID WHERE (((SCOP.CL_NM) IN (").OpCc(null,this.modelname)).OpCc(null,netrexx.lang.Rexx.toRexx(")) AND ((IIf([ERM_CMPNT_TP].[CL_OID]=2792,[RLN].[CL_OID],[OBJ_ENT].[CL_OID]))="))).OpCcblank(null,entityID)).OpCcblank(null,netrexx.lang.Rexx.toRexx(") AND ((0)=0) AND ((ERM_CMPNT_TP.CL_OID) In (2627,2792)) AND ((ERM_CMPNT_IMPL_CL.[CL X_CL TP_OID])=2636) AND ((SCOP.PBLSD_SCM_OID)=2618) AND ((SCOP_INCL_CL.[CL X_CL TP_OID])=2637) AND ((SCOP_INCL_CL.END_DT) Is Null)) ORDER BY RLN.RANK;"));
else if ((this.engine.pos(netrexx.lang.Rexx.toRexx("DB2"))).OpGt(null,$03)||this.engine.OpEq(null,$05))
{
QS=(((((((((((((((((((((((((((((netrexx.lang.Rexx.toRexx(" SELECT DISTINCT RLN.CL_OID AS RLN_OID, ").OpCcblank(null,netrexx.lang.Rexx.toRexx("CASE WHEN ERM_CMPNT_TP.CL_OID=2792 THEN OBJ_ENT.CL_OID ELSE SBJ_ENT.CL_OID END AS SBJ_OID, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("CASE WHEN ERM_CMPNT_TP.CL_OID=2792 THEN OBJ_ENT.CL_NM ELSE SBJ_ENT.CL_NM END AS SBJ_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("SBJ_CRDNL.CL_NM AS SBJ_CRDNL_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("RLN.RL_NM AS RL_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("CASE WHEN ERM_CMPNT_TP.CL_OID=2792 THEN OBJ_ENT.CL_NM ELSE SBJ_ENT.CL_NM END AS ATT_TMP_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("RLN.X_NM, RLN.RVRS_X_NM AS RVRS_XNM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("CASE WHEN ERM_CMPNT_TP.CL_OID=2792 THEN RLN.CL_OID ELSE OBJ_ENT.CL_OID END AS OBJ_OID, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("CASE WHEN ERM_CMPNT_TP.CL_OID=2792 THEN RLN.CL_NM ELSE OBJ_ENT.CL_NM END AS OBJ_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("CASE WHEN ERM_CMPNT_TP.CL_OID=2792 THEN \'1:1\' ELSE OBJ_CRDNL.CL_NM END AS OBJ_CRDNL_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("RLN.RANK,  "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("RLN.ID_RLN_IND,  "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("ERM_CMPNT_TP.CL_OID AS ERM_CMPNT_TP_OID "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("FROM CL AS OBJ_CRDNL INNER JOIN (CL AS OBJ_ENT  "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN ((CL AS SBJ_ENT  "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN ((((CL AS SCOP INNER JOIN CL_X_CL AS SCOP_INCL_CL ON SCOP.CL_OID = SCOP_INCL_CL.SBJ_CL_OID)  "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL AS RLN ON SCOP_INCL_CL.OBJ_CL_OID = RLN.CL_OID)  "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL_X_CL AS ERM_CMPNT_IMPL_CL ON RLN.CL_OID = ERM_CMPNT_IMPL_CL.OBJ_CL_OID)  "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL AS ERM_CMPNT_TP ON ERM_CMPNT_IMPL_CL.SBJ_CL_OID = ERM_CMPNT_TP.CL_OID) ON SBJ_ENT.CL_OID = RLN.SBJ_CL_OID)  "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("INNER JOIN CL AS SBJ_CRDNL ON RLN.SBJ_RLN_CRDNL_OID = SBJ_CRDNL.CL_OID) ON OBJ_ENT.CL_OID = RLN.OBJ_CL_OID) ON OBJ_CRDNL.CL_OID = RLN.OBJ_RLN_CRDNL_OID  "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("WHERE (((SCOP.CL_NM) IN ("))).OpCc(null,this.modelname)).OpCc(null,$013)).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((CASE WHEN ERM_CMPNT_TP.CL_OID=2792 THEN RLN.CL_OID ELSE OBJ_ENT.CL_OID END))= "))).OpCcblank(null,entityID)).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((ERM_CMPNT_TP.CL_OID) In (2627,2792))  "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((ERM_CMPNT_IMPL_CL.CL_X_CL_TP_OID)=2636)  "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((SCOP.PBLSD_SCM_OID)=2618)  "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((SCOP_INCL_CL.CL_X_CL_TP_OID)=2637)  "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("AND ((SCOP_INCL_CL.END_DT) Is Null))  "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("ORDER BY RLN.RANK "));



























}
else{
netrexx.lang.RexxIO.Say("getRelationsForEntity not implemented for this DBMS engine");}
}

this.rs=this.stmt.executeQuery(netrexx.lang.Rexx.toString(QS));

{for(;;){if(!new netrexx.lang.Rexx(this.rs.next()).OpNotEq(null,$03))break;
r=new com.abnamro.midms.Relation();
r.setOid(netrexx.lang.Rexx.toRexx(this.rs.getString("RLN_OID")));
r.setTargetname(netrexx.lang.Rexx.toRexx(this.rs.getString("SBJ_NM")));
r.setSubjectcardinality(netrexx.lang.Rexx.toRexx(this.rs.getString("SBJ_CRDNL_NM")));
r.setActivesentence(netrexx.lang.Rexx.toRexx(this.rs.getString("X_NM")));
r.setPassivesentence(netrexx.lang.Rexx.toRexx(this.rs.getString("RVRS_XNM")));
if (this.engine.OpEq(null,$04)) r.setAttributename(netrexx.lang.Rexx.toRexx(this.rs.getString("ATT_NM")));
if ((this.engine.pos(netrexx.lang.Rexx.toRexx("DB2"))).OpGt(null,$03)||this.engine.OpEq(null,$05)) 
{
relnm=netrexx.lang.Rexx.toRexx(this.rs.getString("RL_NM"));
if (this.rs.wasNull()) relnm=netrexx.lang.Rexx.toRexx("");
attnm=netrexx.lang.Rexx.toRexx(this.rs.getString("ATT_TMP_NM"));
if (this.rs.wasNull()) attnm=netrexx.lang.Rexx.toRexx("");
r.setAttributename((relnm.OpCc(null,attnm)).OpCc(null,$015));
}

r.setObjectcardinality(netrexx.lang.Rexx.toRexx(this.rs.getString("OBJ_CRDNL_NM")));

icomment=netrexx.lang.Rexx.toRexx("");
if (icomment==null) icomment=netrexx.lang.Rexx.toRexx("");
r.setComment(icomment);
v.add((java.lang.Object)r);
relationcount=new netrexx.lang.Rexx(relationcount).OpAdd(null,$07).toint();
}}
return v;}

catch (java.sql.SQLException $20){e2=$20;
netrexx.lang.RexxIO.Say("SQLException(s) caught in getRelationsForEntity");
{for(;;){if(!((e2!=null)))break;
netrexx.lang.RexxIO.Say($012.OpCcblank(null,netrexx.lang.Rexx.toRexx(e2.getSQLState())));
netrexx.lang.RexxIO.Say($08.OpCcblank(null,netrexx.lang.Rexx.toRexx(e2.getMessage())));
netrexx.lang.RexxIO.Say($09.OpCcblank(null,new netrexx.lang.Rexx(e2.getErrorCode())));
netrexx.lang.RexxIO.Say("");
e2=e2.getNextException();
}}
return v;
}}}

public void writeModelData(java.util.ArrayList a,java.util.ArrayList b,java.util.TreeMap c,java.util.TreeMap d,java.util.TreeMap e,java.util.ArrayList f) throws java.io.FileNotFoundException,java.io.IOException{java.io.FileOutputStream fos;java.util.zip.GZIPOutputStream gzos;java.io.ObjectOutputStream out;
fos=new java.io.FileOutputStream(netrexx.lang.Rexx.toString((safemodelname.OpCc(null,modelversion)).OpCc(null,$01)));
gzos=new java.util.zip.GZIPOutputStream((java.io.OutputStream)fos);
out=new java.io.ObjectOutputStream((java.io.OutputStream)gzos);
out.writeObject((java.lang.Object)a);
out.writeObject((java.lang.Object)b);
out.writeObject((java.lang.Object)c);
out.writeObject((java.lang.Object)d);
out.writeObject((java.lang.Object)e);
out.writeObject((java.lang.Object)f);
out.flush();
out.close();return;}

public void readModelData() throws java.io.FileNotFoundException,java.io.IOException,java.io.StreamCorruptedException,java.io.OptionalDataException,java.lang.ClassNotFoundException{java.io.FileInputStream fis;java.util.zip.GZIPInputStream gzis;java.io.ObjectInputStream in;
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.setWaitCursor()));
this.size=6;
this.pMonitor=new javax.swing.ProgressMonitor((java.awt.Component)this.parentFrame,(java.lang.Object)("Resurrecting Compiled Model"),"Note",0,this.size);
this.pMonitor.setProgress(0);
this.pMonitor.setMillisToPopup(0);
this.pMonitor.setMillisToDecideToPopup(0);
this.alreadyread=0;
fis=new java.io.FileInputStream(netrexx.lang.Rexx.toString((safemodelname.OpCc(null,modelversion)).OpCc(null,$01)));
gzis=new java.util.zip.GZIPInputStream((java.io.InputStream)fis);
in=new java.io.ObjectInputStream((java.io.InputStream)gzis);
this.modeldata=(java.util.ArrayList)(in.readObject());
this.pMonitor.setProgress(1);
this.alreadyread=1;
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.updateCounter()));
this.modeldatatypes=(java.util.ArrayList)(in.readObject());
this.pMonitor.setProgress(2);
this.alreadyread=2;
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.updateCounter()));
this.oidIndexMap=(java.util.TreeMap)(in.readObject());
this.pMonitor.setProgress(3);
this.alreadyread=3;
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.updateCounter()));
this.oidHierarchyMap=(java.util.TreeMap)(in.readObject());
this.pMonitor.setProgress(4);
this.alreadyread=4;
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.updateCounter()));
this.cloidIndexMap=(java.util.TreeMap)(in.readObject());
this.pMonitor.setProgress(5);
this.alreadyread=5;
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.updateCounter()));
this.cl=(java.util.ArrayList)(in.readObject());
this.pMonitor.setProgress(6);
this.alreadyread=6;
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.updateCounter()));
in.close();
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.updateCounter()));
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.setDefaultCursor()));
doUpdateGUI((java.lang.Runnable)(new com.abnamro.midms.ERModel.closeMonitor()));

setEntitycount(new netrexx.lang.Rexx(this.modeldata.size()).OpSub(null,$07).toint());
return;}


public java.util.Iterator iterator(){
return this.modeldata.iterator();}

public java.util.ListIterator listIterator(){
return this.modeldata.listIterator();}

public java.util.Iterator datatypeIterator(){
return this.modeldatatypes.iterator();}

public int size(){
return this.modeldata.size();}

public java.util.ArrayList addAttributesForEntities(java.util.ArrayList a){java.util.ListIterator iter;com.abnamro.midms.Entity erwEnt=null;java.util.ArrayList temp=null;netrexx.lang.RexxTrace $21=new netrexx.lang.RexxTrace(1334,System.out,"ERModel.nrx");

iter=a.listIterator();
{for(;;){if(!(iter.hasNext()))break;
erwEnt=new com.abnamro.midms.Entity();
erwEnt=(com.abnamro.midms.Entity)(iter.next());
temp=new java.util.ArrayList((java.util.Collection)(this.getAttributesForEntity(erwEnt.getOid())));
temp.addAll((java.util.Collection)(new java.util.ArrayList((java.util.Collection)(this.getParentAttributesForAttributiveEntities(erwEnt.getOid())))));
temp.addAll((java.util.Collection)(new java.util.ArrayList((java.util.Collection)(this.getChildAttributesForAttributiveEntities(erwEnt.getOid())))));
erwEnt.setAttributelist(temp);
iter.set((java.lang.Object)erwEnt);
$21.newlevel(0);
}}

return a;}

public java.util.ArrayList addSubTypeSetsForEntities(java.util.ArrayList a){java.util.ListIterator iter;com.abnamro.midms.Entity erwEnt=null;java.util.ArrayList temp=null;

iter=a.listIterator();
{for(;;){if(!(iter.hasNext()))break;
erwEnt=(com.abnamro.midms.Entity)(iter.next());
temp=new java.util.ArrayList((java.util.Collection)(this.getSubTypeSetForEntity(erwEnt.getOid())));
erwEnt.setSubtypesetlist(temp);
iter.set((java.lang.Object)erwEnt);
}}

return a;}

public java.util.ArrayList addRelationsForEntities(java.util.ArrayList a){java.util.ListIterator iter;com.abnamro.midms.Entity erwEnt=null;java.util.ArrayList temp=null;

iter=a.listIterator();
{for(;;){if(!(iter.hasNext()))break;
erwEnt=(com.abnamro.midms.Entity)(iter.next());
temp=new java.util.ArrayList((java.util.Collection)(this.getRelationsForEntity(erwEnt.getOid())));
erwEnt.setRelationslist(temp);
iter.set((java.lang.Object)erwEnt);
}}

return a;}




public java.util.ArrayList getScopedComment(netrexx.lang.Rexx entityID){java.util.ArrayList v;netrexx.lang.Rexx QS=null;com.abnamro.midms.Comment commnt=null;netrexx.lang.Rexx c=null;java.sql.SQLException e3=null;java.sql.SQLException e2=null;
if (istimedisplayed) netrexx.lang.RexxIO.Say(netrexx.lang.Rexx.toRexx("in getScopedComment").OpCcblank(null,this.timer.getDiff()));
v=new java.util.ArrayList();

{try{
{/*select*/
if (this.engine.OpEq(null,$04))
{
QS=(((netrexx.lang.Rexx.toRexx("SELECT SCOP.CL_NM AS SCOP_NM, [SCOP_INCL_CL].[OBJ_CL_OID]+0 AS OID, 0 AS VERSION, SCOP_INCL_CL.CMNT AS CMNT FROM CL AS SCOP INNER JOIN CL_X_CL AS SCOP_INCL_CL ON SCOP.CL_OID = SCOP_INCL_CL.[SBJ CL_OID] WHERE (((SCOP.CL_NM) In (").OpCc(null,this.modelname)).OpCc(null,netrexx.lang.Rexx.toRexx(")) AND (([SCOP_INCL_CL].[OBJ_CL_OID]+0)="))).OpCcblank(null,entityID)).OpCcblank(null,netrexx.lang.Rexx.toRexx(") AND ((0)=0) AND ((SCOP_INCL_CL.CMNT) Is Not Null) AND ((SCOP.PBLSD_SCM_OID)=2618) AND ((SCOP_INCL_CL.[CL X_CL TP_OID])=2637) AND ((SCOP_INCL_CL.END_DT) Is Null));"));
}
else if ((this.engine.pos(netrexx.lang.Rexx.toRexx("DB2"))).OpGt(null,$03)||this.engine.OpEq(null,$05))
{
QS=(((netrexx.lang.Rexx.toRexx("SELECT SCOP.CL_NM AS SCOP_NM, SCOP_INCL_CL.OBJ_CL_OID AS OID, SCOP_INCL_CL.CMNT AS CMNT FROM CL AS SCOP INNER JOIN CL_X_CL AS SCOP_INCL_CL ON SCOP.CL_OID = SCOP_INCL_CL.SBJ_CL_OID WHERE (((SCOP.CL_NM) In (").OpCc(null,this.modelname)).OpCc(null,netrexx.lang.Rexx.toRexx(")) AND ((SCOP_INCL_CL.OBJ_CL_OID)="))).OpCcblank(null,entityID)).OpCcblank(null,netrexx.lang.Rexx.toRexx(") AND ((SCOP_INCL_CL.CMNT) Is Not Null) AND ((SCOP.PBLSD_SCM_OID)=2618) AND ((SCOP_INCL_CL.CL_X_CL_TP_OID)=2637) AND ((SCOP_INCL_CL.END_DT) Is Null))"));
}
else{}
}
this.rs2=this.stmt2.executeQuery(netrexx.lang.Rexx.toString(QS));
{for(;;){if(!new netrexx.lang.Rexx(this.rs2.next()).OpNotEq(null,$03))break;
commnt=new com.abnamro.midms.Comment();
{try{
c=netrexx.lang.Rexx.toRexx(this.rs2.getString("CMNT"));}
catch (java.sql.SQLException $22){e3=$22;
{for(;;){if(!((e3!=null)))break;
netrexx.lang.RexxIO.Say($012.OpCcblank(null,netrexx.lang.Rexx.toRexx(e3.getSQLState())));
netrexx.lang.RexxIO.Say($08.OpCcblank(null,netrexx.lang.Rexx.toRexx(e3.getMessage())));
netrexx.lang.RexxIO.Say($09.OpCcblank(null,new netrexx.lang.Rexx(e3.getErrorCode())));
netrexx.lang.RexxIO.Say("");
e3=e3.getNextException();
}}
}}
if (c!=null) commnt.setContent(c);
{try{
c=netrexx.lang.Rexx.toRexx(this.rs2.getString("SCOP_NM"));}
catch (java.sql.SQLException $23){
;
}}
if (c!=null) commnt.setScope(c);
v.add((java.lang.Object)commnt);
}}}

catch (java.sql.SQLException $24){e2=$24;
netrexx.lang.RexxIO.Say("SQLException(s) caught in getScopedComment");
{for(;;){if(!((e2!=null)))break;
netrexx.lang.RexxIO.Say($012.OpCcblank(null,netrexx.lang.Rexx.toRexx(e2.getSQLState())));
netrexx.lang.RexxIO.Say($08.OpCcblank(null,netrexx.lang.Rexx.toRexx(e2.getMessage())));
netrexx.lang.RexxIO.Say($09.OpCcblank(null,new netrexx.lang.Rexx(e2.getErrorCode())));
netrexx.lang.RexxIO.Say("");
e2=e2.getNextException();
}}
return v;
}}

return v;}





public netrexx.lang.Rexx getDefinition(netrexx.lang.Rexx entityID) throws java.sql.SQLException{netrexx.lang.Rexx d=null;

{
this.rs3=this.stmt2.executeQuery(netrexx.lang.Rexx.toString(netrexx.lang.Rexx.toRexx("SELECT CL_DSC as DSC from CL WHERE CL_OID = ").OpCcblank(null,entityID)));

{for(;;){if(!new netrexx.lang.Rexx(this.rs3.next()).OpNotEq(null,$03))break;
{try{
d=netrexx.lang.Rexx.toRexx(this.rs3.getString("DSC"));
if (d==null) d=netrexx.lang.Rexx.toRexx("");}
catch (java.sql.SQLException $25){
;
}}
return d;
}}
}

return d;}





public netrexx.lang.Rexx getComment(netrexx.lang.Rexx entityID) throws java.sql.SQLException{netrexx.lang.Rexx d=null;

{
this.rs3=this.stmt2.executeQuery(netrexx.lang.Rexx.toString(netrexx.lang.Rexx.toRexx("SELECT CL_DSC as DSC from CL WHERE CL_OID = ").OpCcblank(null,entityID)));

{for(;;){if(!new netrexx.lang.Rexx(this.rs3.next()).OpNotEq(null,$03))break;
{try{
d=netrexx.lang.Rexx.toRexx(this.rs3.getString("DSC"));
if (d==null) d=netrexx.lang.Rexx.toRexx("");}
catch (java.sql.SQLException $26){
;
}}
return d;
}}
}

return d;}






public netrexx.lang.Rexx getMultiScopeComment(netrexx.lang.Rexx ID) throws java.sql.SQLException{netrexx.lang.Rexx d=null;

{
this.rs3=this.stmt2.executeQuery(netrexx.lang.Rexx.toString((((((netrexx.lang.Rexx.toRexx("SELECT CMNT_SCP_RLN.CMNT, CMNT_SCP_RLN.OBJ_CL_OID FROM CL AS CMNT_SCP INNER JOIN CL_X_CL AS CMNT_SCP_RLN ON CMNT_SCP.CL_OID = CMNT_SCP_RLN.[SBJ CL_OID] WHERE (((CMNT_SCP_RLN.CMNT) Is Not Null) AND ((CMNT_SCP_RLN.OBJ_CL_OID) In (SELECT  RSTN_SCP_RLN.OBJ_CL_OID FROM CL_X_CL AS RSTN_SCP_RLN INNER JOIN CL AS RSTN_SCP ON RSTN_SCP_RLN.[SBJ CL_OID] = RSTN_SCP.CL_OID WHERE (((RSTN_SCP.CL_NM) In (").OpCc(null,this.modelname)).OpCc(null,netrexx.lang.Rexx.toRexx(")) AND ((RSTN_SCP_RLN.[CL X_CL TP_OID])=2637)))) AND ((CMNT_SCP_RLN.OBJ_CL_OID)="))).OpCcblank(null,ID)).OpCcblank(null,netrexx.lang.Rexx.toRexx(") AND ((CMNT_SCP_RLN.[CL X_CL TP_OID])=2637) AND ((CMNT_SCP.CL_NM) In ("))).OpCc(null,this.commentscopes)).OpCc(null,$023)));

{for(;;){if(!new netrexx.lang.Rexx(this.rs3.next()).OpNotEq(null,$03))break;
{try{
d=netrexx.lang.Rexx.toRexx(this.rs3.getString("CMNT"));
if (d==null) d=netrexx.lang.Rexx.toRexx("");}
catch (java.sql.SQLException $27){
;
}}
return d;
}}
}

return d;}




public java.util.ArrayList getDatatypes(){java.util.ArrayList v;netrexx.lang.Rexx QS=null;com.abnamro.midms.Datatype dType=null;netrexx.lang.Rexx infotype=null;netrexx.lang.Rexx name=null;netrexx.lang.Rexx oid=null;netrexx.lang.Rexx precision=null;java.sql.SQLException e2=null;
if (istimedisplayed) netrexx.lang.RexxIO.Say(netrexx.lang.Rexx.toRexx("in getDatatypes").OpCcblank(null,this.timer.getDiff()));
v=new java.util.ArrayList();
{try{
{/*select*/
if (this.engine.OpEq(null,$04))
{
QS=netrexx.lang.Rexx.toRexx("SELECT DSCTR_TP.CL_OID AS DSCTR_TP_OID, DSCTR_TP.CL_NM AS DSCTR_TP_NM, IIf([prn_data_fmt].[pblsd_Scm_OId]=[data_fmt].[pblsd_Scm_OId],[prn_data_fmt].[cl_Oid],[data_fmt].[cl_Oid]) AS DATA_TP_OID, IIf([prn_data_fmt].[pblsd_Scm_OId]=[data_fmt].[pblsd_Scm_OId],[prn_data_fmt].[cl_nm],[data_fmt].[cl_nm]) AS DATA_TP_NM, DATA_FMT.LEN AS LEN, DATA_FMT.NBR_DCM_PLC FROM (CL AS DATA_FMT INNER JOIN (CL AS DSCTR_TP INNER JOIN CL_X_CL ON DSCTR_TP.CL_OID = CL_X_CL.OBJ_CL_OID) ON DATA_FMT.CL_OID = CL_X_CL.[SBJ CL_OID]) INNER JOIN CL AS PRN_DATA_FMT ON DATA_FMT.PRN_CL_OID = PRN_DATA_FMT.CL_OID WHERE (((CL_X_CL.[CL X_CL TP_OID])=10008916));");
}
else if ((this.engine.pos(netrexx.lang.Rexx.toRexx("DB2"))).OpGt(null,$03)||this.engine.OpEq(null,$05))
{
QS=(((((((((((netrexx.lang.Rexx.toRexx(" SELECT DSCTR_TP.CL_OID AS DSCTR_TP_OID, DSCTR_TP.CL_NM AS DSCTR_TP_NM, ").OpCcblank(null,$024)).OpCcblank(null,netrexx.lang.Rexx.toRexx(" WHEN prn_data_fmt.pblsd_Scm_OId=data_fmt.pblsd_Scm_OId THEN prn_data_fmt.cl_Oid "))).OpCcblank(null,netrexx.lang.Rexx.toRexx(" ELSE data_fmt.cl_Oid END AS DATA_TP_OID, "))).OpCcblank(null,$024)).OpCcblank(null,netrexx.lang.Rexx.toRexx(" WHEN prn_data_fmt.pblsd_Scm_OId=data_fmt.pblsd_Scm_OId THEN prn_data_fmt.cl_nm "))).OpCcblank(null,netrexx.lang.Rexx.toRexx(" ELSE data_fmt.cl_nm END AS DATA_TP_NM, "))).OpCcblank(null,netrexx.lang.Rexx.toRexx(" DATA_FMT.LEN AS LEN, DATA_FMT.NBR_DCM_PLC "))).OpCcblank(null,netrexx.lang.Rexx.toRexx(" FROM (CL AS DATA_FMT INNER JOIN (CL AS DSCTR_TP "))).OpCcblank(null,netrexx.lang.Rexx.toRexx(" INNER JOIN CL_X_CL ON DSCTR_TP.CL_OID = CL_X_CL.OBJ_CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx(" ON DATA_FMT.CL_OID = CL_X_CL.SBJ_CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx(" INNER JOIN CL AS PRN_DATA_FMT ON DATA_FMT.PRN_CL_OID = PRN_DATA_FMT.CL_OID "))).OpCcblank(null,netrexx.lang.Rexx.toRexx(" WHERE (((CL_X_CL.CL_X_CL_TP_OID)=10008916)); "));












}
else{}
}
this.rs=this.stmt.executeQuery(netrexx.lang.Rexx.toString(QS));

{for(;;){if(!new netrexx.lang.Rexx(this.rs.next()).OpNotEq(null,$03))break;
dType=new com.abnamro.midms.Datatype();
infotype=netrexx.lang.Rexx.toRexx(this.rs.getString("DSCTR_TP_NM"));
name=netrexx.lang.Rexx.toRexx(this.rs.getString("DATA_TP_NM"));
oid=netrexx.lang.Rexx.toRexx(this.rs.getString("DSCTR_TP_OID"));
precision=netrexx.lang.Rexx.toRexx(this.rs.getString("LEN"));
if (name==null) name=netrexx.lang.Rexx.toRexx("");
if (oid==null) oid=netrexx.lang.Rexx.toRexx("");
if (infotype==null) infotype=netrexx.lang.Rexx.toRexx("");
if (precision==null) precision=netrexx.lang.Rexx.toRexx("");
dType.setName(name);
dType.setOid(oid);
dType.setInformationtype(infotype);
dType.setPrecision(precision);
infotypecount=new netrexx.lang.Rexx(infotypecount).OpAdd(null,$07).toint();
v.add((java.lang.Object)dType);
}}
return v;}

catch (java.sql.SQLException $28){e2=$28;
netrexx.lang.RexxIO.Say("SQLException(s) caught in getDatatypes");
{for(;;){if(!((e2!=null)))break;

netrexx.lang.RexxIO.Say($08.OpCcblank(null,netrexx.lang.Rexx.toRexx(e2.getMessage())));
netrexx.lang.RexxIO.Say($09.OpCcblank(null,new netrexx.lang.Rexx(e2.getErrorCode())));
netrexx.lang.RexxIO.Say("");
e2=e2.getNextException();
}}
return v;
}}}

public java.util.ArrayList selectClassifications(){java.util.ArrayList v;com.abnamro.midms.Classification clf=null;java.sql.SQLException e2=null;
v=new java.util.ArrayList();
{try{
this.rs=this.stmt.executeQuery("SELECT CL_OID, PRN_CL_OID FROM CL");

{for(;;){if(!new netrexx.lang.Rexx(this.rs.next()).OpNotEq(null,$03))break;
clf=new com.abnamro.midms.Classification();
clf.setCL_OID(netrexx.lang.Rexx.toRexx(this.rs.getString("CL_OID")));
if (this.rs.wasNull()) clf.setCL_OID(netrexx.lang.Rexx.toRexx("-1"));

clf.setPRN_CL_OID(netrexx.lang.Rexx.toRexx(this.rs.getString("PRN_CL_OID")));
if (this.rs.wasNull()) clf.setPRN_CL_OID(netrexx.lang.Rexx.toRexx("-1"));

v.add((java.lang.Object)clf);
}}
return v;}


catch (java.sql.SQLException $29){e2=$29;
netrexx.lang.RexxIO.Say("SQLException(s) caught in selectClassifications");
{for(;;){if(!((e2!=null)))break;

netrexx.lang.RexxIO.Say($08.OpCcblank(null,netrexx.lang.Rexx.toRexx(e2.getMessage())));
netrexx.lang.RexxIO.Say($09.OpCcblank(null,new netrexx.lang.Rexx(e2.getErrorCode())));
netrexx.lang.RexxIO.Say("");
e2=e2.getNextException();
}}
return v;
}}}

public java.util.ArrayList selectClassificationsInScope(){java.util.ArrayList v;netrexx.lang.Rexx QS=null;com.abnamro.midms.Classification clf=null;java.sql.SQLException e2=null;
v=new java.util.ArrayList();
{try{
{/*select*/
if ((this.engine.pos(netrexx.lang.Rexx.toRexx("DB2"))).OpGt(null,$03)||this.engine.OpEq(null,$05))
{
QS=((((((netrexx.lang.Rexx.toRexx("SELECT DISTINCT Q1.PRN_CL_OID, Q1.CL_OID ").OpCcblank(null,netrexx.lang.Rexx.toRexx(" FROM CL AS Q1, CL_X_CL AS Q2, CL "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("   AS Q3, CL AS Q4 "))).OpCcblank(null,netrexx.lang.Rexx.toRexx(" WHERE (Q2.OBJ_CL_OID = Q1.CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx(" AND (Q1.PBLSD_SCM_OID = Q3.CL_OID) AND (Q4.CL_OID = Q2.SBJ_CL_OID) AND "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("   (Q4.CL_NM IN ("))).OpCc(null,this.modelname)).OpCc(null,netrexx.lang.Rexx.toRexx(")) AND (Q2.CL_X_CL_TP_OID = 2637) "));





}
else if (this.engine.OpEq(null,$04))
{
QS=((((((netrexx.lang.Rexx.toRexx("SELECT DISTINCT Q1.PRN_CL_OID, Q1.CL_OID ").OpCcblank(null,netrexx.lang.Rexx.toRexx(" FROM CL AS Q1, CL_X_CL AS Q2, CL "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("   AS Q3, CL AS Q4 "))).OpCcblank(null,netrexx.lang.Rexx.toRexx(" WHERE (Q2.OBJ_CL_OID = Q1.CL_OID) "))).OpCcblank(null,netrexx.lang.Rexx.toRexx(" AND (Q1.PBLSD_SCM_OID = Q3.CL_OID) AND (Q4.CL_OID = Q2.[SBJ CL_OID]) AND "))).OpCcblank(null,netrexx.lang.Rexx.toRexx("   (Q4.CL_NM IN ("))).OpCc(null,this.modelname)).OpCc(null,netrexx.lang.Rexx.toRexx(")) AND (Q2.[CL X_CL TP_OID] = 2637) "));





}
else{}
}
this.rs=this.stmt.executeQuery(netrexx.lang.Rexx.toString(QS));

{for(;;){if(!new netrexx.lang.Rexx(this.rs.next()).OpNotEq(null,$03))break;
clf=new com.abnamro.midms.Classification();
clf.setCL_OID(netrexx.lang.Rexx.toRexx(this.rs.getString("CL_OID")));
if (this.rs.wasNull()) clf.setCL_OID(netrexx.lang.Rexx.toRexx("-1"));

clf.setPRN_CL_OID(netrexx.lang.Rexx.toRexx(this.rs.getString("PRN_CL_OID")));
if (this.rs.wasNull()) clf.setPRN_CL_OID(netrexx.lang.Rexx.toRexx("-1"));

v.add((java.lang.Object)clf);
}}
return v;}


catch (java.sql.SQLException $30){e2=$30;
netrexx.lang.RexxIO.Say("SQLException(s) caught in selectClassifications");
{for(;;){if(!((e2!=null)))break;

netrexx.lang.RexxIO.Say($08.OpCcblank(null,netrexx.lang.Rexx.toRexx(e2.getMessage())));
netrexx.lang.RexxIO.Say($09.OpCcblank(null,new netrexx.lang.Rexx(e2.getErrorCode())));
netrexx.lang.RexxIO.Say("");
e2=e2.getNextException();
}}
return v;
}}}

public java.util.ListIterator clIterator(){
return this.cl.listIterator();}




public void makeHierarchyMap(){java.util.ListIterator i;netrexx.lang.Rexx children;com.abnamro.midms.Classification cl1=null;java.util.ArrayList a=null;netrexx.lang.Rexx list=null;netrexx.lang.Rexx j=null;
if (istimedisplayed) netrexx.lang.RexxIO.Say(netrexx.lang.Rexx.toRexx("Mapping hierarchy ...").OpCcblank(null,this.timer.getDiff()));
i=clIterator();
children=netrexx.lang.Rexx.toRexx("");
{for(;;){if(!(i.hasNext()))break;

cl1=(com.abnamro.midms.Classification)(i.next());
children.getnode(cl1.getPRN_CL_OID()).leaf=(children.getnode(cl1.getPRN_CL_OID()).leaf).OpCcblank(null,cl1.getCL_OID());
}}
i=clIterator();
{for(;;){if(!(i.hasNext()))break;
a=new java.util.ArrayList();
cl1=(com.abnamro.midms.Classification)(i.next());
list=children.getnode(cl1.getCL_OID()).leaf;
{netrexx.lang.Rexx $31=list.words();j=new netrexx.lang.Rexx((byte)1);j:for(;j.OpLtEq(null,$31);j=j.OpAdd(null,new netrexx.lang.Rexx(1))){
if ((list.word(j))!=null) a.add((java.lang.Object)(list.word(j)));
}}/*j*/
this.oidHierarchyMap.put((java.lang.Object)(cl1.getCL_OID()),(java.lang.Object)a);
}}
if (istimedisplayed) netrexx.lang.RexxIO.Say(netrexx.lang.Rexx.toRexx("Mapping hierarchy ended").OpCcblank(null,this.timer.getDiff()));return;}

public java.util.ArrayList getSubTypeArrayForOID(netrexx.lang.Rexx oid){java.util.ArrayList v;java.util.ArrayList a=null;java.util.Iterator i=null;
v=new java.util.ArrayList();
{try{
a=new java.util.ArrayList((java.util.Collection)((java.util.ArrayList)(oidHierarchyMap.get((java.lang.Object)oid))));
i=a.iterator();
{for(;;){if(!(i.hasNext()))break;
v.add((java.lang.Object)((netrexx.lang.Rexx)(i.next())));
}}
return v;}
catch (java.lang.NullPointerException $32){
return (java.util.ArrayList)null;
}}}


public void makeIndexMap(){java.util.Iterator i;netrexx.lang.Rexx j;com.abnamro.midms.Entity cl1=null;
if (istimedisplayed) netrexx.lang.RexxIO.Say(netrexx.lang.Rexx.toRexx("Mapping EntityIndex ...").OpCcblank(null,this.timer.getDiff()));
i=this.iterator();
j=new netrexx.lang.Rexx((byte)0);
{for(;;){if(!(i.hasNext()))break;
cl1=new com.abnamro.midms.Entity();
cl1=(com.abnamro.midms.Entity)(i.next());
this.oidIndexMap.put((java.lang.Object)(cl1.getOid()),(java.lang.Object)j);
j=j.OpAdd(null,$07);
}}return;}

public void makeclIndexMap(){java.util.ListIterator i;netrexx.lang.Rexx j;com.abnamro.midms.Classification cl1=null;
if (istimedisplayed) netrexx.lang.RexxIO.Say(netrexx.lang.Rexx.toRexx("Mapping CL index ...").OpCcblank(null,this.timer.getDiff()));
i=clIterator();
j=new netrexx.lang.Rexx((byte)0);
{for(;;){if(!(i.hasNext()))break;
cl1=new com.abnamro.midms.Classification();
cl1=(com.abnamro.midms.Classification)(i.next());
this.cloidIndexMap.put((java.lang.Object)(cl1.getCL_OID()),(java.lang.Object)j);
j=j.OpAdd(null,$07);
}}return;}

public com.abnamro.midms.Classification getCLForOid(netrexx.lang.Rexx oid){netrexx.lang.Rexx index;
index=(netrexx.lang.Rexx)(this.cloidIndexMap.get((java.lang.Object)oid));
return ((com.abnamro.midms.Classification)(this.cl.get(index.toint())));}

public com.abnamro.midms.Entity getEntityforOID(netrexx.lang.Rexx oid){netrexx.lang.Rexx index;
index=(netrexx.lang.Rexx)(this.oidIndexMap.get((java.lang.Object)oid));
{try{
return ((com.abnamro.midms.Entity)(this.modeldata.get(index.toint())));}
catch (java.lang.NullPointerException $33){
return (com.abnamro.midms.Entity)null;
}}}

public void doUpdateGUI(java.lang.Runnable r){java.lang.reflect.InvocationTargetException e1=null;java.lang.InterruptedException e2=null;
{try{
javax.swing.SwingUtilities.invokeAndWait(r);}
catch (java.lang.reflect.InvocationTargetException $34){e1=$34;}
catch (java.lang.InterruptedException $35){e2=$35;
java.lang.System.err.println((java.lang.Object)e1);
java.lang.System.err.println((java.lang.Object)e2);
}}
return;}public netrexx.lang.Rexx getModelname(){return modelname;}public void setModelname(netrexx.lang.Rexx $36){modelname=$36;return;}public netrexx.lang.Rexx getSafemodelname(){return safemodelname;}public void setSafemodelname(netrexx.lang.Rexx $37){safemodelname=$37;return;}public netrexx.lang.Rexx getCommentscopes(){return commentscopes;}public void setCommentscopes(netrexx.lang.Rexx $38){commentscopes=$38;return;}public netrexx.lang.Rexx getModelversion(){return modelversion;}public void setModelversion(netrexx.lang.Rexx $39){modelversion=$39;return;}public int getEntitycount(){return entitycount;}public void setEntitycount(int $40){entitycount=$40;return;}public int getAttributecount(){return attributecount;}public void setAttributecount(int $41){attributecount=$41;return;}public int getRelationcount(){return relationcount;}public void setRelationcount(int $42){relationcount=$42;return;}public int getSubtypesetcount(){return subtypesetcount;}public void setSubtypesetcount(int $43){subtypesetcount=$43;return;}public int getSubjectareacount(){return subjectareacount;}public void setSubjectareacount(int $44){subjectareacount=$44;return;}public int getInfotypecount(){return infotypecount;}public void setInfotypecount(int $45){infotypecount=$45;return;}public java.util.ArrayList getModeldata(){return modeldata;}public void setModeldata(java.util.ArrayList $46){modeldata=$46;return;}public java.util.ArrayList getModeldatatypes(){return modeldatatypes;}public void setModeldatatypes(java.util.ArrayList $47){modeldatatypes=$47;return;}public java.util.TreeMap getOidIndexMap(){return oidIndexMap;}public void setOidIndexMap(java.util.TreeMap $48){oidIndexMap=$48;return;}public java.util.TreeMap getCloidIndexMap(){return cloidIndexMap;}public void setCloidIndexMap(java.util.TreeMap $49){cloidIndexMap=$49;return;}public java.util.ArrayList getCl(){return cl;}public void setCl(java.util.ArrayList $50){cl=$50;return;}public java.util.TreeMap getOidHierarchyMap(){return oidHierarchyMap;}public void setOidHierarchyMap(java.util.TreeMap $51){oidHierarchyMap=$51;return;}public javax.swing.JFrame getParentFrame(){return parentFrame;}public void setParentFrame(javax.swing.JFrame $52){parentFrame=$52;return;}public java.sql.Connection getCon(){return con;}public void setCon(java.sql.Connection $53){con=$53;return;}public com.abnamro.midms.timeit getTimer(){return timer;}public void setTimer(com.abnamro.midms.timeit $54){timer=$54;return;}public boolean isIstimedisplayed(){return istimedisplayed;}public void setIstimedisplayed(boolean $55){istimedisplayed=$55;return;}
class setWaitCursor implements java.lang.Runnable{private final transient java.lang.String $0="ERModel.nrx";
public void run(){
if ((ERModel.this.getParentFrame())!=null) ERModel.this.getParentFrame().setCursor(new java.awt.Cursor(java.awt.Cursor.WAIT_CURSOR));
return;}public setWaitCursor(){return;}}

class setDefaultCursor implements java.lang.Runnable{private final transient java.lang.String $0="ERModel.nrx";
public void run(){
if ((ERModel.this.getParentFrame())!=null) ERModel.this.getParentFrame().setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));return;}public setDefaultCursor(){return;}}

class updateCounter implements java.lang.Runnable{private final transient java.lang.String $0="ERModel.nrx";
public void run(){
ERModel.this.pMonitor.setNote(netrexx.lang.Rexx.toString(((new netrexx.lang.Rexx(ERModel.this.alreadyread).OpCcblank(null,$025)).OpCcblank(null,new netrexx.lang.Rexx(ERModel.this.size))).OpCcblank(null,$026)));
ERModel.this.pMonitor.setProgress(ERModel.this.alreadyread);
return;}public updateCounter(){return;}}

class closeMonitor implements java.lang.Runnable{private final transient java.lang.String $0="ERModel.nrx";
public void run(){
ERModel.this.pMonitor.close();
return;}public closeMonitor(){return;}}}