Tech Doc Search Tech Support User Forums WebFOCUS Newsletter Summit Education

Go
New
Search
Notify
Tools
Reply
  
[SOLVED] FOC260 Error
 Login/Join
 
Member
posted
I get this error on my define and Im not really sure why, Im pretty sure this worked before.

0 ERROR AT OR NEAR LINE 28 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC260) AN OPERATION IS MISSING AN ARGUMENT
0 ERROR AT OR NEAR LINE 31 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC260) AN OPERATION IS MISSING AN ARGUMENT
0 ERROR AT OR NEAR LINE 34 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC260) AN OPERATION IS MISSING AN ARGUMENT
0 ERROR AT OR NEAR LINE 37 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC260) AN OPERATION IS MISSING AN ARGUMENT
0 ERROR AT OR NEAR LINE 40 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: Ben64
0 ERROR AT OR NEAR LINE 77 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC003) THE FIELDNAME IS NOT RECOGNIZED: NHRDIST.NHRDIST.Deduction
BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT

here is the code.

DEFINE FILE NHRDIST
run_by_fund /A13='&fund_option.(,).Run with funds?.';
payroll_type /A15='&payroll_option.(,,).Select type of payroll.';
BDCA_Group /A2=EDIT(NHRDIST_BDCA_CODE,'99$');
name/A25=SPRIDEN_LAST_NAME||', '||SPRIDEN_FIRST_NAME;
Deduction/D12.2=IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'D' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HEEL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%1' THEN NHRDIST.NHRDIST.NHRDIST_AMT * -1
ELSE IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'C' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HEEL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%1' THEN NHRDIST.NHRDIST.NHRDIST_AMT
ELSE 0;
Ben64/D12.2=IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'D' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%1' THEN NHRDIST.NHRDIST.NHRDIST_AMT * -1
ELSE IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'C' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%1' THEN NHRDIST.NHRDIST.NHRDIST_AMT
ELSE 0;
Ben79/D12.2=IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'D' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%2' THEN NHRDIST.NHRDIST.NHRDIST_AMT * -1
ELSE IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'C' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%2' THEN NHRDIST.NHRDIST.NHRDIST_AMT
ELSE 0;
Ben131/D12.2=IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'D' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%3' THEN NHRDIST.NHRDIST.NHRDIST_AMT * -1
ELSE IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'C' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%3' THEN NHRDIST.NHRDIST.NHRDIST_AMT
ELSE 0;
ben_total/D12.2=Ben64 + Ben79 + Ben131;
....


Again, not really sure why this errors...nothing has changed as far as I know, but I dont manage the server

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6
Windows, All Outputs

 
Posts: 15 | Location: Houston , TX | Registered: May 08, 2012Reply With QuoteReport This Post
Virtuoso
posted Hide Post
 run_by_fund /A13='&fund_option.(,).Run with funds?.';
payroll_type /A15='&payroll_option.(,,).Select type of payroll.' 


This really worked in the DEFINE? Do you get prompted for it?

This message has been edited. Last edited by: Prarie,
 
Posts: 1857 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Member
posted Hide Post
let me try this again.....html putting in some weird characters....

DEFINE FILE NHRDIST
run_by_fund /A13='&fund_option.(<With Funds,With Funds>,<Without Funds,Without Funds>Wink.Run with funds?.';
payroll_type /A15='&payroll_option.(<Adjustment,Adjustment>,<Original Event,Original Event>,<Both,Both>Wink.Select type of payroll.';
BDCA_Group /A2=EDIT(NHRDIST_BDCA_CODE,'99$');
name/A25=SPRIDEN_LAST_NAME||', '||SPRIDEN_FIRST_NAME;
Deduction/D12.2=IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'D' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HEEL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%1' THEN NHRDIST.NHRDIST.NHRDIST_AMT * -1
ELSE IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'C' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HEEL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%1' THEN NHRDIST.NHRDIST.NHRDIST_AMT
ELSE 0;
Ben64/D12.2=IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'D' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%1' THEN NHRDIST.NHRDIST.NHRDIST_AMT * -1
ELSE IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'C' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%1' THEN NHRDIST.NHRDIST.NHRDIST_AMT
ELSE 0;
Ben79/D12.2=IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'D' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%2' THEN NHRDIST.NHRDIST.NHRDIST_AMT * -1
ELSE IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'C' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%2' THEN NHRDIST.NHRDIST.NHRDIST_AMT
ELSE 0;
Ben131/D12.2=IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'D' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%3' THEN NHRDIST.NHRDIST.NHRDIST_AMT * -1
ELSE IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'C' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%3' THEN NHRDIST.NHRDIST.NHRDIST_AMT
ELSE 0;
ben_total/D12.2=Ben64 + Ben79 + Ben131;


WebFOCUS 7.6
Windows, All Outputs

 
Posts: 15 | Location: Houston , TX | Registered: May 08, 2012Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Please surround your code with CODE tags.

And can you run just the DEFINE setion, with &ECHO=ON, and post the output?
 
Posts: 1582 | Location: NYC & Richmond | In FOCUS since 1983 | Registered: January 11, 2005Reply With QuoteReport This Post
Guru
posted Hide Post
You need to wrap things around in parenthesis so you don't get that error. Like this:

Ben64/D12.2=IF (NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'D' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%1') THEN (NHRDIST.NHRDIST.NHRDIST_AMT * -1)
ELSE IF (NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'C' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%1') THEN NHRDIST.NHRDIST.NHRDIST_AMT
ELSE 0;


WF 7.7.03 Win7 IE8
 
Posts: 294 | Location: Orlando, FL | Registered: October 17, 2006Reply With QuoteReport This Post
Member
posted Hide Post
it has to do with the

* -1

took this out and it doesnt error....the DEFINE editor doesnt even let me do it....

really weird, because I know ive done this before.


WebFOCUS 7.6
Windows, All Outputs

 
Posts: 15 | Location: Houston , TX | Registered: May 08, 2012Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Do this all the time, BUT, you need to do it this way:

* (-1)


Tom Flynn
WebFOCUS 8.0.07
Windows, UNIX, MVS
 
Posts: 1543 | Location: Richmond, VA | Registered: January 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
this was it! Thanks Tom!

I swear Ive done it without the (), owell it works now!


WebFOCUS 7.6
Windows, All Outputs

 
Posts: 15 | Location: Houston , TX | Registered: May 08, 2012Reply With QuoteReport This Post
  Powered by Social Strata  
 


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