Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I just established a connection to my desired Teradata server. I have a SQL statement already created and I want to be able to use it in the load editor so that all my changes/manipulation to the data appear in the table. Can I paste or insert my SQL statement into the load editor script so that it returns the results?
@JSF Yes if you have established connection from your load script. you can copy paste query. If in query table name is not prefixed with database name, you might need to prefix it with database_name.table_name. You can run the query with SQL key word in data load editor and load the data
SQL SELECT * FROM database.table where X='Y';
@JSF Yes if you have established connection from your load script. you can copy paste query. If in query table name is not prefixed with database name, you might need to prefix it with database_name.table_name. You can run the query with SQL key word in data load editor and load the data
SQL SELECT * FROM database.table where X='Y';