Re: LOAD ? UNLOAD ?

Nayan Jain wrote: > > Hi all ! > > I want to unload data from a table to a file.But i want it to unload it to > a file in a different directory or a specific directory. But by default it > unload it to ur present directory. > > I tried this way > > unload to ~/nj/n/<file-name> select * from emp > load from ~/nj/n/<file-name> insert into emp> Please reply urgently. > Bye > Thanks in advance > Nayan Try this: unload to '/u/nj/n/<file-name>' select * from emp; Informix does not understand the tilde ('~') character in filenames as it is interpreted by the shell, not the filing system. You also need quotes. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions AND the release notes. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/