Search results for query: *

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=&quot;top&quot; align=&quot;left&quot; width=&quot;100%&quot;> <font face=&quot;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...

Thanx alot for ur help Vivek, I'll let u know, after trying ur ideas. Prapagar

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