Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if we are using qualifier *.it will rename for all table otherwise we should give unqualifier for every table.
ex:
qualifier *,
t1:
load
can we give something like
qualifier t1;
so we can restrict for one table.
we can write write qualifier for particular column ,
but i want for all columns in single table should change
I guess add qualify before your table load and unqualify afterwards
QUALIFY *;
t1:
LOAD ...
FROM ....;
UNQUALIFY *;
t2:
LOAD ...
FROM ...;
t1 will be qualified, but t2 won't be
hi i got it thanks
hi thanks