How to get weekly chart updates
In Excel macros I would like to change a reference cell incrementally each time I do a button click. How would I do that? For example start out referencing cell b6 then one button click reference cell b7 and so on as often as I push the button it would increase the cell reference to [...]
Answer Question
| February 28, 2013 8:25 PM
Microsoft Excel, Microsoft Excel macros
In Excel macros I would like to change a reference cell incrementally each time I do a button click. How would I do that? For example start out referencing cell b6 then one button click reference cell b7 and so on as often as I push the button it would increase the cell reference to [...]
Answer Question
| February 28, 2013 8:25 PM
Microsoft Excel, Microsoft Excel macros
Constant variable in SQL cursor
select gthamcode as hamcode, gtnumber as item, ‘G’ from testlib/gtinl01 where (gtnumber between 08000000000000 and 08999999999999) union all select modkey as hamcode, modndcnum as item, ‘M’ from testlib/hammodel where (modndcnum between 08000000000 and 08999999999) This works with interactive SQL but I need to use this in an COBOL embbeded SQL cursor. The ’M’ and ’G’ are constants [...]
Answer Question
| February 28, 2013 7:23 PM
AS/400, SQL Cursors
select gthamcode as hamcode, gtnumber as item, ‘G’ from testlib/gtinl01 where (gtnumber between 08000000000000 and 08999999999999) union all select modkey as hamcode, modndcnum as item, ‘M’ from testlib/hammodel where (modndcnum between 08000000000 and 08999999999) This works with interactive SQL but I need to use this in an COBOL embbeded SQL cursor. The ’M’ and ’G’ are constants [...]
Answer Question
| February 28, 2013 7:23 PM
AS/400, SQL Cursors
Sending Sterling FileGateway to Direct:Connect
I’m sending a file from Sterling Filegateway to Direct:Connect. It fails. FG lists that a mandatory parameter is missing. The C:D stats show error codes of LCOT000I, LCOA007I and LIPT027I. What do I need to do to fix this?
Answer Question
| February 28, 2013 5:57 PM
Remote access
I’m sending a file from Sterling Filegateway to Direct:Connect. It fails. FG lists that a mandatory parameter is missing. The C:D stats show error codes of LCOT000I, LCOA007I and LIPT027I. What do I need to do to fix this?
Answer Question
| February 28, 2013 5:57 PM
Remote access
EXE files
Why can’t I open my EXE files….says I need an association
Answer Question
| February 28, 2013 4:36 PM
.EXE file, Windows Vista
Why can’t I open my EXE files….says I need an association
Answer Question
| February 28, 2013 4:36 PM
.EXE file, Windows Vista
Are multiple hypervisors in your future?
Recent surveys show that 65% of large and enterprise-sized businesses are now using multiple hypervisors, and even medium and small companies are joining in. For those using hypervisors, are you considering enabling additional hypervisors?
Answer Question
| March 11, 2013 3:29 PM
hypervisors, Virtualization
Recent surveys show that 65% of large and enterprise-sized businesses are now using multiple hypervisors, and even medium and small companies are joining in. For those using hypervisors, are you considering enabling additional hypervisors?
Answer Question
| March 11, 2013 3:29 PM
hypervisors, Virtualization
Synon related: Searching calling program in Synon (PRTFIL).
How can be search external program (outside Synon) which is calling print file function (PRTFIL). Actually, I know to search all function which are calling print file by the option 91 or take U at subfile selector or 95 at object usage screen but that approach can only work to identify internal function. Do you [...]
Answer Question
| February 28, 2013 12:36 PM
AS/400 Synon, Synon
How can be search external program (outside Synon) which is calling print file function (PRTFIL). Actually, I know to search all function which are calling print file by the option 91 or take U at subfile selector or 95 at object usage screen but that approach can only work to identify internal function. Do you [...]
Answer Question
| February 28, 2013 12:36 PM
AS/400 Synon, Synon
Servlets
I am new to servlets. I installed my Tomcat server in C: drive. Is it possible to store all my servlets related files like .class file web.XML file in G: drive and make work the program. Instead of saving the files in tom container folder?
Answer Question
| February 28, 2013 11:55 AM
Servlet, Tomcat
I am new to servlets. I installed my Tomcat server in C: drive. Is it possible to store all my servlets related files like .class file web.XML file in G: drive and make work the program. Instead of saving the files in tom container folder?
Answer Question
| February 28, 2013 11:55 AM
Servlet, Tomcat
Reading XML file from RPGLE program by using XML-INTO opcode
How can I move data from XML to Data structure if data is more than 9999 in XML? The problem is I can declare the data structure with array max size 9999 where as using XML-INTO (ex: XML-INTO OrderList %XML(‘/home/orderlist.xml’) : ‘ doc=file case=any’) ). I can load first 9999 set of data but then [...]
Answer Question
| February 28, 2013 9:53 AM
AS/400, RPGLE, XML
How can I move data from XML to Data structure if data is more than 9999 in XML? The problem is I can declare the data structure with array max size 9999 where as using XML-INTO (ex: XML-INTO OrderList %XML(‘/home/orderlist.xml’) : ‘ doc=file case=any’) ). I can load first 9999 set of data but then [...]
Answer Question
| February 28, 2013 9:53 AM
AS/400, RPGLE, XML
SAN to SAN hardware level replicaiton to replicate MSSQL 2008 R2 databases
If SAN to SAN hardware level replication solution is implemented, how can we utilize this solution to transfer MSSQL 2008 R2 databases’ MDF and LDF files.
Answer Question
| February 28, 2013 9:26 AM
MSSQL, MSSQL 2008, SAN
If SAN to SAN hardware level replication solution is implemented, how can we utilize this solution to transfer MSSQL 2008 R2 databases’ MDF and LDF files.
Answer Question
| February 28, 2013 9:26 AM
MSSQL, MSSQL 2008, SAN
Email remove from OAB
Dear Expert, Everything was working fine for me. One bad day I have removed my GM email account and created new email account after 2 days. The problem I’m facing is the user sending mail from cache mode can’t send him email. User send email from web Outlook have no problem. What I think in [...]
Answer Question
| February 28, 2013 6:12 AM
Microsoft Exchange 2010, OAB
Dear Expert, Everything was working fine for me. One bad day I have removed my GM email account and created new email account after 2 days. The problem I’m facing is the user sending mail from cache mode can’t send him email. User send email from web Outlook have no problem. What I think in [...]
Answer Question
| February 28, 2013 6:12 AM
Microsoft Exchange 2010, OAB
DNS issues
Can I own a domain name indefinitely?
Answer Question
| February 28, 2013 10:33 PM
DNS, domain names
Can I own a domain name indefinitely?
Answer Question
| February 28, 2013 10:33 PM
DNS, domain names
Creating physical files
What command would I use to create a physical file?
Answer Question
| February 28, 2013 9:36 PM
AS/400, Physical File
What command would I use to create a physical file?
Answer Question
| February 28, 2013 9:36 PM
AS/400, Physical File
Migrating names.nsf from 8.5.3 to 8.5.2
I copied my names.nsf from a 8.5.3 client to a 8.5.2 client and got a ‘RRV bucket is corrupt’ error. Unfortunately, I did not backup the 8.5.2 names.nsf first. How do I create a fresh names.nsf file so I can export and import my contacts? I am not sure why my company wants me to [...]
Answer Question
| February 27, 2013 6:09 PM
Lotus Notes 8.5, Lotus Notes error messages, Lotus Notes migration
I copied my names.nsf from a 8.5.3 client to a 8.5.2 client and got a ‘RRV bucket is corrupt’ error. Unfortunately, I did not backup the 8.5.2 names.nsf first. How do I create a fresh names.nsf file so I can export and import my contacts? I am not sure why my company wants me to [...]
Answer Question
| February 27, 2013 6:09 PM
Lotus Notes 8.5, Lotus Notes error messages, Lotus Notes migration
Does your company invest in social media analytics?
A buzz is stirring through enterprises as they decide whether to use social media analytics. While it provides a lower-cost alternative with instantaneous feedback on different data services, many businesses are wondering if this is the right time to jump on the bandwagon. Does your company invest in social media analytics? If so, has it [...]
Answer Question
| March 11, 2013 3:46 PM
Analytics, social media
A buzz is stirring through enterprises as they decide whether to use social media analytics. While it provides a lower-cost alternative with instantaneous feedback on different data services, many businesses are wondering if this is the right time to jump on the bandwagon. Does your company invest in social media analytics? If so, has it [...]
Answer Question
| March 11, 2013 3:46 PM
Analytics, social media
Printing from AS/400 to Canon iR3235
Hi, I am having problems printing from AS/400 running v5r4 to a Canon iR3235. Prints seem to be coming off out of order. But only happening half way through each batch of around 100 prints. The first half is fine, but then all comes off wrong. IBM have recommended setting up printer over LPR and using [...]
Answer Question
| February 27, 2013 3:36 PM
AS/400, Canon
Hi, I am having problems printing from AS/400 running v5r4 to a Canon iR3235. Prints seem to be coming off out of order. But only happening half way through each batch of around 100 prints. The first half is fine, but then all comes off wrong. IBM have recommended setting up printer over LPR and using [...]
Answer Question
| February 27, 2013 3:36 PM
AS/400, Canon
User input
How do I get the user input, so I can use it on my query on Oracle Reports Builder 6? The report will be executed on a client desktop. Im using autosearch, and just found this : Report.GetAutoSearchDescriptionLines(Memo1.Lines);which get me the whole search description, including the user input for the search criteria. Is there any [...]
Answer Question
| March 1, 2013 1:45 PM
Oracle Reports 6i, Oracle Reports Builder, SQL Query
How do I get the user input, so I can use it on my query on Oracle Reports Builder 6? The report will be executed on a client desktop. Im using autosearch, and just found this : Report.GetAutoSearchDescriptionLines(Memo1.Lines);which get me the whole search description, including the user input for the search criteria. Is there any [...]
Answer Question
| March 1, 2013 1:45 PM
Oracle Reports 6i, Oracle Reports Builder, SQL Query
Antivirus for external hard disk
I have 1TB external HDD. I want to know if it is possible to install any antivirus in my external hard drive because I might plug it in another computer that doesn’t have an update and that has a virus. Which one is good antivirus for external hard drive?
Answer Question
| February 27, 2013 1:14 PM
Antivirus, HDD, Security
I have 1TB external HDD. I want to know if it is possible to install any antivirus in my external hard drive because I might plug it in another computer that doesn’t have an update and that has a virus. Which one is good antivirus for external hard drive?
Answer Question
| February 27, 2013 1:14 PM
Antivirus, HDD, Security
CPU
Are AMD processors as good as Intel processors?
Answer Question
| February 27, 2013 1:11 PM
AMD processors, Intel Processors
Are AMD processors as good as Intel processors?
Answer Question
| February 27, 2013 1:11 PM
AMD processors, Intel Processors
Lotus Notes 8.5 – New message
When I create a new message, the lines in the To, CC & BCC are missing.
Answer Question
| February 27, 2013 8:03 AM
Lotus Notes 8.5, Lotus Notes administration
When I create a new message, the lines in the To, CC & BCC are missing.
Answer Question
| February 27, 2013 8:03 AM
Lotus Notes 8.5, Lotus Notes administration
Block access of Operational ASSIST Menu
Hi ! How can I block the users for the use of Operational Assistance Menu(Esc Key)?
Answer Question
| February 27, 2013 6:03 AM
AS/400, AS/400 Menus
Hi ! How can I block the users for the use of Operational Assistance Menu(Esc Key)?
Answer Question
| February 27, 2013 6:03 AM
AS/400, AS/400 Menus
