Hello,
I'm trying to find a way to get the columns fields that a COMPUTE expression contains.
Something like:
COMPUTE XPTO/A30 = COL1+COL2+COL3;

I thought in using the WF parsing functions to get the columns. But is very difficult to parse complex expression.

The other option was something like:
TABLE FILE filename
PRINT COMPUTE XPTO/A30 = COL1+COL2+COL3;
ON TABLE HOLD AS RES
END

CHECK FILE RES HOLD AS MYCHECK
TABLE FILE MYCHECK
PRINT *
END

This way I get the COL1, COL2 and COL3. The point is that I need to execute the query. In may case this is not an option.
So my question is: It's possible to get this information without executing the query?

Or maybe there is another way to solve this issue.

Thanks in advanced,
Carlos Dias

This message has been edited. Last edited by: Carlos Dias,

Why do you want to eval COMPUTES ?

Is there a reason or problem ?

There is no problem at all... I just want to get the columns of the COMPUTE to make another operations.

I can get this running the query. But the best was to create the HOLD to get the master file without running the query. It's possible? Why is necessary to execute the query to get the master file created by the HOLD? The data is not necessary.

Thanks,
Carlos Dias

Should the result of the expression be an a30 field?
But maybe I lust do not understand the question.

Carlos,

To get a Master for a HOLD file without accessing the data, add this code before the TABLE FILE command:

SET XRETRIEVAL=OFF

Change it to ON when you want to access data (or delete the command).

You are using + signs in your COMPUTE statement, we assume the columns COL1, COL2 and COL3 are numeric. If so, XPTO must be numeric. If COL1, COL2 and COL3 are alphanumeric, you need to concatenate the columns:

COMPUTE XPTO/A30 = COL1 | COL2 | COL3;
COMPUTE XPTO/A30 = COL1 || COL2 || COL3;

| - Weak concatenation - Preserves trailing blanks.

|| - Strong concatenation - Moves trailing blanks to the end of a concatenated string.

The XRETRIEVAL works.

In the example XPTO in not a alphanumeric, but a number.

Thank you.