MVSFORUMS.com

arunkumar_e · Posted: Fri May 28, 2004 1:15 am Post subject: sql error code -438

When i run a querry in spufi i am getting sql error code of -438.I am trying to delete a row from the table which matches the criteria mentioned in the querry.Can any one tell me what this error code represents & how can i fix this.Below mentioned is the querry & the error message.

Delete from TABLE1
Where id = 'xxxxx'
and code > '499'

SQLCODE = -438, ERROR: APPLICATION RAISED ERROR WITH DIAGNOSTIC TEXT
SQLSTATE = 75001 SQLSTATE RETURN CODE
SQLERRP = DSNXRTYP SQL PROCEDURE DETECTING ERROR
SQLERRD = 1 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION

Thanks
_________________
Arun
"Genius is one percent inspiration and ninety-nine percent perspiration." -- Thomas A. Edison

arunkumar_e · Posted: Sun May 30, 2004 11:28 pm Post subject:

Thanks Ravi for the information !!
_________________
Arun
"Genius is one percent inspiration and ninety-nine percent perspiration." -- Thomas A. Edison