1
Track SQL Statements run by a specific user through ODBC Connection
There is a user id connecting to our iSeries System through ODBC Connection and will be executing some selected queries on iSeries using a 3rd Party Application. Those selected queries are approved by the Application Owner. Hence we would like to track the SQL Statements which are executed by this id on daily basis to [...]
Answer Question
| March 31, 2012 6:45 AM
iSeries DB2, SQL statements
There is a user id connecting to our iSeries System through ODBC Connection and will be executing some selected queries on iSeries using a 3rd Party Application. Those selected queries are approved by the Application Owner. Hence we would like to track the SQL Statements which are executed by this id on daily basis to [...]
Answer Question
| March 31, 2012 6:45 AM
iSeries DB2, SQL statements
Dropping a DB2 Stored Procedure
In my DB2 stored procs I always first drop the procedure and then do a create statement. Is there any way I could say something like…if exists (select * from sysroutines where routine_name = ‘procname’) then drop procedure procname; ? I tried this, but the proc doesn’t like the IF statement as the first line. [...]
Answer Question
| October 15, 2009 5:32 PM
AS/400 stored procedures, DB2 stored procedures, iSeries DB2
In my DB2 stored procs I always first drop the procedure and then do a create statement. Is there any way I could say something like…if exists (select * from sysroutines where routine_name = ‘procname’) then drop procedure procname; ? I tried this, but the proc doesn’t like the IF statement as the first line. [...]
Answer Question
| October 15, 2009 5:32 PM
AS/400 stored procedures, DB2 stored procedures, iSeries DB2
Conversion of SQL Server 2000 to iSeries DB2 V6R1
Hi there. We are converting SQL Server 2000 to DB2 on iSeries V6R1. We’re ok with the JDE tables and views, but are having difficulty with the non-JDE tables, views, and stored procedures. Is there a tool or something that could help us? Thank you.
Answer Question
| October 24, 2009 7:50 PM
DB2, iSeries DB2, SQL Server 2000, SQL Server to iSeries Database, V6R1
Hi there. We are converting SQL Server 2000 to DB2 on iSeries V6R1. We’re ok with the JDE tables and views, but are having difficulty with the non-JDE tables, views, and stored procedures. Is there a tool or something that could help us? Thank you.
Answer Question
| October 24, 2009 7:50 PM
DB2, iSeries DB2, SQL Server 2000, SQL Server to iSeries Database, V6R1
SQL script output to a file
I am running ad hoc SQL scripts in iSeries Navigator (V5R4) and need to direct the output to a text file. Is there a way to do this? TIA… Steve B
Answer Question
| December 15, 2008 4:54 PM
AS/400 database, AS/400 DB2, iSeries database, iSeries DB2, iSeries Navigator, SQL scripts, V5R4
I am running ad hoc SQL scripts in iSeries Navigator (V5R4) and need to direct the output to a text file. Is there a way to do this? TIA… Steve B
Answer Question
| December 15, 2008 4:54 PM
AS/400 database, AS/400 DB2, iSeries database, iSeries DB2, iSeries Navigator, SQL scripts, V5R4
AS/400 and Oracle Access Manager
I have a strange behavior in an SQLRPGLE program accessing iSeries DB2 and Oracle via Oracle Access Manager. The program is very simple and reads values from two Oracle Tables in this way : a. SELECT …. into ….. FROM Table1 WHERE ….. return OK : 1 row as expected with my two fields filled. [...]
Answer Question
| April 22, 2010 3:58 PM
AS/400, DB2, iSeries DB2, Oracle Access Manager, RPGLE, SQL, SQLRPGLE
I have a strange behavior in an SQLRPGLE program accessing iSeries DB2 and Oracle via Oracle Access Manager. The program is very simple and reads values from two Oracle Tables in this way : a. SELECT …. into ….. FROM Table1 WHERE ….. return OK : 1 row as expected with my two fields filled. [...]
Answer Question
| April 22, 2010 3:58 PM
AS/400, DB2, iSeries DB2, Oracle Access Manager, RPGLE, SQL, SQLRPGLE
1
