?_E/M5,l']n2DB2-400 Import/&;)z4:second", "info")Obsydian Information GuideThe DB2/400 Import Utility enables you to rapidly describe your AS/400 physical tables to an Obsydian Model. It will eliminate a great deal of keying and thus will eliminate a potential source for errors. In a matter of minutes, you can populate an Obsydian model with thousands of objects and triples, complete with necessary implementation names and a proper association with objects in the Obsydian class libraries.2 ' HOverviewH-, (8HoDB2-400 Import features/\' HTasks-GO l9H;o㍏o㼑o ooDisplay LibrariesDisplay TablesGo To LibraryDisplay FieldsImport OptionsAS/400 and DB2/400 are registered trademarks of IBM Corporation. > \1Go To Library7G'  HGo To Library' OHThis dialog box allows you to display the tables from a specific library. If you know the name of the AS/400 library, using this dialog box can save you some time.1 ' HOptions=/ .HޢoLibrary @818GME Field Limit9q' $HGME Field LimitsI8* "HThis field shows the maximum number of fields a table can have in order to inherit from OBASE/Grid Maintained Entity (GME). Any table with a single key field and more fields than this limit inherits from OBASE/User Maintained Entity. The default is 5.Tables with more than one key field inherit from OBASE/Business Entity. 5q1Name/H' HNames`( HA name triple is generated for each field. The target name object is the field name itself. 6H 1Z * Label0 6 ' HLabels * ) HA label triple is generated for each field. The target label object is the field name itself. Depending on how you set the Import Options, you can get Left Label, Right Label, and Top Label triples. 76 a 1a  Limits0 * ' HLimits~Va  ( HA limits triple is generated for each field. The target system value ALL is used. < K 1K  Right label5 ' HRight LabeliK  ( HA right label triple is generated for each field. It comes from the Text keyword in the field's DDS. : K 1rK Top label3  ~ ' HTop LabelK ) HA top label triple is generated for each field. It is used for the column heading for grids and comes from the COLHDG keyword in the field's DDS. If no COLHDG keyword exists, the name from the TEXT keyword is used. ; ~ 1 Left label4 ' HLeft Labelo ( HA left label triple is generated for each field. Its value comes from the Text keyword in the field's DDS. F 1x  @Replacement character?' 0HReplacement Character @* "HThis character replaces invalid characters found in table and field names. Invalid characters for Obsydian include the following: < > / . , :The default replacement character is an underscore _.  @7D@1q D@~CFolderR+ @@' VHImport File Location (Library or Folder)D@cA' MHThis is the location of the Import File or Document on the AS/400. The name of this field changes depending on what you select for the Generate Output As: option.@hB5 8T:H If you are generating an Import File, this field contains the Library that the File will be placed in. If you are generating a Document, this is the Folder that the Document will be placed in. cA~C) HNo validation is performed. The Folder must exist already on the AS/400. If not, no Document will be created. If the Library does not exist, the File will be created and will be found in the DB2-400 Import Utility product library. 9hBC11 CEDocument2 ~CC' HDocumentCE* "9HThe name of an AS/400 document in a shared folder. You can import this file directly into Obsydian by selecting it from the "I:" drive (although on your PC, the drive may be given a different name). The maximum length of the file name (without the extension) is 8. If you do not enter an extension (.xxx), an extension of .4MP is added. If you do not want an extension, end the file name with a period. < CE1 EGImport file5E F' HImport Filei?EG* "HThe import data is generated to an AS/400 physical file that you name, in the library containing the DB2/400 Import Utility program. If you create a file instead of a document in a shared folder, you need to use a file transfer utility to move the file to your PC before executing the Import tool within Obsydian. ? FG1 GeLImport optionsCG H' 8HImport Generation Options[GH& HThis dialog box allows you to select certain options before generating the Import File.  HJ5 8T:H You can indicate whether the Import File should be a physical file or a document in an AS/400 shared folder. You can give the file or document a meaningful name (up to 10 and 8 characters, respectively). If you chose to use a physical file, it should either be one that was created by the DB2/400 Import Utility or it should not exist. If a file or field name contains a character which is invalid in Obsydian, it will be replaced by the character indicated on this panel.xLHK, (T:H Finally, you can control which triples should be created upon import.1 JOK' HOptionsKeLv AH o4o_o⊣o#notooĕoooAS400 import fileDocumentLibrary or FolderReplacement characterGME field limitLeft labelTop labelRight labelLimitsLabelName ; OKL1LfMField type4 eLL' HField TypejLfM( HThe Field Type is the AS/400 data type. Types of data include character, packed, signed, binary, etc. ; LM1MhNField text4 fMM' HField TextkMhN( HThis is the DDS text name of the field. If no Text exists for the field, the field's DDS name is used. 6MN1NOField4 hNN' HField NameGNO( >HThis is the DDS field name. ?NXO1bXODisplay Fields8OO' "HDisplay Fields]XO$+ &HThis window displays the fields and their attributes for the table yO$Oou selected. Columnsc&O= JLHo)o oFieldField textField type = $Ā1Ā%Browse Files8' "HDisplay TablesĀ/ ,H oThis window displays the tables in the library you selected. Choose Select Table from the Select menu or double-click the Selected column to select one or more tables for import. When you have selected all the tables you need, choose Create File from the Select menu.To see a list of the fields in a table and their attributes select a table and choose Display Fields from the Select menu.1 ' HColumns; %/ .HӲoTable > c1cCStd File name/%' HTablecC) HAn AS/400 physical file or SQL table. Only physical files, SQL tables, and source files are displayed in the Display Tables window. A1FStd Library name1 C' HLibraryiF( HAn AS/400 library. Only libraries with tables in them are displayed in the Display Libraries window. A1>Browse Libraries;F…' (HDisplay Libraries- (H㍏oThis window displays the libraries on your AS/400 that contain one or more tables. Select one of the libraries and choose Display Tables from the Select menu. Only one library at a time can be processed.1 …' HColumnsL>6 <,HޢoӲoLibraryTable H1/yDB2-400 Import featuresd9>+ &rHUsing the DB2/400 Import UtilityLicense information.Yp- (HuThe DB2/400 Import Utility is a licensed product and it is checked each time the utility is used. The system you run the utility from must have a current Obsydian license installed. The first time it is run a dialog panel is displayed: Display license path, asking you to enter the directory where you have the Obsydian product installed.=' ,HThe Import process.nHp& HImporting AS/400 tables into an Obsydian model is a two step process:wƊ4 8T:H Build an import file (the same one Obsydian uses to import Synon/2 objects). Import the file into Obsydian.B' 6HTo build an import file:v,Ɗ~J bYT:H;o㍏o oo1.Choose Display Libraries from the Select menu. This list displays all the libraries on your AS/400 that contain a table. 2.Select a library and choose Display Tables from the Select menu to see the tables in that library.3.Choose Display Fields from the Select menu to see all of the fields in a table and their properties.4.Double-click the Selected column for each table you want to process.5.Choose Create File from the Select menu to generate the import file. The Import Options dialog box is displayed asking you if you want to:)> JT:H Generate a physical file (you can use file transfer utilities to copy it to your PC), or Generate a PC file (in a shared folder on the AS/400). Generate triples for left, right, and top labels, limits, name and label.~i( 5ȂHThe build of the import file happens on the AS/400. It generates objects and triples for each table selected, along with the fields from those tables.K$' HHTo import the file into Obsydian:#i0 .T:H1.Start Obsydian and creat>e a local model.2.Extract the OBASE and OBJECTS class libraries into your local model.3.From the Tools menu, choose DB2/400 from the Import sub-menu.4.Select the import file you just created, then click OK.]7@& nHOnce you do the import in Obsydian, you will notice: `M hT:H A Subject Area is created which includes all tables selected. Each entity 'is a' User Maintained Entity, Grid Maintained Entity, or Business Entity based upon rules defined in the .INI file. Each table includes 'file name', 'impl name', 'record', 'column', and '..impl' triples. Primary key fields are identified by looking at existing AS/400 access paths, and defined with 'known by' triples. All other fields are defined by 'has' triples.@y? LT:H Each field 'is a' class library field like Code, Status, Narrative, Quantity, Price, Percent, Numeric, Value, etc. It matches the field attribute with the class library properties to determine which object it inherits from. For each field, additional triples can be created based on the options selected at generation time. Invalid characters in names have been replaced by the character you specified in the Generation Options dialog (the default is '_'). G`1DB2/400 Import Utility6y' HLicense pathu) "HType in the location of the Obsydian product.Use the following format: ":\\Obsydian.exe" 11 XHelvN Nt+SymbolFFVFMS Sans SerifV,0Arialv^FV- !}k\&XÉKԈU5Mr?r|/&;)LzF&5^SDB2/400 Import UtilityGo To Library|GME Field LimitName?LabelLimitsrRight labelTop labelLeft labelMReplacement characterFolderDocument5Import fileImport optionsԈField typeKField textÉFieldDisplay Fields&Browse FilesStd File namekStd Library nameBrowse LibrariesDB2-400 Import featuresDB2/400 Import UtilityhƋ^_]UWV~ v&*FF&*"F&*F u FGF~u0؀~t} ~| ~+^_]UWVvF&F*+RPDQPQV4 ^*&8Ƌ^_]UWVvFPV;4*+RPWVDWPNH5 NJF&ƌ^_]UWVv ~^ F&8u <t!FG&*6*6:*u:tFG吸5+"4؎F &***F&**+^_]UWVv ~^ F&8u t FG&*6+6:+u:tFG吸e6+"5؎F &*+*F&+*+^_]UVvΌ^ *6-F<u[6؋V^]UVvΌ^ *6,F<u︲6؋V^]@PRP^15U$WVNF u+FNF@Pv v^1U7FV t؋VV@PRP^1i7V uvv37뫐Fމ~Fv vvv vQ7 FV&E&U~t?^F&&Wv&&TFގ&?&G&G& Gu^FގF&&GN^F&G& GtF&w&<&Dv+&D&FގF&&G&G& u FގF&?&G^_]UWVvF&D& Dt &u&u3q8FPV347^_]UWV^ F u+~F ^FˉFFv&9