Browse Prior Art Database

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

IP.com 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

IBM

Abstract

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.

DO NOT OMIT ANY OF THESE LABELS, OR A...