Computing

Error Message:

Job execution failed.
Dispatched job to resource group : Default Async...
Starting...

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?

 Solution:

 By using ‘OUTPUT’ command.

Throwing An Exception

You can throw an exception explicitly using the throw statement.

For e.g.

You need to throw an exception when a user enters a wrong login ID or password.

To use the DELETE EXACT parameter to delete data from base tables other than the target base table, specify the user key columns only for a single base table for each row in the interface table.

A lot has been said and written about removing null tags in xml messages.

1. Create a new Database view e.g. ‘CX_V_CMP_CN_SUM’. The process of creating a new Database view is following: 

Through EIM process we load bulk amount of data from an external system to Siebel base tables. The performance of these EIM jobs has to be maintained at optimum levels in order to reduce the load on the Siebel application and database servers.

Use DB2 load replace option when loading EIM tables and turn off table logging if possible.Use separate

Oracle Siebel introduced Gateway authentication in Siebel 8 onwards, which mandates the database login authentication for accessing the Siebel Administration – Server Management view.

Pages

Subscribe to Computing