We are moving from IVc to IVc4. The table tfgld419 has a new field added to the table. This field is also a part of index. We are using Level I database driver to informix. We want to unload the data from old table and drop the table and create the table with new schema and load the data back. With level 1 driver the hash field also has to a part of the data. If the index is a combination of string fields, it's not a problem. But if the index is a combination of strings and integers i don't know how to build the hash field.
Can any body help me to make this migration easy ??

with an awk:

# awk-tfgld419 ajout d'une colonne pour chargement c4
cd /tempo/100
mv ttfgld419100.S tfgld419.100
awk 'BEGIN {FS="|";OFS="|"} {print $1,$2,$3,$4,$5,$6,"0",$7,$8,$9,$10,$11,$12,$13,$14,$15}' tfgld419.100\
> /infdump/atempo/ttfgld419100.S
And loaded the file after that.

Regards