How To fill all the fields of a column with the same field (another value)?

[bouderbc]

Hi Experts,

How To fill all the fields of a column with the same field ? without using Load if , cause i have many fields to load

Thanx

Example :

Column: Data

Fields: A B C D E

Replace All the fields with : F

Result: F F F F F

Thanx

Regards

Ali

[sunny_talwar]

May be just this

LOAD ....,

     'F' as Data

FROM ...

[Anil_Babu_Samineni]

One simple solution occurs

Load *, 'F' as Field From ...

OR

Rename Command??

[pradosh_thakur]

LOAD

'F' AS Data

FROM  [table name]

;

[its_anandrjs]

Without load means on the load Script you do not need to do this.

[its_anandrjs]

In this

Example :

Column: Data

Fields: A B C D E

Replace All the fields with : F

Result: F F F F F

You write Fields: A B C D E to be change with F you need to change the fields data or rename the field name be specific please.

[bouderbc]

    

[bouderbc]

[sunny_talwar]

LOAD 'G' as DATA

Is this not working for you?

[its_anandrjs]

Find the attached did you looking for this. Or elaborate more on the requirement.