You should be able to... If it's a large QVD, the load becomes not optimized though, so you might be better off loading the QVD with no order by, and then reloading in memory with the sorting options.
You might be getting an error if you are adding the Order By before the qualifier (qvd), or if one of your field names is misspelled.
You should be able to... If it's a large QVD, the load becomes not optimized though, so you might be better off loading the QVD with no order by, and then reloading in memory with the sorting options.
You might be getting an error if you are adding the Order By before the qualifier (qvd), or if one of your field names is misspelled.
ORDER BY does not work when directly loading from a QVD file.
You need to load it into a temp table, then sort in a second load from the resident table. Be sure to use NoConcatenate in the second load, so the tables aren't combined.
