I try to import data with gateway instead of using LOAD command and when I load text delimited with ( ' ) I have problems. The data to be loaded is : 12873,20031001,1800,2000,0,0,0,'2',1 and the field with data '2' returns an error. The table has text(1) and the only way I had found is add 2 positions, text(3). The gateway returns no errors, but the data apears with ' on the DB. I've tested with CSV, QSV, and so on, but the result is the same. what's the file type to do it? The cfg of the Db is quotes = ' so it must be OK. I have another problem with DATE imports (the second fiels on the example is a DATE). If the field has no "/" separators, but I use a temporary table with text type and it runs. There's a datatype to import data in format yyyymmdd?
I try to use GATEWAY because I have too much problems using LOAD, it gives me a lot of message "waiting to access to a required resource 25%" and blocks the process until I push the cancel button. I think NT or R:base keeps as owner the ascii file and cannot be openet by another workstation. It looks like using gateway command (Now only two of all LOAD instructions on the procedure are changed to gateway) the process have less locks messages. I only search the way to import data in a multi-user environmet comming >from ascii files (more o less 500). I load this files using 4 PC's at same time, and the tables are differents for each PC. Witch is the better way? Best Regards, Ramon Guardiola fermatic Three system Barcelona (Spain)
