Home > AS/400 Featured Topic
EMAIL THIS
 Featured Topic:  Expert advice on SQL
Last Updated: Aug 04, 2005 
Search400.com's SQL-savvy experts are on hand to answer your toughest questions. Some recent Q&As include, accessing data, improving SQL performance, embedding SQL and more. >> 20 SQL tips in 20 minutes
ADVICE:
>> Access data on an SQL server from the iSeries
ASK THE EXPERTS : I need to access data on an SQL server from our iSeries. I'm not sure where to start. Can you direct me?
>> Audit the interactive SQL session
ASK THE EXPERTS :How can I logging or audit the interactive SQL session, without the users knowing?
>> BETWEEN clause -- faster or slower SQL Performance?
ASK THE EXPERTS :My experienced mainframe DB2 colleagues have warned me that coding the predicate "WHERE part_no IS BETWEEN :foo AND :bar" is ...
>> Creating SQL views
ASK THE EXPERTS : Is there a way to create a SQL view where fields are dynamically obtained each time the View is used. I am trying to ...
>> How do you read a formatted dump of an SQL RPGLE program?
ASK THE EXPERTS :How do you read a formatted dump of an SQL RPGLE program and what do you look for? For example, I received an error message ...
>> Which is preferred: logical file or embedded SQL?
ASK THE EXPERTS :Would it be faster to create a logical or embedded SQL in the following cases? First, I have a physical file that has 100 ...
>> Run multiple SQL statements
ASK THE EXPERTS : How can I run multiple SQL statements within interactive SQL? I have tried using the :, " ,;, but it will not recognize ...
>> Is the SQL Path being used?
ASK THE EXPERTS : I am running interactive SQL (STRSQL) on iSeries at V5R1 set path a73dta2 PATH statement complete.
 select ... 
>> Calling an RPG LE program from a SQL trigger procedure
ASK THE EXPERTS : Is it possible to call an RPG LE program from SQL trigger procedure? Sample of SQL trigger:
Create trigger ...
>> Embedding SQL into RPG LE programs
ASK THE EXPERTS : We have an iSeries running V5R3. We're working on embedding SQL into RPG LE programs and then creating stored ...

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


RELATED CONTENT
SQL & Query
Fast guide to iSeries SQL
Audit the interactive SQL session

iSeries SQL commands and statements
Enhancing RPG with external SQL stored procedures
Tracking data changes on IBM i with triggers
Introduction to SQLRPGLE on IBM i: Making a report
Making the most of RPG data handling on IBM i
When is the YES option for 'reuse deleted files' function the best choice?
Monitoring members 'stuck' within a physical file on an EDI system
Creating a host variable of the 'where in' statement in SQL
SQL server error message -321
Choose which column names are returned via ODBC when working with DB2 files
Convert a numeric physical file to a character in SQL without leading zeros
iSeries SQL commands and statements Research

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 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.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




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