Search Results

Hi All,

got the solutions....


echo "LOAD DATA
infile '&1'
APPEND
INTO TABLE dummy_table
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '\"'
TRAILING NULLCOLS " > somfile.ctl

Hi,

what is the escape char for " in shell script. following way i want to write file using echo command

echo "LOAD DATA
infile '&1'
APPEND
INTO TABLE dummy_table
FIELDS TERMINATED BY ',' ...