DATE, TIME and TIMESTAMP fields in the database files
Hi I created DATE, TIME and TIMESTAMP fields in a physical file. But I donot know how to populate the values to these fields from a COBOL program. When I include the file in a cobol program, the date field comes as FILLER PIC X(10), the tome field comes as FILLER PIC X(8) and the [...]

Answer Question   |  November 9, 2005  7:22 AM
AS/400, Database, DB2 Universal Database, RPG

Reading a file twice in CL
I declared a file in CL. I read all the records, i.e End Of File has reached. Now again i want to read he file from beginning within the same program.I tried with OVRDBF and POSDBF.But could not succeed.Can any body help me?

Answer Question   |  November 18, 2009  6:53 AM
AS/400, Database, DB2 Universal Database, RPG

Accessing Oracle database on Linux from Mainframe
I want to read some data from Oracle 9i tables running on Linux machine. Can some ne help me as I am not very expert on mainframe systems Thanks.

Answer Question   |  November 19, 2005  3:23 AM
AS/400, DB2 Universal Database, Linux, Oracle

STRQMQRY not sum up the right total
I try to use STRQMQRY to pass in a variable to run a query. It works great except the query suppose to have a grand total, for some reason, it doesn’t add up right. When i run the query manually without using STRQMQRY, it works fine. Anyone know what do I have to do here? [...]

Answer Question   |  November 17, 2009  9:39 AM
AS/400, Database, DB2 Universal Database, RPG

Maximum program per trigger event
Hi, Can we have only one program per trigger event on a physical file? For example: On ABC file can we have one one trigger program for Update-After trigger event.

Answer Question   |  October 31, 2005  4:49 PM
AS/400, DB2 Universal Database, RPG

ODBC Connections to AS400 from HP-UX or Solaris systems.
I think I have the answer to this question, but I am trying to get confirmation on this. Is there IBM AS400 Client Access ODBC drivers to install on an HP-UX (Unix systems) or Solaris systems that would allow me to create ODBC connections to the AS400 from these systems? I have looked on IBM’s [...]

Answer Question   |  October 27, 2005  5:06 PM
AS/400, Database, DB2 Universal Database, RPG

Impact Analysis – None Answered till now
Hi all, I have a question and submitted long back. But till now i didn’t get any reponse. Task: If there is any change in the length of a field or a new field added into the existing file, we need to do some Impact Analysis which is time consuming.So i thought of developing a [...]

Answer Question   |  November 30, 2010  2:58 AM
AS/400, Database, DB2 Universal Database, RPG

Error executing stored procedure calling a CL that run an STRQMQRY
I have created a stored procedure that call a CLP in which there is a STRQMQRY for creating a file in output. this is the command of creation: CREATE PROCEDURE TESMC/WP3007P (IN SALD CHAR ( 1), IN ORDIN CHAR (1)) LANGUAGE CL NOT DETERMINISTIC MODIFIES SQL DATA EXTERNAL NAME ‘TESMC/WP3007′ PARAMETER STYLE GENERAL when I [...]

Answer Question   |  October 27, 2005  12:15 PM
AS/400, Database, DB2 Universal Database, RPG

MMAIL
Hello everyone, I recently downloaded the MMAIL Utility for Windows from http://www-922.ibm.com/mmailh/wmimemenu.htm I believe it installed successfully, but I get the following error for several functions like edit, display or open mime files. Error: “The value specified for one of the parameters is not valid for QZRUCLSP API.” Any help will be greatly appreciated. Joe [...]

Answer Question   |  November 16, 2009  9:58 AM
AS/400, Database, DB2 Universal Database, RPG

OPNDBF
This may sound stupid but I have not used OPNDBF command till now. I tried to use it thinking it will perform the same function as opening a database file in a COBOL program. I issued OPNDBF in a CL program and then tried to read records within a COBOL program without opening it in [...]

Answer Question   |  November 16, 2009  4:49 AM
AS/400, Database, DB2 Universal Database, RPG

