Re: dbexport/UNIX <-> dbimport/dos
>
> One simple problem:
>
> I want to export a database on (SCO) UNIX and import this
> database with I-SQL DOS !
>
> The dbexport on UNIX generates to long filenames, so i can4t use
> the SQL-Script and the unload files.
>
> The database has about 600 tables and it4s a little bit to much
> work to modifty all filenames by hand.
>
> Is there a secret option for generating DOS filenames ??
>
> Thank4s for any idea.
Try this:
{tabren.ace}
database xxxxxx end
output
top margin 0
bottom margin 0
page length 1
end
select tabname from systables where tabid > 99
end
format
on every row
print "mv ", tabname clipped, ".unl ", tabname[1,8], ".unl"
end
--- end ---
I can't remember offhand what the unix extension of the unload files, but
thats easy to fix. This will generate a script to rename all of the files
for you. If you run it as sacego -q you wont even have to mess with the
headers
j.
_____________________________________________________________________________
Jack Parker |
Hewlett Packard, BSMC Boise, Idaho, USA| No soap - radio!
jparker@hpbs3645.boi.hp.com |
_____________________________________________________________________________
Any opinions expressed herein are my own and not those of my employers.
_____________________________________________________________________________