| Attributes | Values |
|---|
| type
| |
| Date Created
| |
| Date Modified
| |
| label
| |
| maker
| |
| Title
| |
| isDescribedUsing
| |
| has creator
| |
| attachment
| |
| 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.
|
| id
| - fb8338636aa088553f2b9c08350fcfc1
|
| link
| |
| has container
| |
| http://rdfs.org/si...ices#has_services
| |
| atom:title
| |
| atom:source
| |
| atom:author
| |
| atom:published
| |
| atom:updated
| |
| topic
| |
| is made
of | |
| is container of
of | |
| is link
of | |
| is http://rdfs.org/si...vices#services_of
of | |
| is links to
of | |
| is creator of
of | |
| is atom:entry
of | |
| is atom:contains
of | |
![[RDF Data]](/fct/images/sw-rdf-blue.png)
![[cxml]](/fct/images/cxml_doc.png)
![[csv]](/fct/images/csv_doc.png)
![[text]](/fct/images/ntriples_doc.png)
![[turtle]](/fct/images/n3turtle_doc.png)
![[ld+json]](/fct/images/jsonld_doc.png)
![[rdf+json]](/fct/images/json_doc.png)
![[rdf+xml]](/fct/images/xml_doc.png)
![[atom+xml]](/fct/images/atom_doc.png)
![[html]](/fct/images/html_doc.png)