Query database using ODBC from a linux machine - Revision history

Heiko: /* PHP Code using ODBC */

2020-05-19T15:17:39Z

PHP Code using ODBC

← Older revision		Revision as of 17:17, 19 May 2020
Line 136:		Line 136:
	After some research<ref>php-mmap-issue: https://stackoverflow.com/questions/42132558/odbc-prepare-gives-fatal-error-allowed-memory-size-exhausted</ref><ref>php-mmap-issue: https://stackoverflow.com/questions/21286589/linux-odbc-fatal-error-allowed-memory-size/21412667#21412667</ref><ref>unixodbc-32/64bit drivers: http://www.unixodbc.org/doc/db2.html</ref>I'm pretty sure, its old 32bit ODBC-drivers conflicting with 64bit PHP<ref>Oddly, the same drivers work with perl</ref>.		After some research<ref>php-mmap-issue: https://stackoverflow.com/questions/42132558/odbc-prepare-gives-fatal-error-allowed-memory-size-exhausted</ref><ref>php-mmap-issue: https://stackoverflow.com/questions/21286589/linux-odbc-fatal-error-allowed-memory-size/21412667#21412667</ref><ref>unixodbc-32/64bit drivers: http://www.unixodbc.org/doc/db2.html</ref>I'm pretty sure, its old 32bit ODBC-drivers conflicting with 64bit PHP<ref>Oddly, the same drivers work with perl</ref>.

	~~STAY TUNED WE ARE WORKING ON A SOLUTION~~.		UPDATE: Installing an newer driver fixed this problem. Unfortunately it has another flaw: If a query result contains an [https://en.wikipedia.org/wiki/Umlaut german umlaut], <code>odbc_fetch_array()</code> causes an <tt>segmentation fault</tt>. After some digging I used <code>setlocale (LC_ALL, 'de_DE');</code> to get it working.

	==== PHP Code using DB2 client ====		==== PHP Code using DB2 client ====

Heiko: /* Create a database */

2020-05-05T11:01:32Z

Create a database

← Older revision		Revision as of 13:01, 5 May 2020
Line 5:		Line 5:

	== Create a database ==		== Create a database ==
	I suggest you try [[99 Bottles Of Beer (using REXX)]] and [[Hello World (using database, display file and RPG)]] before you try this!<ref>[[User:Heiko\|Heiko]] made this pretty brief, f.e. not every <code>F3</code> or <code>⏎</code> is noted.</ref><br/>		I suggest you try [[99 Bottles of Beer (using REXX)]] and [[Hello World (using database, display file and RPG)]] before you try this!<ref>[[User:Heiko\|Heiko]] made this pretty brief, f.e. not every <code>F3</code> or <code>⏎</code> is noted.</ref><br/>

	=== Create a database to play with ===		=== Create a database to play with ===

PoC: Linkfix

2020-02-23T20:36:33Z

Linkfix

← Older revision		Revision as of 22:36, 23 February 2020
Line 1:		Line 1:
	{{FIXME\|Rephrase, reformat, set links and wade out unneccessary stuff.}}		{{FIXME\|Rephrase, reformat, set links and wade out unneccessary stuff. Maybe move to user's subpage?}}
	Accessing a AS/400 via ODBC is something that might come in handy some day, so I decided to explore how it can be done.		Accessing a AS/400 via ODBC is something that might come in handy some day, so I decided to explore how it can be done.

Line 5:		Line 5:

	== Create a database ==		== Create a database ==
	I suggest you try [[~~Beginners Project:~~ 99 Bottles Of Beer (using REXX)]] and [[~~Beginners Project:~~ Hello World (using database, display file and RPG)]] before you try this!<ref>[[User:Heiko\|Heiko]] made this pretty brief, f.e. not every <code>F3</code> or <code>⏎</code> is noted.</ref><br/>		I suggest you try [[99 Bottles Of Beer (using REXX)]] and [[Hello World (using database, display file and RPG)]] before you try this!<ref>[[User:Heiko\|Heiko]] made this pretty brief, f.e. not every <code>F3</code> or <code>⏎</code> is noted.</ref><br/>

	=== Create a database to play with ===		=== Create a database to play with ===

PoC: +cat

2020-02-23T20:34:28Z

+cat

← Older revision		Revision as of 22:34, 23 February 2020
Line 1:		Line 1:
			{{FIXME\|Rephrase, reformat, set links and wade out unneccessary stuff.}}
	Accessing a AS/400 via ODBC is something that might come in handy some day, so I decided to explore how it can be done.		Accessing a AS/400 via ODBC is something that might come in handy some day, so I decided to explore how it can be done.

PoC: PoC moved page Beginners Project: Create a database and query it using ODBC from a linux machine to Query database using ODBC from a linux machine without leaving a redirect: Better name

2020-02-23T20:33:19Z

PoC moved page Beginners Project: Create a database and query it using ODBC from a linux machine to Query database using ODBC from a linux machine without leaving a redirect: Better name

← Older revision	Revision as of 22:33, 23 February 2020
(No difference)

Heiko: /* Output */

2019-10-16T20:04:17Z

Output

← Older revision		Revision as of 22:04, 16 October 2019
Line 345:		Line 345:
	----		----
	Footnotes and references:		Footnotes and references:
	</~~references~~>		<references/>

Heiko: /* Output */

2019-10-16T20:04:05Z

Output

← Older revision		Revision as of 22:04, 16 October 2019
Line 343:		Line 343:

	\o/		\o/
			----
			Footnotes and references:
			</references>

Heiko: /* Insert content into the database */

2019-10-16T20:02:07Z

Insert content into the database

← Older revision		Revision as of 22:02, 16 October 2019
Line 33:		Line 33:
	** If you're still in STRSQL, enter: <code>SELECT * FROM CALLS</code>		** If you're still in STRSQL, enter: <code>SELECT * FROM CALLS</code>
	** On command line, try this: <code>DSPF FILE(ODBC/ODBCDBPF)</code>		** On command line, try this: <code>DSPF FILE(ODBC/ODBCDBPF)</code>
	** Or use <code>STRDFU</code>, select option 5 and fill out the displayed form.		** Or use <code>STRDFU</code>, select option 5 and fill out the displayed form
	[[Image:ODBC_DSPF01.png\|666px\|Displayed using <code>DSPF</code>]]		[[Image:ODBC_DSPF01.png\|666px\|Displayed using <code>DSPF</code>]]

Heiko: /* Create a database to play with */

2019-10-16T20:01:29Z

Create a database to play with

← Older revision		Revision as of 22:01, 16 October 2019
Line 11:		Line 11:
	* <code>CRTSRCPF FILE(ODBC/ODBCDB) RCDLEN(112) TEXT('Project ODBC and Database')</code> to create new physical file to hold the DDS.		* <code>CRTSRCPF FILE(ODBC/ODBCDB) RCDLEN(112) TEXT('Project ODBC and Database')</code> to create new physical file to hold the DDS.
	* <code>WRKMBRPDM FILE(ODBC/ODBCDB)</code> Work with this file.		* <code>WRKMBRPDM FILE(ODBC/ODBCDB)</code> Work with this file.
	* <code>F6</code> to create new member, insert member's name <code>~~ODBCDBPF~~</code> and the type <code>PF</code>:<br/>[[Image:ODBCDB01.png\|666px]]		* <code>F6</code> to create new member, insert member's name <code>ODBCDB</code><ref>This wil change later. Read on...</ref> and the type <code>PF</code>:<br/>[[Image:ODBCDB01.png\|666px]]
	* Enter this DDS: ([https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzakc/rzakcdatel.htm Learn what the below means] [https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_74/rzasb/cpdtex.htm Especially time- and dateformats] [https://www.db2tutorial.com/db2-basics/db2-time/ Even more about wibbly-wobbly-timey-wimey-stuff] [https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/intro/src/tpc/db2z_datetimetimestamp.html and more])		* Enter this DDS: ([https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzakc/rzakcdatel.htm Learn what the below means] [https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_74/rzasb/cpdtex.htm Especially time- and dateformats] [https://www.db2tutorial.com/db2-basics/db2-time/ Even more about wibbly-wobbly-timey-wimey-stuff] [https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/intro/src/tpc/db2z_datetimetimestamp.html and more])
	*************** Datenanfang *****************************************************************************************		*************** Datenanfang *****************************************************************************************

Heiko: /* Create a database to play with */

2019-10-16T20:00:44Z

Create a database to play with

← Older revision		Revision as of 22:00, 16 October 2019
Line 11:		Line 11:
	* <code>CRTSRCPF FILE(ODBC/ODBCDB) RCDLEN(112) TEXT('Project ODBC and Database')</code> to create new physical file to hold the DDS.		* <code>CRTSRCPF FILE(ODBC/ODBCDB) RCDLEN(112) TEXT('Project ODBC and Database')</code> to create new physical file to hold the DDS.
	* <code>WRKMBRPDM FILE(ODBC/ODBCDB)</code> Work with this file.		* <code>WRKMBRPDM FILE(ODBC/ODBCDB)</code> Work with this file.
	* <code>F6</code> to create new member, insert member's name (<tt>ODBCDBPF</tt>) and the type <code>PF</code>:<br/>[[Image:ODBCDB01.png\|666px]]		* <code>F6</code> to create new member, insert member's name <code>ODBCDBPF</code> and the type <code>PF</code>:<br/>[[Image:ODBCDB01.png\|666px]]
	* Enter this DDS: ([https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzakc/rzakcdatel.htm Learn what the below means] [https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_74/rzasb/cpdtex.htm Especially time- and dateformats] [https://www.db2tutorial.com/db2-basics/db2-time/ Even more about wibbly-wobbly-timey-wimey-stuff] [https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/intro/src/tpc/db2z_datetimetimestamp.html and more])		* Enter this DDS: ([https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzakc/rzakcdatel.htm Learn what the below means] [https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_74/rzasb/cpdtex.htm Especially time- and dateformats] [https://www.db2tutorial.com/db2-basics/db2-time/ Even more about wibbly-wobbly-timey-wimey-stuff] [https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/intro/src/tpc/db2z_datetimetimestamp.html and more])
	*************** Datenanfang *****************************************************************************************		*************** Datenanfang *****************************************************************************************