view field length and type

Start
Prev
1
Next
End

nobuzaki
Topic Author
Offline
New Member

8 years 1 month ago #20415 by nobuzaki

view field length and type was created by nobuzaki

Hi All,
how to know the table structure like field length and type (numeric, char, decimal) from application, lets say Customer.

Thank you.

Please Log in or Create an account to join the conversation.

VK
Offline
Platinum Member
Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test

8 years 1 month ago #20417 by VK

Replied by VK on topic view field length and type

Hi
Field definitions are stored in the file dictionary:

CT DICT FBNK.CUSTOMER
    SHORT.NAME
001 D                <<<<<<<<<<<<<<< data field
002 2                <<<<<<<<<<<<<<< position
003
004 SHORT.NAME   
005 35L          <<<<<<<<<<<<<< length; left formatting
006 M             <<<<<<<<<<<<<<< multi-valued
007
008

There is T24 application STANDARD.SELECTION which reflects this structure (with addition of "types", see "IN2 routines" manual):

     FILE.NAME......... CUSTOMER
 ------------------------------------------------------------------------------
   1. 1 SYS.FIELD.NAME. @ID
   2. 1 SYS.TYPE....... D
   3. 1. 1 SYS.FIELD.NO 0
   4. 1. 1 SYS.VAL.PROG IN2CUS
   5. 1 SYS.CONVERSION.
   6. 1 SYS.DISPLAY.FMT 10R
   7. 1 SYS.ALT.INDEX.. N
   8. 1. 1 SYS.IDX.FILE
   9. 1 SYS.INDEX.NULLS
  10. 1 SYS.SINGLE.MULT S
  11. 1 SYS.LANG.FIELD. N
  12. 1 SYS.GENERATED.. Y
  13. 1. 1 SYS.CNV.TYPE
  14. 1. 1 SYS.REL.FILE
   1. 2 SYS.FIELD.NAME. CUSTOMER.CODE
   2. 2 SYS.TYPE....... D
 ------------------------------------------------------------------------------

Cheers
VK

The following user(s) said Thank You: nobuzaki

Please Log in or Create an account to join the conversation.

nobuzaki
Topic Author
Offline
New Member

8 years 1 month ago #20418 by nobuzaki

Replied by nobuzaki on topic view field length and type

Hi VK,

Thank you for you fast response. as far as i am searching, i cannot see the description for numeric/dec/char. Only left adjust and right adjust. Or is it how the t24 data types stored? only 2 types?

Please Log in or Create an account to join the conversation.

VK
Offline
Platinum Member
Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test

8 years 1 month ago #20419 by VK

Replied by VK on topic view field length and type

Hi
In the database everything is stored as a string;
However T24 has a thing called "IN2 routines" - links to them are stored in SS. They (read: checks) are applied at the application level.
E.g.:

   1. 1 SYS.FIELD.NAME. @ID
   2. 1 SYS.TYPE....... D
   3. 1. 1 SYS.FIELD.NO 0
   4. 1. 1 SYS.VAL.PROG IN2CUS
...
   1. 4 SYS.FIELD.NAME. MNEMONIC
   2. 4 SYS.TYPE....... D
   3. 4. 1 SYS.FIELD.NO 1
   4. 4. 1 SYS.VAL.PROG IN2MNE
...
   1. 5 SYS.FIELD.NAME. SHORT.NAME
   2. 5 SYS.TYPE....... D
   3. 5. 1 SYS.FIELD.NO 2
   4. 5. 1 SYS.VAL.PROG IN2SWI
...

There's a manual describing these types.

Cheers
VK

Please Log in or Create an account to join the conversation.