If you place curly braces ({}) around your SQL statement in a Tabular SQL object, that SQL statment will be sent directly to the database. Note that no validity checking is done on the SQL, so the report author is fully responsible for the correct operation of the SQL statement.
Steps:
Create a Tabular SQL object.
Write you SQL statement. Ensure that it is surround by curly braces. For example, if your SQL statement isSELECT * FROM ORDER_HEADERyou need to write it as:
{SELECT * FROM ORDER_HEADER}
Subscribe to:
Post Comments (Atom)
Working with Compression on HDFS
Copy and uncompress file to HDFS without unziping the file on local filesystem If your file is in GB's then this command would cer...
-
Web Portals The IBM Cognos 8 Web portal is IBM Cognos Connection. IBM Cognos Connection replaces Upfront and the PowerPlay Table of Contents...
-
As part of setting up trigger-based scheduling, you must schedule an entry based on an occurrence. Trigger-based schedule is activated if th...
-
Few days back, I got an opportunity to prepare features list for Mobile reporting solution tool. We all know that days are not too far when...
No comments:
Post a Comment