Professional Web Applications Themes

Question about LIKE - IBM DB2

"dfdfd" <dfdfaol.com> wrote in message news:o0qSa.13409$N%3.10974lakeread01... > I have a Java application and I am using JDBC with a DB2 v8 database. The > database has a number of tables with keys > specified as CHARACTER 24. They keys are generally less then 24 characters, > and when I read them in the > resulting java Strings have the blanks on the end. I am removing the blanks > because I need to display the keys and > also allow the user to enter new keys and also to enter the old keys. So in > other words I am ...

  1. #1

    Default Re: Question about LIKE

    "dfdfd" <dfdfaol.com> wrote in message
    news:o0qSa.13409$N%3.10974lakeread01...
    > I have a Java application and I am using JDBC with a DB2 v8 database. The
    > database has a number of tables with keys
    > specified as CHARACTER 24. They keys are generally less then 24
    characters,
    > and when I read them in the
    > resulting java Strings have the blanks on the end. I am removing the
    blanks
    > because I need to display the keys and
    > also allow the user to enter new keys and also to enter the old keys. So
    in
    > other words I am removing the blanks
    > for GUI purposes.
    >
    > Now when I am performing other queries and updates to the database I of
    > course need to take into account
    > the fact that I have removed the blanks, so I am using x LIKE 'y%' as my
    > predicate. However I am concerned
    > that I may not get the appropriate matches with LIKE, in other words
    'ABC%'
    > might match 'ABC1' instead
    > of 'ABC'. Can anyone tell me if this is an issue? So far it seems to
    work
    > correctly, but I really haven't
    > tested it very well yet.
    >
    > In general I am not using host variables, but instead creating the
    (dynamic)
    > sql as strings.
    >
    > Thanks,
    >
    > Bruce
    >
    LIKE 'ABC%' will match on 'ABC' or 'ABC '


    Mark A Guest

  2. #2

    Default Question about LIKE

    I have a Java application and I am using JDBC with a DB2 v8 database. The
    database has a number of tables with keys
    specified as CHARACTER 24. They keys are generally less then 24 characters,
    and when I read them in the
    resulting java Strings have the blanks on the end. I am removing the blanks
    because I need to display the keys and
    also allow the user to enter new keys and also to enter the old keys. So in
    other words I am removing the blanks
    for GUI purposes.

    Now when I am performing other queries and updates to the database I of
    course need to take into account
    the fact that I have removed the blanks, so I am using x LIKE 'y%' as my
    predicate. However I am concerned
    that I may not get the appropriate matches with LIKE, in other words 'ABC%'
    might match 'ABC1' instead
    of 'ABC'. Can anyone tell me if this is an issue? So far it seems to work
    correctly, but I really haven't
    tested it very well yet.

    In general I am not using host variables, but instead creating the (dynamic)
    sql as strings.

    Thanks,

    Bruce


    dfdfd Guest

  3. #3

    Default Re: Question about LIKE


    "Mark A" <maswitchboard.net> wrote in message
    news:2LqSa.58$%S5.85748news.uswest.net...
    > "dfdfd" <dfdfaol.com> wrote in message
    > news:o0qSa.13409$N%3.10974lakeread01...
    > > I have a Java application and I am using JDBC with a DB2 v8 database.
    The
    > > database has a number of tables with keys
    > > specified as CHARACTER 24. They keys are generally less then 24
    > characters,
    > > and when I read them in the
    > > resulting java Strings have the blanks on the end. I am removing the
    > blanks
    > > because I need to display the keys and
    > > also allow the user to enter new keys and also to enter the old keys.
    So
    > in
    > > other words I am removing the blanks
    > > for GUI purposes.
    > >
    > > Now when I am performing other queries and updates to the database I of
    > > course need to take into account
    > > the fact that I have removed the blanks, so I am using x LIKE 'y%' as
    my
    > > predicate. However I am concerned
    > > that I may not get the appropriate matches with LIKE, in other words
    > 'ABC%'
    > > might match 'ABC1' instead
    > > of 'ABC'. Can anyone tell me if this is an issue? So far it seems to
    > work
    > > correctly, but I really haven't
    > > tested it very well yet.
    > >
    > > In general I am not using host variables, but instead creating the
    > (dynamic)
    > > sql as strings.
    > >
    > > Thanks,
    > >
    > > Bruce
    > >
    > LIKE 'ABC%' will match on 'ABC' or 'ABC '
    >
    >
    Great! Thanks a lot.

    Bruce


    dfdfd Guest

Similar Threads

  1. Newbie Question: Biz Card Template Question
    By Thomas_Porter@adobeforums.com in forum Adobe Indesign Windows
    Replies: 4
    Last Post: May 30th, 08:08 AM
  2. Replies: 9
    Last Post: April 27th, 04:44 AM
  3. Pen Tool Use Question. (Embarrassingly Newbie Question)
    By Bozo Schmozo in forum Macromedia Flash
    Replies: 0
    Last Post: November 12th, 10:00 PM
  4. Global variable question question
    By Jason Giangrande in forum PHP Development
    Replies: 3
    Last Post: July 23rd, 08:27 PM
  5. newB question: related tables question
    By Blue man in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: June 30th, 04:13 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139