The most-watched IT questions this week: Nov. 24, 2009
Is this a question? Is it relevant to post it here in Home > IT Answers > AS/400 > The most-watched IT questions this week: Nov.... just wondering!
Is this a question? Is it relevant to post it here in Home > IT Answers > AS/400 > The most-watched IT questions this week: Nov.... just wondering!
6810 pts.
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...
How do I confirm all the data moved from Source to target for different tables
With SQL. use the Select COUNT(*) option for each of the tables in both the source and target system. That will tell you if your record count is correct. * If you want to get to the record level, you can do a EXCEPTION JOIN
With SQL. use the Select COUNT(*) option for each of the tables in both the source and target system. That will tell you if your record count is correct. * If you want to get to the record level, you can do a EXCEPTION JOIN
as/400 query printing with DBCS data
What software did you upgrade? If it was working before and not now, check with the vendor of the software.
What software did you upgrade? If it was working before and not now, check with the vendor of the software.
Business Agility
It is like wanting one part of the body to be Agile and rest as it is. Will the complete body be in sync or function properly? No. similarly the complete organization has to adopt agile approach instead of focusing just on IT to be Agile.
It is like wanting one part of the body to be Agile and rest as it is. Will the complete body be in sync or function properly? No. similarly the complete organization has to adopt agile approach instead of focusing just on IT to be Agile.
Help with VB Script to delete old files and subfolders
A function to delete empty folders could be like this: Function DeleteEmptyFolders(foldername) For Each Folder In fso.GetFolder(foldername).SubFolders DeleteEmptyFolders(Folder.Path) If Folder.Files.Count = 0 and Folder.SubFolders.Count = 0 Then fso.DeleteFolder(Folder.Path) End If Next ...
A function to delete empty folders could be like this: Function DeleteEmptyFolders(foldername) For Each Folder In fso.GetFolder(foldername).SubFolders DeleteEmptyFolders(Folder.Path) If Folder.Files.Count = 0 and Folder.SubFolders.Count = 0 Then fso.DeleteFolder(Folder.Path) End If Next ...
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...
sql help
The way you cited, update table/detail set condition = 'r' where condition = ' ' and number_d = (select number_h from table/header where date between 050101 and 051231) is one way to do it. Here's a more efficient way, especially if number_h is indexed: UPDATE...
The way you cited, update table/detail set condition = 'r' where condition = ' ' and number_d = (select number_h from table/header where date between 050101 and 051231) is one way to do it. Here's a more efficient way, especially if number_h is indexed: UPDATE...
Using open source software for commercial purposes
That will depend on the software license. You should read the license for the specific software you want to use, in order to know if you can use it for commercial purposes. --------------------- usually open source projects are meant for unconditional public use
That will depend on the software license. You should read the license for the specific software you want to use, in order to know if you can use it for commercial purposes. --------------------- usually open source projects are meant for unconditional public use
Project Charter
ShakeelSoft, a project charter should be a one page summary which identifies who the project sponsors are, what the business need is, what is in- and out-of-scope, what criteria measures the project's success, deliverables, constraints and a sign-off of key individuals ------------------- read...
ShakeelSoft, a project charter should be a one page summary which identifies who the project sponsors are, what the business need is, what is in- and out-of-scope, what criteria measures the project's success, deliverables, constraints and a sign-off of key individuals ------------------- read...
QSH error "find: 001-2191 The ending ';' character was not found.".
I am unfamiliar with qshell as well. But, if you are looking for a programmatic way to clean up the IFS, you might want to check out this site. http://www.scottklement.com/rpg/ifs_ebook/ I have downloaded the code and modified per our needs and it works well. ...
I am unfamiliar with qshell as well. But, if you are looking for a programmatic way to clean up the IFS, you might want to check out this site. http://www.scottklement.com/rpg/ifs_ebook/ I have downloaded the code and modified per our needs and it works well. ...
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.
Upgrade the Oracle Client to 10i from 8.1 without losing database connectivity?
If your actual database is version 8.1, then you can't! The highest client that will still connect to an 8.1 database is 9i, so you either have to use that, or upgrade your database. If your database is a higher version, then you can just install the latest client on your machine, in which case,...
If your actual database is version 8.1, then you can't! The highest client that will still connect to an 8.1 database is 9i, so you either have to use that, or upgrade your database. If your database is a higher version, then you can just install the latest client on your machine, in which case,...
How to encrypt a big list of sp's at once
No there isn't. You have to do an ALTER PROCEDURE specifying the WITH ENCRYPTION option. Do keep in mind that this encryption is very easy to undo. There are plenty of freeware software packages out there to decrypt the procedures. It also makes things look very unfriendly to the DBA when you...
No there isn't. You have to do an ALTER PROCEDURE specifying the WITH ENCRYPTION option. Do keep in mind that this encryption is very easy to undo. There are plenty of freeware software packages out there to decrypt the procedures. It also makes things look very unfriendly to the DBA when you...
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
data search using popup window
You should be able to modify this to do what you need. A*%%TS SD 20081210 094755 REL-V5R4M0 5722-WDS A*%%EC A DSPSIZ(24 80 *DS3) A PRINT A INDARA A ...
You should be able to modify this to do what you need. A*%%TS SD 20081210 094755 REL-V5R4M0 5722-WDS A*%%EC A DSPSIZ(24 80 *DS3) A PRINT A INDARA A ...
C API to user32.dll in Notes eclipse 8.x does not work
Resolved! http://www-10.lotus.com/ldd/nd85forum.nsf/DateAllThreadedWeb/e959d2f5f69a4d5085257671005ebbd5?OpenDocument
Resolved! http://www-10.lotus.com/ldd/nd85forum.nsf/DateAllThreadedWeb/e959d2f5f69a4d5085257671005ebbd5?OpenDocument
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
