× 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
  • Junior Member
  • Posts: 28
  • Karma: -5
  • Thank you received: 0

tester111 created the topic: field name by sql

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?
#21686

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 745
  • Thank you received: 106

VK replied the topic: field name by sql

Hi
check the corresponding dictionary - e.g. D_F_SPF for F_SPF etc.

Cheers
VK
#21690

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

  • Posts: 1
  • Thank you received: 0

Lakshminarayanan replied the 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?
#22522

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 745
  • Thank you received: 106

VK replied the 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).

Cheers
VK
#22523

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

Time to create page: 0.158 seconds