Method for editing the contents of a DB.sub.2 table using an edi

Details Method for editing the contents of a DB.sub.2 table using an edi Method for editing the contents of a DB.sub.2 table using an edi

1992-10-30

1995-03-07

Kulik, Paul V.

Boots, shoes, and leggings

364DIG1, 36422281, 3642229, 3642258, G06F 708, G06F 710

Patent

active

053966236

ABSTRACT:
A computer-executed method permits one or more of the following three functions to be performed on a DB2 data table: (1) dynamically altering (replacing) the EDITPROC parameter in the DB2 catalog definition of the DB2 data table, without the necessity of unloading the data from the table; (2) dynamically adding an EDITPROC to an existing DB2 data table whose DB2 catalog definitional information does not include an EDITPROC parameter; and (3) dynamically adding a column (field) to an existing DB2 data table that already includes an EDITPROC. The method does not make the assumption, made by IBM's DSNUTILB utility program, that the DBD records for a given database are untrustworthy and that all definitional information therefore must be verified. The method makes use of code to trick DB2 into bringing certain definitional information for the data table in question, including the DBD and OBD records, into memory from DASD (disk) storage. The method also makes use of a swapping routine which provides a dynamic procedure for exchanging DBD and OBD information between the DB2 table to be modified and a shadow DB2 table which already contains the modified DBD and OBD information.

REFERENCES:
patent: 5159180 (1992-10-01), Feiler
patent: 5222235 (1993-06-01), Hintz et al.
"Writing Exit Routines" Administration Guide, vol. III; p. X-75; IBM Database 2 Version 2, No. Date.

Affiliated with

Also associated with

Rating

Method for editing the contents of a DB.sub.2 table using an edi does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method for editing the contents of a DB.sub.2 table using an edi, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for editing the contents of a DB.sub.2 table using an edi will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1413726