Several macros are added in TMPL files.
UTML files also have several tags which refer to macros (in the comment part of utml
Example a macro ERROR_MESSAGE
=============================
<td valign="top" align="left" width="100%">
<font face="arial...
Vivek,
able to get the function in Expression Editor,
I changed the following section in impfunct.ini & orfunct.ini,
[check_numeric]
label=check_numeric
param=1
return=CH
1=CH;String_exp
exp=check_numeric(^1)
tip=Syntax:check_numeric(String_exp)
tip1=String expression
so there is no...
Hi all,
Pls help me in UDF,DB is Oracle.
I did the following steps but not able to get in Impromtu.
1)Created this function in DB.
CREATE OR REPLACE function check_numeric(xvar varchar2) return varchar2 as
yn varchar2(1) := 'Y';
nvar number := 0;
begin
select xvar/100 into nvar from dual...
Hi all,
I saw many threads related to this issue. still I'm not able to find solution. hope somebody will help me.
There are 5 columns in my list report,of those 2 are non-numeric Column and rest are numeric column. In those 2 non-numeric Columns, in some cases there will be Numeric data...
Thanx again Lex,
I've 5 Columns for a report.Those five columns in the database is VARCHAR2.Those Columns can have Numeric as well as Non-Numeric data.here I've to do few calculations if those Columns have Numeric data(still VARCHAR2 in DB) by converting the data using the function...
How to find a column in Impromptu reports whether that column is numeric or non-numeric, depending on the datatype some calculations has to be carried out(if numeric).
Can anyone pls tell me how to find the datatype?
Thanx
Prapagar
Native drivers provided by Cognos not Oracle, anyway we will check with Cognos Support Team. Thanx for ur response, if at all u can get a solution pls mail me at prapagar@yahoo.com.
also we'll convey u once we find solution for this issue.
Thanx
Prapagar
We don't have any seperate driver to connect with the DB, it's native driver which is used. Is there any other way to avoid this timeout by setting it in some properties file.
Powerprompt Script has to wait until it gets response from the DB, whatever time it may be.
Appreciate ur Help...
Hi lex,
Thanks for ur response.
Yes, we are thinking same ,in that two scenarios only we are getting that error.
U said some thing about the Agent Settings, Plz help me where exactly i have to set the Values to avoid such problems.
I am using Cognos Version 7.2 .
Appreciate ur help.
Prapagar
In my application I'm calling a stored procedure report in the PowerPrompt Script code. some times it gives error like 'Timeout to Receive Data'. Is this problem in Oracle Stored Procedure which is called or it's error given by Cognos.
Please help me in this
Thanks
Prapagar
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.