×
Discuss about OFS, Temenos Connectors, Various OFS modes, OFS with Versions, OFS performance, Logging, EB.PHANTOM, OFS.SOURCE etc…
field name by sql
- tester111
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 29
- Thank you received: 0
6 years 1 month ago #21686
by tester111
field name by sql was created by tester111
i found that the database store xml reocrd with the tag <c1> <c2> <c...>, how can i match the field name with these tag name by sql script?
Please Log in or Create an account to join the conversation.
- VK
-
- Offline
- Platinum Member
-
- Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
Less
More
- Posts: 1116
- Thank you received: 150
6 years 1 month ago #21690
by VK
Cheers
VK
Replied by VK on topic field name by sql
Hi
check the corresponding dictionary - e.g. D_F_SPF for F_SPF etc.
check the corresponding dictionary - e.g. D_F_SPF for F_SPF etc.
Cheers
VK
Please Log in or Create an account to join the conversation.
- Lakshminarayanan
- Offline
- New Member
-
Less
More
- Posts: 1
- Thank you received: 0
4 years 3 months ago - 4 years 3 months ago #22522
by Lakshminarayanan
Replied by Lakshminarayanan on topic field name by sql
Standard.Selection table store the information about column name, routine used, size of column.
1. do it store the column information of all the tables starting with "F"?
2. do the dictionary table and Standard.Selection information table holds the same information?
1. do it store the column information of all the tables starting with "F"?
2. do the dictionary table and Standard.Selection information table holds the same information?
Last edit: 4 years 3 months ago by Lakshminarayanan.
Please Log in or Create an account to join the conversation.
- VK
-
- Offline
- Platinum Member
-
- Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
Less
More
- Posts: 1116
- Thank you received: 150
4 years 3 months ago #22523
by VK
Cheers
VK
Replied by VK on topic field name by sql
Hi
answers:
(1) No, only applications (those having entries in FILE.CONTROL and PGM.FILE type H, U, L, T, W, D).
(2) Dictionary is being rebuilt when you amend and authorise SS (or amend local fields). So, generally it's the same information (in native jBASE / Pick format).
answers:
(1) No, only applications (those having entries in FILE.CONTROL and PGM.FILE type H, U, L, T, W, D).
(2) Dictionary is being rebuilt when you amend and authorise SS (or amend local fields). So, generally it's the same information (in native jBASE / Pick format).
Cheers
VK
Please Log in or Create an account to join the conversation.
Time to create page: 0.099 seconds