Not logged in : Login
(Sponging disallowed)

About: VirtProgressPKNull     Goto   Sponge   Distinct   Permalink

An Entity of Type : atom:Entry, within Data Space : www.openlinksw.com associated with source document(s)
QRcode icon
http://www.openlinksw.com/describe/?url=http%3A%2F%2Fwww.openlinksw.com%2Fdataspace%2Fdav%2Fwiki%2FMain%2FVirtProgressPKNull

AttributesValues
has container
Date Created
maker
topic
described by
seeAlso
Date Modified
link
id
  • d0cb50e0cc4e66ef5677150efb1e043f
  • d0cb50e0cc4e66ef5677150efb1e043f
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.
  • %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.
Title
  • VirtProgressPKNull
  • VirtProgressPKNull
attachment
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/Databaseconnect.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/Databaseconnect.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/ExecuteProfile.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/ExecuteProfile.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/IndexEditorModifyOption.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/IndexEditorModifyOption.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/IndexEditorSelectNullableField.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/IndexEditorSelectNullableField.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/LocateMandatorySetting.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/LocateMandatorySetting.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/LoginProgressDBServer.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/LoginProgressDBServer.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/NavigateToTableField.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/NavigateToTableField.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/ProgressFieldEditor.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/ProgressFieldEditor.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/ProgressGoField.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/ProgressGoField.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/ProgressIndexEditor.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/ProgressIndexEditor.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/ProgressIndexFields.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/ProgressIndexFields.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/ProgressModifyTable.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/ProgressModifyTable.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/RunProgres.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/RunProgres.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/SelectModifyTableSubItem.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/SelectModifyTableSubItem.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/SelectProgressTable.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/SelectProgressTable.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/SelectTargetDatabase.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/SelectTargetDatabase.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/SetMandatoryYes.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/SetMandatoryYes.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/ToolsDataDictionary.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/ToolsDataDictionary.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/cdProgressRootDirectory.png
  • http://www.usnet.private:8889/wiki/main/Main/VirtProgressPKNull/cdProgressRootDirectory.png
has creator
Faceted Search & Find service v1.17_git122 as of Jan 03 2023


Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:   [cxml] [csv]     RDF   [text] [turtle] [ld+json] [rdf+json] [rdf+xml]     ODATA   [atom+xml] [odata+json]     Microdata   [microdata+json] [html]    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3330 as of Apr 5 2024, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (30 GB total memory, 26 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software