Partial search on an ADABAS file

kanisha_prabha · New User Joined: 10 Mar 2006 Posts: 10

I need to do a partial search on a particular descriptor field in ADABAS. In DB2 I could use something like hte following -
SELECT ...
FROM ...
WHERE EMP_NAME LIKE 'KANISHA%'
...

Is there any way I can represent the LIKE parameter in ADABAS?

Gnanas SNG · Posted: Mon Apr 28, 2008 5:38 pm Post subject:

Same query will work in ADABAS also if it's in ANSI SQL standard...

ofer71 · Posted: Mon Apr 28, 2008 5:56 pm Post subject:

You can use the STARTING FROM operand of the READ statement.

O.