As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.
New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.
What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.
During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.
Thanks but still the same issue. I tried a different stored proc. without any parameter and it gives me
(FOC1400) SQLCODE IS 229 (HEX: 000000E5) XOPEN: S0005 : (229) [S0005] The EXECUTE permission was denied on the object 'uspname' (FOC1405) SQL PREPARE ERROR.This message has been edited. Last edited by: BM,
Posts: 167 | Location: Montreal | Registered: September 23, 2014
Well, that is a different error which points to execution permissions on the database side.
Please make sure that whichever DB account you are using in your adapter connection from WebFOCUS can indeed EXECUTE the stored procedure.
It would also help if you posted actual code/error messages. I mean, your code seems to attempt execution of a stored procedure called "spname", yet the error message complains about permissions on "uspname". Which one is it? It is really not relevant to us but does cause confusion.
Check for proper DB permissions and you should be fine.
Hi, Thanks.. sorry for the confusion. I didn't want to put the real stored proc. name and that's when I mistyped. I was able to solve the security issue by granting access to stored proc. But now I am back to my original issue which is the poping up of File download window asking me to download WFSevlet.ibfs. It gives me 3 options. "Find", "Save", "Cancel". Whichever option I choose, it gives me a message "Waiting for Response".
WebFOCUS 8202M
Posts: 167 | Location: Montreal | Registered: September 23, 2014
Try something like this and let us know what you get:
ENGINE SQLMSS SET DEFAULT_CONNECTION &severname
SQL SQLMSS SET NOCOUNT ON
SQL SQLMSS SET ANSI_WARNINGS OFF
SQL SQLMSS
EX spname '&P1', '&P2', '&P3', '&P4', '&P5', '&P6'
;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS HREPORT
END
-RUN
TABLE FILE HREPORT
PRINT *
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT HTML
END
-RUN
I used global temporary table. Here the stored proc updates the GTT and which i use the GTT as normal database table. SQL SQLORA CALL stored_proc('&PARAM1.EVAL','&PARAM2.EVAL',&PARAM3.EVAL,'&FDT.EVAL','&PARAM4.EVAL', '&PARAM5', '&PARAM6') ; END -RUN -***The stored proc is called and updates at Global temp table(GLOBAL_TEMP_TABLE) which is further used as simple SQL passthrough SQL SQLORA PREPARE SQLOUT FOR SELECT * FROM GLOBAL_TEMP_TABLE END
Originally posted by njsden: Try something like this and let us know what you get:
ENGINE SQLMSS SET DEFAULT_CONNECTION &severname
SQL SQLMSS SET NOCOUNT ON
SQL SQLMSS SET ANSI_WARNINGS OFF
SQL SQLMSS
EX spname '&P1', '&P2', '&P3', '&P4', '&P5', '&P6'
;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS HREPORT
END
-RUN
TABLE FILE HREPORT
PRINT *
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT HTML
END
-RUN
WebFOCUS 8202M
Posts: 167 | Location: Montreal | Registered: September 23, 2014
Hi all, after a few tries I was able to resolve the issue.
Here is my code.
-***Code** ENGINE SQLMSS SET DEFAULT_CONNECTION &servername SQL SQLMSS PREPARE SQLOUT FOR EXEC [dbname].[dbo].[spname] &p1 END TABLE FILE SQLOUT PRINT * ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty, $ ENDSTYLE END
WebFOCUS 8202M
Posts: 167 | Location: Montreal | Registered: September 23, 2014