Importing Android SQlite database data to db2


Is there is any way to move the sqlite data to db2.. Data has to be collected offline  using using a tablet which is android base and it has to sync on it  once it finds the connectivity and automatically it has move the data into db2. Let us know how this can be achieved

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kent OlsenDBACommented:
Hi Roy,

I'm not familiar with any way to link SQLLite and DB2 (directly).

You'll need to dump the data from the SQLLite database into a form that DB2 can process.

roy_sanudeveloperAuthor Commented:
I can use csv as a format.. how can I automate the data into db2.. is there any tool or we have to write any program to do that
Kent OlsenDBACommented:
If you can write the data as CSV, you can use IMPORT or LOAD to get data from the file into DB2.  IMPORT will probably be the easiest.  

Run the DB2 command line.  From within the utility, run the IMPORT command.   "? IMPORT" from within the utility will show you all of the options.

db2 => IMPORT FROM {filename} OF DEL INSERT (column_list)

That's the basic import statement.  The items in column_list need to be the column names in the order that the columns were written to the CSV file.

Good Luck!

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Hi dude, i have also find out one good example
<a href="">
SQLite Basic Commands
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.