Split code to edit repetitive Fields ¿SubRoutine?

[cristian_av]

Hi

I'm searching for some way to separate the code to edit just some repetitive fields. I don't want to repeat the code for fields that are equal but that are in different tables.

I thought that maybe with a subroutine I can do it, but I don't know how!

Is it any way to do that?

Thanks!

An Example:

LOAD *,

     num(ID_RUT) as ID_RUT2

;

[Table1]:

ID_RUT,

NAME

FROM file1.qvd (qvd)

LOAD*

     num(ID_RUT) as ID_RUT2

;

[Table2]:

ID_RUT

ANOTHER_FIELD,

ANOTHER_FIELD2,

FROM file222.qvd (qvd)