OVRDBF in JAVA
Execute command OVRDBF MYFILE OTHERMBR where OTHERMBR is the one you wish to insert records into. Do this before doing anything with SQL. ========================================================== An ALIAS might be a good idea, but be aware that it creates a permanent (SQL) object. An OVRDBF might be needed, especially if the member name is variable. If creating [...]

View Answer   |  November 25, 2009  2:08 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, Printing, RPG, RPGLE, Security, Web development

JDBC connection to DB2/400
There is no maximun number of connections. If your running the application now, then the question is are you have any performance issues? If you are, then you need to to the analysis to determine the cause and cure.

View Answer   |  November 24, 2009  10:29 PM
DB/400, DB2/400, JDBC

To retrieve data from a remote system
One of my clients used to use Sockets for communicating between an AS400 and a Unix box and that worked very well. I keep meaning to “have a go” with socket programming and have seen a lot of good press on Scott Klement’s tutorial at http://www.scottklement.com/rpg/socktut/index.html Hope it helps Jonathan ================================================ Since there have been [...]

View Answer   |  November 23, 2009  8:07 AM
390, Application development, AS/400, AS/400 careers, Backup & recovery, Billing and customer care, Billing Support Systems, CLP, DataCenter, DB2, DB2 Universal Database, Development, Email, IBM Marketing Sound Off, Mainframe, Mobile, Mobile security, Network protocols, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, VoIP, Web development, Wireless, zSeries

Using SQLRPG on a DDM File
Ruwan… The only way I know to do this is to issue an SQL “CONNECT” statement to attach to the remote database. This can be done within an SQLRPG pgm, but you will need to compile the program against the remote database (see the compile prompts). You may want to do this in a separate [...]

View Answer   |  November 22, 2009  9:59 AM
DB2 Universal Database, RPG, RPGLE

Updating a VSAM file
Optimally, I’d think that you want to mount the file as a remote file on the 400, then use standard record operations to do the job, without involving the program on the Z side. — Sheldon Linker Linker Systems, Inc. www.linkersystems.com sol@linker.com 800-315-1174 +1-949-552-1904 ========================================================== “Remote file” might best be restated as DDM/DRDA. Add the [...]

View Answer   |  November 21, 2009  9:05 PM
AS/400, DB2 Universal Database

What is correct syntax for SQL for Maxrecords in OS400/DB2?
I don’t believe that MAXRECORDS is part of the “SQL Standard”. I know a few databases (big ones included) have implemented it, but it’s not a part of DB2. I believe it can be set as a property on OLE and ADO DB providers. sorry =================================================== Your automatic generator doesn’t generate standard SQL. It generates [...]

View Answer   |  November 20, 2009  8:44 AM
AS/400, DB2 Universal Database, SQL Server

Msg 102, level 15, State 1, Line 14
Remove all the ‘GO’s that are inside the stored procedure body, and it should work.

View Answer   |  November 19, 2009  7:09 PM
CREATE TABLE statement, SQL, Stored Procedures

foxpro 2.6 on windows 98
Your program call stack is too big. You must have a program (do xxx.prg) calling another program (do yyy.prg) repeated 16 times. Besides the design issues, this makes it tough to debug. Good luck………KM (www.MurphySoftware.net) —————- check either of the two: 1. in one of the endless or ‘repeating too much’ loop you have given [...]

View Answer   |  November 19, 2009  6:32 AM
FoxPro, FoxPro 2.6, Windows 98

inactive timeout different for one user
Yes, here is a link that will explain how. http://newsgroups.derkeiler.com/Archive/Comp/comp.sys.ibm.as400.misc/2007-11/msg00250.html

View Answer   |  November 18, 2009  5:46 PM
AS/400 user sessions, Timeout

How do I retrieve the JOB/USER/NBR for a spoolfile generated by a GUI program?
I suggest that you use rtvjoba OR qusrjobi, not both in the same time. Try with WRKUSRJOB command, read help for this command, and it will work. (Some similar things work for me with WRKUSRJOB) ==================================================== You probably want to use the <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/apis/QSPRILSP.htm”>Retrieve Identity of Last Spooled File Created (QSPRILSP) API</a>. But you might [...]

View Answer   |  November 18, 2009  7:19 AM
AS/400, Database, DB2 Universal Database, RPG

To trap the item name of more than one item selected in list control
For your first requirement, you can use the SELECTED property. You could move through the elments in the items array, and check whether they are selected or not. Try this: <pre>For i = 0 To List1.ListCount – 1 If List1.Selected(i) = True Then MsgBox (List1.List(i)) End If Next i</pre>

