× Discuss on Insight, business intelligence and reporting, Regulatory, Risk, Financial & Performance, Monitoring with Systar, T-Risk, ALCO Reporting, etc…

DW.EXPORT - extract from $HIS tables

Start
Prev
1
Next
End

Thomas
Topic Author
Offline
New Member

8 years 10 months ago #18848 by Thomas

DW.EXPORT - extract from $HIS tables was created by Thomas

Hello,

Is there a standard procedure in DW.EXPORT for extracting all records from the history table of a T24 application ? Same question for $NAU ?
For example, FUNDS.TRANSFER$HIS, FUNDS.TRANSFER$NAU.

I already know the APIs DW.HIST.SELECT.API and DW.HIST.PROCESS.API, but they extract only the records from $HIS having @ID like ...;1

Thank you in advance.

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

jpb
Offline
Moderator
retired . . . ¯\_(ツ)_/¯

8 years 10 months ago #18854 by jpb

Replied by jpb on topic DW.EXPORT - extract from $HIS tables

DW.HIST.SELECTAPI is selecting only ...;1 but with DW.HIST.PROCESS.API it will return the latest history record (using EB.READ.HISTORY.REC) ??
There are also DW.NAU.SELECT.API and DW.NAU.PROCESS.API, no restriction on selection here.

The following user(s) said Thank You: Thomas

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

Thomas
Topic Author
Offline
New Member

8 years 10 months ago #18855 by Thomas

Replied by Thomas on topic DW.EXPORT - extract from $HIS tables

Thank you for the prompt and clear answer.

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

Start
Prev
1
Next
End

Time to create page: 0.080 seconds