My Oracle Support Banner

E1: BSFN: How to Write LIKE Key Word SQL through a Business Function (Doc ID 1092305.1)

Last updated on MARCH 16, 2020

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.

Goal

To optimize system resource across EnterpriseOne, the query below is required,

SQL> SELECT return columns FROM Schema.Table WHERE Column LIKE 'ABC%' ORDER BY Column;

Using the EnterpriseOne APIs (Application Programming Interface), JDEBASE APIs will be used to access the database which are made up of:

Desired Result:
SQL> SELECT KGITEM, KGCO, KGMCU, KGOBJ, KGSUB FROM PRODDTA.F0012 WHERE KGITEM LIKE 'SP%' AND KGCO = '00000';

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.