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... And as fond as I am of DBLOAD, you should really look at the High Performance Loader. Initial tests on a very badly configured machine show that it's twice as fast as DBLOAD.... ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com