Validate SQL and display the output
I have a screen where the user can enter an SQL script, I need to validate whether the SQL query is a valid one, if so then display the output on to the screen. I am planning to execute a SQL prepare statement out of the script entered and then use SQLCOD to determine whether [...]
Answer Question
| January 29, 2013 8:14 AM
SQL Query, SQL scripts, SQLRPGLE
I have a screen where the user can enter an SQL script, I need to validate whether the SQL query is a valid one, if so then display the output on to the screen. I am planning to execute a SQL prepare statement out of the script entered and then use SQLCOD to determine whether [...]
Answer Question
| January 29, 2013 8:14 AM
SQL Query, SQL scripts, SQLRPGLE
Question is about ILERPG
I have been given a module name and I’m asked to find out the name of the service programs which included that module. Is there any possible way to find it?
Answer Question
| January 29, 2013 7:27 AM
AS/400, AS/400 commands, ILERPG
I have been given a module name and I’m asked to find out the name of the service programs which included that module. Is there any possible way to find it?
Answer Question
| January 29, 2013 7:27 AM
AS/400, AS/400 commands, ILERPG
Single page subfile with filter
I have a single page subfile which has two fields, ‘Account’ and ‘description’. The subfile is displayed from File1 which has account(key) but doesn’t have description. I am fetching description from another file based on the ‘account’. Now in the subfile I want to include a filter or a ‘position to’(any of the one will [...]
Answer Question
| January 29, 2013 7:13 AM
AS/400, AS/400 Subfiles
I have a single page subfile which has two fields, ‘Account’ and ‘description’. The subfile is displayed from File1 which has account(key) but doesn’t have description. I am fetching description from another file based on the ‘account’. Now in the subfile I want to include a filter or a ‘position to’(any of the one will [...]
Answer Question
| January 29, 2013 7:13 AM
AS/400, AS/400 Subfiles
How to open XNK file
I moved a Microsoft Outlook folder to my desktop, but cannot open it. It is an XNK file. I read on this web site that Windows can open it. How? What is the procedure? Claire
Answer Question
| January 29, 2013 11:21 PM
Microsoft Outlook, Microsoft Outlook folders, XNK FILE
I moved a Microsoft Outlook folder to my desktop, but cannot open it. It is an XNK file. I read on this web site that Windows can open it. How? What is the procedure? Claire
Answer Question
| January 29, 2013 11:21 PM
Microsoft Outlook, Microsoft Outlook folders, XNK FILE
IKM assessment
Can anybody help me with IKM Quality Assurance sample questions please
Answer Question
| January 29, 2013 11:16 PM
IKM, Quality assurance, Quality assurance testing
Can anybody help me with IKM Quality Assurance sample questions please
Answer Question
| January 29, 2013 11:16 PM
IKM, Quality assurance, Quality assurance testing
Where can I find online resources relating to MTA examinations?
Hi, I am sitting MTA exam 98-365 Windows Server administration fundamentals. I am looking for resources that may help me prepare for same have the book. DOK
Answer Question
| January 29, 2013 10:24 PM
MTA exam, Windows server administration, Windows Server Training
Hi, I am sitting MTA exam 98-365 Windows Server administration fundamentals. I am looking for resources that may help me prepare for same have the book. DOK
Answer Question
| January 29, 2013 10:24 PM
MTA exam, Windows server administration, Windows Server Training
Incoming/Outgoing server and account type
How do I find out this information for rocketmail.com?
Answer Question
| January 29, 2013 9:40 PM
Email, Email account
How do I find out this information for rocketmail.com?
Answer Question
| January 29, 2013 9:40 PM
Email, Email account
Panasas storage cluster
I have a Panasas storage cluster and I need help on installing it (home lab). I didn’t find any documentation online about how to install it. Can anyone help me or lead me to step by step installation and setup user guide? I don’t have any cable so I don’t know which cables I need to use. [...]
Answer Question
| January 28, 2013 8:17 PM
Panasas, Storage, Storage arrays
I have a Panasas storage cluster and I need help on installing it (home lab). I didn’t find any documentation online about how to install it. Can anyone help me or lead me to step by step installation and setup user guide? I don’t have any cable so I don’t know which cables I need to use. [...]
Answer Question
| January 28, 2013 8:17 PM
Panasas, Storage, Storage arrays
Run Oracle Procedure in SSRS dataset
Have an Oracle stored procedure that needs to run to repopulate a table. Do not need data from sp, have a separate dataset to pull from refreshed table. What I need is a way to run the sp that is acceptable to SSRS inside or outside of dataset.
Answer Question
| January 28, 2013 7:43 PM
Oracle, SSRS, Stored Procedure
Have an Oracle stored procedure that needs to run to repopulate a table. Do not need data from sp, have a separate dataset to pull from refreshed table. What I need is a way to run the sp that is acceptable to SSRS inside or outside of dataset.
Answer Question
| January 28, 2013 7:43 PM
Oracle, SSRS, Stored Procedure
Security management
How a problem of a computer losing its system security can be solved?
Answer Question
| January 28, 2013 6:01 PM
Security, Security management
How a problem of a computer losing its system security can be solved?
Answer Question
| January 28, 2013 6:01 PM
Security, Security management
What will be the next big data center transformation?
As technology and most notably ‘data’ continues to grow over the next decade, many companies will depend on the evolution of data centers to keep pace with the growth rate. Some notable (and possible) data center transformations could include: Energy-efficient servers, power distribution and cogeneration. What do you think will be the next big data [...]
Answer Question
| February 7, 2013 4:58 PM
Big Data, DataCenter
As technology and most notably ‘data’ continues to grow over the next decade, many companies will depend on the evolution of data centers to keep pace with the growth rate. Some notable (and possible) data center transformations could include: Energy-efficient servers, power distribution and cogeneration. What do you think will be the next big data [...]
Answer Question
| February 7, 2013 4:58 PM
Big Data, DataCenter
How can I direct Interactive jobs to specific subsystems?
We have 2 interactive subsystems. One was intended for all the interactive jobs of the IT department. The other was for all non-IT users. The idea being – if necessary, the non-IT user subsystem could be ended while IT people were still logged on fixing a problem or whatever. When interactive sessions are started the [...]
Answer Question
| January 28, 2013 4:42 PM
AS/400, AS/400 subsystem
We have 2 interactive subsystems. One was intended for all the interactive jobs of the IT department. The other was for all non-IT users. The idea being – if necessary, the non-IT user subsystem could be ended while IT people were still logged on fixing a problem or whatever. When interactive sessions are started the [...]
Answer Question
| January 28, 2013 4:42 PM
AS/400, AS/400 subsystem
RPG Programmer
I am IT consultant and have worked on two short contracts for clients based in Melbourne(Australia) as RPG Programmer for a period of 10 months. One client is into Fleet Leasing and another one is in Superannuation. Along with this I have also worked as Technical Support assistant and happen to get some basic experience [...]
Answer Question
| January 28, 2013 1:30 PM
AS/400, AS/400 training
I am IT consultant and have worked on two short contracts for clients based in Melbourne(Australia) as RPG Programmer for a period of 10 months. One client is into Fleet Leasing and another one is in Superannuation. Along with this I have also worked as Technical Support assistant and happen to get some basic experience [...]
Answer Question
| January 28, 2013 1:30 PM
AS/400, AS/400 training
Automatic resizing of images through mail merge in Publisher 2010
Hi, I am new to the whole world of mail merge and trying to help our charity administrator with a wee problem she has, but have become rather stuck myself! We are trying to produce a high volume of child profiles for a child sponsorship program we administer. In the past all information has been [...]
Answer Question
| January 28, 2013 1:08 PM
Microsoft Excel, Microsoft Publisher 2010
Hi, I am new to the whole world of mail merge and trying to help our charity administrator with a wee problem she has, but have become rather stuck myself! We are trying to produce a high volume of child profiles for a child sponsorship program we administer. In the past all information has been [...]
Answer Question
| January 28, 2013 1:08 PM
Microsoft Excel, Microsoft Publisher 2010
Reporting period
Need help to create 12-month running total by customer_id which include the following: 1. MonthlyTotal 2. Monthly Percentage, 3. Previous Month total, 3. YTD 4 . YTD Percentage Below is an example of what I am trying to accomplish. Within the example there are customer_id , 24 and 25. Each row of data represents one [...]
Answer Question
| January 28, 2013 12:52 PM
SAS, SAS 9.2
Need help to create 12-month running total by customer_id which include the following: 1. MonthlyTotal 2. Monthly Percentage, 3. Previous Month total, 3. YTD 4 . YTD Percentage Below is an example of what I am trying to accomplish. Within the example there are customer_id , 24 and 25. Each row of data represents one [...]
Answer Question
| January 28, 2013 12:52 PM
SAS, SAS 9.2
BlackBerry Curve 8520
My blackberry can’t open even when I open it to write. To me, that it is an error and I must push the bottom of reset and when I push it to open again, the same problem occurs. Is it the software?
Answer Question
| January 28, 2013 9:46 AM
BlackBerry, Blackberry Curve
My blackberry can’t open even when I open it to write. To me, that it is an error and I must push the bottom of reset and when I push it to open again, the same problem occurs. Is it the software?
Answer Question
| January 28, 2013 9:46 AM
BlackBerry, Blackberry Curve
Dock
What is the meaning of DOCK that relates to the computer? What does it actually mean? What courses relates to it?
Answer Question
| January 28, 2013 9:07 AM
computer dock, dock
What is the meaning of DOCK that relates to the computer? What does it actually mean? What courses relates to it?
Answer Question
| January 28, 2013 9:07 AM
computer dock, dock
How to limit exact file name for data access on AS/400 through ODBC
How to limit exact file name…we need the restrict exact file name (not at all) when our user use data access on AS/400 through ODBC.
Answer Question
| January 28, 2013 7:17 AM
AS/400, ODBC
How to limit exact file name…we need the restrict exact file name (not at all) when our user use data access on AS/400 through ODBC.
Answer Question
| January 28, 2013 7:17 AM
AS/400, ODBC
Long field in display file
I have a display file which has a long field which is meant to hold a SQL query. The field is assumed to appear in the screen as 16 lines, with 68A per line. So When I declared a field of length 1088A(16*68) but how can I declare it to have only 68 per line [...]
Answer Question
| January 28, 2013 7:16 AM
AS/400, DSPF, SQL Query
I have a display file which has a long field which is meant to hold a SQL query. The field is assumed to appear in the screen as 16 lines, with 68A per line. So When I declared a field of length 1088A(16*68) but how can I declare it to have only 68 per line [...]
Answer Question
| January 28, 2013 7:16 AM
AS/400, DSPF, SQL Query
Mirror/Clone
I have a client with IBM made server using Windows 2003 Server running Oracle applications and some other stuff. He is having another IBM made server with same configuration and everything but is not installed with any OS or apps whatsoever. Now, he wants to create a exact replica of the first server with Windows [...]
Answer Question
| January 28, 2013 7:13 AM
IBM Servers, Oracle applications, Windows 2003 Server
I have a client with IBM made server using Windows 2003 Server running Oracle applications and some other stuff. He is having another IBM made server with same configuration and everything but is not installed with any OS or apps whatsoever. Now, he wants to create a exact replica of the first server with Windows [...]
Answer Question
| January 28, 2013 7:13 AM
IBM Servers, Oracle applications, Windows 2003 Server
