Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Load statement precedes SQL statements whenever i load data from a db.
1. What is the use of load statement?
2. When would load statement be useful and not useful?
3. If my db table has 6 columns, my load statement also has 6 columns. But if i create a new field under "Load" statement then will i face error since Load statement has 7 fields and SQL statement has 6 fields?
4. If i write add a new column under SQL Statement should i also add a field under "Load" statement with same output?
hi
1. load statement allows you , to add calculated fields on top of the existing fields from SQL query or any table
with out the need referance the table, or call the table , it makes your script more readable .
2.it's not about useful , there are some cases you can't use it , as if you join two table the load will only consider the first table , ordering the table is also something you can't use in preceding load .
3.no problem to add columns, as long as they are built using the fields in the Sql query
4. yes you'll need to update both parts