1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

What Is Meaning Here Order 20 And Order 30

Discussion in 'Database Admin' started by Mike, Oct 24, 2017.

  1. Mike

    Mike Moderator

    Dear Team,

    Is any one can tell me this below is .df:-


    I want to know here what do you mean by order 20 /30 here marked red .Please explain me:-


    Sample .df of the 'Monitor' table:

    ADD TABLE "Monitor"
    AREA "Schema Area"
    DUMP-NAME "monitor"

    ADD FIELD "cTableName" OF "Monitor" AS character
    FORMAT "X(8)"
    INITIAL ""
    POSITION 2
    SQL-WIDTH 16
    ORDER 10

    ADD FIELD "cFieldName" OF "Monitor" AS character
    FORMAT "X(8)"
    INITIAL ""
    POSITION 3
    SQL-WIDTH 16
    ORDER 20

    ADD FIELD "cUserId" OF "Monitor" AS character
    FORMAT "X(8)"
    INITIAL ""
    POSITION 4
    SQL-WIDTH 16
    ORDER 30

    ADD FIELD "rOldRecid" OF "Monitor" AS recid
    FORMAT ">>>>>>9"
    INITIAL ?
    POSITION 5
    SQL-WIDTH 4
    ORDER 40<<<<<<<<

    ADD FIELD "rNewRecId" OF "Monitor" AS recid
    FORMAT ">>>>>>9"
    INITIAL ?
    POSITION 6
    SQL-WIDTH 4
    ORDER 50 <<<<

    ADD FIELD "cOldStringValue" OF "Monitor" AS character
    FORMAT "X(8)"
    INITIAL ""
    POSITION 7
    SQL-WIDTH 16
    ORDER 60 <<<<<<<<<<<<<<<

    ADD FIELD "cNewStringValue" OF "Monitor" AS character
    FORMAT "X(8)"
    INITIAL ""
    POSITION 8
    SQL-WIDTH 16
    ORDER 70

    ADD FIELD "cTime" OF "Monitor" AS character
    FORMAT "HH:MM:SS"
    INITIAL ""
    POSITION 9
    SQL-WIDTH 16
    ORDER 80

    ADD FIELD "cDate" OF "Monitor" AS date
    FORMAT "99/99/9999"
    INITIAL ?
    POSITION 10
    SQL-WIDTH 4
    ORDER 90

    ADD FIELD "Deal" OF "ATC" AS character
    DESCRIPTION "Deal Code"
    FORMAT "x(3)"
    INITIAL ""
    LABEL "Deal"
    POSITION 3
    MAX-WIDTH 3
    COLUMN-LABEL "Deal"
    HELP "Deal Code"
    ORDER 20 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<,,

    ADD FIELD "Coast" OF "ATC" AS character
    DESCRIPTION "Coast code"
    FORMAT "x(1)"
    INITIAL ""
    LABEL "Coast"
    POSITION 4
    MAX-WIDTH 1
    COLUMN-LABEL "Coast!Code"
    HELP "Coast Code. Leave blank for both coasts"
    ORDER 30 <<<<<<<<<<<<<<<<<<<


    with Regards
    Shane
     
  2.  
  3. Cringer

    Cringer ProgressTalk.com Moderator Staff Member

    It's the order of the fields within a table. In general they will be in the order they are added, so more recent additions have a higher order than older ones. It's just a sort order really. It has no real impact on the system.
     
  4. TheMadDBA

    TheMadDBA Active Member

    One thing that will matter if the order is changed.. if you so simple exports of data (export Monitor) from the table and try and import it again with different field orders you are likely to get errors or logical data corruption at the least.

    But essentially it should be something you ignore in a DF and just let OE manage it.. assuming you are doing proper incremental DFs
     
  5. Cringer

    Cringer ProgressTalk.com Moderator Staff Member

    That's a good point about import/export. And in this case I wouldn't assume anything!
     

Share This Page