I am trying to put a .csv file in the database with Unix LineBricks. I'm running:
bulk INSERT table_name FROM with 'C: \ file.csv' (FIELDTERMINATOR = ',', ROWTERMINATOR = '\ n') If I load the file in a Windows format, it works, but if I can avoid it then I do not want to do this extra step. Any ideas?
I think that I had the same problem, as should be forced to contribute, And I need to read 2 Unix files from SAP twice at least one day. Therefore, instead of using Unix2dos, I should be more automated by some more programming with less manual intervention.
As mentioned, the character (10) works within the SQL string. I did not want to use a SQL string, and so I used '+ + (+0) +' ", but for some reason, it did not compile.
What Happened
The problem with Hexa solved!
Hope this helps someone.
Comments
Post a Comment