field names

[#1]

hi all,

is there a way to automatically name the fields loaded in a load script with

as TABLENAME.FIELDNAME

?

If i load multiple tables that might have some fields with the same name i want to prevent the creation of keys without having to look at each field and check if this field name already exists...

thanks a lot!

[#2]

Hi,

You can use

QUALIFY  ;

write this before the load statement.

this will qualify all the fields with thr respective table names.

i hop this will solve ur need.

[#3]

QUALIFY *;

table name:

load script.....

this will rename all fields like "table name.field name"

[jonathandienst · Accepted solution]

Hi

The QUALIFY statement does that. If you want all field names to be qualified with table names, the use:

QUALIFY *;

For specific fields, use the list of field names in the QUALIFY statements.

Turn off the qualification with UNQUALIFY *.

Hope that helps

Jonathan