Extracting data from FXYX.ACCOUNT ,FABC.ACCOUNT

Start
Prev
1
Next
End

emushaija
Topic Author
Offline
Senior Member

12 years 1 week ago #11117 by emushaija

Extracting data from FXYX.ACCOUNT ,FABC.ACCOUNT was created by emushaija

Hello Good People

The file set up of the system i am working on are set up according to the company .I want to extract the files from different companies all in one file using routine

i,e SELECT F.ACCOUNT (F.ACCOUNT i assume should contain the files from all mneumonic)

but that is not the case i get only files from BNK

Thanks for your help

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

durai611
Offline
Elite Member

12 years 1 week ago #11119 by durai611

Replied by durai611 on topic Re: Extracting data from FXYX.ACCOUNT ,FABC.ACCOUNT

In COMPANY.CHECK file you can get the financial mnemonic of each company in record FIN.FILE.

Loop each mnemonic, form the respective company account file name and select the account records.

Loop
Remove MNE from FinancailMnemonic
SELECT 'F':MNE:'ACCOUNT
Repeat

Is this you want?

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

jpb
Offline
Moderator
TAFj-R20 - 'unix'

12 years 1 week ago - 12 years 1 week ago #11120 by jpb

Replied by jpb on topic Re: Extracting data from FXYX.ACCOUNT ,FABC.ACCOUNT

If you use OPF to open the files you should loop thru all defined companies, do a LOAD.COMPANY and then open the file, extract data etc.

    SEL.CMD = 'SSELECT F.COMPANY'
    CMP.LIST = ''
    CALL EB.READLIST(SEL.CMD,CMP.IDS,"","","")
    LOOP
        READNEXT COMPANY.ID FROM CMP.IDS ELSE COMPANY.ID = ''
    WHILE COMPANY.ID
        ID.COMPANY = COMPANY.ID
        CALL LOAD.COMPANY(ID.COMPANY)
        FN.ACCOUNT = "F.ACCOUNT"
        F.ACCOUNT  = ""
        CALL OPF(FN.ACCOUNT,F.ACCOUNT)
...
REPEAT

Or use OPEN statement instead of OPF with the complete filename.

Last edit: 12 years 1 week ago by jpb.

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

emushaija
Topic Author
Offline
Senior Member

12 years 1 week ago #11121 by emushaija

Replied by emushaija on topic Re: Extracting data from FXYX.ACCOUNT ,FABC.ACCOUNT

Helo Durai

that was the quickest response ,thanks so much it works.

I thought may be t24 had internal function that can handle this kind of situation.

Nevertheless am fine working with the tip you provided

Be blessed

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

emushaija
Topic Author
Offline
Senior Member

12 years 1 week ago #11123 by emushaija

Replied by emushaija on topic Re: Extracting data from FXYX.ACCOUNT ,FABC.ACCOUNT

Thanks Jpb !

As usual you are always there to support

be blessed cheers

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

Start
Prev
1
Next
End

Time to create page: 0.110 seconds