Join Network
Categories
Archives
- Sort results by:
- Date
- Relevance
Podcast: What's New in DB2 on i?
What's the latest on DB2 for i? What does the future of our integrated database hold? Skip Marchesani from System i Developer (the folks who bring you RPG DB2 Summit) spoke with Mike Cain of IBM regarding the future of DB2 on i. I think it's safe to say ...
Updated IFSDIR UDTF Provides Create Date
... been using your IFSDIR tool to read IFS directories from SQL . It works nicely, letting me query different attributes and so forth. ...
Writing Overloaded SQL UDFs in RPG
... (UDF) is a routine that can be called from within an SQL statement, very... in SQL itself and in external languages such as RPG. External UDFs in RPG are ...
From the Forums: Breaking SQL Queries into Pages
... I/O (using the READ and READP opcodes in RPG) as well as SQL , using... SQL techniques posted to the various online forums that help you solve this ...
Using SQL’s Powerful CASE Statement
. SQL offers a similar method to RPG’s SELECT statement for executing code ... and END statements, which can be used to simplify your SQL work. The syntax...] [...]] [ELSE expressionN] END The CASE statement adds a powerful tool to your SQL arsenal... values, and help create totals in a SQL statement if you ...
UDTFs and Subfiles Make a Great Pair
... a great pair. What's a UDTF? A UDTF is a type of SQL ... typically list a column name. When SQL sees the UDF, it calls the routine and uses the returned value in place ...
SQL Server JDBC Driver Tip
... an open-source (free) JDBC driver for Microsoft SQL Server that performs better than the one from...-ready JDBC driver for SQL Server and Sybase" and states that it supports the following databases: ...
Easy400 Improves Support for Uploads
(photo_name)); photo_fo = SQFRD; exec SQL set option commit=*none,naming=*sys; exec sql Select count(*) Into :exists From EmpPhot where empno=:empno; if sqlstt= if exists 0; exec sql update EmpPhot set Photo=:Photo where empno=:empno; else; exec sql ...
JDBC from RPG with Unicode Support
, Microsoft SQL Server, Oracle) from an RPG program. By interfacing RPG with Java, I can ... JDBC_prepStmtC JDBC_prepStmt Prepare an SQL statement from a character string. JDBC_callStmtC JDBC_callStmt Prepare an SQL statement that calls a stored procedure from... from RPG Handle Null ...
MySQL and the DB2 Storage Engine for IBM i
of the SQL statements from the actual storage/retrieval of the data. By having ... engine, as shown in Figure 2 . Basically, MySQL has an SQL tier that performs the actual processing of the SQL statement. It parses the statement, validates the syntax, builds a ...