To make the best decisions when it comes to data management you'll need to keep up on emerging technologies, such as DB2 UDB, data management tools, integration, BI, and much more. Let us help you find the resource you'll need.
Programmatically reduce database space
TIP :With the field level keyword VARLEN for Physical Files you can programmatically reduce the size of the database.
Is it a flat file or a database file?
ASK THE EXPERTS :If a legacy application is using RPG II to write data files to an iSeries 400 machine, are the files flat files instead of ...
Get the most out of your database
ASK THE EXPERTS :Can you recommend a good book or methodology to make sure that we get the
best performance out of our databases?
What MIB objects does DB2 UDB use?
ASK THE EXPERTS :I understand that DB2 UDB for AS/400 uses some of the RDBMS MIB objects and does not have a private MIB. Which objects does ...
>>
iSeries 400 file structures
ASK THE EXPERTS :Being an Integrated System, OS/400 and DB2/400 RDBMS are started
automatically when we start the iSeries 400 System.
Can I ...
Issue SQL statements to the DB2/400
ASK THE EXPERTS :I'm executing SQL statements through the Client Access ODBC driver against an iSeries V4R2M0. It works, but the time response ...
>>
Export\import data to DB2 on the iSeries
ASK THE EXPERTS :Is there a way to transfer a dBASE IV (.DBF file) file that contains memo
fields (.DBT file) to an iSeries 400 DB2 physical ...
>>
Creating a database that runs on the iSeries
ASK THE EXPERTS :I currently support a MS access procedure database on the Client/Server side and would like to know if there is any available ...
>>
Updating audit fields
ASK THE EXPERTS :I have a database file which has some audit fields on it: add date and
time, and update date and time (all numeric fields). ...
>>
Can you tell me a little about UDB?
ASK THE EXPERTS :I'm working with V5R1. My knowledge on UDB is very limited. I create my files with DDS or SQL Create Table, but what is the ...
>>
Combine colums on a DB2 table
ASK THE EXPERTS :There are three separate columns on a DB2 table that have to match the
corresponding input info that I have to pull off the ...
>>
Is it possible to re-use deleted records?
ASK THE EXPERTS :If I use 're-use deleted records' on a database file, what impact on performance should I expect? If the performance is not ...
>>
Extract data from files on the AS/400
TIP :Here's a simple method to extract data from files on the AS/400 and make the results available on another platform.
Dynamically reorganizing DB2 files
TIP :Learn how information can be extracted from DB2 files and used to reorganize members when deleted records exist.
iSeries and AS/400 SQL at Work Price: $ 84.55
This book will show you how to make SQL work in your business environment. It contains the AS/400 query optimizer, advanced ...
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.
