Qualify statement doubts

[#1]

Hi All,

I have a basic doubt in qualify statement. As per the contents section in QV this is the example given for qualify

qualify *;

unqualify TransID;

select * from tab1;

select * from tab2;

select * from tab3;

Only TransID will be used for associations between the tables tab1, tab2 and tab3.

As per my interpretation of the Qualify statement TranID will be the only field not be qualified, Am I right ? Can any one explain me the in detail with a small example for qualify.

Thanks in Advance,

Sai.

[#2 · Accepted solution]

s

only trans id is unqualified statement

rest of the fields are qualifed

[#3]

Thanks for the quick reply.

[#4]

welcome

[its_anandrjs]

Hi,

Here in all table load TransID is only unqualify field

Ex:-

Qualify *;

Unqualify TransID;

Table1:

select * from tab1;

select * from tab2;

select * from tab3;

After all this load assume you get fields like

TransID,Table1.field1,Table1.field2,Table1.field3........

Regards

Anand