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...
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...
7525 pts.
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.
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.
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...
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...
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 module from...
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 module from...
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 ...
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 ...
Access Tab Control Problem
You need to put the tab control's name in there now. [Forms]![Sales Home]![Tab1]![ConvoQuery subform].Form![ConversationID]
View Answer
| Nov 20 2009 2:18 PM GMT
Access Forms Database, Access 2007 forms, Microsoft Access 2007
You need to put the tab control's name in there now. [Forms]![Sales Home]![Tab1]![ConvoQuery subform].Form![ConversationID]
View Answer
| Nov 20 2009 2:18 PM GMTAccess Forms Database, Access 2007 forms, Microsoft Access 2007
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...
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...
Msg 102, level 15, State 1, Line 14
Remove all the 'GO's that are inside the stored procedure body, and it should work.
Remove all the 'GO's that are inside the stored procedure body, and it should work.
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...
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...
SQL
No, SQL Server doesn't provide a way to prompt the user for input. You would have to write your own app which supported this. The native tools do not.
No, SQL Server doesn't provide a way to prompt the user for input. You would have to write your own app which supported this. The native tools do not.
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
Yes, here is a link that will explain how. http://newsgroups.derkeiler.com/Archive/Comp/comp.sys.ibm.as400.misc/2007-11/msg00250.html
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 Retrieve Identity of...
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 Retrieve Identity of...
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: For i = 0 To List1.ListCount - 1 If List1.Selected(i) = True Then MsgBox (List1.List(i)) End If Next i
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: For i = 0 To List1.ListCount - 1 If List1.Selected(i) = True Then MsgBox (List1.List(i)) End If Next i
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); ...
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); ...
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...
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...
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
| Nov 16 2009 3:28 PM GMT
Windows Server 2003 Enterprise Edition, Microsoft Access 2003, Visual Basic 6
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
| Nov 16 2009 3:28 PM GMTWindows Server 2003 Enterprise Edition, Microsoft Access 2003, Visual Basic 6
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...
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...
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...
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...
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...
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...
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++,...
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++,...
