Forum
Keyword

Download all field from t24

  • nobuzaki
  • nobuzaki's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 8
  • Thank you received: 0

nobuzaki created the topic: Download all field from t24

Hello all,
Currently i have to deal with temenos system and its is my first time. I tried every source on the internet and only find a few resources.
I want to ask questions can we download all available field from files. example i want to download FBNK.CUSTOMER that contain all fields ( i want to make csv from it). What i have tried is by selecting it to save list, but it only download the key. also my other question is how to make some program/operation that runs periodically every month to do download operations as i asked before?

Thank you very much.
#20382

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: 541
  • Karma: 9
  • Thank you received: 78

VK replied the topic: Download all field from t24

Hi
to export all fields from a file you either have to issue a very long jQL statement like:
SELECT FBNK.CUSTOMER SAVING EVAL "DQUOTE(@ID):',':DQUOTE(MNEMONIC):',':DQUOTE(SHORT.NAME)"
SAVE.LIST CUST.csv

(you will have to add all other fields after SHORT.NAME)

... or to write a program/subroutine that reads the FBNK.CUSTOMER record by record, replaces each @FM (field mark) to a comma (not forgetting to enclose each field in double quotes) and then write the result to the output flat file. Should be quite easy.

for your code to be run monthly you need to add it to a COB job with frequency = "M"

Cheers
VK
#20383
The following user(s) said Thank You: nobuzaki

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

  • nobuzaki
  • nobuzaki's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 8
  • Thank you received: 0

nobuzaki replied the topic: Download all field from t24

Thank you for your quick response VK!
i see so i have to do mention all fields then...
i will explore and find about program example then.
#20384

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

  • nobuzaki
  • nobuzaki's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 8
  • Thank you received: 0

nobuzaki replied the topic: Download all field from t24

hi again VK,

can u give me some example how to do this in program?

Thank you
#20394

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: 541
  • Karma: 9
  • Thank you received: 78

VK replied the topic: Download all field from t24

Hi
I think it will be better if you write this program yourself so you clearly understand what's what.

Use jBC statement OPEN to open a file; use SELECT to get all record @IDs, then LOOP ...READNEXT to read each record.
To transform field marks to commas use CHANGE statement.

To create and populate the output flat file use OPENSEQ .. WRITESEQ .. CLOSESEQ.
Good luck!

More information and examples:
jbc.temenos.com

Cheers
VK
#20395

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

Time to create page: 0.124 seconds