PowerBuilder with Unidata

[siraj777]

I am running PB 6.5 with IBM UNIDATA connected thru ODBC. The application was working fine and all of sudden got the following problems.

The login/password/privileges are not changed.
Reading from the database is successful in 1 & 2, but updates/deletes/commits are not successful. Please see the below error messages. (dw_1.Update() returns -1)
3. dw_1.retrieve() returns -1

1. 030529 11:11:06 > DW Error: (999 Row 1) SQLSTATE = S1000
[Ardent][UniData ODBC Driver][Informix][SQL Client][UNIDATA]Open file error

2. DELETE FROM PTRN WHERE ID = '001*GANGTEST*12924*54720*10-40*170*1502'
030529 11:11:09 > DW Error: (999 Row 1) SQLSTATE = S1000
[Ardent][UniData ODBC Driver][Informix][SQL Client][UNIDATA]Open file error

3. 030529 11:11:11 > DW Error: (999 Row 0) Select error: SQLSTATE = S1000
[Ardent][UniData ODBC Driver][Informix][SQL Client][UNIDATA]Unidata lower level function error with fetch

 

[royjimcam]

It´s difficult to see the problem...

Try this, get the SQL Syntax that generate your dw, later, paste it in a SQL Tool and execute it... if there is a error, the problems are your datas.

Luck and later you tell me...