Kbase 21659: Error 7559 When Loading Data Via The SQLLOAD Utility
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
SYMPTOM(s):
Error while loading data with the SQLLOAD Utility.
Error inserting row <xxx> : sqlcode = -20036 :
File <FileName.dsql>
Statement not prepared (7559)
CAUSE:
The commit frequency is not specified.
FIX:
The workaround consist in using the -c parameter in order to specify the commit frequency. The maximum number of records has to be known in order to completely load data into the database.
The syntax is as followed:
sqlload -u <User Name> -a <Password> -c <Max. Number Of Records>
-t % progress:T:<Host Name>:<Port Number>:<Database Name>