How to load QVD order by a field

[#1]

Good morning, I have this script to load a table:

load

* from \Pruebas\PROY_PRODUCCIONES\ACTPRODUCCIONES.QVD (qvd);

It works correctly but I would need to get the resulting table oredered by a field called 'FECHA' and I'm not able to write the right sintaxis.

Can anyboy help me please?

Thanks

[mvluttge]

HI,

You have to resident load your actual-table.

The load you have now is fine (perhaps name the tabel "<tabelname>_TMP", or so), but then afterwards, you do a resident load on your "_tmp" table. Here you are able to order by which field you like.

I hope it helps

/Martin

[Anonymous]

As Martin Says.

First:

TablaTemp:

load

  * from \Pruebas\PROY_PRODUCCIONES\ACTPRODUCCIONES.QVD (qvd);

Then:

TablaFinalOrdenada:

load

*

resident TablaTemp Order By Fecha Asc;

Asc is ascending, desc would be newest first. And Drop Table Tabla Temp;

[maxgro]

add a noconcatenate to Roberto answer

TablaTemp:

load

    *     

from

     \Pruebas\PROY_PRODUCCIONES\ACTPRODUCCIONES.QVD (qvd);

TablaFinalOrdenada:

noconcatenate load

     *

resident TablaTemp Order By FECHA;

Drop Table Tabla Temp;

[Anonymous]

Yes. Sorry Thanks Massimo. I had forgotten.