https://doc.sibvisions.com/ 2026-04-17T13:49:46+00:00 https://doc.sibvisions.com/ https://doc.sibvisions.com/lib/tpl/material/images/favicon.ico text/html 2025-06-23T13:42:49+00:00 https://doc.sibvisions.com/jvx/server/db/as400?rev=1750686169&do=diff We support most operations of DB2 on IBM i series but it depends on your configuration. If you don't use journaling, it's not possible to update/delete records. If you work with journaling it's not possible to drop or alter columns. But this shouldn't be a big deal for developers. text/html 2020-06-29T13:06:08+00:00 https://doc.sibvisions.com/jvx/server/db/func_proc?rev=1593435968&do=diff If you use database procedures and/or functions in your application, wouldn't it be great to call them with one simple call? Normally, a function or procedure call is very complex because you have to define a CallableStatement, set the output parameters, execute the statement, and read the result. And don't forget that the parameter index starts with 1 instead of 0! text/html 2020-06-29T13:00:13+00:00 https://doc.sibvisions.com/jvx/server/db/table_functions?rev=1593435613&do=diff Table or pipelined functions are a cool thing. Use them to dynamically create records directly -- without a physical table -- in the database with all available database features. Not all database systems support table functions but Oracle and PostgreSql do. Here's an example for a table function with Oracle.