New to TOAD. Running SQL Teradata code created by someone else. I have 10 separate SQL code strings that contain both volatile and create tables. Previously used SQLA which worked fine but SQLA has been retired in my organization so now using TOAD. The issue is I have a volatile table in SQL String 2 (Single Editor Tab in Toad) that relies on SQL String 1 (also a Single Editor Tab in Toad). I run string 1 with no issues but then when I run string 2 it says that the "table does not exist". Is there a way to store volatile tables from one editor to the next? Similar to how SQLA works?
Probably a simple question but no one in my organization can seem to figure it out. Thanks!
This is the Toad for Oracle forum, but sounds like you are using Toad Data Point?
If you could re-post your question to the forum there, then other TDP users may have some insight,
That said, are both editors part of the same session/connection thread. If not, then the second editor will not be aware of the volatile table in the other thread. Something to check while you re-post.