Author Topic: how to concatenate % or $ with Procedure column  (Read 2307 times)

Offline aamuktha

  • Full Member
  • ***
  • Posts: 34
  • Forum Citizenship: +1/-0
how to concatenate % or $ with Procedure column
« on: 12 Jan 2006 12:25:24 am »
hi

 here is the issue....
 
             i need to concat % to a procedure column..

i have used concat function on table column it is working fine.But the same function is not working with Procedure column.

is it bug in cognos??


for example 

                     EMP is a table

                         CONCAT(EMP.SAL,%)    IT IS WORKING FINE.
                   
                   PKG_EMP IS A PROCEDURE

                        CONCAT(PKG_EMP.SAL,%)  IS N0T VALIDATING . IT IS GIVING ERROR.


PLEASE SUGGEST ME .


THANKS
aamuktha








Offline JoeBass

  • Global Moderator
  • Community Leader
  • *****
  • Posts: 143
  • Forum Citizenship: +8/-0
Re: how to concatenate % or $ with Procedure column
« Reply #1 on: 12 Jan 2006 07:38:55 am »
I tried this (with SQL Server) and also got a strange problem.  The calculation validates fine (Using reportnet function to cast) Cast([Datasource].[QuerySubject].[Field], char) + '%',  but, when I run the report, I get an error that complains the string has been right-truncated. 

What is the error you are getting?

Offline mrcool

  • Statesman
  • ******
  • Posts: 265
  • Forum Citizenship: +27/-28
Re: how to concatenate % or $ with Procedure column
« Reply #2 on: 23 Jan 2006 05:01:21 am »
hi

this is the error getting

QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-239'.
UDA-EE-0094 The operation "add" is invalid for the following combination of data types: "double" and "character" UDA-EE-0094 The operation "add" is invalid for the following combination of data types: "double" and "character" UDA-SQL-0460 A general exception has occurred during local processing.
 Is it a bug in Report net

it is coming only for procedure column.


thanks
s

Offline JoeBass

  • Global Moderator
  • Community Leader
  • *****
  • Posts: 143
  • Forum Citizenship: +8/-0
Re: how to concatenate % or $ with Procedure column
« Reply #3 on: 23 Jan 2006 05:51:15 am »
It is complaining about the difference in data types.  Have you tried casting the number as a string? 
« Last Edit: 23 Jan 2006 07:02:53 am by JoeBass »

Offline mrcool

  • Statesman
  • ******
  • Posts: 265
  • Forum Citizenship: +27/-28
Re: how to concatenate % or $ with Procedure column
« Reply #4 on: 23 Jan 2006 06:05:48 am »
hi


this is the error when Iam using cast function...Iam getting this error only while running the report,not when validating...Report is getting validated without errors...

UDA-EE-0092 Data exception occurred. String data has been right truncated.

UDA-SQL-0460 A general exception has occurred during local processing.

UDA-CUR-0000 Unable to fetch the row.

RSV-SRV-0025 Unable to execute this request.

Trace back:

WPBIBusMethod.cpp(190): QSException: CCL_CAUGHT: WPBIBusMethod::run

WPReportExecutionMethod.cpp(180): QSException: CCL_RETHROW: WPReportExecutionMethod::checkRequestForExceptions

WPExecuteRequestThread.cpp(169): QSException: WPExecuteRequestThread::checkException

WPEngine.cpp(946): QSException:

WPController.cpp(263): QSException: CCL_RETHROW: WPController::executeRendering()

LWDataRetrievalEngine.cpp(785): QSException: CCL_RETHROW: LWDataRetrievalEngine::iterateResultSets

Source/QEDmResultSet.cpp(76): QSException: CCL_THROW: QE


Offline JoeBass

  • Global Moderator
  • Community Leader
  • *****
  • Posts: 143
  • Forum Citizenship: +8/-0
Re: how to concatenate % or $ with Procedure column
« Reply #5 on: 23 Jan 2006 06:25:39 am »
Thats the same scenario I mentioned above.  Sounds buggy.

Offline BIsrik

  • Statesman
  • ******
  • Posts: 473
  • Forum Citizenship: +12/-3
Re: how to concatenate % or $ with Procedure column
« Reply #6 on: 23 Jan 2006 07:18:14 am »
u can't create calculation on the procedure query subject..

Srik

Offline BIsrik

  • Statesman
  • ******
  • Posts: 473
  • Forum Citizenship: +12/-3
Re: how to concatenate % or $ with Procedure column
« Reply #7 on: 23 Jan 2006 07:19:53 am »
Refer page 15 of Frame work manager user guide...

Srik

Offline aamuktha

  • Full Member
  • ***
  • Posts: 34
  • Forum Citizenship: +1/-0
Re: how to concatenate % or $ with Procedure column
« Reply #8 on: 23 Jan 2006 08:57:16 pm »
hi

Thanks for your reply


aamuktha

Offline BIsrik

  • Statesman
  • ******
  • Posts: 473
  • Forum Citizenship: +12/-3
Re: how to concatenate % or $ with Procedure column
« Reply #9 on: 23 Jan 2006 10:28:12 pm »
can u plz update the status of the topic..

Srik

Offline aamuktha

  • Full Member
  • ***
  • Posts: 34
  • Forum Citizenship: +1/-0
Re: how to concatenate % or $ with Procedure column
« Reply #10 on: 24 Jan 2006 10:02:20 pm »
hi

came to know that it is not possible with procedure column.May be it is bug with cognos.But not sure...........


aamuktha