Viewing stored procedure statements in AS/400
Hi, I created many stored procedures using STRSQL. And I called those procedures using SQLRPGLE program. It worked but I need to view those statements. I don’t know how to view stored procedure statements which was created using STRSQL. Can anybody help me?
Answer Question
| January 22, 2013 10:26 AM
AS/400, SQLRPGLE, STRSQL
Hi, I created many stored procedures using STRSQL. And I called those procedures using SQLRPGLE program. It worked but I need to view those statements. I don’t know how to view stored procedure statements which was created using STRSQL. Can anybody help me?
Answer Question
| January 22, 2013 10:26 AM
AS/400, SQLRPGLE, STRSQL
Calculate overtime in Excel
Hi All, I need to work out if the time captured in my AmendedDate column falls outside normal business hours. So basically I am reporting for a Call Centre, which logs support tickets. In my Database I already have a created Date (when the Ticket was Issued), AmendedDate (When the technician made any changes) and [...]
Answer Question
| January 22, 2013 9:20 AM
Microsoft Excel 2010, Microsoft Excel formulas
Hi All, I need to work out if the time captured in my AmendedDate column falls outside normal business hours. So basically I am reporting for a Call Centre, which logs support tickets. In my Database I already have a created Date (when the Ticket was Issued), AmendedDate (When the technician made any changes) and [...]
Answer Question
| January 22, 2013 9:20 AM
Microsoft Excel 2010, Microsoft Excel formulas
Highlight Heading in color background in DSPF
In a display file I want to highlight the heading in a color background. How can I achieve this? eg: similar to what we can see when we use a fill color in Excel sheet.
Answer Question
| January 22, 2013 5:38 AM
AS400 DSPF
In a display file I want to highlight the heading in a color background. How can I achieve this? eg: similar to what we can see when we use a fill color in Excel sheet.
Answer Question
| January 22, 2013 5:38 AM
AS400 DSPF
Deleted calendar appointments in Outlook 2010
Is there any way possible in Outlook 2010 that when someone deletes an appointment in the calendar the delegates will be notified? We tried having the person that deleted the item to be considerate and email their admin/delegate but the person deleting the message would forget to let the admin/delegate know. I need to find [...]
Answer Question
| January 21, 2013 6:20 PM
Microsoft Outlook 2010, Microsoft Outlook Calendar
Is there any way possible in Outlook 2010 that when someone deletes an appointment in the calendar the delegates will be notified? We tried having the person that deleted the item to be considerate and email their admin/delegate but the person deleting the message would forget to let the admin/delegate know. I need to find [...]
Answer Question
| January 21, 2013 6:20 PM
Microsoft Outlook 2010, Microsoft Outlook Calendar
What do you see happening in the networking industry in 2013?
Network security, data center networks, campus LANs, software-defined networking…these are just some of the major topics that are making waves in the networking industry. The SearchNetworking team recently asked several industry analysts for their networking predictions for 2013. How about you? What do you see happening in the industry in 2013?
Answer Question
| February 25, 2013 5:36 PM
Networking, Networking security, Networking services, SDN
Network security, data center networks, campus LANs, software-defined networking…these are just some of the major topics that are making waves in the networking industry. The SearchNetworking team recently asked several industry analysts for their networking predictions for 2013. How about you? What do you see happening in the industry in 2013?
Answer Question
| February 25, 2013 5:36 PM
Networking, Networking security, Networking services, SDN
Distributing forms in Acrobat 9 Pro
In trying to submit a form in Acrobat 9 I get the message “the data collection workflow has ended and data is no longer being accepted.” How can I correct that?
Answer Question
| January 21, 2013 5:19 PM
PDF fillable forms
In trying to submit a form in Acrobat 9 I get the message “the data collection workflow has ended and data is no longer being accepted.” How can I correct that?
Answer Question
| January 21, 2013 5:19 PM
PDF fillable forms
Job plan in sequence
I have job plans that are in a sequence in Maximo 5.2 but the supervisor field becomes blank whenever the next jp plan is called. All the plans should have the same supervisor.
Answer Question
| January 21, 2013 2:13 PM
Maximo 5.2
I have job plans that are in a sequence in Maximo 5.2 but the supervisor field becomes blank whenever the next jp plan is called. All the plans should have the same supervisor.
Answer Question
| January 21, 2013 2:13 PM
Maximo 5.2
Leaving a computer on for a long period of time
Should a computer be left on for a long period of time (non server)?
Answer Question
| January 21, 2013 12:57 PM
Computers, Hardware
Should a computer be left on for a long period of time (non server)?
Answer Question
| January 21, 2013 12:57 PM
Computers, Hardware
Find one instance of each file extention on a PC
Hello, I am looking for an app that will give me one instance of each file extension on a PC HDD. I would like to use this info to include in a XXcopy script so I could separate the user files from the os/app files etc. so I could clean up a drive quickly. Thank [...]
Answer Question
| January 21, 2013 12:54 PM
Applications, File extensions
Hello, I am looking for an app that will give me one instance of each file extension on a PC HDD. I would like to use this info to include in a XXcopy script so I could separate the user files from the os/app files etc. so I could clean up a drive quickly. Thank [...]
Answer Question
| January 21, 2013 12:54 PM
Applications, File extensions
High usage of SQL Server
The SQL Server usage becomes high….How do I reduce the usage of SQL Server? The system performance becomes slow.
Answer Question
| January 21, 2013 11:55 AM
Data usage, SQL Server
The SQL Server usage becomes high….How do I reduce the usage of SQL Server? The system performance becomes slow.
Answer Question
| January 21, 2013 11:55 AM
Data usage, SQL Server
Add text with pictures in a report
We have embedded pictures inside a memo field and want to add these pictures into a report. If possible, how can we implement this?
Answer Question
| January 21, 2013 7:33 AM
Crystal Report, Crystal Reports fields
We have embedded pictures inside a memo field and want to add these pictures into a report. If possible, how can we implement this?
Answer Question
| January 21, 2013 7:33 AM
Crystal Report, Crystal Reports fields
Coding variables
I have 3 variables in the data set(PR1, PR2, PR3)of medical procedures which coded with procedures that the patients received (normal data). I need create a variable containing 2 codings (001 and 002) from all these 3 procedures (PR1,PR2,PR3). I also need to keep 001 and 002 coding separately for analysis. Anyone knows how to [...]
Answer Question
| January 21, 2013 11:11 PM
SPSS, SPSS 21
I have 3 variables in the data set(PR1, PR2, PR3)of medical procedures which coded with procedures that the patients received (normal data). I need create a variable containing 2 codings (001 and 002) from all these 3 procedures (PR1,PR2,PR3). I also need to keep 001 and 002 coding separately for analysis. Anyone knows how to [...]
Answer Question
| January 21, 2013 11:11 PM
SPSS, SPSS 21
Closing BOM components
Can you set up master data to close work orders when a % of the total has been issued on specific components?
Answer Question
| January 21, 2013 9:26 PM
BOM, BOM components
Can you set up master data to close work orders when a % of the total has been issued on specific components?
Answer Question
| January 21, 2013 9:26 PM
BOM, BOM components
Excel 2010 question
How do I execute fill right, fill down, and simply undo?
Answer Question
| January 21, 2013 4:40 PM
Microsoft Excel 2010, microsoft excel functions
How do I execute fill right, fill down, and simply undo?
Answer Question
| January 21, 2013 4:40 PM
Microsoft Excel 2010, microsoft excel functions
Upgrading my network
I own a heavy truck dealership with 2 locations, 75 employees and approx 35 computers. Currently all employees operate off there desk computers with files storage directly on there hard drives with no back up solution. Email is hosted by our internet provider currently works fine and we use Microsoft Office. I need a solution [...]
Answer Question
| January 21, 2013 11:23 AM
Microsoft Office, Microsoft Office 365
I own a heavy truck dealership with 2 locations, 75 employees and approx 35 computers. Currently all employees operate off there desk computers with files storage directly on there hard drives with no back up solution. Email is hosted by our internet provider currently works fine and we use Microsoft Office. I need a solution [...]
Answer Question
| January 21, 2013 11:23 AM
Microsoft Office, Microsoft Office 365
What Is The Best Touch-Screen Monitor For Me?
I need a touch screen monitor that connects to either vga or dvi on my desktop. The screen must be at least 9 inches big and it must be precise with a touch pen. I am looking to spend less than $150 on it. Also, it should be in a stand, like a regular desktop [...]
Answer Question
| January 20, 2013 10:57 AM
Desktop, MONITOR, touchscreen
I need a touch screen monitor that connects to either vga or dvi on my desktop. The screen must be at least 9 inches big and it must be precise with a touch pen. I am looking to spend less than $150 on it. Also, it should be in a stand, like a regular desktop [...]
Answer Question
| January 20, 2013 10:57 AM
Desktop, MONITOR, touchscreen
Active Directory
Why change my time settings automatically from Active Directory server 2008 r2 when I restart my computer?
Answer Question
| January 21, 2013 8:17 AM
Active Directory, Active Directory 2008
Why change my time settings automatically from Active Directory server 2008 r2 when I restart my computer?
Answer Question
| January 21, 2013 8:17 AM
Active Directory, Active Directory 2008
Wireless connecton when computer sleeps
My wireless connection is use through my PC. When my PC goes to sleep, my wireless connection turns off. How could I continue using my wireless connection when my PC sleeps?
Answer Question
| January 21, 2013 6:11 AM
Wireless, Wireless connection
My wireless connection is use through my PC. When my PC goes to sleep, my wireless connection turns off. How could I continue using my wireless connection when my PC sleeps?
Answer Question
| January 21, 2013 6:11 AM
Wireless, Wireless connection
How to convert FXP to PRG file name (ITMAS.FXP TO ITMAS.PRG)
How can I convert FXP to PRG?
Answer Question
| January 21, 2013 2:09 AM
FXP, PRG
How can I convert FXP to PRG?
Answer Question
| January 21, 2013 2:09 AM
FXP, PRG
Picture Doesn’t Appear
In my preview window I see the picture I have inserted into my document, but when I open up the document the picture is not showing and this message appears where the picture should have been. {SHAPE/*MERGEFORMAT} Is there anything I can do to get the picture to appear?
Answer Question
| January 21, 2013 5:36 PM
Microsoft Word, Microsoft Word features
In my preview window I see the picture I have inserted into my document, but when I open up the document the picture is not showing and this message appears where the picture should have been. {SHAPE/*MERGEFORMAT} Is there anything I can do to get the picture to appear?
Answer Question
| January 21, 2013 5:36 PM
Microsoft Word, Microsoft Word features
