Questions & Answers
Active Directory, AS/400, Business Intelligence, Career Development, CIO, 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, 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
When we do DSPFD for a file it shows physical and logical reads. What is the difference between physical and logical reads?
I have created one physical file with 1 key field. After that I added some data in that file. Records in the file are displayed in arrival order. While viewing the records using DSPPFM, STRSQL commands. As per my assumption, it should be ascending order. Why it is not displaying in ascending order?
I lost the installation disk, so what other way can I install this printer (HP photosmart C7280 series)?
What is the difference between DB2 and DB2/400?
In DB2/400, even after we delete record from file, the record exists until we are done with RGZPFM. The deleted record can be identified by a indication field with value "Y" or "N". How to see this indicator field? How to see the DB2/400 RRN (Relative record number) field? I tried with RUNQRY...
When exporting a spreadsheet to Excel 2007, currencies show in the wrong format (ie. 1,882,456.96 shows as 1882456:96). I've tried to format the cell but this does nothing. Also I've verified switching the regional settings but no luck there neither. Help will be truly appreciated, Max.
Why do I need a logical file in DB2/400?
When will an access path be created, and when will an open data path be created?
Hi All, I have a series of questions I would like to discuss few of them here. I'll post them in a different threads so that it will be easier to track them: AS 400 question 1: When you say that an OVRDBF and an OPNQRY creates a temporary logical file, - Say I am just using OVRDBF and not OPNQRY....
I need to convert a spreadsheet into a flatfile using the mid function. I only want to use a couple fields out of the spreadsheet, can someone help me?
I'm getting these 2 errors on both my Windows 2003 domain controllers:1030: Windows cannot query for the list of Group Policy objects. Check the event log for possible messages previously logged by the policy engine that describes the reason for this. 1058: Windows cannot access the file gpt.ini...
We have a small network (less than 50 workstations), and I notice in the Security Event Logs of each workstation there will usually be several audit failures. For example: Event Type: Failure Audit Event Source: Security Event Category: Logon/Logoff Event ID: 529 Date: 3/30/2009 Time: 8:19:25 AM...
How to handle Reverse Image Indicator through RPG program?
I want to automate the process of deleting a file in a LAN Folder based on Creation Date. Eg: Extract in text format will be sent to C: on a daily basis. Then Extract will get deleted after 7th Day of Creation Date. I want to achieve this in AS/400 and automate this entire process. Please help me...
Hello, Does anyone know how to step into and through the code in the macro customization window of AS/400? Thank you, Carissa
Hi, I need a CL program to display a record from a file in a loop condition. If a file exists, then it should display the records or else it should display the message 'file does not exist'. Please help me. The program should contain dcf,monmsg,rcvf.
I have inherited an Access Database. There is a form that provides a menu for user access to the various functions such as adding, changing records and various reports. Originally the users would only see this menu form. I modified the form and now they see Access and all the various Access...
I want to package all PDF files into one PDF file. Same as ADOBE - packaging. Is it possible in AS/400?
I have 4 servers and 100 clients. One of my servers is file server and I created a common shared folder for all users for transfer files and folder. I have given full access to domain users but when user try to paste EXE file from network, a message appear access denied. Please guide why user not...
How can we remove the two years back data from our table? We don't have any time stamp in a table. Please let me know the process to achieve it.