Scripting with dme's - Server timeouts

 0 Replies
 0 Subscribed to this topic
 12 Subscribed to this forum
Sort:
Author
Messages
Lorenda
New Member
Posts: 1
New Member
    Hoping someone in this group can give me some pointers on how to adjust the below dme by adding indexes, etc to avoid the periodic server timeouts I'm experiencing. First of all, what I am trying to do is build a report to pull our budget data for our supplies accounts, and compare this to the actuals that are coming in on a daily basis. I've done this by pulling all the accounts with our supplies summary account ID. Since I want this to run unassisted, I've inserted variables to provide my fiscal year and current period. FY is my fiscal year variable, rptPER is my Period variable. I am coding in VSOT, Visual Basic.

    KEYUSAGE=PARAM&MAX=9999&NOHEADER=TRUE&OUT=CSV&DELIM=%2c&INDEX=FBDSET1&NEXT=TRUE&PROD=PRD&FIELD=COMPANY%3BFISCAL-YEAR%3BBUDGET-NBR%3BCHART-NAME%3BACCT-UNIT%3BACCOUNT%3BCR-AMOUNT-" & rptPER & "%3BDB-AMOUNT-" & rptPER & "%3BBLANK%3BUNTBUD" & rptPER & "%3BMAINT-DATE%3BCHART-DETAIL.SUMRY-ACCT-ID&FILE=FBDETAIL&SELECT=CHART-DETAIL.SUMRY-ACCT-ID%3D167&KEY=1000%3D" & FY & "%3D1&SK1=1000&SK2=" & FY & "&SK3=1&"