× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

Selection of RE.CONSOL.SPEC.ENTRY

Start
Prev
1
Next
End

kartsnek
Topic Author
Visitor

5 years 7 months ago #22445 by kartsnek

Selection of RE.CONSOL.SPEC.ENTRY was created by kartsnek

Hi,

We are migrating T24 data to external system so that we have to extract whole data in text format per table wise.

Could you please let me know on how to select RE.CONSOL.SPEC.ENTRY as it's a huge file?

How to select SPEC entry by year wise?.

Applied direct select which cause timeout error.

Regards,
Karthik

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

VK
Offline
Platinum Member
Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test

5 years 7 months ago #22446 by VK

Replied by VK on topic Selection of RE.CONSOL.SPEC.ENTRY

Hi
the first 5 digits in @ID represent the system date of record creation in internal jBASE format.

You can check this typing in jsh:

LIST FBNK.RE.CONSOL.SPEC.ENTRY DATE.TIME EVAL "OCONV(@ID[1,5],'DG')" ID.SUPP

Of course you can use DATE.TIME but using only @ID will be much faster.

Cheers
VK

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

Start
Prev
1
Next
End

Time to create page: 0.041 seconds