Using Variables in Load Sentence

[#1]

Hello Everyone, i have a problem, i want to use a variable into a load sentence.

I declare my variable in this way:

vProceso="31-01-2014";

And I want to use it in the following sentence:

LOAD

     vProceso as 'Fecha',

     Transacciones as Tran

from

     xxxxx;

Also I used $(vProceso) but I didn't get the result.

The table that I will wish to get is:

Fecha               Tran

'31-01-2014'     12345

Thanks for help me!!!!

[Gysbert_Wassenaar]

Try it like this:

SET vProceso= 31-01-2014;

LOAD

     '$(vProceso)' as Fecha,

     Transacciones as Tran

from

     xxxxx;

[MK_QSL · Accepted solution]

May be like below

vProceso= '31-01-2014';

and

'$(vProceso)' as Fecha,

[#4]

Thanksssss...

[MK_QSL]

Hi gwassenaar

just want to know what is wrong in my answer?

I tried and it's working !

[Gysbert_Wassenaar]

Yeah, it works. I think it's just better to be explicit about declaring variables by using LET or SET.

[MK_QSL]

Thanks... ! Have a nice weekend.

[Gysbert_Wassenaar]

You too!