This HTML5 document contains 49 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

Subject Item

n4:this

foaf:made

n2:VirtProgressPKNull

Subject Item

n22:this

sioc:creator_of

n2:VirtProgressPKNull

Subject Item

n24:item

n23:services_of

n2:VirtProgressPKNull

Subject Item

n18:this

sioc:creator_of

n2:VirtProgressPKNull

Subject Item

n6:VOS

sioc:container_of

n2:VirtProgressPKNull

atom:entry

n2:VirtProgressPKNull

atom:contains

n2:VirtProgressPKNull

Subject Item

n2:VirtProgressPKNull

rdf:type

sioct:Comment atom:Entry

dcterms:created

2017-06-13T05:38:16.171679

dcterms:modified

2017-06-13T05:38:16.171679

rdfs:label

VirtProgressPKNull

foaf:maker

n8:this n4:this

dc:title

VirtProgressPKNull

opl:isDescribedUsing

n34:rdf

sioc:has_creator

n18:this n22:this

sioc:attachment

n10:png n11:png n12:png n13:png n14:png n15:png n16:png n17:png n19:png n20:png n21:png n25:png n26:png n28:png n29:png n30:png n31:png n32:png n35:png

sioc:content

%META:TOPICPARENT{name="VirtProgressEntityFrameworkUsage"}% ---+ Ensuring Progress Primary Keys (PKs) are NOT NULLABLE While Progress does not formally have Primary Keys defined per table, it does have INDEXes. For many purposes, including Entity Frameworks, all fields comprising the INDEX must be set not-nullable, or "mandatory" in Progress parlance. Use the following procedure to check the relevant fields: 1 Log in to the machine that hosts your Progress DBMS. %BR%%BR%<img src="%ATTACHURLPATH%/LoginProgressDBServer.png" style="wikiautogen"/> %BR%%BR% 1 Navigate to the root of the Progress installation. %BR%%BR%<img src="%ATTACHURLPATH%/cdProgressRootDirectory.png" style="wikiautogen"/>%BR%%BR% 1 Use the <code>su</code> command to switch to your local Progress user. %BR%%BR%<img src="%ATTACHURLPATH%/ExecuteProfile.png" style="wikiautogen"/>%BR%%BR% 1 Execute the <code>.profile</code> associated with the Progress user. %BR%%BR%<img src="%ATTACHURLPATH%/ExecuteProfile.png" style="wikiautogen"/>%BR%%BR% 1 Launch the <b><code>_progres</code></b> utility. %BR%%BR%<img src="%ATTACHURLPATH%/RunProgres.png" style="wikiautogen"/>%BR%%BR% 1 Use the <b>Tools</b> menu to access the <b>Data Dictionary</b> utility. %BR%%BR%<img src="%ATTACHURLPATH%/ToolsDataDictionary.png" style="wikiautogen"/>%BR%%BR% 1 Expand the <b>Database</b> menu and use <b>Connect</b> to connect to the target database. %BR%%BR%<img src="%ATTACHURLPATH%/SelectTargetDatabase.png" style="wikiautogen"/>%BR%%BR% 1 Repeat the following steps for each field in each table's index. 1 Expand the <b>Schema</b> menu and select the <b>Index Editor</b>. %BR%%BR%<img src="%ATTACHURLPATH%/ProgressIndexEditor.png" style="wikiautogen"/>%BR%%BR% 1 Select the target table. %BR%%BR%<img src="%ATTACHURLPATH%/SelectProgressTable.png" style="wikiautogen"/>%BR%%BR% 1 Review the fields that comprise that table's index. %BR%%BR%<img src="%ATTACHURLPATH%/ProgressIndexFields.png" style="wikiautogen"/>%BR%%BR% 1 Select <b><nop>GoField</b>. %BR%%BR%<img src="%ATTACHURLPATH%/ProgressGoField.png" style="wikiautogen"/>%BR%%BR% 1 Select <b>Modify</b>. %BR%%BR%<img src="%ATTACHURLPATH%/IndexEditorModifyOption.png" style="wikiautogen"/>%BR%%BR% 1 Navigate to the field that you want to check. %BR%%BR%<img src="%ATTACHURLPATH%/IndexEditorSelectNullableField.png" style="wikiautogen"/> %BR%%BR% 1 Look for the field's <b>Mandatory</b> property. %BR%%BR%<img src="%ATTACHURLPATH%/LocateMandatorySetting.png" style="wikiautogen"/>%BR%%BR% 1 Ensure the value passed to Mandatory is <b>yes</b>, and hit <b>F4</b> to save your changes. %BR%%BR% <img src="%ATTACHURLPATH%/SetMandatoryYes.png" style="wikiautogen"/>%BR%%BR% 1 Exit the utility, and proceed to your other tasks.

sioc:id

fb8338636aa088553f2b9c08350fcfc1

sioc:link

n2:VirtProgressPKNull

sioc:has_container

n6:VOS

n23:has_services

n24:item

atom:title

VirtProgressPKNull

atom:source

n6:VOS

atom:author

n4:this

atom:published

2017-06-13T05:38:16Z

atom:updated

2017-06-13T05:38:16Z

sioc:topic

n6:VOS

Subject Item

n2:VirtProgressEntityFrameworkUsage

sioc:links_to

n2:VirtProgressPKNull