Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5
Thanks Michael I got it to work. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Black, Michael (IS) Sent: Saturday, February 11, 2012 7:57 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5 Here's exactly what I did. You get a different result? sqlite3 test1.db create table grocery(a int,b int); insert into grocery values(1,2); insert into grocery values(2,3); .quit copy test1.db test2.db copy test1.db test3.db At this point I have: 02/11/2012 06:53 AM 228 dump.bat 02/11/2012 06:42 AM49 loop.bat 02/11/2012 06:48 AM 2,048 test1.db 02/11/2012 06:48 AM 2,048 test2.db 02/11/2012 06:48 AM 2,048 test3.db loop test?.db Then I have 02/11/2012 06:53 AM 228 dump.bat 02/11/2012 06:54 AM70 grocery.sql 02/11/2012 06:42 AM49 loop.bat 02/11/2012 06:54 AM 8 test1.csv 02/11/2012 06:48 AM 2,048 test1.db 02/11/2012 06:54 AM 8 test2.csv 02/11/2012 06:48 AM 2,048 test2.db 02/11/2012 06:54 AM 8 test3.csv 02/11/2012 06:48 AM 2,048 test3.db 9 File(s) 6,515 bytes 2 Dir(s) 201,627,729,920 bytes free D:\SQLite\xx>more test1.csv 1,2 2,3 Using these two batch files loop.bat @for %%i in (%1) do @call dump %%i dump.bat @del /q %~n1.csv @if not exist %1 echo No such file: %1 @echo .separator "," >grocery.sql @echo .output %~n1.csv >>grocery.sql @echo select * from grocery; >>grocery.sql @echo .quit >>grocery.sql @sqlite3 %1 mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Black, Michael (IS) Sent: Thursday, February 09, 2012 3:04 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5 Let's change them a touch...one too many @'s in loop.bat loop.bat @for %%i in (%1) do @call dump %%i dump.bat @echo .separator "," >grocery.sql @echo .output %~n1.csv >>grocery.sql @echo select * from grocery; >>grocery.sql @echo .quit >>grocery.sql @sqlite3 %1 grocery.sql echo .output %~n1.csv >>grocery.sql echo select * from grocery; >>grocery.sql echo .quit >>grocery.sql sqlite3 %1 mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Thursday, February 09, 2012 1:39 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5 On 9 Feb 2012, at 6:28pm, Tim Leland wrote: > That will work but we have to import the sqlite file into our AS400/Iseries > IBM (DB2)system. Easiest way is convert it to a .csv file for the import. My > last resort is just run a script on the PC side that will run sqlite3.exe > shell and convert the sqlite file to a .csv but I want to avoid that step. > If you know of a way for an as400 to import sqlite files that would be > great! Oh, you're that guy. Okay, I'd forgotten your hosting side was on an AS400. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5
I still wasn't able to get this to work. It doesn't do anything. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Black, Michael (IS) Sent: Thursday, February 09, 2012 3:04 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5 Let's change them a touch...one too many @'s in loop.bat loop.bat @for %%i in (%1) do @call dump %%i dump.bat @echo .separator "," >grocery.sql @echo .output %~n1.csv >>grocery.sql @echo select * from grocery; >>grocery.sql @echo .quit >>grocery.sql @sqlite3 %1 grocery.sql echo .output %~n1.csv >>grocery.sql echo select * from grocery; >>grocery.sql echo .quit >>grocery.sql sqlite3 %1 mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Thursday, February 09, 2012 1:39 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5 On 9 Feb 2012, at 6:28pm, Tim Leland wrote: > That will work but we have to import the sqlite file into our AS400/Iseries > IBM (DB2)system. Easiest way is convert it to a .csv file for the import. My > last resort is just run a script on the PC side that will run sqlite3.exe > shell and convert the sqlite file to a .csv but I want to avoid that step. > If you know of a way for an as400 to import sqlite files that would be > great! Oh, you're that guy. Okay, I'd forgotten your hosting side was on an AS400. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5
Would this be able to run on windows mobile or windows ce? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Andrew Barnes Sent: Friday, February 10, 2012 1:46 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5 Hi, Not sure if anyone has suggested this already but rather than messing with the shell and bat files, cant you write a little program which reads the database, outputs a CSV file and puts it wherever it needs putting Andy ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5
I can use CE if that's the problem. Can someone get sqlite3.exe shell to run on windows CE? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Random Coder Sent: Thursday, February 09, 2012 2:51 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5 On Thu, Feb 9, 2012 at 10:17 AM, Tim Leland <tlel...@wleeflowers.com> wrote: > Ok now I understand. I need the shell for windows mobile. The reason why im > doing this is the application running on windows mobile is really just an > html5 browser storing data in a sqlite database. I need to convert the > sqlite database to a .csv file and send that file to a ftp server. Any ideas > on getting the shell to work on windows mobile? Since Windows Mobile doesn't include the console aspects of CE, not only will you need to get the SQLite shell to compile, you'll have to create some sort of GUI shell around it to use it interactively. Unless someone knows of a Windows Mobile SQLite explorer application that's already out there, you're going to need to start coding. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5
Haha ya Im "that guy". Ive tried to create these .bat files and they don't seem to do anything. Here they are: Two batch files will do it. loop.bat @for %%i in (%1) do @call @dump %%i dump.bat echo .separator "," >grocery.sql echo .output %~n1.csv >>grocery.sql echo select * from grocery; >>grocery.sql echo .quit >>grocery.sql sqlite3 %1 mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Thursday, February 09, 2012 1:39 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5 On 9 Feb 2012, at 6:28pm, Tim Leland wrote: > That will work but we have to import the sqlite file into our AS400/Iseries > IBM (DB2)system. Easiest way is convert it to a .csv file for the import. My > last resort is just run a script on the PC side that will run sqlite3.exe > shell and convert the sqlite file to a .csv but I want to avoid that step. > If you know of a way for an as400 to import sqlite files that would be > great! Oh, you're that guy. Okay, I'd forgotten your hosting side was on an AS400. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5
That will work but we have to import the sqlite file into our AS400/Iseries IBM (DB2)system. Easiest way is convert it to a .csv file for the import. My last resort is just run a script on the PC side that will run sqlite3.exe shell and convert the sqlite file to a .csv but I want to avoid that step. If you know of a way for an as400 to import sqlite files that would be great! -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Thursday, February 09, 2012 1:26 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5 On 9 Feb 2012, at 6:17pm, Tim Leland wrote: > Ok now I understand. I need the shell for windows mobile. The reason why im > doing this is the application running on windows mobile is really just an > html5 browser storing data in a sqlite database. I need to convert the > sqlite database to a .csv file and send that file to a ftp server. Why not send the sqlite database to the ftp server ? It's just a single file on disk. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5
Ok now I understand. I need the shell for windows mobile. The reason why im doing this is the application running on windows mobile is really just an html5 browser storing data in a sqlite database. I need to convert the sqlite database to a .csv file and send that file to a ftp server. Any ideas on getting the shell to work on windows mobile? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Random Coder Sent: Thursday, February 09, 2012 1:17 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5 On Thu, Feb 9, 2012 at 10:07 AM, Tim Leland <tlel...@wleeflowers.com> wrote: > What software would I need to compile? Persumably whatever software you're using to compile the rest of your application. Visual Studio is the common way to compile Windows Mobile applications. SQLite is a library meant to be used in another program. While there is a shell application available for some operating systems, that shell isn't available for Windows Mobile (nor would it be useful to most people if it was), so you'll need to integrate the library directly into your own application. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5
What software would I need to compile? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Random Coder Sent: Thursday, February 09, 2012 1:06 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5 On Thu, Feb 9, 2012 at 9:57 AM, Tim Leland <tlel...@wleeflowers.com> wrote: > Ok so what would be the process of compiling the c#? Ive never done anything > like that before. Unless you have a need for the C# library, you should skip it. Just bring in the C source file and header from the amalgamation from http://www.sqlite.org/download.html into your project and use it. I don't remember needing to do anything special to compile sqlite3.c on Windows Mobile. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5
Ok so what would be the process of compiling the c#? Ive never done anything like that before. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jim Morris Sent: Thursday, February 09, 2012 12:44 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5 Sorry, no. SQLite is embedded in our application and requires authentication and sync to server before you can get off the login page. On 2/9/2012 9:33 AM, Tim Leland wrote: > Is the sqlite part separate or emended in the application? Is it possible to > just send me the .exe and test it on the scan gun? > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jim Morris > Sent: Thursday, February 09, 2012 12:22 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5 > > It will definitely run. Pelles is new to me. Our application uses > SQLite 3.5.9 on WinCE 4.2 through 6.5 using C++. I don't recall that we > had to change any source, but we did modify the shell for better input > handling, but there were probably some compiler flags we needed to set. > Been years since I had to touch it. > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5
Is the sqlite part separate or emended in the application? Is it possible to just send me the .exe and test it on the scan gun? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jim Morris Sent: Thursday, February 09, 2012 12:22 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5 It will definitely run. Pelles is new to me. Our application uses SQLite 3.5.9 on WinCE 4.2 through 6.5 using C++. I don't recall that we had to change any source, but we did modify the shell for better input handling, but there were probably some compiler flags we needed to set. Been years since I had to touch it. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5
Found this site. Anyone have any experience using this? http://www.smorgasbordet.com/pellesc/ -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Tim Leland Sent: Thursday, February 09, 2012 11:48 AM To: 'General Discussion of SQLite Database' Subject: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5 Does anyone have any tips/suggestions for getting sqlite3 to run on windows mobile 6.5? Thanks Tim Leland W. Lee Flowers & Co. 127 E. W Lee Flowers Rd. Scranton, S.C. 29591 (843)389-2731 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Compiling SQLite3 to run on Windows Mobile 6.5
Does anyone have any tips/suggestions for getting sqlite3 to run on windows mobile 6.5? Thanks Tim Leland W. Lee Flowers & Co. 127 E. W Lee Flowers Rd. Scranton, S.C. 29591 (843)389-2731 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite] .output Question
Maybe I wasn't clear or I don't understand. Im using windows powershell to loop through a folder with multiple ".db" files. I want them to be named correctly. For ex. Test1.db >> test1.csv Test2.db >> test2.csv Test3.db >> test3.csv .separator "," .output "orginal DB file name" + .csv select * from grocery; .quit -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Black, Michael (IS) Sent: Thursday, February 09, 2012 9:34 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] sqlite] .output Question echo .separator "," >grocery.sql echo .output %filename% >>grocery.sql echo select * from grocery; >>grocery.sql echo .quit >>grocery.sql sqlite3 grocery.db http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] .output Question
Im using sqlite3.exe to convert my database to .csv file. Here are the commands Im passing to sqlite3. .separator "," .output text.csv select * from grocery; .quit How can I get .output txt.csv to be %filename%.csv thanks Tim Leland W. Lee Flowers & Co. 127 E. W Lee Flowers Rd. Scranton, S.C. 29591 (843)389-2731 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] RE Connect As400/Iseries to SQLite .db
We just want to simplify the process. If pc goes down our files wont be converted and its just another piece to troubleshoot. As400 can compile C so that is an option. I don't think anyone has done something like this and there is not much info on it. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Black, Michael (IS) Sent: Wednesday, February 08, 2012 11:47 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] RE Connect As400/Iseries to SQLite .db Do you have a C compiler on the AS400 you can use? I couldn't find anybody doing this so if you want to avoid the PC side you may be on your own to build the shell. I assume there's some logical reason for not doing the sql dump on the PC side? Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Tim Leland [tlel...@wleeflowers.com] Sent: Wednesday, February 08, 2012 10:21 AM To: 'General Discussion of SQLite Database' Subject: EXT :Re: [sqlite] RE Connect As400/Iseries to SQLite .db We are trying to avoid running anything on the pc side. The files are put in a folder with ftp and then we want to import them into the as400. Attached is the file format. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Black, Michael (IS) Sent: Wednesday, February 08, 2012 11:09 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] RE Connect As400/Iseries to SQLite .db Yesjust use the sqlite shell to .dump the database on whatever other platform you have and copy the file over. You need to do this in the shell. .output sqlout.txt .dump .quit If there's nothing crazy in the database it may well be 100% compatible with db2. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Tim Leland [tlel...@wleeflowers.com] Sent: Wednesday, February 08, 2012 9:58 AM To: 'General Discussion of SQLite Database' Subject: EXT :Re: [sqlite] RE Connect As400/Iseries to SQLite .db No we do not need an ongoing connection. The dump method would be fine but does it have to first be run on the pc side. Anyone try compile sqlite3 to run on an as400? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Black, Michael (IS) Sent: Wednesday, February 08, 2012 10:46 AM To: General Discussion of SQLite Database Subject: [sqlite] RE Connect As400/Iseries to SQLite .db Any reason you can't just .dump your SQLite database and import into db2? Or do you need an ongoing connection? There's a guy in this thread that connected his Linux system to AS400 using PHP but the .dump/import would be a lot easier. http://php.net/manual/en/function.odbc-connect.php Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Tim Leland [tlel...@wleeflowers.com] Sent: Wednesday, February 08, 2012 9:35 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Connect As400/Iseries to SQLite .db Hey all, Im trying to find a way to connect an as400 to a sqlite database and import the data into db2/physical files. Does anyone have any experience with something similar to this. I found this site and not sure if this will do what Im looking for. http://www.rpgiv.com/sqllite.html Any help will be greatly appreciated. Thanks Tim Leland W. Lee Flowers & Co. 127 E. W Lee Flowers Rd. Scranton, S.C. 29591 (843)389-2731 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi
Re: [sqlite] Connect As400/Iseries to SQLite .db
Ya I just realize that. Its SQL Lite with two 'L's -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dan Kennedy Sent: Wednesday, February 08, 2012 11:11 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Connect As400/Iseries to SQLite .db On 02/08/2012 10:35 PM, Tim Leland wrote: > Hey all, > > > > Im trying to find a way to connect an as400 to a sqlite database and import > the data into db2/physical files. Does anyone have any experience with > something similar to this. I found this site and not sure if this will do > what Im looking for. http://www.rpgiv.com/sqllite.html Any help will be > greatly appreciated. Thanks Looks like an unrelated product to me. Copyright on the site is 1998, which predates even the earliest version of (the www.sqlite.org) SQLite by a couple of years. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] RE Connect As400/Iseries to SQLite .db
We are trying to avoid running anything on the pc side. The files are put in a folder with ftp and then we want to import them into the as400. Attached is the file format. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Black, Michael (IS) Sent: Wednesday, February 08, 2012 11:09 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] RE Connect As400/Iseries to SQLite .db Yesjust use the sqlite shell to .dump the database on whatever other platform you have and copy the file over. You need to do this in the shell. .output sqlout.txt .dump .quit If there's nothing crazy in the database it may well be 100% compatible with db2. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Tim Leland [tlel...@wleeflowers.com] Sent: Wednesday, February 08, 2012 9:58 AM To: 'General Discussion of SQLite Database' Subject: EXT :Re: [sqlite] RE Connect As400/Iseries to SQLite .db No we do not need an ongoing connection. The dump method would be fine but does it have to first be run on the pc side. Anyone try compile sqlite3 to run on an as400? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Black, Michael (IS) Sent: Wednesday, February 08, 2012 10:46 AM To: General Discussion of SQLite Database Subject: [sqlite] RE Connect As400/Iseries to SQLite .db Any reason you can't just .dump your SQLite database and import into db2? Or do you need an ongoing connection? There's a guy in this thread that connected his Linux system to AS400 using PHP but the .dump/import would be a lot easier. http://php.net/manual/en/function.odbc-connect.php Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Tim Leland [tlel...@wleeflowers.com] Sent: Wednesday, February 08, 2012 9:35 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Connect As400/Iseries to SQLite .db Hey all, Im trying to find a way to connect an as400 to a sqlite database and import the data into db2/physical files. Does anyone have any experience with something similar to this. I found this site and not sure if this will do what Im looking for. http://www.rpgiv.com/sqllite.html Any help will be greatly appreciated. Thanks Tim Leland W. Lee Flowers & Co. 127 E. W Lee Flowers Rd. Scranton, S.C. 29591 (843)389-2731 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] RE Connect As400/Iseries to SQLite .db
No we do not need an ongoing connection. The dump method would be fine but does it have to first be run on the pc side. Anyone try compile sqlite3 to run on an as400? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Black, Michael (IS) Sent: Wednesday, February 08, 2012 10:46 AM To: General Discussion of SQLite Database Subject: [sqlite] RE Connect As400/Iseries to SQLite .db Any reason you can't just .dump your SQLite database and import into db2? Or do you need an ongoing connection? There's a guy in this thread that connected his Linux system to AS400 using PHP but the .dump/import would be a lot easier. http://php.net/manual/en/function.odbc-connect.php Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Tim Leland [tlel...@wleeflowers.com] Sent: Wednesday, February 08, 2012 9:35 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Connect As400/Iseries to SQLite .db Hey all, Im trying to find a way to connect an as400 to a sqlite database and import the data into db2/physical files. Does anyone have any experience with something similar to this. I found this site and not sure if this will do what Im looking for. http://www.rpgiv.com/sqllite.html Any help will be greatly appreciated. Thanks Tim Leland W. Lee Flowers & Co. 127 E. W Lee Flowers Rd. Scranton, S.C. 29591 (843)389-2731 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Connect As400/Iseries to SQLite .db
Hey all, Im trying to find a way to connect an as400 to a sqlite database and import the data into db2/physical files. Does anyone have any experience with something similar to this. I found this site and not sure if this will do what Im looking for. http://www.rpgiv.com/sqllite.html Any help will be greatly appreciated. Thanks Tim Leland W. Lee Flowers & Co. 127 E. W Lee Flowers Rd. Scranton, S.C. 29591 (843)389-2731 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users