IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    Caster question ..how to extract the scheduleid from the running schedule
Go
New
Search
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Expert
Posted
anybody know how to extract the schedule id from the current running schedule?
the way &FOCFOCEXEC gives the name of current fex. I want to use Jodye Yates's cool method for postponing a caster sched, but i want to do it generically, grabbing the schedid from the caster job..('cause every wee change you make to a caster job changes the schedid)




DevStu 767; wintell 767; Unix 765,Oracle: /// iplanet; Dev 765 tomcat 6;///MRE/BID/PMF
 
Posts: 2627 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteEdit or Delete MessageReport This Post
Expert
Posted Hide Post
Susannah,

Just a quick throw away suggestion - but have you tried just having -? & in a castered fex to trap the variables?

T


Old FOCUS coders never die, they just become functionally stable. (Tony A Wink)

Current Client: WebFOCUS 7.6.2 Win XP SP2/IIS 6/Tomcat 5.5 - MRE / BID MS SQL / Oracle - DevStudio 7.6.6 7.1.6
Local: WebFOCUS 7.6.6 7.1.6 on Win XP SP2/Apache/Tomcat 5.5 - Self Service
 
Posts: 2860 | Location: England U.K. (Freelance) | Registered: April 08, 2004Reply With QuoteEdit or Delete MessageReport This Post
Expert
Posted Hide Post
i can't see anything in a caster log if the echo is on, it won't log the job at all.
i'm looking for maybe some secret && i can elevate to active, like &&IBI_IF_FLDS, or some extraction function. I've got Jodye's caster update method working, i just wanna bullet-proof it.
Live, i get this:
CURRENTLY DEFINED & VARIABLES:
&&IBI_IF_FLDS = d:\ibi\apps\excludef.fex
&ACCEPTS = 0
&APPROOT = D:\ibi\apps
&AUTOINDEX = NO
&BASEIO = 0
&CHNGD = 0
&DATE = 12/22/05
&DELTD = 0
&DMY = 221205
&DMYY = 22122005
&DUPLS = 0
&ECHO = OFF
&EXITRC = 0
&FOCEXURL = /ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERV
&FOCFOCEXEC = _ADHOCRQ
&FOCHTMLURL = /ibi_html
&FOCINCLUDE = ADHOCRQ
&FOCNEXTPAGE = 0
&FOCREL = R720527B
&FORMAT = 0
&IBIF_wfdescr>= OFF
&IBIMR_user = admin
&INDEXIO = 0
&INPUT = 0
&INVALID = 0
&LINES = 0
&MDY = 122205
&MDYY = 12222005
&NOMATCH = 0
&READS = 0
&RECORDS = 0
&REJECTS = 0
&RETCODE = 0
&SETFILE =
&SORTIO = 0
&TOD = 08.59.40
&TRANS = 0
&WFDESCRIBE = OFF
&YMD = 051222
&YYMD = 20051222




DevStu 767; wintell 767; Unix 765,Oracle: /// iplanet; Dev 765 tomcat 6;///MRE/BID/PMF
 
Posts: 2627 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteEdit or Delete MessageReport This Post
Expert
Posted Hide Post
I haven't been working with Caster for a while so I'm beginning to forget some stuff, but I think the only way you can determine the Sched ID is to read the appropriate Caster repository table...


Francis



Env 1: WebFOCUS 5.3.2 Servlet - MRE/BID/Self Service/ReportCaster - MS Windows Server 2003 - IIS/New Atlanta ServletExec - MS SQL Server 2000 - DataMigrator 5.3.4
Env 2: WebFOCUS 7.6.5 Servlet - MRE/BID/Self Service - MS Windows XP SP2 - Apache Tomcat/5.5.25 - MS SQL Server 2000
Env 3: WebFOCUS 5.3.3 CGI - Self Service - AIX 5.2 - IBM DB2
Output formats: HTML, Excel 2000 and PDF
 
Posts: 3379 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteEdit or Delete MessageReport This Post
Expert
Posted Hide Post
that's what i would be doing, within the fex, in order to update the nextruntime. But i'ld like to determine the schedid without having to hardcode it.
MODIFY FILE BOTSCHED
MATCH SCHEDULEID
ON MATCH UPDATE NEXTRUNTIME
otherwise go home.
Thing is, the schedid changes if you make some modifications to the job, so i don't want to have to remember to re-figure out the new id, and then edit the modify part of the job.
It all works ok now, hardcoded.
But i wanna bullet-proof it.
Moderators...can you get Vincent Lam to log in and tell us how to do this? gracias.




DevStu 767; wintell 767; Unix 765,Oracle: /// iplanet; Dev 765 tomcat 6;///MRE/BID/PMF
 
Posts: 2627 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteEdit or Delete MessageReport This Post
Platinum Member
Posted Hide Post
Hi Susannah

Did you ever get this to work? I posted the exact same question a while ago... and never got an answer. Then I realized that I could simply lookup the scheduleid based on the jobdesc. So if you have access to the jobdesc as a parameter then you are all set.


WebFOCUS 716 Server on Linux
Dev Studio 717
RCaster 71
 
Posts: 163 | Registered: October 01, 2003Reply With QuoteEdit or Delete MessageReport This Post
Expert
Posted Hide Post
hmm. what i think i meant was...the way you can extract the userid from a fex-in-action, i wanted to extract the schedule id from a caster-job-in-action. caster changes the schedule id wheneve ryou make changes to the job in some way..and i didn't want to have to keep track manually. i don't want to have to look up by job name...because i don't have the job name either when i'm running...and its a character string, which i'm not fond of using as a lookup..whereas skedid is a nice contiguous fixed-size thingy.




DevStu 767; wintell 767; Unix 765,Oracle: /// iplanet; Dev 765 tomcat 6;///MRE/BID/PMF
 
Posts: 2627 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteEdit or Delete MessageReport This Post
Member
Posted Hide Post
Try &DSTSCHEDID in the focus procedure.
 
Posts: 15 | Location: Jersey City, NJ | Registered: August 04, 2005Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    Caster question ..how to extract the scheduleid from the running schedule

Copyright © 1996-2008 Information Builders, leaders in enterprise business intelligence.