Questions & Answers
Active Directory, AS/400, Business Intelligence, Career Development, CIO, CRM, Database, DataCenter, Development, Hardware, IBM DB2, IBM iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, Marketing, Marketing Technology, Microsoft Access, Microsoft Excel, Microsoft Exchange, Microsoft Exchange 2003, Microsoft Exchange 2007, Microsoft Outlook, Microsoft Outlook 2003, Microsoft Outlook 2007, Microsoft Windows, Microsoft Windows 7, Microsoft Windows Server 2003, Microsoft Windows XP, Mobile, Networking, Oracle, OS, Routers, RPG, RPGLE, SAP, Security, Servers, SQL, SQL Server, SQL Server 2005, Storage, Virtualization, VoIP, VPN, Windows Server, Windows Server 2008 ...VIEW ALL TAGS
- Business Intelligence
- Career Development
- Cloud Computing
- Content Management
- Data Management
- Desktop Management
- Email Administration
- IT Strategy
- Lotus Domino
- Microsoft Exchange
- Microsoft Windows
I am trying to retrieve, within a CL program, the information under the WRKJOB command - with OPTION(*CMNSTS) selected. I am successfully using the API QUSRJOBI in a CL program to retrieve information such as Current User but I can't see any reference that looks like the Communication Status panel....
How can I find the duplicate rows count from employee table in Oracle 9i?
how to call trigger stored in database using oracle forms
How can I call a trigger in a SQL Server stored procedure?
How do I find duplicate records in a table?
Can u please tell me how to call a oracle stored procedure that accepts 2 in parms and returns a Ref cursor as out parameter exmple: CREATE OR REPLACE PROCEDURE GetReportData ( Id1 IN NUMBER, Id2 IN NUMBER, resultSet OUT sys_refcursor )
In my Oracle database, I have this stored procedure: procedure getInfo ( p_ids IN IDS_TABLE, p_details OUT cursor ) Here's what the IDS_TABLE means: create or replace type IDS_TABLE as table of IDS create or replace type IDS as object ( id1 NUMBER, id2 NUMBER, id3 NUMBER ) Would it be possible for...
How to find the second highest value in a table using a Query. For example, in a table of employees how to find the second highest salaried employee.
We've been working on an ASP.NET project that's using an Oracle database. We've been using TOAD to add and manage stored procedures. This is where the problem lies....we're having too much trouble testing an Oracle stored procedure. Here's an example of one of our stored procedures: CREATE OR...
Find the employees who earn a salary greater than the average salary for their departments using a SQL query
there are two tables employees and jobs .employees table attributes are job_id and salary.jobs having attibute job_id,job_title.i want to retrieve sum(salary),job_title group by job_id
One table named as employee has 3 columns (name, salary, department). I need to retrieve the employees whose salary is greater than average salary of their department. that is name salary department iioo 10000 Technical aaaa 15000 HR pppp 17000 ...
How to solve to my PC question. My user profile cannot be loaded. What should I do?
SBS 2003 (Exchange 2003 sp2) Hi, I installed an SBS 2003 and all work fine. Now, I have 2 smartphone: 1 nokia and 1 htc (wm6.1) For nokia I use Mail for Exchange to synchronise mails, contacts and calendar For htc, I use ActiveSync. All sync works fine *** but *** I have 1 issue: * I defined some...
Please a simple batch file for displaying a popup window with a message Thanks
Open Report - No Saved Data This report file does not contain saved data and cannot be viewed. New install of CR 2008 viewing report over vender database. How do I link data to reports I write?
When I open database expert and open a new DB connection, only tables and stored procedures are shown. How do I get views to show? And yes, I did select views under options/database.
I'm pretty new to EWS MAPI and I'm having some difficulty with how to create and managed tasks. I've figured out how to create a task for myself with a problem but here's where I'm stuck. I can't create a task and assign it to another user. Can't interrogate the status of the task (percent...
We are moving our Microsoft Access database to SQL Server 2005, and the Access database has password protection. How can you add a password to a database in SQL Server 2005?
Hi all, The APO system has many data sources. I have activated all the datasource with TCODE RSA5. I want to extract APO data to BW (Not APO's),where the APO data come from for BW extract. APO BW? SAP transparent table of APO? APO liveCache? Please help me. Thank you very much.