1. Forum
  3. T24 Technical Discussions
  5. T24 Development & Customization
  7. STMT.ENTRY table
× 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...

STMT.ENTRY table

  • MIKALE
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
13 years 8 months ago #9289 by MIKALE
STMT.ENTRY table was created by MIKALE
Hi,
i am having an issue with the local programs that i have developed to extract statement entries from the STMT.ENTRY and STMT.ENTRY.DETAIL files.
The issue is that our server is slow and it becomes a challenge to extract the statements, is there anything that i can do to the programs to make them more efficient

regards

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

  • isaac_adebayo2003@yahoo.com
  • Offline
  • New Member
  • New Member
More
13 years 8 months ago #9299 by isaac_adebayo2003@yahoo.com
Replied by isaac_adebayo2003@yahoo.com on topic Re: STMT.ENTRY table
hi
You can use STMT.VAL.ENTRY table this is a concate table . The id of this table is the account number

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

  • madhump
  • Visitor
  • Visitor
13 years 8 months ago #9300 by madhump
Replied by madhump on topic Re: STMT.ENTRY table
Hi,

Distribute the STMT.ENTRY and STMT.ENTRY.DETAIL tables. it will solve your problem


Regards
Madhu

Hi,
i am having an issue with the local programs that i have developed to extract statement entries from the STMT.ENTRY and STMT.ENTRY.DETAIL files.
The issue is that our server is slow and it becomes a challenge to extract the statements, is there anything that i can do to the programs to make them more efficient

regards

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

  • VigneshGautam
  • Visitor
  • Visitor
13 years 8 months ago #9310 by VigneshGautam
Replied by VigneshGautam on topic Re: STMT.ENTRY table
When was the last time an archival was performed on STMT.ENTRY and other related files? Try to purge some unwanted data from the LIVE file and try to run your extraction program. Also filter as many records as possible by providing more conditions to your SELECT statements.

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

  • MIKALE
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
13 years 8 months ago #9334 by MIKALE
Replied by MIKALE on topic Re: STMT.ENTRY table
Thanks Madhu.
could you kindly explain to me how i can distribute the tables

Regards

Mike

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

  • madhump
  • Visitor
  • Visitor
13 years 8 months ago #9335 by madhump
Replied by madhump on topic Re: STMT.ENTRY table
Hi Mikale,

You can contact Temenos Help Desk. they will recommend distribution of STMT.ENTRY by analyzing table growth .

Regards
Madhu

Thanks Madhu.
could you kindly explain to me how i can distribute the tables

Regards

Mike

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

More
13 years 8 months ago #9347 by aryarr_nayak
Replied by aryarr_nayak on topic Re: STMT.ENTRY table
Hi,
Can you expalin how to distribute that tables?

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

More
13 years 8 months ago #9350 by DUBLIN
Replied by DUBLIN on topic Re: STMT.ENTRY table
tcsp.temenos.com/r10/T24_Application_Fra...ibuted_Files_Example

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

  1. Forum
  3. T24 Technical Discussions
  5. T24 Development & Customization
  7. STMT.ENTRY table
Time to create page: 0.041 seconds