DBISQLC.EXE is the utility used to connect to sample/local database for DML, DDL operations. But how do we export the results of a query to a file. Use “OUTPUT” command to export the queried results in dbisqlc.exe. Here is the syntax.Syntax:OUTPUT TO file-name[ APPEND ][ VERBOSE ][ FORMAT output-format ][ ESCAPE CHARACTER character ][ ESCAPES { ON | OFF }[ DELIMITED BY string ][ QUOTE string [ ALL ] ][ COLUMN WIDTHS (integer, ...) ][ HEXADECIMAL...
Read More...
We have the "Add & Go" and "Search & Go" functionality in Siebel 8. At times, there may arise situations where you need to manipulate the search expression for "Search & Go" applet. Let's consider the following scenario.We have a "Search & Go" functionality for FAQs on homepage of eService application. This applet has 2 fields - FAQ and Answer. The out of box functionality suffixes the search string of each field with wildcard "*"...