Results 1 to 2 of 2

Thread: Db2, Nolock

  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: Db2, Nolock

    Hi guys,

    I am a new user for DB2.

    In DB2 V8, i have a table with some no of columns.

    table test
    col1
    col2
    col3
    col4

    Now i want to issue a query like this.

    select col1 from test with(NOLOCK) where col1 = <some value>

    when i am executing this query on that time i am getting a error message like this...

    SQL0158N The number of columns specified for "MT.TEST" is not the
    same as the number of columns in the result table. SQLSTATE=42811

    Anyone can help me???

    i tried to find out.

    I did the same thing with SQL server 2000.
    I am not facing any problem there.

    Thanks & Regards,
    Muthu

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    You should post it on DB2 forum and this is related to SQL Server.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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