Re: dbload and its unix environment

From: steve_roach@NOSPAMibm.net (Stephen Roach) You really shouldn't put a NOSPAM in your e-ddress if you expect us to reply by e-mail. :-/ >I'm using dbload to load some files but it doesn't seem to like using >environmental variables. The setup looks like this: [SNIP] >Also in /usr/steve/upload I have a dbload text file: > >FILE "$MY_HOME/data/datafile.unl DELIMITER "|" 8; DBLOAD doesn't recognise environment variables in the command file. You would have to hard code the proper path. Your only way around this (that I can think of) is to have a shell script generate the command file using your environment variables. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com