Not logged in : Login

About: VirtProgressPKNull     Goto   Sponge   NotDistinct   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
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.
Title
  • VirtProgressPKNull
attachment
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
has creator
is described using
atom:source
atom:updated
  • 2014-01-23T15:32:12Z
atom:title
  • VirtProgressPKNull
atom:author
label
  • VirtProgressPKNull
topic
atom:published
  • 2010-02-01T14:51:03Z
type
is topic of
Faceted Search & Find service v1.17_git63 as of Apr 23 2021


Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:       RDF       ODATA       Microdata      About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3321 as of May 18 2021, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (30 GB total memory)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2021 OpenLink Software