SQL Server Performance

SQLCODE +1 while rehosting

Discussion in 'SQL Server 2005 General DBA Questions' started by Arun_eee28, Feb 19, 2007.

  1. Arun_eee28 New Member

    I am getting a SQLcode of +1 in my query which is given below. I have to find the reason of the warning. Any help?

    EXEC SQL
    SELECT
    DATEDIFF(d,getdate(),DUE_DATE)
    ,getdate(),DUE_DATE
    INTO :WS-DATE-DIFFERENCE,
    :WS-RETURN-DATE,:WS-DUE-DATE
    FROM LIB_TRANSACT
    WHERE MEM_ID=:WS-MEMID AND BOOK_ID=:WS-BOOKID
    AND RETURN_DATE IS NULL
    END-EXEC

    This is the query.

    Arun Kumar,
    BAngalore
  2. satya Moderator

    Are you trying to map the results as XML?
    Are you using SQLCLR?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page