Re: dbload

>Obnoxio The Clown wrote: >> >> >This is a newbie question. I am using the dbload utility. I am creating >> >the command or .ctl file and want the path of the file using an >> >environment variable. If I type: FILE "/path/filename" this works, but >> >it does not work using an environment variable(ex. FILE "$NAME"). This >> >is a pretty basic question, but would appreciate any help. >> >> Did you export the FILE environment variable? >> >I did export the environment variable. FILE .. INTO is SQL. Can it not >recognize environment variables? Ah. Evidently not. You would probably have to write a shell script which generates the load script and does the load -- that would be able to read environment variables... ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com