Upgrade OS from V4R5 to V5R2 and SQL stopped working
Hi, We have just upgraded from V4R5 to V5R2 and have difficulty running an interactive SQL statement that worked fine at R4R5. The statement is as follows: update grmlib/mspmp100 as t1 set pmfp2=(select pmfp2 from grmlib/sin gupl2 as t2 where t1.prdno=t2.prdno and t2.pmfp2<>0) Previously this returned the following result: 674 rows updated in MSPMP100 in [...]

Answer Question   |  October 18, 2005  6:42 AM
Database, DB2 Universal Database

CPYTOPCD command.
Are any of you familiar with this command? Can this be used to copy something from the AS400 to a shared folder on a Windows system, or do any of you know how to accomplish this?

Answer Question   |  November 16, 2009  4:12 PM
AS/400, Database, DB2 Universal Database, RPG

AS/400 – iSeries SQL Update of on table with values from another joined table
I’ve use an SQL utility on the AS/400 call SEQUEL by ASC, that allows updating of values in one table from values in another joined table. The syntax is something like this: update set((a.fld1=b.fld1)(a.fld2=b.fld2)) from file1 a join file2 b on a.key1=b.key1 where a.key1='OnlyTheOneIWant' I no longer have access to the SEQUEL tool, and I’m [...]

Answer Question   |  May 8, 2013  1:34 PM
AS/400, DB2 Universal Database, SQL

CPYF in arrival sequence
Anyone know a quick and dirty to copy data from a keyed physical file to another physical in arrival sequence in a CLP program? I can’t find a native os/400 command that will do it.

Answer Question   |  November 15, 2009  1:28 PM
AS/400, DB2 Universal Database

ODBC Request from iSeries to Excel
I am trying to use an ODBC DSN I have created, that uses the iSeries Access for Windows Driver, to download data from a file in QUSRSYS, to Excel. I have to download from QUSRSYS because the file is IBM supplied. Note: QUSRSYS appears in QSYSLIBL system value. The problem I have is that unless [...]

Answer Question   |  November 15, 2009  9:54 AM
AS/400, DB2 Universal Database, Microsoft Office, SQL

AS400 SQL
Is anyone using a third party product that maes AS400 SQL easier and more user frienfly?

Answer Question   |  October 13, 2005  10:19 AM
DB2 Universal Database, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server

How to use API to access DB2 file on iSeries
Gredon would like to access (search, read, insert, update and delete) a DB2 file on the iSeries with an API. He said he’s searched the IBM manual, but he couldn’t find the APIs that he can use. Can you help him? – Michelle Davidson, editor, Search400.com

Answer Question   |  November 15, 2009  10:23 AM
AS/400, DB2 Universal Database

iseries prepared stored procedure call from ile rpg
how i call a dynamic(prepared) stored procedure from ILE RPG IV ?

Answer Question   |  October 7, 2005  12:19 PM
DB2 Universal Database, RPG ILE, SQL

AS400 File Transfer using RUMBA Office V 7.3.0
We use RUMBA Office V 7.3.0 for AS/400 Display. We would like to restrict certain users from using the RUMBA AS/400 to PC File Transfer. Is there a way we can do this from the 400? The only reason that I ask is that we are a corporation and have more than 70 AS/400′s. A [...]

Answer Question   |  November 21, 2011  9:30 AM
AS/400, DB2 Universal Database

SYSTEM OPENESS INCLUDES
Hello everyone, I wanted to install the OS/400 System Openness Includes (5722-SS1, opt13). I found 12 CD’s labeled 5722-SS1. I listed them below. I was wondering if someone knew which one to use to install the System Openness Includes. Any help is greatly appreciated. I_BASE-01 L2924_01 L2924_02 B2924_01 B2924_02 B2924_03 B2924_04 B2924_05 B2924_06 B2924_07 B2924_08 [...]

Answer Question   |  October 7, 2005  9:30 AM
AS/400, Database, DB2 Universal Database, RPG