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

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.
Checked for Relevance on 01-26-2012
Checked for Relevance on 07-01-2013


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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms