473,386 Members | 1,803 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Loading CSV file into DB2

Hi,

I am actually running DB2 from Amazon Virtual Instance and accessing DB2 via Technology Explorer web interface.

I am trying to load a CSV file into the table that I created but it is giving an error SQL 46...

I tried both Load and Import commands as
LOAD FROM /home/tc/myfile.del of DEL
INTO TABLE mytable(column1,column2)


It seems like the file path is not understood, I tried putting file inside the Virtual Instance's home directory and then calling it from Technology Explorer but it did not work.
I am not confident if i am correctly pointing it to the directory or file perhaps should be in a specific folder for db2 to pick up (i thought it will pick up the path from /home directory)

Does anybody know how to fix this?

Many Thanks,

Hawk
Jul 25 '10 #1
0 1337

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Daniel Mori | last post by:
Im at a loss on where to proceed next. I wonder if anyone can help me. I have a managed C++ DLL is basically a thin wrapper around several unmanaged classes. This DLL builds fine. In my...
3
by: Jose | last post by:
I would like to know if anyone can help me with this. I would like to load a file into a switch/case function but dont know how. Here is an example file. ;File Example ;Created 03/04/99 name =...
3
by: Uday | last post by:
Hello all, I have a XML file of 10 MB, I do not want to load this file in Memory using DOM,I know that using SAX I can read the xml file but I want to modify this XML file. I want add, delete...
4
by: Gustaf Liljegren | last post by:
This may be a question of taste, but if there is a best practice, I want to know. I have two choises: SomeClass s = new SomeClass(file); // Load the file or SomeClass s = new SomeClass();...
1
by: Jigar Mehta | last post by:
Hye friends!! Jigar Mehta from India. Currently I am loading one BMP file around 2.5 MB from the disk from my VC program and show it to its DC... But while CBitmap object tries to load it by...
2
by: dana lees | last post by:
Hi, I am developing a c# asp.net application. I have a button which when i click on i open a pdf file. Since the pdf file is very very large i would like to open a window that says "Loading...
4
by: liuliuliu | last post by:
hello -- i'm running python/pygame on maemo (nokia 770). my situation is that i'm continually scouring this one directory for incoming files. if i see if there's a new file (coming in via...
2
by: Mani | last post by:
I have a file browse dialog and an IFRAME on my web page. User will select an RTF file using the file browse dialog and I need to load the contents of that file in IFRAME so that the user could...
1
by: vanita01 | last post by:
Hi Can anyone please help me. I am trying to browse for a file. I would like the file path name to be shown on a text box. Using the upload button I would then like to save the file on mysql. is...
0
by: cnb | last post by:
Python-mode worked right out out of the box in Emacs and then I added Python to my path so now the interpreter works as well. However when I try to load a file(that is not located in site-...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.