Discussions tagged Cursor
Dynamic Cursor is not working
- Last updated 11 months ago
- Vishrut Dave replied 11 months ago
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...
using two or more dynamic staging area cursors at once
- Last updated 2 years ago
- kevin Rowe replied 2 years ago
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. -----------------------------------------...
Set The Cursor Position
- Last updated 4 years ago
- Chris Pollach @Appeon replied 4 years ago
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 :