Browse Prior Art Database

Method of Processing Procedural Code within SQL

IP.com Disclosure Number: IPCOM000099034D
Original Publication Date: 2005-Mar-09
Included in the Prior Art Database: 2005-Mar-09
Document File: 1 page(s) / 21K

Publishing Venue

IBM

Abstract

A procedural component within SQL allows Java code to be applied to table data rows. This will provide extensive data manipulation, data validation, and additional complex function not currently available in SQL. It provides the richness of procedural coding inside the declarative SQL programming.

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

Page 1 of 1

Method of Processing Procedural Code within SQL

     SQL is a widely used declaration language used within most DBMS systems to query data tables. As it is widely popular, many programming languages have access to a SQL API. This allows procedural language coders access to the capabilities of SQL. Unfortunately, many SQL users are data analysts and not programmers. Learning "full blown" procedural language like C, C++, or Java is not a viable option for them. The benefits of procedural processing are typically unavailable to them.

     Listed below are two examples. The first is a standard SQL select statement. The second is a "code statement" statement that would provide a suitable syntax for adding in Java programming code.

     /* Example 1 of a simple listing (in standard SQL) */ select x, y

from proj1.myData ;

/* Example 2 of processing through the same data with Java

statements to manipulate the data - within SQL */ code

on proj1.myData

[ x = x + 2 ;

y = y * Math.random() ;

if (x < y) x = 27.9 ; ] ;

     The implication would be that the "code statement" would provide a process looping through each row of the table. Then an SQL user would be able to write Java to effect the underlying data within the table - without having to completely learn Java. This is similar to having HTML coders use Java within JSPs - without having to write complete Java applications, Java applets, or Java servlets.

1