Text (expression)

[#1]

Is there a way to load all the data from a source as text without having to reference each field individually?

If I have a table  abc with

              Code1

              Code2

              Description3

All fields can be alpha numberic so if Code1 = 00361 and Code2 = 0032 and Desciption3 = 000000009 the precdiing 0's need to remain.

Since all fields need to be read is as text is there a way to specify that for the entire table?

Thanks for any help.

[#2]

you can try:

load text(Code1) as Code1,text(Code2) as Code2,text(Description3) as Description3 from abc.txt;

Kiran Rokkam.

[#3]

Thanks Kiran.

I didn't know if I could ensure they are all text in one statement such as

Load

   Text(*)

from abc

so I would not need to code text for all the fields.

[#4]

I want to load all the fields from table abc.

Instead of coding

Load

   Text(field1), as field1,

   Text(field2) as field2,

   ..

    ..

   Text(fieldx) as fieldx

from table abc

is there anyway to load in all the fields from the table as text in a single statement without having to reference each field in the load statment?

Thanks.