Skip to Content
author's profile photo Former Member
Former Member

Query wildcard LIKE ' * ' works in DEV box .same query not working in QA.

1 ) I have a Query SELECT * FROM TABLE X WHERE A LIKE 'S*' and B = itabvalue.

The same query works properly in CID but not working correctly in QA though there is required data in QA.

Any idea what is the problem,,,no error with the query.SY-SUBRC = 4

2 ) I tried other example with NOT LIKE 'K' it retrieves oppositly in QA ..i.e. retrieves records like ' K ' .so SY-SUBRC = 0

but that is not correct result.....

This also works correctly in DEV...

Any idea ?

I see a line in ABAP DOCU help which says wildcard maynot be succesful based on database system ....a sentence similar to this...

how to correct this.

Any suggestion from you all.Thanks.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 04:16 AM

    Hi Sona,

    Your query is fine. But one thing in second condition B = tabvalue. what is this tabvalue. Is this any internal table.

    please eloborate ur problem.

    Regards,

    AZAD.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      yes.that filed is from internal table from previous step..data is there in that field.

      just forget about it..

      More elaborate ?

      To be simple consider below query

      this query is not fetching records in CIQ system....the same query works fine for CID system(same table in FROM )

      CIQ also has data starting with S in that field.

      Query SELECT * FROM TABLE X WHERE A LIKE 'S*'

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 03:27 PM

    Why don't you try with Like "S%"?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 06:04 PM

    Could you post your exact code? What is Table X? (Transparent Table - Internal Table, etc ...).

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.