Browse Prior Art Database

Automated population of Siebel Interface tables using a 'c' program and externalised criteria Disclosure Number: IPCOM000125596D
Original Publication Date: 2005-Jun-09
Included in the Prior Art Database: 2005-Jun-09
Document File: 2 page(s) / 53K

Publishing Venue



The present publication discloses a programme designed to populate Siebel* interface tables with data retrieved via externalised select & insert statements. It manages elements such as the number of rows written for a batch, the number of batches contained within a range and the frequency with which changes are committed to the database. * Siebel is a registered trademark of Siebel Systems Inc.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 53% of the total text.

Page 1 of 2

Automated population of Siebel Interface tables using a 'c' program and externalised criteria

The programme is written in C for DB2 and requires the following parameters:

/c the commit frequency, number of records procesed before a commit statement is issued. /o the optimization class for DB2 /r the number of batches in a range of batches /b the number of records within a batch /s the starting point for batch numbering /f the input file containing the select & insert statements

     This optional parameter allows echo of the sql statements built by the process.

/v position to Y for feedback.

     In addition to these elements connection details to the database are retrieved as environment variables:

siebeldbname siebeluserid siebelpassword

The C programme contains 3 parts.

The first actions are to control the presence of mandatory arguments, and the structure of the query file. In case of absence of any of the mandatory arguments, or of a badly constructed query file the program exits.

The second process reads the contents of the query file, concatenating the lines read to build two dynamic cursors, one for select & one for update. Each line is stripped of the last character which represents a carriage return. The total number of characters for each cursor is currently set to 1000.

The third process is a loop to perform the update statements on records retrieved by the select statement.

Notes concerning the input file:

This is the most important element in the process. The file is split into 2 parts; a select statement signalled by the SELECT label and the update statement signalled by the UPDATE label.

The end of the file is signalled by the FINISH label.