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: [email protected] [[email protected]] on behalf of Tim Leland [[email protected]] 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: [email protected] [mailto:[email protected]] 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 Yes....just 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: [email protected] [[email protected]] on behalf of Tim Leland [[email protected]] 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: [email protected] [mailto:[email protected]] 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: [email protected] [[email protected]] on behalf of Tim Leland [[email protected]] Sent: Wednesday, February 08, 2012 9:35 AM To: [email protected] 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
