Kbase P884: Environment Variables resolve 0 Records in Delimited ASCII Loaded Into - PATH issue
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 8.x
Progress 9.0x
Progress 9.1A
SYMPTOM(s):
User prefers not to use Proenv (Windows users only) to start the progress session.
User prefers not to move the quoter executable from it's current location.
User prefers not to Upgrade to Progress 9.1B
Message: 0 records in Delimited ASCII format loaded into <table> received loading data into the database.
CAUSE:
The import utility runs the executable, quoter in background to format a data file into a format Progress can read. When Progress tries to run the quoter executable, it cannot find the quoter executable in your PATH.
FIX:
If the quoter command is available in the PATH, the Data Dictionary or Data Administration utility will load the data normally.
Add $DLC/bin or %DLC%\bin directory to the Operating Systems PATH environment variable before starting Progress.
Example: PATH=$DLC/bin:$PATH;export PATH (UNIX)
set %PATH%=%PATH%;%DLC%\bin (DOS or MS-Windows)
- $DLC refers to the DLC environment variable on UNIX
- %DLC% refers to the DLC environment variable on MS-Windows
The "echo variablename" commands can be run to verify the value of the DLC and PATH environment variables.
Example: echo $DLC (UNIX platform)
echo $PATH
echo %DLC% (echo or set can be used to view settings on Windows
echo %PATH% based platform)