View Answer   |  November 17, 2009  11:28 PM
Microsoft Access, SQL, Visual Basic 6.0

DECFLOAT – Internal Format
Hello, I am not sure what you mean by “visual format.” I will take a guess that you want a floating point number to be returned to your application as a decimal number. Use the DECIMAL function. For example: CREATE TABLE TTEST (F_COL FLOAT); ———+———+———+———+———+———+—– DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 INSERT INTO [...]

View Answer   |  November 17, 2009  6:42 PM
DB2, DB2 9, DB2 administration, DECFLOAT, z/OS

Daylight Savings Time Change
The speed-up and slow-down clock process is a hardware function. It works that way only on i5 hardware (model 520 570 etc.) If you have V5R3 on a 170 or 720 or even an 8xx box it will just SLAM it back) ========================================================== It doesn’t matter what hardware or model is involved; the result is [...]

View Answer   |  November 17, 2009  7:38 AM
AS/400, Database

Microsoft Access 2003 slow on Windows Server 2003 Enterprise
Yes, I am having the same trouble. I have tried everything that I can think of including changing my entire network to Gigabit. Has anyone found the solution?? I am also running Access 2003 and Server 2003 Enterprise.

View Answer   |  November 16, 2009  3:28 PM
Access 2003, Microsoft Access 2003, VB 6, Visual Basic 6, Windows Server 2003, Windows Server 2003 Enterprise Edition

OPNDBF
You’ll have to do an OVRDBF with SHARE(*YES) and then the COBOL will still need the OPEN. It’s just that the OPEN won’t really have to do anything when it’s executed. i.e., no open data path (OPD) will be created. ============================================================== The OPNDBF will create an ODP. If shared, the COBOL OPEN can use the [...]

View Answer   |  November 16, 2009  12:51 AM
AS/400, Database, DB2 Universal Database, RPG

CPYTOPCD command.
it is not the good command, youy have to copy your file to QNTC disk system, not QDLS disk system; use CPYTOSTMF to copy to QNTC look at http://www.iseriesnetwork.com/Forums/Index.cfm?CFApp=55&Message_ID=113086 ===================================================== To copy a streamfile from the IFS to a share on a Windows system, use they CPY command. To copy an externally described database file, [...]

View Answer   |  November 15, 2009  7:38 AM
AS/400, Database, DB2 Universal Database, RPG

CPYF in arrival sequence
Try messing with the ACCPTH(*ARRIVAL) parameter on OPNDBF. OPNDBF FILE(file) OPTION(*INP) ACCPTH(*ARRIVAL) OVRDBF FILE(file) SHARE(*YES) CPYF… DLTOVR FILE(file) CLOF FILE(file) I’ve not actually tried this but give it a go. CPYF does not ignore overrides so it should use the shared access path already opened in arrival sequence by the OBNDBF command. ========================================================== CPYF FROMRCD(1) [...]

View Answer   |  November 15, 2009  5:19 AM
AS/400, DB2 Universal Database

How to use API to access DB2 file on iSeries
The key to understanding how to do this is that DB2 tables are AS/400 files. (Actually, they’re members of AS/400 files, but generally there is only one member in the file.) So, to access these tables, you open the file, define records as you usually define records in RPG or structures in C/C++, use record [...]

View Answer   |  November 15, 2009  3:42 AM
AS/400, DB2 Universal Database

Triggers and commitment control
In my opinion, you have mixed two tools that realy are not linked. first is triggers. triggers are on proccess side : for example if you had no triggers, you would have called the progs yourself. A trigger is a program you call, but not directly, you are just the trigger event, is is enough. [...]

View Answer   |  November 14, 2009  1:09 PM
AS/400, DB2 Universal Database, RPG

“map drive” IFS
So if I understand correctly… - You have created “shares” using iSeries Navigator? (i.e. a share named “root” for the / directory, a share named “test” for /home/jdoe/test, and so on) - And using “net use X: QS6555A8Aroot” or “net use Z: QS6555A8Atest” in a DOS box on a client PC doesn’t work? Very strange [...]

View Answer   |  November 14, 2009  12:44 PM
390, Access, AS/400, Backup & recovery, Data analysis, Database, DB2, DB2 Universal Database, Desktops, Development, Hardware, IBM, Mainframe, Management, Microsoft Office, Microsoft Windows, OS, RPG, Security, Servers, SQL Server, Storage, Tech support