view field length and type

  • nobuzaki
  • Topic Author
  • Offline
  • New Member
  • New Member
More
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
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
More
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
  • New Member
More
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
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
More
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.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • retired . . . ¯\_(ツ)_/¯
More
8 years 1 month ago #20420 by jpb
Replied by jpb on topic view field length and type
Quick reference to IN2 :

Attachments:

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

Time to create page: 0.084 seconds