Discussions tagged Cursor
Dear Support Team,
Following code is not working in my environment.
Connect using SQLCA;
integer cmpnt_Id_var
DECLARE my_cursor DYNAMIC CURSOR FOR SQLSA ;
PREPARE SQLSA FROM "SELECT cmpnt_Id FROM Component" ;
OPEN DYNAMIC my_cursor ;
IF SQ...
I have code that i need to use dynamic cursors for to scan for key values in referential testing.
database is postgres.
the first query must be in sql as the compiler does not recognize the @ character as SQL. it works fine.
the second query canno...
At APPEON
In DW window, Oracle Porcedure delivers a query of the results.
Tibero Procedure on the same DW window will generate an error when querying results.
I ask if there is any solution.
-----------------------------------------...
Helo all
How do i set the cursor at the end of the text in a specific field in dw ?
using pb 2017 r2
thanks
...
- Page :
- 1