0

i´m trying to upload registers in mysql using a procedure in genexus with SQL[!&Query!]. The command works to create the table, but not with the load.

&Query = 'CREATE TABLE tmpent (registro varchar(500));'
SQL [!&Query!]
Commit 
&Query = "LOAD DATA LOCAL INFILE 'C:/Program Files/Apache Software Foundation/Tomcat 9.0/txtfiles/Maeent.txt' INTO TABLE tmpent LINES TERMINATED BY '\r\n' (registro);"
SQL [!&Query!]
Commit

i´m doing something wrong?

Santiago Adan
  • 11
  • 2
  • Check whether you have enabled local data loading. See [this](https://stackoverflow.com/a/60717467). Also enable JDBC logging on genexus and check its output after running your code. – gusbro Sep 02 '22 at 16:19

0 Answers0