Search results for query: *

Dimandja, Further appreciation for your assistance. I found more. An example is this (bear with me for the PLSQL syntax): EXEC SQL declare vcurs_1 static optccval cursor for dynamic_sql END-EXEC By making WS-SELECT contain a variable content, I was able to populate the statement and open the...

I have been doing this sort of extraction myself, with a legacy Btrieve system (6.1.5), flattening the files and normalizing them for insertion into Oracle tables through sql loader. The flattening process is somewhat tricky, but you can get around it if you're willing to jump through a few...

Dimandja, Thanks, your kindness is appreciated. BTW, did you ever work in Atlanta, on a Tandem system? Forgive me if your name is more common than I think, but in the mid-80s I worked with a man who had your name. He was as helpful as you, but with TAL. If that was you, then it's a small...

Dimandja, Thanks for both replies. Of course, I knew how to populate a working-storage area to build the SQL statement. But your post confirmed that the syntax is simply PREPARE and EXECUTE, surrounded by the EXEC and END-EXEC. I didn't know it would be that simple, but it was my first...

What I'm seeing is the closest thing to my struggles with Microfocus and embedded SQL. I too have a legacy app to convert, specifically from BTRIEVE to Oracle though that is not really important. My specific issue is this. In the embedded SQL syntax, such as EXEC SQL ... sql text ... END-EXEC...