Home > AS/400 Featured Topic
EMAIL THIS
 Featured Topic:  Expert advice on DB2
Last Updated: Jun 29, 2007 
Need a little help using DB2/400 or DB2 UDB? IBM's Kent Milligan shares his experience in these top 10 expert Q&As.
>> Ask Kent your DB2-related questions, or view previous Q&As.
>> Expert webcast: DB2 UDB for iSeries -- V5R2 enhancements
DB2/400 DB2 UDB Fact or Fiction?

(03 Jun 2004)

DB2 expert Kent Milligan provides advice to Search400.com's members on a regular basis. Do you feel you're also a DB2 guru? Test your knowledge against some of Kent's recent Q&As below. Mark each question with either a True or False. Jot down your answer on a piece of paper, and then click over to the answer sheet to see if you agree with Kent's answer.

Read Full Story
ADVICE:
>> DB2 Information Integrator
ASK THE EXPERTS : I currently have VB 6.0 applications that access Oracle databases and write the data to an iSeries. We have a growing ...
>> Do DB2 UDB servers support a library list?
ASK THE EXPERTS : I connected through to DB2 on OS/390 for the first time with the iSeries using connect statement. I then issued a ...
>> Using Crystal Reports against iSeries databases
ASK THE EXPERTS : I have a prospect that is used to running Crystal Reports on a PC. Do Crystal Reports work on accessing data on an ...
>> Converting dates in character fields
ASK THE EXPERTS : We have files that have dates in character fields in the format "mm/dd/yy". The dates are stored in character ...
>> Saving an address in the iSeries database
ASK THE EXPERTS : How do I save an address -- a pointer value -- in the iSeries database? I'm trying to do it from a RPG program.
>> Creating a date field using SQL
ASK THE EXPERTS : I've created a table using SQL with a date field. I've used STRPDM to view the data in the date field and found ...
>> Connecting to a remote database using SQL
ASK THE EXPERTS :How can I make a connection to a remote database using SQL 400 specifying the database name and the machine where it is?
>> What is dynamic join?
ASK THE EXPERTS :Can you please explain what a dynamic join is? Dynamic selection is only possible in OPENQRYF and embedded SQL. When we use ...
>> When must I journal a table?
ASK THE EXPERTS :My application accesses and manipulates data in DB2 on the iSeries. I encountered SQL error 7008; I then started to journal ...
>> Auditing indexes on the iSeries
ASK THE EXPERTS : I manage an iSeries that serves as the enterprise server for a large ERP package. Over the ...

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
DB2 UDB for iSeries
Make your database easy to read
Top 10 tips from our experts
DB2 expert Kent Milligan offers advice
Schedule stored procedures in DB2 UDB
Special features make creating tables simple
How to use DB2's cross-reference files to help manage your database -- Part II
How to use DB2's cross-reference files to help manage your database -- Part I
Revisit your database naming conventions
DB2/400 and DB2 UDB
'Twas the Night Before Christmas in IT

DB2 UDB (universal databases)
How to: Sort arrays using RPGIV
Debating DB2 versus Oracle
IBM i news updates for the week of 10/13/2008
Auditing: RPG with embedded SQL showing up as a changed object
DB2 on AS/400: What has it done for me lately?
How to: Transfer unlimited data to Excel from AS/400
What is an integrated database?
An automated CL method of moving a query from AS/400 to Excel
Using WebSphere information integrator to access MS server data using SQLRPGLE
Querying system catalog tables to determine table alias
DB2 UDB (universal databases) Research

Oracle on iSeries
Debating DB2 versus Oracle
IBM steps up iSeries, pSeries overlap
Securing query definitions
New, undocumented Query function can boost your productivity
Get the system to recognize a date separator
Run multiple SQL statements
Populate a Lotus Notes database with iSeries data
Updating the 'VALUE' column using DB2/400
Inserting data into a table
Is the SQL Path being used?

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary

> iSeries backup and recovery
> Understanding stored procedures
> System i user groups: Find one nearest you
> Top 10 System i white papers
> Looking at LPAR
View full list of Featured Topics

HomeNewsTopicsITKnowledge ExchangeTipsBlogsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 1999 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts