What Is Meaning Here Order 20 And Order 30

[Mike]

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

 

[Cringer]

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.

 

[TheMadDBA]

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

 

[Cringer]

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