|
|
Tips & Techniques -
Database
|
|
Written by Mike Pavlak
|
|
Friday, 22 May 2009 00:00 |
|
Both a primer and a reference, this book is a must-have for anyone who wants to program in PHP. By Mike Pavlak After developing Web solutions for the iSeries in Net.Data and then getting a sour taste from Java, I wanted something better. PHP was certainly the right choice, but making it run on an iSeries at the time was no small feat. Then Zend came to the table, and the rest, as they say, is history. There is no way any of us on the ground floor of this amazing union could have anticipated this level of excitement and interest. We continue to see huge numbers being drawn to PHP on IBM i as well as Linux, UNIX, and Windows. And this book comes at just the right time; it's both a primer and a reference. |
|
Last Updated on Friday, 22 May 2009 06:36 |
|
Read more...
|
|
Tips & Techniques -
Database
|
|
Written by Floyd Del Muro
|
|
Thursday, 21 May 2009 10:00 |
|
Is your BI solution hard to install and difficult to use? By Floyd Del Muro Is your data out-of-date and your report backlog still a backlog? Is your BI technical department larger than two people, and do they spend most of their time redefining your data to make the solution work? Does your technical team spend hours upon hours installing program fixes? Does your solution work with only one database, and is it too complicated to allow end users to write their own inquiries? Do you have to pay more any time you want to do more? Is your BI solution meeting your needs? |
|
Last Updated on Tuesday, 26 May 2009 08:10 |
|
Read more...
|
|
Tips & Techniques -
Database
|
|
Written by KENT MILLIGAN
|
|
Thursday, 12 March 2009 18:00 |
|
The overhead that a monitor can place on disk and I/O subsystems is no longer the problem it used to be.  By Kent Milligan
Starting a Database Monitor on your server is quite simple, whether you're using the STRDBMON CL command or the System i Navigator graphical interface. The challenging part of a Database Monitor is minimizing the overhead that a monitor can place on disk and I/O subsystems while it's writing the collected data. |
|
Last Updated on Thursday, 21 May 2009 11:28 |
|
Register to read more...
|
|
Tips & Techniques -
Database
|
|
Written by Tom Huntington
|
|
Thursday, 19 February 2009 18:00 |
|
Can you provide remote database access from IBM i?  By Tom Huntington Where is your business data? Is it all in IBM i DB2, or do you have data in MySQL, Microsoft SQL Server, or maybe an Oracle database? Do you need to consolidate this data across DB2 partitions? Does your current reporting and data access solution consolidate and provide instant access to this remote data? |
|
Register to read more...
|
|
Tips & Techniques -
Database
|
|
Written by Michael Sansoterra
|
|
Thursday, 23 October 2008 18:00 |
|
Give users offline access to DB2 data in a versatile pivot table format. By Michael Sansoterra In "Crunching AS/400 Data with OLAP Cubes and Excel 2000," I outlined how to use the Pivot Table wizard with Excel 2000 (and higher) to create pivot tables from DB2 data using an ODBC data source. This TechTip will go a step further. |
|
Last Updated on Thursday, 21 May 2009 11:28 |
|
Register to read more...
|
|
Tips & Techniques -
Database
|
|
Written by Michael Sansoterra
|
|
Thursday, 09 October 2008 18:00 |
|
Data replication chores are a snap with the new MERGE T-SQL statement. By Michael Sansoterra Released in August 2008, SQL Server 2008 is the latest incarnation of Microsoft's flagship database platform. While there are some cool new features for developers, there is one for DB2 developers that deserves special mention: the new Transact SQL (T-SQL) MERGE statement. MERGE will be useful to any IBM i (aka AS/400, iSeries, System i) shop that needs to replicate DB2 for i (formerly known as DB2 for i5/OS and DB2/400) data to SQL Server. This includes shops that use SQL Server for reporting, data warehousing. and application data sharing. |
|
Last Updated on Thursday, 09 October 2008 09:55 |
|
Register to read more...
|
|
Tips & Techniques -
Database
|
|
Written by Tom Huntington
|
|
Tuesday, 09 September 2008 18:00 |
|
And now your IT staff needs an easy-to-implement solution. By Tom Huntington Do you provide users with a modern "look and feel" for System i data? Are users telling you that green-screen reports are unacceptable? Is your backlog of text-based reports overwhelming? Is your data warehouse project over budget, past due, and unsatisfying to users? Are you confused about what tools to use to access System i business data? In April 2007, IBM announced that Query/400 is outdated. This exciting announcement confirms what we've been saying all along: your System i (AS/400, iSeries) database has a wealth of information that should be harnessed into executive decision-making tools without using another platform. |
|
Register to read more...
|
|
Tips & Techniques -
Database
|
|
Written by Tyler Even
|
|
Thursday, 04 September 2008 18:00 |
|
What do you do when you need to create a field that's a calculated value based on real data?  By Tyler Even If you've used the DB2 Web Query for IBM i development tools, you may have noticed the ability to create two types of virtual fields: defined fields and computed fields. Often, when building a report, you need to create a field that is not in the original database but is instead a calculated value based on real data. For example, "gross profit" may not actually exist in your data, but it can be calculated from revenue and cost values. Each virtual field type has its own distinct advantages and purpose in report development. This TechTip uses a real-world example to illustrate when you should use which field type. |
|
Last Updated on Wednesday, 03 September 2008 07:13 |
|
Register to read more...
|
|
|
<< Start < Prev 1 2 3 4 5 6 7 Next > End >>
|
|
Page 1 of 7 |
