Results 1 to 15 of 15

Thread: Sql0130

  1. #1
    Join Date
    Sep 2011
    Posts
    6

    Unanswered: Sql0130

    Hi Team,

    Can you please help me in this issue?

    <eb1>SQL0130 - ESCAPE character *N or LIKE pattern is not valid.
    State1000,Native:-130,Origin:[IBM][iSeries Access ODBC Driver][DB2 UDB
    Regards,
    Princy

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    What DB2 version/release and platform OS are you using?

    There are some restrictions for parameters of LIKE predicate depending on DB2 version/release.

  3. #3
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    It will be better to check "Disable smilies in text" checkbox.

  4. #4
    Join Date
    Sep 2011
    Posts
    6

    Sql0130

    We are using DB2/400 .

  5. #5
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    Quote Originally Posted by tonkuma View Post
    What DB2 version/release and platform OS are you using?

    There are some restrictions for parameters of LIKE predicate depending on DB2 version/release.
    Why do you save so much your work/effort?

  6. #6
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    Extracted from "System i Database SQL messages and codes Version 6 Release 1"
    Code:
    SQL0130
    
    Message Text:
    ESCAPE character &1 or LIKE pattern is not valid.
    
    Cause Text:
    Either ESCAPE character &1 is not valid or the use of the ESCAPE character in the LIKE
     pattern is not valid.
    The ESCAPE character is not valid if:
     v The length is not 1 SBCS character or 1 graphic character.
     v The shift-in (X0E) and the shift-out (X0F) characters are specified.
    
    The LIKE pattern is not valid if:
     v The character string expression forming the pattern contains an ESCAPE character that is
       not followed by a percent sign, an underscore, or another ESCAPE character.
     v The graphic string expression forming the pattern contains an ESCAPE character that is
       not followed by a DBCS percent sign, a DBCS underscore, or another ESCAPE character.
    
    Recovery Text:
    Specify a valid LIKE pattern and ESCAPE character. Try the request again.
    
    SQLCODE or SQLCODEs:
    -130
    
    SQLSTATE or SQLSTATEs:
    22019, 22025

  7. #7
    Join Date
    Sep 2011
    Posts
    6

    re

    I am not using Like in my query.

  8. #8
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    What is your whole/exact query?

    <eb1>SQL0130 - ESCAPE character *N or LIKE pattern is not valid.
    State1000,Native:-130,Origin:[IBM][iSeries Access ODBC Driver][DB2 UDB
    Is this all/exact error message which you got?
    Nothing after "...[iSeries Access ODBC Driver][DB2 UDB"?

  9. #9
    Join Date
    Jul 2009
    Location
    NY
    Posts
    963

    Question

    Quote Originally Posted by princyinit View Post
    I am not using Like in my query.
    Show to us your query, please.

  10. #10
    Join Date
    Sep 2011
    Posts
    6

    re

    Quote Originally Posted by tonkuma View Post
    What DB2 version/release and platform OS are you using?

    There are some restrictions for parameters of LIKE predicate depending on DB2 version/release.

    We are using query tool "qtodbc 5.0".

    Fyi.. We are not using "LIKE" in our query.

  11. #11
    Join Date
    Sep 2011
    Posts
    6

    re

    Please see the attachment,

    Even though if we remove the line which is using the "LIKE" it is throwing the same error "SQL0130"

    The below is the error

    "<eb1>SQL0130 - ESCAPE character *N or LIKE pattern is not valid.
    State1000,Native:-130,Origin:[IBM][iSeries Access ODBC Driver][DB2 UDB]</eb1>
    Attached Files Attached Files
    Last edited by princyinit; 02-22-12 at 10:03. Reason: neet to give details

  12. #12
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    Would you try this?

    Code:
    SELECT COUNT(*)
     FROM  (
           /* put your query here, like ... */
           SELECT 'New Business' AS RptCode,
           ...
           ...
           ...
           END = INT(LNRDUEX.LNRDUDTE/100)
    
           )
           /* end of your query */
           ) t
    ;

  13. #13
    Join Date
    Sep 2011
    Posts
    6

    re

    Actually if we remove Pcompny file then this query works fine and more over if you give fetch first 1200 records it is working fine.

    Can you please look into this ?

  14. #14
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    I thought that you were not well at conversation.

    Please answer my question, before asking new question or moving to another issue.

    Quote Originally Posted by tonkuma View Post
    Would you try this?

    Code:
    SELECT COUNT(*)
     FROM  (
           /* put your query here, like ... */
           SELECT 'New Business' AS RptCode,
           ...
           ...
           ...
           END = INT(LNRDUEX.LNRDUDTE/100)
    
           )
           /* end of your query */
           ) t
    ;

  15. #15
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    And, you didn't answer my basic question yet
    DB2 version/release

    I asked twice ...
    Quote Originally Posted by tonkuma View Post
    What DB2 version/release and platform OS are you using?

    There are some restrictions for parameters of LIKE predicate depending on DB2 version/release.
    Quote Originally Posted by tonkuma View Post
    Why do you save so much your work/effort?
    and it is one of basic requirements in this forum, see...
    http://www.dbforums.com/db2/854783-m...e-posting.html
    1) Every question posted must include your DB2 Version, fixpack and Edition + your Operating System(including version info) + ...
    Last edited by tonkuma; 02-22-12 at 12:49. Reason: Add QUOTE to "1) Every question posted must include ..." in "Must Read before posting".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •