How to write a correct request?

Question

SQL

Good day!
I am learning Teradata DBMS syntax. And recently I came across a rather interesting script option for writing a script - bteq (this is something like a shell for writing SQL scripts that can be executed on any environment where this subd is located). I decided to write a script, everything seems to be fine (it works). But then I decided to complicate the task a little for myself and write a script that will select data from a table that does not have a specific field. When executing this script, it crashes with an error. I tried to catch the error through the ERRORCODE and ACTIVITYCOUNT constructs, but to no avail. Has anyone come across this situation, how can I get around it?

Answer 1

I solved the problem as follows: I
wrote a script that compares two tables (an existing one and from which I am going to insert data). If the structure is different, then I do nothing and go to the exit, if it is the same, then I insert the data.