SQL Server Performance Forum – Threads Archive
SQLCODE +1 while rehosting
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 SQLSELECT
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
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.
]]>