iSeries database management
New & Notable
Advance your data center career by mastering these 5 IT Skills
Maintaining an IT skill set that is up-to-date is essential, not just to maintain your career, but to advance it as well --otherwise you risk falling behind in this fast-paced, extremely competitive IT job market. Access this 25-page guide for expert insight, career forecasts and tips you need to know to keep your IT skills sharp.
iSeries database management News
-
August 03, 2006
03
Aug'06
IBM releases DB2 email archiving hardware and software
IBM announced the release of its DB2 CommonStore Email Archiving Solution, an appliance that SMBs with little to no IT staffs can install quickly and easily.
-
June 15, 2006
15
Jun'06
DB2 Viper to boost XML capabilities
Analysts say the big plus for the System i in IBM's DB2 Viper release, is its ability to leverage XML for service-oriented architectures
-
December 12, 2005
12
Dec'05
Unstructured info management on the iSeries
Big Blue unveiled new software for iSeries shops that want to get more out of unstructured information, such as call center notes, e-mails and printed documents.
-
November 10, 2005
10
Nov'05
DB2 trivia challenge
Test your knowledge!
iSeries database management Get Started
Bring yourself up to speed with our introductory content
-
Running AS/400 query to find records based on date
Learn about a quick way of running an AS/400 query to select records based on current sysdate. Continue Reading
-
Tracking data changes on IBM i with triggers
Triggers can be implemented on the AS/400 using a high-level language or SQL and can be used to enforce business rules or validating input data. Learn how to use DB2 triggers as a means of auditing data inserts, deletes or changes. Continue Reading
-
Convert a numeric physical file to a character in SQL without leading zeros
In SQL, when converting a numeric physical file to digits, pass the results of the DIGITS function through the STRIP function in order to avoid leading zeros. Continue Reading
Evaluate iSeries database management Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
-
Choose which column names are returned via ODBC when working with DB2 files
When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC because SQL-based interfaces use the long column name by default. Continue Reading
-
Developing tables in a parent-child relationship in DB2
When developing tables in a parent-child relationship, use a primary key and a foreign key along with a unique ID to make your database easier to maintain over time. Continue Reading
-
When is the YES option for 'reuse deleted files' function the best choice?
IBM did not change the default of the reuse deleted files function to YES for physical files in order to minimize the impact on any existing applications that may have dependencies on deleted records that are not being used. However, there there are... Continue Reading
Manage iSeries database management
Learn to apply best practices and optimize your operations.
-
Connecting multiple iSeries systems through DDM
Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed data management (DDM). Continue Reading
-
Blocking access to SQL line commands
You may think that blocking access to SQL line commands will protect your data. However, Carol Woodbury warns that object level security is the only real way to keep your data safe from unwanted manipulation. Continue Reading
-
How to select disk drives for DBMS
This tip offers suggestions about what to take into account when choosing disks for database management systems. Continue Reading
Problem Solve iSeries database management Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
-
Enhancing RPG with external SQL stored procedures
Registering an external SQL stored procedure and leveraging RPG with your creation allows for increased flexibility in dealing with numerous types of data. Continue Reading
-
Introduction to SQLRPGLE on IBM i: Making a report
Using RPG ILE with embedded SQL can be a fast way to make database reports on the IBM i. Joe Pluta shares the code of his first SQLRPGLE program. Continue Reading
-
Making the most of RPG data handling on IBM i
By virtue of being bult-in to the AS/400, RPG has speed for some operations that SQL cannot touch. Learn how RPG works with indexing to retrieve data from your IBM i. Continue Reading