Create a macro for populating cells.
I get raw data and need to clean it up. The data is a bunch of different products and the spreadsheet tracks the time it takes to process each individual product. The spreadsheet had about 100 different products. The first column is the product name, then the rest of the columns are subcategories and ways [...]
Answer Question
| June 15, 2012 6:09 PM
Microsoft Excel 2003, Microsoft Excel macros
I get raw data and need to clean it up. The data is a bunch of different products and the spreadsheet tracks the time it takes to process each individual product. The spreadsheet had about 100 different products. The first column is the product name, then the rest of the columns are subcategories and ways [...]
Answer Question
| June 15, 2012 6:09 PM
Microsoft Excel 2003, Microsoft Excel macros
printing SW3
I Thanks, George have Songworks and try to print my composition. What program can I use?
Answer Question
| June 13, 2012 5:50 PM
printing SW3
I Thanks, George have Songworks and try to print my composition. What program can I use?
Answer Question
| June 13, 2012 5:50 PM
printing SW3
Retrieving Subfile Size in RPGLE
Hi Is there any way for us to retrieve subfile size in RPGLE code instead of hard coding it by seeing from the display file. -Vivek
Answer Question
| June 14, 2012 4:08 PM
RPG ILE, Subfile Size
Hi Is there any way for us to retrieve subfile size in RPGLE code instead of hard coding it by seeing from the display file. -Vivek
Answer Question
| June 14, 2012 4:08 PM
RPG ILE, Subfile Size
Library list in Batch job
How can we set up a library list for a batch job?
Answer Question
| June 13, 2012 10:55 AM
Batch jobs
How can we set up a library list for a batch job?
Answer Question
| June 13, 2012 10:55 AM
Batch jobs
Service program can be deleted after having a reference to the Service program?
I have a program which refer to a service program, now if the service program gets deleted,any impact? I know a module obj can be deleted after we create a program from that module as it is bind by copy. But since the service program is a bind by reference, will that delete cause any [...]
Answer Question
| June 14, 2012 10:52 AM
Service program
I have a program which refer to a service program, now if the service program gets deleted,any impact? I know a module obj can be deleted after we create a program from that module as it is bind by copy. But since the service program is a bind by reference, will that delete cause any [...]
Answer Question
| June 14, 2012 10:52 AM
Service program
Embedded SQL Update Query
Suppose I have a file with empid and telephone number, I realised the telephone number value is not correct for some 3-4 employee ids. I have a backup file for this file and it has the correct telephone number value . I need to write an SQL querry to correct the wrong telephone number by [...]
Answer Question
| June 15, 2012 10:42 AM
Embedded SQL
Suppose I have a file with empid and telephone number, I realised the telephone number value is not correct for some 3-4 employee ids. I have a backup file for this file and it has the correct telephone number value . I need to write an SQL querry to correct the wrong telephone number by [...]
Answer Question
| June 15, 2012 10:42 AM
Embedded SQL
Return more than one parameter from a subprocedure
I want to return Name, DOB and Place of Birth from a Subprocedure. Is it possible to return more than one parameter at a time? Any method other than using the same parameter as input and output?
Answer Question
| June 14, 2012 10:38 AM
Subprocedure
I want to return Name, DOB and Place of Birth from a Subprocedure. Is it possible to return more than one parameter at a time? Any method other than using the same parameter as input and output?
Answer Question
| June 14, 2012 10:38 AM
Subprocedure
BRMS Select Device (Q1ASLTDEV) API
Hello, I found in the BRMS manual that the BRMS select device API lets you select a device to allocate or deallocate, or to select search values such as location and media class to locate and allocate an available device for BRMS media input or output operations. Well, I don’t understand very well how and [...]
Answer Question
| June 13, 2012 10:24 AM
API, BRMS
Hello, I found in the BRMS manual that the BRMS select device API lets you select a device to allocate or deallocate, or to select search values such as location and media class to locate and allocate an available device for BRMS media input or output operations. Well, I don’t understand very well how and [...]
Answer Question
| June 13, 2012 10:24 AM
API, BRMS
AS/400 Domino Backups.
At times backup hangs up with message as Backup failed due to Pointer not set for location referenced. Backup waits in JobQ and it is not getting in Media library. Kindly help
Answer Question
| June 13, 2012 8:49 AM
AS/400, AS/400 Domino
At times backup hangs up with message as Backup failed due to Pointer not set for location referenced. Backup waits in JobQ and it is not getting in Media library. Kindly help
Answer Question
| June 13, 2012 8:49 AM
AS/400, AS/400 Domino
opendns.com certficate on exchange
Hi. When i open outlook it gives me secirity sertficate error opendns.com . Buttons Yes, NO and view certficate. What may be a problem? how can i recolve it?
Answer Question
| June 20, 2012 8:08 AM
Microsoft Outlook 2007, Microsoft Outlook error messages, Micrososft Exchange 2010
Hi. When i open outlook it gives me secirity sertficate error opendns.com . Buttons Yes, NO and view certficate. What may be a problem? how can i recolve it?
Answer Question
| June 20, 2012 8:08 AM
Microsoft Outlook 2007, Microsoft Outlook error messages, Micrososft Exchange 2010
Initial library
Hi, I would like to create a profile that have 4 initial libraries. How can this be done without changing global system values? or Job descriptions? Thank you
Answer Question
| June 15, 2012 7:03 AM
iSeries, iSeries application development tools, iSeries data center
Hi, I would like to create a profile that have 4 initial libraries. How can this be done without changing global system values? or Job descriptions? Thank you
Answer Question
| June 15, 2012 7:03 AM
iSeries, iSeries application development tools, iSeries data center
Windows XP Installation
Hi Good Morning to All can please tell me how to install win XP in sata mode AHCI Because safeboot only support AHCI mode so plzz tell how i can fix this problem
Answer Question
| June 13, 2012 6:20 AM
SATA, Windows XP
Hi Good Morning to All can please tell me how to install win XP in sata mode AHCI Because safeboot only support AHCI mode so plzz tell how i can fix this problem
Answer Question
| June 13, 2012 6:20 AM
SATA, Windows XP
VMware on diskless workstation
Can anyone tell me if it is possible run a VM workstation instance on a computer with no HD?
Answer Question
| June 13, 2012 8:22 PM
VM Workstation, VMware
Can anyone tell me if it is possible run a VM workstation instance on a computer with no HD?
Answer Question
| June 13, 2012 8:22 PM
VM Workstation, VMware
RCLSTG MCH4429
I need to run RCLSTG *DBXREF, but receive MCH4429 which ends the job abnormally. I have run RCLSTG before with no issues. Can anyone tell me why this may be happening and how to fix it? The system is V5R3M5
Answer Question
| June 14, 2012 7:41 PM
AS/400, iSeries
I need to run RCLSTG *DBXREF, but receive MCH4429 which ends the job abnormally. I have run RCLSTG before with no issues. Can anyone tell me why this may be happening and how to fix it? The system is V5R3M5
Answer Question
| June 14, 2012 7:41 PM
AS/400, iSeries
How can i search spool files fast?
my user have so many spool files that are not been deleted. i was wondering if there is a way to search for a specific file or a different way for me to search? i only use the page up and down to see everything.
Answer Question
| June 12, 2012 6:34 PM
AS/400 Reports
my user have so many spool files that are not been deleted. i was wondering if there is a way to search for a specific file or a different way for me to search? i only use the page up and down to see everything.
Answer Question
| June 12, 2012 6:34 PM
AS/400 Reports
Block of DID’s
Is it possible to automate the way that we issue phone numbers through the use of DID’s to new hires in our company? We are trying to find a way to minimize human interaction.
Answer Question
| June 19, 2012 4:30 PM
DID's, Programming
Is it possible to automate the way that we issue phone numbers through the use of DID’s to new hires in our company? We are trying to find a way to minimize human interaction.
Answer Question
| June 19, 2012 4:30 PM
DID's, Programming
Working with job queue
Hi How can I find out in which job queue my program is submitted and how can I hold/kill the program in that job queue.
Answer Question
| June 13, 2012 3:07 PM
AS/400, AS/400 Job Queue
Hi How can I find out in which job queue my program is submitted and how can I hold/kill the program in that job queue.
Answer Question
| June 13, 2012 3:07 PM
AS/400, AS/400 Job Queue
How to make a global calendar in Exchange 2003
How do i make a global calender in exchange 2003 to show in outlook 2007 so that everyone can view and make changes??
Answer Question
| June 13, 2012 2:34 PM
Microsoft Exchange 2003, Microsoft Outlook 2007
How do i make a global calender in exchange 2003 to show in outlook 2007 so that everyone can view and make changes??
Answer Question
| June 13, 2012 2:34 PM
Microsoft Exchange 2003, Microsoft Outlook 2007
how to configure iseries navigator with Windows 7(32bit)
I was just issued a new pc desktop with Windows 7 as OS and im having a problem using i-Series Navigator. The iseries access version i have is version 5 release 3 Modification level 0 Service Level SI30707.I’m prompted with the message “Unable to complete the connection to central system 192.xxx.xxx.xxx“. This is when [...]
Answer Question
| June 23, 2012 2:26 PM
iSeries, iSeries Navigator, Management Central
I was just issued a new pc desktop with Windows 7 as OS and im having a problem using i-Series Navigator. The iseries access version i have is version 5 release 3 Modification level 0 Service Level SI30707.I’m prompted with the message “Unable to complete the connection to central system 192.xxx.xxx.xxx“. This is when [...]
Answer Question
| June 23, 2012 2:26 PM
iSeries, iSeries Navigator, Management Central
CRTPGM VS CRTSRCPGM
Hi I just wanted to know the differences betweent the below 2 scenarios: Scenario1: ———— Create modules of rpgle codes mycode1 and mycode2 and then combine them using CRTPGM command. Scenario 2: ————- Create modules of rpgle codes mycode1 and mycode2 and then create service program for them. Is there any difference between the abvoe [...]
Answer Question
| June 16, 2012 1:47 PM
CRTPGM, CRTSRVPGM
Hi I just wanted to know the differences betweent the below 2 scenarios: Scenario1: ———— Create modules of rpgle codes mycode1 and mycode2 and then combine them using CRTPGM command. Scenario 2: ————- Create modules of rpgle codes mycode1 and mycode2 and then create service program for them. Is there any difference between the abvoe [...]
Answer Question
| June 16, 2012 1:47 PM
CRTPGM, CRTSRVPGM
