Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

7.20 DEF_ARRAY

Note

Note: Usage options

The DEF_ARRAY command is used to define an array structure within an RDML function.

...

However, it must be emphasized that the use of array constructs in database files is NOT considered to be the best long-term strategy in terms of relational database design.

...

7.20.3 DEF_ARRAY Examples


Panel
bgColor#ffffcc

                                                                                           Required

  DEF_ARRAY 

No Format
                                                        Required   DEF_ARRAY

----

NAME

 NAME ---------

#name of array

 #name of array ----------------->

             >

                    >--

INDEXES

-------

#index

field

name

--------------->

                             |                    |                               


                                                |                                     |
                                                 -------

50

max

---------

             >

                  >--

OF_FIELDS

-------

#field

name

--------------------->

                             |  expandable group expression    |                               


                                                   |  expandable group expression    |
                                                    ----------

100

max

-------------- 

                 

                         --

OR

--

             >

                 >--

OVERLAYING

---

#field

name

--

start

position

------>

 -----------------------------------------------------------------

                                                         Optional              >-- TYPE

------
                                                                                            Optional

                 >-- TYPE ---------

*CHAR

*DEC

*PACKED

*SIGNED

-----

>              >

>

                 >--

TOT_ENTRY

---

-

total

entries

(1-9999)

-------------->

             >

                 >--

ENTRY_LEN

---

-

entry

length

(1-256)

--------------->

             >

                >--

ENTRY_DEC

-

---

number

of

decimals

(0-9)

-----------|