Hi, This task is really enormous. The extract itself isn't very complex - you need to write a small program that selects PGM.FILE and then opens each file in a loop, reads every records, changes @FM to comma (and commas inside fields to something else) and writes these records (including @ID) to a flat file. (Don't forget about $NAU and $HIS files as well.) The complex thing comes when you try to analyse the contents. In T24 settings are stored the same way as data is so you need to know what's settings and what's data. Also you have to strip the audit trail (where it presents).Then you have some fields with frequency in it where only trailing 5 symbols matter. Some files you don't need at all (like temporary ones - F.ENQUIRY.SELECT etc). In some files (F.LOCKING) some records matter and some do not. In financial applications (like FUNDS.TRANSFER) part of an @ID is assigned on random basis so even if you have absolutely the same data from financial point of view - the record @IDs wouldn't match.
Last but not least - many tables in T24 don't have PGM.FILE entry. (Hint: take a look at: LIST VOC WITH *A1 LIKE F...) Try to narrow down the task. What you need - check setup, financial data, or see if environments are absolutely equal? VK On Sep 23, 7:54 am, Lalit Patil <[email protected]> wrote: > Thanks Ahmet & pat for the info, > > but actually thing is that, i would like to compare two T24 environments on > the basis of PGM.file, enquiries & versions only, from broader perspective. > & in our area, there are thousands of records in each application/table. > > Does anyone knw, how to extract it in excel form/.csv format in one shot by > any means/routine or something else *from classic mode*?? > (Not from browser mode, since browser mode already has option to save > records as CSV) > > > > > > > > On Fri, Sep 23, 2011 at 3:11 AM, pat <[email protected]> wrote: > > Assuming you wish to compare the environment variable settings in two > > 'environments' > > > Unix : > > > From the Unix command prompt in environment '1' : > > > env > /tmp/env1.out > > > From the Unix command prompt in environment '2' : > > > env > /tmp/env2.out > > > diff /tmp/env1.out /tmp/env2.out > > > Windows : > > > From the Windows DOS command prompt in environment '1' : > > > set > \tmp\env1.out > > > From the Windows DOS command prompt in environment '2' : > > > set > \tmp\env2.out > > > windiff \tmp\env1.out \tmp\env2.out > > > On Sep 21, 6:49 am, Lalit Patil <[email protected]> wrote: > > > Hi All, > > > > Is there any utility/tool for T24 wherein we can check the *differences > > between 2 different environments & compare them? > > > or Please suggest me any other alternative by which we can achieve this > > functionality/requierment > > > > Help would be greatly appreciated. > > > Thanks in advance. > > > > Regards, > > > Lalit Patil > > > -- > > Please read the posting guidelines at: > >http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > > IMPORTANT: Type T24: at the start of the subject line for questions > > specific to Globus/T24 > > > To post, send email to [email protected] > > To unsubscribe, send email to [email protected] > > For more options, visit this group at > >http://groups.google.com/group/jBASE?hl=en -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
