Chain function to find a specific record
Hi everyone. I need to use CHAIN function to find a specific record. The key is composed from 4 field but I know only two of them. It is possible? Thanks a lot (and sorry for my bad english!! )
Answer Question
| April 11, 2012 11:41 AM
AS/400, AS/400 Records
Hi everyone. I need to use CHAIN function to find a specific record. The key is composed from 4 field but I know only two of them. It is possible? Thanks a lot (and sorry for my bad english!! )
Answer Question
| April 11, 2012 11:41 AM
AS/400, AS/400 Records
Logical File
Hi, I have written two online programs. The first one uses PRDATA-FILE. The second one uses a logical file based on PRDATA-FILE. When the screen of the first online program is displayed, the screen of the second online program does not display records. Is this because PRDATA-FILE is locked by the first online program? How [...]
Answer Question
| April 26, 2012 10:12 AM
AS/400 logical file, COBOL, iSeries 820
Hi, I have written two online programs. The first one uses PRDATA-FILE. The second one uses a logical file based on PRDATA-FILE. When the screen of the first online program is displayed, the screen of the second online program does not display records. Is this because PRDATA-FILE is locked by the first online program? How [...]
Answer Question
| April 26, 2012 10:12 AM
AS/400 logical file, COBOL, iSeries 820
can not explore NAS server after reinstalling windows 7
Hi. I have a problem after reinstalling PC with Windows 7 Ultimate, I can’t explore NAS server (Buffalo). But ping in DOS command still works. It happened to 3 PCs. If you have any suggestion would be helpfull for me. Thanks.
Answer Question
| April 13, 2012 9:20 AM
DOS, NAS, Windows 7 Ultimate
Hi. I have a problem after reinstalling PC with Windows 7 Ultimate, I can’t explore NAS server (Buffalo). But ping in DOS command still works. It happened to 3 PCs. If you have any suggestion would be helpfull for me. Thanks.
Answer Question
| April 13, 2012 9:20 AM
DOS, NAS, Windows 7 Ultimate
How to Upload Image into SQL Server 2005
Please i need help to upload images into sql server 2005 using vb.net 2008. kindly assist please as i am working on an application that would require users to upload their credentials.
Answer Question
| April 11, 2012 6:40 AM
SQL Server 2005, VB.NET 2008
Please i need help to upload images into sql server 2005 using vb.net 2008. kindly assist please as i am working on an application that would require users to upload their credentials.
Answer Question
| April 11, 2012 6:40 AM
SQL Server 2005, VB.NET 2008
Query in SQL400
Hi, I want one query in SQL400, I will give small example? Suppose there are two tables, TAb1 Tab2 1.CMP 1.CMP 2.Item NO 2. Item NO 3.Status 3.Warehouse 4.Quantity 4.Costing type Now I want the data from tab2 where warehouse = 502 , Costing type = ’2′ and status = ’20′ (tab1) so, how to write the query? [...]
Answer Question
| April 20, 2012 6:37 AM
AS/400, SQL Query, SQL/400
Hi, I want one query in SQL400, I will give small example? Suppose there are two tables, TAb1 Tab2 1.CMP 1.CMP 2.Item NO 2. Item NO 3.Status 3.Warehouse 4.Quantity 4.Costing type Now I want the data from tab2 where warehouse = 502 , Costing type = ’2′ and status = ’20′ (tab1) so, how to write the query? [...]
Answer Question
| April 20, 2012 6:37 AM
AS/400, SQL Query, SQL/400
Sending eMail from iSeries
I’ve Configured something on my AS400 to send email to receipients. ,Then i tried to send mail using SNDDST command ,getting “Send distribution completed successfully”message ,but the email is not going out. Usually once we send mail,It shuld also show its presence here.. WRKLNK ‘/QTCPTMM/MAIL’ If any has idea,Pls help me in finding clue to [...]
Answer Question
| April 11, 2012 5:22 AM
AS/400 v6r1, AS400 iseries, SNDDST
I’ve Configured something on my AS400 to send email to receipients. ,Then i tried to send mail using SNDDST command ,getting “Send distribution completed successfully”message ,but the email is not going out. Usually once we send mail,It shuld also show its presence here.. WRKLNK ‘/QTCPTMM/MAIL’ If any has idea,Pls help me in finding clue to [...]
Answer Question
| April 11, 2012 5:22 AM
AS/400 v6r1, AS400 iseries, SNDDST
NGN UA500
There is problem that usually happens to our network operator: Just recently they are implementing NGN as there new core switch that can handle all calls within land line to land line, mobile to land line, and land line to mobile. well for quiet some few days in between we always experience out of services [...]
Answer Question
| April 11, 2012 5:05 AM
Core Switches, NGN UA500
There is problem that usually happens to our network operator: Just recently they are implementing NGN as there new core switch that can handle all calls within land line to land line, mobile to land line, and land line to mobile. well for quiet some few days in between we always experience out of services [...]
Answer Question
| April 11, 2012 5:05 AM
Core Switches, NGN UA500
How do I create 1000s of mandatory Outlook appointments for ~700 calendars?
Hello, We need to populate Outlook calendars for ~700 people covering a 10 month period. This is for a boarding school, operating on a 24 hr basis–we have 1000s of events. Rather than send out meeting invitations for these events (classes, activities, etc) we would like to populate the calendars ourselves since the events are [...]
Answer Question
| April 11, 2012 5:18 PM
Microsoft Exchange, Microsoft Outlook 2010
Hello, We need to populate Outlook calendars for ~700 people covering a 10 month period. This is for a boarding school, operating on a 24 hr basis–we have 1000s of events. Rather than send out meeting invitations for these events (classes, activities, etc) we would like to populate the calendars ourselves since the events are [...]
Answer Question
| April 11, 2012 5:18 PM
Microsoft Exchange, Microsoft Outlook 2010
Getting Apache REMOTE_USE variable (CGIDEV2)
My RPG on iSeries program doesn’t seem to get the REMOTE_USE variable when it is responding to a web call from a Reverse Proxy server (Apache/Linux/PHP). I am using getenv() function from CGIDEV2 library and it works perfectly when the call comes from within the LAN. If the call comes from the reverse proxy, function [...]
Answer Question
| April 10, 2012 5:06 PM
iSeries RPG, iseries v5r4
My RPG on iSeries program doesn’t seem to get the REMOTE_USE variable when it is responding to a web call from a Reverse Proxy server (Apache/Linux/PHP). I am using getenv() function from CGIDEV2 library and it works perfectly when the call comes from within the LAN. If the call comes from the reverse proxy, function [...]
Answer Question
| April 10, 2012 5:06 PM
iSeries RPG, iseries v5r4
Getting timed out in the AS400
How can I stop from getting time out in the AS400? I am monitoring the AS 400 work that is coming in all through the day and every so often I get time out if I don’t do any action on system. The AS 400 will log me out automatically because it thinks I am not using it any [...]
Answer Question
| April 11, 2012 3:52 PM
AS/400, AS/400 login
How can I stop from getting time out in the AS400? I am monitoring the AS 400 work that is coming in all through the day and every so often I get time out if I don’t do any action on system. The AS 400 will log me out automatically because it thinks I am not using it any [...]
Answer Question
| April 11, 2012 3:52 PM
AS/400, AS/400 login
Data transfer from excel to PF
How to transfer data from excel to PF if PF file has more the 300 Fields
Answer Question
| April 12, 2012 10:30 AM
Microsoft Excel, PF file
How to transfer data from excel to PF if PF file has more the 300 Fields
Answer Question
| April 12, 2012 10:30 AM
Microsoft Excel, PF file
outlook shared calendar
We have 5 account managers each with their own outlook calendar. I want to create a master calendar to combine all individual calendars. We do not want a second calendar cause that would mean registering twice. Is this possible? As an alternative is it possible to search over the separate calendars for key words. Like [...]
Answer Question
| April 12, 2012 10:17 AM
Microsoft Outlook 2007, Microsoft Outlook Calendar
We have 5 account managers each with their own outlook calendar. I want to create a master calendar to combine all individual calendars. We do not want a second calendar cause that would mean registering twice. Is this possible? As an alternative is it possible to search over the separate calendars for key words. Like [...]
Answer Question
| April 12, 2012 10:17 AM
Microsoft Outlook 2007, Microsoft Outlook Calendar
Logical file Error.
i try to create Multiple-format Logical File but i getting compile time error. i have two PF dds is as follow.. A R RDEPTMST A DEPTNAME 15 A DID [...]
Answer Question
| April 17, 2012 6:20 AM
AS/400 DB2, Logical File
i try to create Multiple-format Logical File but i getting compile time error. i have two PF dds is as follow.. A R RDEPTMST A DEPTNAME 15 A DID [...]
Answer Question
| April 17, 2012 6:20 AM
AS/400 DB2, Logical File
Query against User Profiles
I was trying to omit some of the user profiles,which generally starts with KMAN*,TMAN*,CMAN* from the list of all user profiles (DSPUSRPRF USRPRF(*ALL) TYPE(*BASIC) OUTPUT(*OUTFILE). I’m querying this against to a outfile,i was able to select the columns what i want,but i couln’t find option/feature to omit certain user profiles which start generally with common [...]
Answer Question
| April 11, 2012 4:55 AM
AS400 -WRKQRY, iSeries V6R1
I was trying to omit some of the user profiles,which generally starts with KMAN*,TMAN*,CMAN* from the list of all user profiles (DSPUSRPRF USRPRF(*ALL) TYPE(*BASIC) OUTPUT(*OUTFILE). I’m querying this against to a outfile,i was able to select the columns what i want,but i couln’t find option/feature to omit certain user profiles which start generally with common [...]
Answer Question
| April 11, 2012 4:55 AM
AS400 -WRKQRY, iSeries V6R1
Domain Admin Permissions to Folder Redirections
Hello, I am working with a clients serverand have ran into some issues. The server is SBS 2008. I need to give the Domain Admin full control of the following directory which has subfolders for the users home folder. c:usersFolderRedirections. What is the easiest way to give the domain admin full control of this top [...]
Answer Question
| April 11, 2012 2:27 AM
SBS 2008, SBS 2008 Migration
Hello, I am working with a clients serverand have ran into some issues. The server is SBS 2008. I need to give the Domain Admin full control of the following directory which has subfolders for the users home folder. c:usersFolderRedirections. What is the easiest way to give the domain admin full control of this top [...]
Answer Question
| April 11, 2012 2:27 AM
SBS 2008, SBS 2008 Migration
How do I subtract 3 days from current date only when current day = 2, so that I retrieve the previous Fridays date?
I am new to using T-SQL, so there is probably an easy way to accomplish this, but I can’t seem to get it right. I want to retrieve the previous day’s date (requires a weekday) to use as a comparsioin to a date field in the table, format is YYYYMMDD. When the current date is [...]
Answer Question
| April 10, 2012 7:59 PM
T-SQL, T-SQL 2008 R2
I am new to using T-SQL, so there is probably an easy way to accomplish this, but I can’t seem to get it right. I want to retrieve the previous day’s date (requires a weekday) to use as a comparsioin to a date field in the table, format is YYYYMMDD. When the current date is [...]
Answer Question
| April 10, 2012 7:59 PM
T-SQL, T-SQL 2008 R2
How to add a user
Can I copy a user prf and make a new user from that?
Answer Question
| May 3, 2012 7:23 PM
AS/400-Users, WRKUSRPRF
Can I copy a user prf and make a new user from that?
Answer Question
| May 3, 2012 7:23 PM
AS/400-Users, WRKUSRPRF
iSeries Access *.OWS File
We are changing the iSeries IP address in company with 3000+ users connecting with different versions of iSeries Access for Windows. Most of these configurations were done with system IP rather than host name. Can all of these be changed with LAN Desk and if so how?
Answer Question
| April 10, 2012 1:49 PM
iSeries Access, LAN Desk
We are changing the iSeries IP address in company with 3000+ users connecting with different versions of iSeries Access for Windows. Most of these configurations were done with system IP rather than host name. Can all of these be changed with LAN Desk and if so how?
Answer Question
| April 10, 2012 1:49 PM
iSeries Access, LAN Desk
Remote systems shutdown through server
Hi, I need to set about 60% (about 50) of the PC’s in our network to automatically shutdown at 8pm every night. I am running Windows server 2003, and the clients are all Windows XP. Can someone tell me the best way to do this. Thanks Ramachandrna
Answer Question
| April 10, 2012 12:09 PM
Windows Server 2003, Windows XP
Hi, I need to set about 60% (about 50) of the PC’s in our network to automatically shutdown at 8pm every night. I am running Windows server 2003, and the clients are all Windows XP. Can someone tell me the best way to do this. Thanks Ramachandrna
Answer Question
| April 10, 2012 12:09 PM
Windows Server 2003, Windows XP
communication between 2 vlans
Hi , I have cisco 3560 series poe-24 switch with and created different vlan1 Vlan 1 - 1-10 vlan 2 – 11 – 20 Vlan 3 21 – 24 i connected 3 pcs to each vlan with ips vlan 1 pc - 192.168.1.100 (connected to port 9) vlan 2 pc – 192.168.2.100 ( connected to [...]
Answer Question
| June 5, 2012 11:45 AM
Cisco 3560, Cisco VLAN
Hi , I have cisco 3560 series poe-24 switch with and created different vlan1 Vlan 1 - 1-10 vlan 2 – 11 – 20 Vlan 3 21 – 24 i connected 3 pcs to each vlan with ips vlan 1 pc - 192.168.1.100 (connected to port 9) vlan 2 pc – 192.168.2.100 ( connected to [...]
Answer Question
| June 5, 2012 11:45 AM
Cisco 3560, Cisco VLAN
