In
general cast function defines as who transforms one data type of a column to
other one as defined in the function.
Syntax :
cast (Column name ,desired_datatype(needs to define))
In
report studio cast function is used to make two query item with different
data type compatible with each other.
There are different scenarios when cast function is used like to convert date column or to create dummy column in UNION.
While using cast report author needs to keep in mind about the performance of report.
As any casting of query item is part of Cognos SQL rather than Native SQL,which processed at cognos server end not at database.
In case you have any question please comment ,i will respond to your query.
0 comments:
Post a Comment