Re: dbload utility

Dan writes: >I ran into a problem using dbload under Informix 4.0 (online). The following >is the command file I was using: >---------------------------------------------- >file "test.txt" delimiter "|" 6; >insert into menusys (menuid, menu_title) > values (f01, f02);>---------------------------------------------- > Dan, I tried to load your data into my table (INFORMIX-TURBO) and it loads. (I used your exact DBLOAD command) I was recently involved in loading a database to a SUN WORKSTATION. It was ON-LINE 4.1, and we tried to use DBLOAD. We had problems with it because the word "delimiter" has to be specified in LOWER case! When I use my version of DBLOAD, I can specify lower or upper case. I have also run into several problems with DBLOAD on runtime versions of INFORMX TURBO. I think its about time INFORMIX got involved and straightened out its utilities! As far as actual advice on your specific problem, I would try to load on a "one to one" basis. Sincerely, Brian MacWilliams USAMC SIMA CHAMBERSBURG +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ THE NORMAL DICLAIMERS ALWAYS APPLY +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++