Network in VMware workstation
I have installed Win Xp Sp2 using VmWare workstation 6.5 in windows 7 Home Premium 64 bit OS. But, I am not able to access the internet in that Xp OS. When I pinged, am getting the reply, but when I tried to access websites using Internet Explorer it is saying that wepage could not [...]
Answer Question
| April 6, 2012 6:18 AM
VMware, VMware Workstation, Windows 7 Home Premium
I have installed Win Xp Sp2 using VmWare workstation 6.5 in windows 7 Home Premium 64 bit OS. But, I am not able to access the internet in that Xp OS. When I pinged, am getting the reply, but when I tried to access websites using Internet Explorer it is saying that wepage could not [...]
Answer Question
| April 6, 2012 6:18 AM
VMware, VMware Workstation, Windows 7 Home Premium
Creating Views in MYSQL via Sysdate
Hello Guys, I can create simple views for MYSQL Database tables but I am unsure on how to create a view for the following requirement: I want to create a view which restricts staff user access to a specific table between working hours of 13:00 – 14:00. I have been told that this can be [...]
Answer Question
| March 27, 2012 8:58 PM
MySQL, MySQL Database, Oracle
Hello Guys, I can create simple views for MYSQL Database tables but I am unsure on how to create a view for the following requirement: I want to create a view which restricts staff user access to a specific table between working hours of 13:00 – 14:00. I have been told that this can be [...]
Answer Question
| March 27, 2012 8:58 PM
MySQL, MySQL Database, Oracle
printing barcodes on *ipds printer from cobol version i6.1
Upgraded to i6.1 from v5R3M0. Very old cobol programs exist that print barcodes on *ipds printer using PRTBAR in QSSP. Getting MCH3601 error: Pointer not set for location referenced. When I call it from the command line, I get MCH3602 Boundary alignment of pointer or template not valid. I figure the parm list has changed, [...]
Answer Question
| March 27, 2012 8:07 PM
AS/400 V5R3M0, iSeries v6.1
Upgraded to i6.1 from v5R3M0. Very old cobol programs exist that print barcodes on *ipds printer using PRTBAR in QSSP. Getting MCH3601 error: Pointer not set for location referenced. When I call it from the command line, I get MCH3602 Boundary alignment of pointer or template not valid. I figure the parm list has changed, [...]
Answer Question
| March 27, 2012 8:07 PM
AS/400 V5R3M0, iSeries v6.1
how to write more than one sql statement under EXEC SQL in SQLRPGLE.
Hi, Can anyone please help me to write more than one SQL statements under single EXEC SQL and END EXEC as below. Since i have 10 sql statements and wanted to include all those 10 statements under single block of EXEC SQL and END EXEC by using any seperator like below. C/EXEC SQL C+Insert into [...]
Answer Question
| March 26, 2012 7:52 PM
as400/DB2, SQLRPGLE
Hi, Can anyone please help me to write more than one SQL statements under single EXEC SQL and END EXEC as below. Since i have 10 sql statements and wanted to include all those 10 statements under single block of EXEC SQL and END EXEC by using any seperator like below. C/EXEC SQL C+Insert into [...]
Answer Question
| March 26, 2012 7:52 PM
as400/DB2, SQLRPGLE
World IPv6 Day 2012
Will there be any difference between World IPv6 Day 2011 and 2012? What activities or events will be different or of particular interest in 2012?
Answer Question
| June 1, 2012 6:09 PM
IPv6, WAN, World IPv6 Day
Will there be any difference between World IPv6 Day 2011 and 2012? What activities or events will be different or of particular interest in 2012?
Answer Question
| June 1, 2012 6:09 PM
IPv6, WAN, World IPv6 Day
batching qsh sftp fails when using a variable for script
Hi all ! this works – SBMJOB CMD(QSH CMD(‘/QOpenSys/usr/bin/sftp -v -b + /home/account/sftpcmd.txt + remote_user_account’)) + JOB(SSHJOB) USER(WIRM5501) this does not SBMJOB CMD(QSH CMD( &CMDSHL )) JOB(SSHJOB) USER(WIRM5501) where &CMDSHL is the exact quoted command in the working script I get this error qsh: 001-0014 Command /QOpenSys/usr/bin/sftp -v -b /home/… not found [...]
Answer Question
| March 30, 2012 4:13 PM
AS400 iseries, iSeries Commands
Hi all ! this works – SBMJOB CMD(QSH CMD(‘/QOpenSys/usr/bin/sftp -v -b + /home/account/sftpcmd.txt + remote_user_account’)) + JOB(SSHJOB) USER(WIRM5501) this does not SBMJOB CMD(QSH CMD( &CMDSHL )) JOB(SSHJOB) USER(WIRM5501) where &CMDSHL is the exact quoted command in the working script I get this error qsh: 001-0014 Command /QOpenSys/usr/bin/sftp -v -b /home/… not found [...]
Answer Question
| March 30, 2012 4:13 PM
AS400 iseries, iSeries Commands
How to get job log for prestart jobs in AS/400
Hi How can we get JOBLOG for prestart job. Please help me. Thanks Supriya
Answer Question
| March 27, 2012 12:59 PM
AS400 - JOB LOG
Hi How can we get JOBLOG for prestart job. Please help me. Thanks Supriya
Answer Question
| March 27, 2012 12:59 PM
AS400 - JOB LOG
Long time to run the select SQL statement for Mimix Jornualed file
Hi Guys, I want to know why it need very long long time to run a select SQL statement on Mimix jornualed files. It ran over 3 days for a select statements on a MimixJrn files (over 1 Millians records). But only use less than 1 hour to complete the same SQL selection statement for [...]
Answer Question
| July 9, 2012 2:55 AM
AS/400, MIMIX, SQL statement
Hi Guys, I want to know why it need very long long time to run a select SQL statement on Mimix jornualed files. It ran over 3 days for a select statements on a MimixJrn files (over 1 Millians records). But only use less than 1 hour to complete the same SQL selection statement for [...]
Answer Question
| July 9, 2012 2:55 AM
AS/400, MIMIX, SQL statement
Question on how to code REXX
I am trying to learn REXX and I am learning on my own. What I want to do is make a wildcard for the end of FWEBSRV to either an “I” or an “M”. I have looked at some other code and it looks like people have used a “namer” and “rname” in the code. [...]
Answer Question
| March 26, 2012 4:43 PM
AF/OPER, REXX
I am trying to learn REXX and I am learning on my own. What I want to do is make a wildcard for the end of FWEBSRV to either an “I” or an “M”. I have looked at some other code and it looks like people have used a “namer” and “rname” in the code. [...]
Answer Question
| March 26, 2012 4:43 PM
AF/OPER, REXX
Wi-Fi in Lenovo Laptop
I am having windows 7 Pro in my Lenovo Laptop. 2 weeks back I had not problems related to Wi-Fi – it used to connect to the available connections. Since last two weeks, it connects only when i restart my laptop and once connected, loses the connection, the moment it goes to sleep mode, or [...]
Answer Question
| March 27, 2012 1:27 PM
lenovo, Wi-Fi, Windows 7 Pro
I am having windows 7 Pro in my Lenovo Laptop. 2 weeks back I had not problems related to Wi-Fi – it used to connect to the available connections. Since last two weeks, it connects only when i restart my laptop and once connected, loses the connection, the moment it goes to sleep mode, or [...]
Answer Question
| March 27, 2012 1:27 PM
lenovo, Wi-Fi, Windows 7 Pro
Server 2003 STD R2 to ENT R2 setup error
Trying to upgrade Windows Server 2003 Standard R2 to Windows Server 2003 enterprise R2 and get an error when I select upgrade. “Setup cannot continue because some necessary information cannot be accessed in the registry.” “An I/O operation initiated by the registry failed unrecoverably. The registry could not read in, or write out, or flush, [...]
Answer Question
| April 4, 2012 10:12 PM
Windows Server 2003 Enterprise R2, Windows Server 2003 Standard R2
Trying to upgrade Windows Server 2003 Standard R2 to Windows Server 2003 enterprise R2 and get an error when I select upgrade. “Setup cannot continue because some necessary information cannot be accessed in the registry.” “An I/O operation initiated by the registry failed unrecoverably. The registry could not read in, or write out, or flush, [...]
Answer Question
| April 4, 2012 10:12 PM
Windows Server 2003 Enterprise R2, Windows Server 2003 Standard R2
FTP and response issues in AS400
Hi Experts, We have just finished relocating our AS400 from one site to another. Hence change of IP was done but setup remains the same machine wise. After which, some FTP and response issues started to arise. My AS400 is a two partition machine running on the same segment as my users and other interfaces. [...]
Answer Question
| March 27, 2012 5:53 PM
AS/400 FTP, AS/400 V7R1
Hi Experts, We have just finished relocating our AS400 from one site to another. Hence change of IP was done but setup remains the same machine wise. After which, some FTP and response issues started to arise. My AS400 is a two partition machine running on the same segment as my users and other interfaces. [...]
Answer Question
| March 27, 2012 5:53 PM
AS/400 FTP, AS/400 V7R1
Insert values into database from form VB.NET
Hi guys, Having abit of trouble with inserting values that i have in my form into my sql database. Basically it supposed to calculate a customer who borrowed a DVD or CD. I select the date that the customer brings the returned item by selecting a datepicker. The calculation works fine, but i want to [...]
Answer Question
| March 28, 2012 9:52 AM
SQL Database, VB.NET
Hi guys, Having abit of trouble with inserting values that i have in my form into my sql database. Basically it supposed to calculate a customer who borrowed a DVD or CD. I select the date that the customer brings the returned item by selecting a datepicker. The calculation works fine, but i want to [...]
Answer Question
| March 28, 2012 9:52 AM
SQL Database, VB.NET
lotus Notes 8.5.2 calendar entry Issue : Status Not Applicable
Hi All, In my calendar I have some entry as repaired entries and its status is not applicable. Can someone tell me what is meaning of Not Applicable.
Answer Question
| April 9, 2012 4:43 AM
Lotus Notes 8.5.2, Lotus Notes errors
Hi All, In my calendar I have some entry as repaired entries and its status is not applicable. Can someone tell me what is meaning of Not Applicable.
Answer Question
| April 9, 2012 4:43 AM
Lotus Notes 8.5.2, Lotus Notes errors
I have a word 2007 form template with legacy controls (text control).
I have a word 2007 form template with legacy controls (text control). I use the default text to identify what goes into a field on the form. The user clicks in the field with the mouse and enters text. The problem is the default text stays while the user is typing. How can I erase [...]
Answer Question
| March 26, 2012 3:35 AM
Legacy controls, Microsoft Word 2007
I have a word 2007 form template with legacy controls (text control). I use the default text to identify what goes into a field on the form. The user clicks in the field with the mouse and enters text. The problem is the default text stays while the user is typing. How can I erase [...]
Answer Question
| March 26, 2012 3:35 AM
Legacy controls, Microsoft Word 2007
One or more rules cannot be uploaded to Microsoft Exchange…
I get a Warning, “One or more rules cannot be uploaded to Microsoft Exchange and have been deactivated. This could be because some of the parameters are not supported, or there is insufficient space to store all of your rules”. Is there a limit to how many rules you can have?
Answer Question
| March 29, 2012 10:40 PM
Microsoft Exchange, Microsoft Exchange errors
I get a Warning, “One or more rules cannot be uploaded to Microsoft Exchange and have been deactivated. This could be because some of the parameters are not supported, or there is insufficient space to store all of your rules”. Is there a limit to how many rules you can have?
Answer Question
| March 29, 2012 10:40 PM
Microsoft Exchange, Microsoft Exchange errors
Can not able to declare character field with the length of 6000 in SQLRPGLE program.
Hi, I am declaring a stand alone character field with the length of 6000 in my SQLRPGLE program, but when i debug the program to see the the values in this character field i could find only 1024 length is allocated for this field. Could anyone please help me urgently to declare a character field [...]
Answer Question
| March 26, 2012 9:30 PM
AS/400, RPG ILE, SQLRPGLE
Hi, I am declaring a stand alone character field with the length of 6000 in my SQLRPGLE program, but when i debug the program to see the the values in this character field i could find only 1024 length is allocated for this field. Could anyone please help me urgently to declare a character field [...]
Answer Question
| March 26, 2012 9:30 PM
AS/400, RPG ILE, SQLRPGLE
Power 7 V6R1 FTP timeout on large SAVF
The FTP is between 2 partitions. A 2g save file has no problems but a 200g savefile fails. Enter an FTP subcommand. > PUT BMICLIB/RC0DAT /QSYS.LIB/BMICLIB.LIB/RC0DAT.SAVF 200 PORT subcommand request successful. 150-NAMEFMT set to 1. 150 Sending file to member 1 in file RC0DAT in library BMICLIB. Unable to send data to server. No response from [...]
Answer Question
| March 26, 2012 5:14 PM
FTP, Power 7 V6R1
The FTP is between 2 partitions. A 2g save file has no problems but a 200g savefile fails. Enter an FTP subcommand. > PUT BMICLIB/RC0DAT /QSYS.LIB/BMICLIB.LIB/RC0DAT.SAVF 200 PORT subcommand request successful. 150-NAMEFMT set to 1. 150 Sending file to member 1 in file RC0DAT in library BMICLIB. Unable to send data to server. No response from [...]
Answer Question
| March 26, 2012 5:14 PM
FTP, Power 7 V6R1
Have to randomly restart Microsoft Exchange 2010 server due to Microsoft Outlook 2010 not accepting correct User Name and Password Credentials
About once or twice a week at random at the beginning of the work day, I have to randomly restart our office Microsoft Exchange 2010 server due to Microsoft Outlook 2010 not receiving User Name and Password Credentials on all computers at my office. When this situation happens, some users are able to send/receive their [...]
Answer Question
| March 30, 2012 1:20 PM
Microsoft Exchange 2010, Microsoft Outlook 2010
About once or twice a week at random at the beginning of the work day, I have to randomly restart our office Microsoft Exchange 2010 server due to Microsoft Outlook 2010 not receiving User Name and Password Credentials on all computers at my office. When this situation happens, some users are able to send/receive their [...]
Answer Question
| March 30, 2012 1:20 PM
Microsoft Exchange 2010, Microsoft Outlook 2010
I would like to run a report on AS/400 to indentify which DB2 tables to reorg.
Hi, New to iSeries. I need to identify which tables need to be reorged. From manual I see that if I do a DSPFD FILE(xxx/*ALL) TYPE(MBRLIST). I get a report where the Total deleted records are more than 10% of the total records I should reorg. Is there a report similar from DB2 side a [...]
Answer Question
| March 23, 2012 9:54 AM
DB2, iSeries, OS/400
Hi, New to iSeries. I need to identify which tables need to be reorged. From manual I see that if I do a DSPFD FILE(xxx/*ALL) TYPE(MBRLIST). I get a report where the Total deleted records are more than 10% of the total records I should reorg. Is there a report similar from DB2 side a [...]
Answer Question
| March 23, 2012 9:54 AM
DB2, iSeries, OS/400
