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.

Hi
to export all fields from a file you either have to issue a very long jQL statement like:

(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"

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.

hi again VK,

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

Thank you

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