Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Teradata SQL syntax for UPDATE, submitted through BTEQ
That worked perfectly. Thanks. One interesting point that I learned in testing it - Teradata insists that a DDL statement must be the last statement in it's transaction, so I had to create the view, which remains as a permanent view in the DB and then run the update as a separate submission...- laurieb
- Post #3
- Forum: NCR: Teradata
-
Teradata SQL syntax for UPDATE, submitted through BTEQ
I am translating an Oracle SQL query to Teradata. The task is to update 2 columns in table A, one with a constant, the other with the max value for that column in table B, where the ID number matches the ID number in table A. This is the Teradata code: update tableA from tableB...- laurieb
- Thread
- Replies: 3
- Forum: NCR: Teradata
