Invention Grant
- Patent Title: Table parameterized functions in database
-
Application No.: US13687157Application Date: 2012-11-28
-
Publication No.: US10007698B2Publication Date: 2018-06-26
- Inventor: Mark Delafranier , Jeffrey J. Plager , Muhammed Sharique , Vipul Sharma , Ivan T. Bowman , Anisoara Nica , Anil K. Goel , Steven A. Kirk
- Applicant: Mark Delafranier , Jeffrey J. Plager , Muhammed Sharique , Vipul Sharma , Ivan T. Bowman , Anisoara Nica , Anil K. Goel , Steven A. Kirk
- Applicant Address: US CA Dublin
- Assignee: SYBASE, INC.
- Current Assignee: SYBASE, INC.
- Current Assignee Address: US CA Dublin
- Agency: Sterne, Kessler, Goldstein & Fox P.L.L.C.
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F3/0484

Abstract:
Systems, methods and computer program product embodiments for providing table parameterized function (TPF) functionality in a database are disclosed herein. An embodiment includes defining a TPF in a database, wherein the definition of the TPF defines one or more parameters of the TPF, at least one of the parameters being a table parameter. A query is received that operates to call the TPF, wherein the query defines one or more input parameters, the input parameters comprising at least one table input parameter to be used as input for calling the TPF. The query is processed to produce a result, and the result of the query is returned.
Public/Granted literature
- US20130138626A1 Table Parameterized Functions in Database Public/Granted day:2013-05-30
Information query