Expert advice on SQL

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

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

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