Powerserver 2017, PowerBuilder 2017 R3, Sybase ASE 16.
Works fine in Client server, but when running in WEB, after the close of the query, AEM still shows transaction opened, eventually it times out and we get the transaction time error. Any ideas why this could be happening.
(Note: We do have other cursors that work fine in both Client Server and Powerserver)
//Sample
ls_sql =" SELECT COLA, COLB,COLC " + &
" FROM TABELA, TABLEB" + &
" WHERE ( TABLEA.COLA = " + string(id_case ) + " ) "
DECLARE case_part_cursor DYNAMIC CURSOR FOR SQLSA;
PREPARE SQLSA FROM :ls_SQL USING SQLCA;
OPEN DYNAMIC case_part_cursor;
ll_count = 1
If SQLCA.SQLCODE = GUO_CON.II_SQL_SUCCESS Then
Do While SQLCA.SQLCODE = 0
FETCH case_part_cursor INTO
:il_COL1[ll_count],
:is_COL2[ll_count],
:is_COL3[ll_count];
If SQLCA.SqlCode <> 0 Then EXIT
ll_count++
Loop
END If
CLOSE case_part_cursor;