view field length and type
- nobuzaki
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 0
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.
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
Less
More
- Posts: 1182
- Thank you received: 157
8 years 1 month ago #20417
by VK
Cheers
VK
Replied by VK on topic view field length and type
Hi
Field definitions are stored in the file dictionary:
There is T24 application STANDARD.SELECTION which reflects this structure (with addition of "types", see "IN2 routines" manual):
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
Less
More
- Posts: 8
- Thank you received: 0
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?
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
Less
More
- Posts: 1182
- Thank you received: 157
8 years 1 month ago #20419
by VK
Cheers
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.:
There's a manual describing these types.
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
- Offline
- Moderator
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 649
8 years 1 month ago #20420
by jpb
Replied by jpb on topic view field length and type
Please Log in or Create an account to join the conversation.
Time to create page: 0.084 seconds