softwarelabs

Oracle Exadata Storage

noreply@blogger.com (prathap) — Wed, 22 Oct 2008 01:40:00 +0000

Oracle Exadata is a family of high performance storage software and hardware products that can improve data warehouse query performance by a factor of 10X or more. Oracle Exadata Storage is a combination of smart storage software from Oracle and industry-standard hardware from HP. Overcoming the limitations of conventional storage, Oracle Exadata uses a massively parallel architecture to dramatically increase data bandwidth between the database server and storage. In addition, smart storage software offloads data-intensive query processing from Oracle Database 11g Servers and does the query processing closer to the data. The result - faster, parallel data processing and less data movement through higher bandwidth connections.

The HP Oracle Exadata Storage Server is based on the HP ProLiant DL180 G5 server, and is a fast, reliable, high-capacity, industry-standard storage building block. With a choice of SAS or SATA drives and a storage capacity up to 12 TB per server, it has Oracle Exadata software pre-installed. In addition to extremely fast query processing for your large data warehouses, the massively parallel architecture offers linear scalability and mission-critical reliability.

Oracle Exadata Storage provides the foundation for building dynamic storage grids, and is the building block for the HP Oracle Database Machine. Designed for large, multi-terabyte data warehouses, the HP Oracle Database Machine is a complete package of software, servers, and storage. Simple and fast to implement, it has the power to tackle large-scale business intelligence problems immediately and can scale linearly as your data warehouse grows.

Highlights from Larry Ellison's Oracle OpenWorld 2008 Keynote (video, 4 min.)
Data sheet: HP Oracle Exadata Storage Server (PDF)

BENEFITS
	Extreme Performance—Accelerate data warehouse query performance and run more queries concurrently for faster access to critical business information Unlimited Scalability—Simply connect additional Oracle Exadata Storage Servers as needed to scale out Enterprise Ready—Get up and running quickly with a complete package of HP hardware and Oracle software

Oracle Database

noreply@blogger.com (prathap) — Fri, 17 Oct 2008 18:53:00 +0000

Oracle Database 11g

Oracle Database 11g, building on Oracle's unique ability to deliver Grid Computing, gives Oracle customers the agility to respond faster to changing business conditions, gain competitive advantage through technology innovation, and reduce costs.

With Oracle Database 11g you can:

Adopt new technology faster with Real Application Testing
Manage more data for less with advanced compression and partitioning
Simplify systems by storing all your data in the Oracle Database with Oracle SecureFiles
Maximize the ROI of disaster recovery resources with Oracle Active Data Guard
Free critical personnel for strategic tasks with management automation
And much, much more...

What's New

Learn about Oracle's hottest new product: Exadata

Listen to great new Oracle OpenWorld presentations through Oracle OpenWorld On Demand including:

"Extreme Scale-Out Architecture with TCO in Oracle Real Application Clusters 11g Versus MySQL" by EDS
"Managing Performance and Availability for 25,000 Siebel Contact Center Users with Oracle Real Application Clusters" by Deutsche Telekom AG
"Best Practices for Oracle Database - Information Management for the Enterprise" by Andy Mendelsohn of Oracle

Database Focus Areas

Application Development	Grid/Clustering	Optimized Storage Management
BI & Data Warehousing	High Availability	Performance
Content Management	Information Integration	Security and Compliance
Database Upgrade	Manageability	Spatial - Location Services
Exadata	Net Services

Learn More

	White paper: Oracle Database 11g Product Family (PDF)
	White paper: Innovate Faster with Oracle Database 11g (PDF)

	Data sheet: Oracle Database 11g Standard Edition (PDF)
	Data sheet: Oracle Database 11g Standard Edition One (PDF)

Option Data Sheets

	Oracle Database 11g Real Application Clusters (PDF)
	NEW! Oracle Database 11g Active Data Guard (PDF)
	NEW! Oracle Database 11g Total Recall (PDF)
	Oracle Database 11g Partitioning (PDF)
	NEW! Oracle Database 11g Advanced Compression (PDF)
	NEW! Oracle Database 11g Real Application Testing (PDF)
	Oracle Database 11g Diagnostic Pack (PDF)
	Oracle Database 11g Tuning Pack (PDF)
	Oracle Database 11g Change Management Pack (PDF)
	Oracle Database 11g Advanced Security (PDF)
	Oracle Database 11g Label Security (PDF)
	Oracle Database 11g Audit Vault (PDF)
	Oracle Database 11g Database Vault (PDF)

	Oracle Database 11g OLAP (PDF)
	Oracle Database 11g Data Mining (PDF)
	Oracle Database 11g Warehouse Builder Data Quality (PDF)
	Oracle Database 11g Warehouse Builder Enterprise ETL (PDF)
	Oracle Database 11g Warehouse Builder Connectors (PDF)
	Oracle Database 11g Spatial (PDF)
	Oracle Database 11g Content Database Suite (PDF)
	NEW! Oracle Database 11g In-Memory Database Cache (PDF)
	Oracle Secure Enterprise Search (PDF)

Oracle Development

noreply@blogger.com (prathap) — Wed, 15 Oct 2008 18:55:00 +0000

For Development:
Oracle WebLogic Server 10.3 Net Installer

The Net Installer is a download manager and installation program that allows you to download and install only the Weblogic Server components you select, without having to download the entire WebLogic Server installation package. You can always add more WebLogic Server components to you installation at a later time if you wish. The advantage of using the Net Installer is that you can minimize the amount of time spent downloading WebLogic Server software before getting started with development.

Download Linux x86 (42 MB) | Download Windows x86 (39 MB) | See All

Mandatory for 10.3 Net/Package Installers: Apache Plug-ins zip
- Security Advisory Page
- Instructions

Oracle JDeveloper 10g Release 3 (10.1.3.3)

Integrated development environment certified on Windows NT/2000/XP, Linux, and Macintosh. License is free (read the Pricing FAQ).

Download Studio Edition (JDeveloper + ADF + WebCenter Extension; 441MB) | See All

For Deployment:
Oracle WebLogic Server 10.3 Full Package Installer

The Package Installer includes all of the WebLogic Server components. You can choose to install a subset of these components, but all components will be downloaded to your system. The advantage of using the Package Installer is that you can install WebLogic Server on systems that are not connected to the Internet, or on secured systems that are not allowed to download files from the Internet.

Oracle and SAP fail to settle

noreply@blogger.com (prathap) — Tue, 07 Oct 2008 18:48:00 +0000

Oracle and SAP held settlement talks Monday in their TomorrowNow lawsuit but failed to reach an agreement that would end the case, an SAP spokeswoman said.
The scheduled meeting was held behind closed doors at the U.S. district court in San Francisco where the case is being heard, she said, declining to give further details. A spokeswoman for Oracle did not immediately return a call seeking comment.

Oracle recently took depositions in the case from SAP CEO Henning Kagermann and co-CEO Leo Apotheker, but it is still waiting to question other executives, including former president Shai Agassi, according to a joint discovery statement filed on Friday.

SAP has made 9 terabytes of documents available for Oracle's review, according to the statement, but the two sides are squabbling over which documents are relevant to the case and how Oracle should have access to them.

Oracle sued SAP last year, accusing employees at its TomorrowNow subsidiary, which provides third-party Oracle support services, of illegally downloading Oracle patches and other materials and using them to win over other Oracle customers.

News that the two sides failed to reach a settlement deal comes as no great surprise. SAP has seemed eager to settle the case, but Oracle has been steadily expanding its complaint, alleging recently that SAP executives knew of TomorrowNow's "illegal business model" when they bought the company.

SAP has admitted that TomorrowNow staff made "inappropriate downloads" from Oracle's Web site but has denied the widespread pattern of wrongdoing that Oracle alleges. SAP announced in July that it would close the TomorrowNow unit after failing to find a buyer.

The companies are scheduled to hold a discovery conference on Friday, followed by a conference call with the district court on Oct. 20. The trial data is currently set for February 2010.

SAP and Oracle have both posted documents from the case at their respective Web sites.

SAP (Systems, Applications and Products in Data Processing

noreply@blogger.com (prathap) — Mon, 06 Oct 2008 18:45:00 +0000

"SAP is the fourth largest "SAP is the fourth largest software company in the world. It ranks after Microsoft,IBM and Oracle in terms of market capitalization. SAP is the largest Enterprise Resource Planning (ERP) solution software provider.SAP's products focus on ERP, which it helped to pioneer. The company's main product is SAP R/3;the "R" stands for real time data processing and the number 3 relates to a three-tier application architecture: database, application server and client SAPgui.Other major product offerings include Advanced Planner and Optimizer (APO),Business Information Warehouse(BW),Customer Relationship Management(CRM),Supplier Relationship Management(SRM), Human Resource Management Systems(HRMS),Product Lifecycle Management(PLM), Exchange Infrastructure(XI) and Knowledge Warehouse(KW).Reportedly, there are over 91,500 SAP installations at more than 28,000 companies. SAP products are used by over 12 million people in more than 120 countries." software company in the world. It ranks after Microsoft,IBM and Oracle in terms of market capitalization. SAP is the largest Enterprise Resource Planning (ERP) solution software provider.SAP's products focus on ERP, which it helped to pioneer. The company's main product is SAP R/3;the "R" stands for real time data processing and the number 3 relates to a three-tier application architecture: database, application server and client SAPgui.Other major product offerings include Advanced Planner and Optimizer (APO),Business Information Warehouse(BW),Customer Relationship Management(CRM),Supplier Relationship Management(SRM), Human Resource Management Systems(HRMS),Product Lifecycle Management(PLM), Exchange Infrastructure(XI) and Knowledge Warehouse(KW).Reportedly, there are over 91,500 SAP installations at more than 28,000 companies. SAP products are used by over 12 million people in more than 120 countries."

Data replication

noreply@blogger.com (prathap) — Thu, 02 Oct 2008 19:13:00 +0000

The first release of Notes included a generalized replication facility. The generalized nature of this feature set it apart from predecessors like Usenet and continues to differentiate Notes from many other systems that now offer some form of synchronization or replication. The facility in Notes and Domino is not limited to email, calendar, and contacts. It works for any data in any application that uses NSF files, which are the standard container for data in the Notes architecture, for its storage. No special programming, tagging, or other configuration is required to enable replication.

Domino servers and Notes clients identify NSF files by their Replica IDs and keep files with matching IDs synchronized by bidirectionally exchanging data, metadata, and application logic and design. Replication between two servers, or between a client and a server, can occur over a network or a point-to-point modem connection. Replication between servers may occur at intervals according to a defined schedule, in near real-time when triggered by data changes in Domino server clusters, or on an ad-hoc basis when triggered by an administrator or programmatically.

Creation of a local replica of an NSF file on the hard disk of a Notes client enables the user of the client to take full advantage of Notes databases while working off-line — with the client synchronizing any changes when client and server next connect. Local replicas are also sometimes maintained for use while connected to the network in order to reduce network latency. Replication between a Notes client and Domino server can run automatically according to a schedule, or manually in response to a user or programmatic request. Local replicas on early releases of the Notes client did not always maintain all security features programmed into the applications, but starting with Notes 6 enforcement of application security is automatic for all local replicas. Early releases also did not offer a way to encrypt NSF files, raising concerns that local replicas potentially exposed too much confidential data on laptops or insecure home office computers,[citation needed] but an optional encryption feature for NSF files was added in more recent releases, and as of Notes 6 it is the default setting for newly created local replicas.

Oracle Database 11g Enterprise Edition

noreply@blogger.com (prathap) — Mon, 29 Sep 2008 18:33:00 +0000

Oracle Database 11g Enterprise Edition delivers industry leading performance, scalability, security and reliability on a choice of clustered or single-servers running Windows, Linux, and UNIX. It provides comprehensive features to easily manage the most demanding transaction processing, business intelligence, and content management applications.

Oracle Database 11g Enterprise Edition comes with a wide range of options to extend the world's #1 database to help grow your business and meet your users' performance, security and availability service level expectations

BENEFITS
Protects from server failure, site failure, human error, and reduces planned downtime
Secures data and enables compliance with unique row-level security, fine-grained auditing, transparent data encryption and total recall of data
High-performance data warehousing, online analytic processing, and data mining
Easily manages entire lifecycle of information for the largest of databases

DBMS

noreply@blogger.com (prathap) — Wed, 24 Sep 2008 19:20:00 +0000

This article is principally about managing and structuring the collections of data held on computers. For a fuller discussion of DBMS software, see Database management system.
A Computer Database is a structured collection of records or data that is stored in a computer system. The structure is achieved by organizing the data according to a database model. The model in most common use today is the relational model. Other models such as the hierarchical model and the network model use a more explicit representation of relationships (see below for explanation of the various database models).

A computer database relies upon software to organize the storage of data. This software is known as a database management system (DBMS). Database management systems are categorized according to the database model that they support. The model tends to determine the query languages that are available to access the database. A great deal of the internal engineering of a DBMS, however, is independent of the data model, and is concerned with managing factors such as performance, concurrency, integrity, and recovery from hardware failures. In these areas there are large differences between products.

oracle

noreply@blogger.com (prathap) — Tue, 23 Sep 2008 19:18:00 +0000

WHY ORACLE THE APPLICATIONS LEADER
Oracle unites the world's best enterprise applications in an open architecture to provide:

The most customer success
The most complete offering
The strongest strategic road map
#1 in CRM2, supply chain management1 and human capital management1
37,000 deployed applications customers
Most open, innovative and fastest growing application platform

oracle RDBMS

noreply@blogger.com (prathap) — Thu, 18 Sep 2008 01:57:00 +0000

Oracle RDBMS on Windows (32-bit and 64-bit)
Windows has become an increasingly popular platform for the deployment of database applications. The challenges to doing this successfully can be considerable. Database applications must simultaneously provide high performance, reliability, and scalability, all at a low total cost of ownership. Oracle Database 10g on Windows provides these capabilities.
The grid is revolutionizing the way companies conduct business with customers, partners, and employees. Oracle10g for Windows enables customers to thrive in these new business environments. With solutions based on Oracle10g technology, any organization, large or small, can seize new opportunities while simultaneously reducing technology costs.

The Oracle Database supports Windows operating systems on both Itanium and AMD64/EM64T hardware. You can download Oracle Database 10g from the software download page. To learn more about the Windows operating systems Oracle is certified on, log into Oracle Metalink and click on the Certify tab.

Technical Information
PDF Oracle Database 10g Release 2 Architecture on Windows - This technical whitepaper describes the Oracle 10g Release 2 RDBMS architecture for Windows and new features in the release, including AMD64/EM64T hardware support and Oracle Database Express Edition.

PDF Oracle Database 10g Architecture on Windows - This technical whitepaper describes the Oracle 10g RDBMS architecture for Windows and new features in the release.

HTML Oracle Database for 64-bit Windows - This article introduces the 64-bit Oracle database for Windows on Itanium and the many benefits from using Oracle on the platform.

PDF Oracle9i Release 2 Database Architecture on Windows - This technical white paper describes how the Oracle9i Release 2 RDBMS operates on Windows and takes advantage of the operating system's enterprise features.

PDF Oracle9i: Database Architecture on Windows - This technical white paper describes how the Oracle9i RDBMS operates on Windows and takes advantage of the operating system's enterprise features.

PDF Oracle8i on Windows NT/2000: Architecure, Scalability, and Tuning - This technical white paper describes how the RDBMS operates on Windows and takes advantage of the operating system's enterprise features. The paper also makes recommendations in maximizing database performance.

oracle

noreply@blogger.com (prathap) — Tue, 16 Sep 2008 18:27:00 +0000

Oracle Database 11g
Oracle Database 11g, building on Oracle's unique ability to deliver Grid Computing, gives Oracle customers the agility to respond faster to changing business conditions, gain competitive advantage through technology innovation, and reduce costs.

With Oracle Database 11g you can:

Adopt new technology faster with Real Application Testing
Manage more data for less with advanced compression and partitioning
Simplify systems by storing all your data in the Oracle Database with Oracle SecureFiles
Maximize the ROI of disaster recovery resources with Oracle Active Data Guard
Free critical personnel for strategic tasks with management automation
And much, much more...

Learn more:

White paper: Oracle Database 11g Product Family (PDF)
White paper: Innovate Faster with Oracle Database 11g (PDF)
Data sheet: Oracle Database 11g Standard Edition (PDF)
Data sheet: Oracle Database 11g Standard Edition One (PDF)

C TEST

noreply@blogger.com (prathap) — Thu, 11 Sep 2008 16:06:00 +0000

Test Yourself
Answer any SIX Questions. Write the programs after verifying on computer.

1. Mention at least 16 keywords (reserved words) of C language.

2. Mention at least 6 Unary operators of C language.

3. What do you know about bitwise left shift and right shift operators ?

4. Write a program, to display 1 to 20 natural numbers and their corresponding factors in tabular form as follows…
--------------------------------------
Number Factors
--------------------------------------
1 1
2 1, 2
3 1, 3
4 1, 2, 4
5 1, 5
6 1, 2, 3, 6
:
:
20 1,2,4,5,10
-----------------------------------------

5. Prepare a structure that can represent employee details like employee number, name and salary. Store 100 employees data in an array and determine how many employees have salary more than 5000/- Rs.

6. Prepare a user defined function that can determine area and perimeter of a circle of radius r. Use the function in main program also.

7. Prepare a program to display the following triangle of numbers using nested loops.
1
01
101
0101
10101
010101
1010101
01010101

sql 2005

noreply@blogger.com (prathap) — Fri, 08 Aug 2008 16:14:00 +0000

Introduction
SQL Server 2005 is available in a number of editions, each suitable for a particular environment or task. It is important to understand the differences between the available editions so that you can select the most appropriate one for your needs.
Available editions
The available editions of SQL Server 2005 are described in the following table.
SQL Server 2005 Edition
Description
Express Edition(Available in 32-bit version only)
A version of SQL Server 2005 for disconnected clients or stand-alone applications.
Standard Edition(Available in 32-bit and 64-bit versions)
Engineered for workgroup or department-level applications. Use this edition if you do not need the levels of scalability, performance, and availability offered by Enterprise Edition.
Developer Edition(Available in 32-bit and 64-bit versions)
Includes all of the functionality of Enterprise Edition, but is licensed for use as a development and test system, not as a production server. Use this edition to develop and test database solutions.This edition can be upgraded to enterprise Edition for production use.
Enterprise Edition(Available in 32-bit and 64-bit versions)
A comprehensive edition of SQL Server engineered for extremely high levels of scalability and performance. Use this edition for large-scale, enterprise-level, mission-critical applications. The Enterprise Edition contains all the features of the Standard Edition, as well as enterprise features, including:
Failover clustering
Database mirroring
Snapshot databases
Mirrored backups
Online page and file restore
Distributed partitioned views
Heterogeneous replication
Peer-to-peer replication
Additionally, 120-day evaluation editions of both versions of SQL Server 2005 Enterprise Edition is available.

sql 2005

noreply@blogger.com (prathap) — Fri, 08 Aug 2008 16:10:00 +0000

c program

noreply@blogger.com (prathap) — Wed, 30 Jul 2008 13:16:00 +0000

Prepare C language programs for the following.
1) to find the value of S using the formula S = U.T + ½ A.T2
2) to find both area and perimeter of a circle using the formulas
area = ÕR2
perimeter = 2ÕR
3) to find the volume V using the formula V = 1/3 ÕR2H
4) A person has gone to a shop and purchased items for some amount. Find the amount paid by him to the shop when shop is giving 30% discount on his purchasing amount.
5) Find the amount paid by a person to the Electricity board by taking previous month and current month readings from the keyboard. Assume the cost per each unit as Rs.3.50
6) Find simple interest using the formula SI = PNR/100
7) Find the temperature in Fahrenheit degrees using the formula
C/100 = (F-32)/180
8) Find the biggest of two numbers using ternary operator
9) Find the biggest of three numbers using ternary operator
10) Find the biggest among two numbers using ternary operator. But do not use any relational operator.
11) Take an integer value from the keyboard. Assume that it seconds values. Find number of Hours, Minutes and Seconds in that value.
12) Find the Hexadecimal number for a given positive Decimal number.
13) Program to display a doubled line box of any size at the center of the screen using the ASCII characters whose ASCII codes are 201, 205, 187, 186, 188, and 200.
14) Swapping: Interchange the values of two integer memory variables without considering the THIRD variable.
15) Display the following output
*
* *
*GOD*
* *
*
16) Find the value of Y where Y = 2X + 5 when x > 20
Y = 7X -12 when x >= 20
17) Find the sum of digits of a given 3 digit number.
18) What is the output of the following printf() statement
Printf(“%c and %c are in %c”,1,2,3);
19) Check whether the given number is a TWO digit number or not.
20) Display the value of 67 divided by TEN Thousand in exponential form.
21) Take a single character M/F from key board and display a male name like RAJU if the character is M or display a name like SITA if it is F.
22) Take the name of a person (Ex: RAJU ) from the keyboard and include it in a wishes message like HELLO, RAJU GOOD MORNING
23) Take a name of a person from the keyboard and display at the center of the screen in red color. The person’s name must contain more than TWO WORDS.
24) The basic salary of a person is input thru the keyboard. If dearness allowance(DA) is 150% of basic salary and if 75% is the Medical Loan then find the gross salary of that person.
25) If the selling price of 15 items and the total profit earned on them is input through the keyboard, write a program to find the cost price of one item.
26) program to display TRUTH TABLE of logical AND operator &&
0 && 0 = 0
0 && 1 = 0
1 && 0 = 0
1 && 1 = 1
27) Similarly display truth tables for Logical OR, Logical NOT and also for BitWise XOR( Exclusive OR ).
28) Program to change the case of an alphabet using bitwise operators.
29) Program to check whether the number is POSITIVE or NEGATIVE using bitwise SHIFT operators and ternary operator.
30) Program to check whether the number is EVEN or ODD using bitwise operators and ternary operator.
31) Program to subtract an integer number from another integer number by the method of 2’s complement addition. Use bitwise 1’s complement and arithmetic +.
32) Swapping: Take two positive integer numbers from key board and interchange their values using bitwise XOR operator. Don’t use any third variable.
33) Program to multiply a given integer number by 2 using bitwise SHIFT operator.
34) Program to multiply a given positive integer number with 5 using bitwise SHIFT and addition operator.
35) program to display the following structure.
**************************************************
* SNO * Roll No. * Student * Date of Birth * Fee Paid *
**************************************************
* *
* *
* *
* *
* *
*****************************************************
36) Take the year value from the key board and check whether it is a LEAP year or not. If year value is divisible by 4 it should be divisible by 100 also OR if it is divisible by 400 then the year will be LEAP year. Use only relational and logical operators. 1600, 1992 etc., are leap years. But 1700, 1997 etc., are not Leap years.
37) take hours, minutes and seconds value of time from the key board and find total number of seconds in that value.
38) Take a 3 digit number from key board and find its reverse number.
39) display GOD on the screen using printf. But printf statement should not be ended with semicolon.
40) Take any single character from key board ad display whether it is a LETTER or DIGIT or SPECIAL symbol.

Data Processing (SI)

noreply@blogger.com (prathap) — Sat, 19 Jul 2008 01:41:00 +0000

1 Data Processing (SI)
User will select option to either load file from UNIX or load file from PC.
If user selects load file from UNIX use OPEN DATASET.
If user selects load file from PC use WS_FILENAME_GET to select from PC and use GUI_UPLOAD to load input text file into internal table i_input.
Verify input data
Gather unique company code.
i. Loop at i_input
1. append BUKRS to i_bukrs
ii. Delete duplicate entries from i_bukrs
Gather data for validation
i. Reconciliation Account in General Ledger
1. Select SAKNR from SKB1 into i_skb1 for all entries in i_bukrs where bukrs = i_bukrs-bukrs and mitkz = ‘K’.
ii. Cash Management Group
1. Select GRUPP from T035 into i_t035.
iii. Recipient Type
1. Select QSREC from T059A into i_t059a where land1 = ‘US’.
iv. Payment Terms
1. Select ZTERM from T052 into i_t052 where KOART = ‘ ‘ or KOART = ‘K’.
v. Payment Methods
1. Select ZLSCH from T042Z into i_t042z where land1 = ‘US’.
vi. Payment Method Supplement
1. Select UZAWE from T042F into i_t042f.
Validate data.
i. Loop at i_input
1. Read table i_skb1 with key SAKNR = i_input-saknr.
a. If sy-subrc <> 0.
i. Move record to i_output, mark status of E, and message = Invalid reconciliation account.
ii. Delete from i_input.
2. Read table i_t035 with key GRUPP = i_input-GRUPP.
a. If sy-subrc <> 0.
i. Move record to i_output, mark status of E, and message = Invalid cash management group.
ii. Delete from i_input.
3. Read table i_t059a with key QSREC = i_input-QSREC.
a. If sy-subrc <> 0.
i. Move record to i_output, mark status of E, and message = Invalid recipient type.
ii. Delete from i_input.
4. Read table i_t052 with key ZTERM = i_input-ZTERM.
a. If sy-subrc <> 0.
i. Move record to i_output, mark status of E, and message = Invalid payment terms.
ii. Delete from i_input.
5. Read table i_t042z with key ZLSCH = i_input-ZWELS.
a. If sy-subrc <> 0.
i. Move record to i_output, mark status of E, and message = Invalid payment method.
ii. Delete from i_input.
6. Read table i_t042f with key UZAWE = i_input-UZAWE.
a. If sy-subrc <> 0.
i. Move record to i_output, mark status of E, and message = Invalid payment method supplement.
ii. Delete from i_input.
Load Vendors
Check i_input is not initial.
Use the following BDC recording. Everything pre-ceding with “record” will be from the input file.
Assume the file will be in the same format as the BDC recording lists the elements for input.

Unix Tutorials

noreply@blogger.com (prathap) — Fri, 14 Mar 2008 14:43:00 +0000

UNIX - TUTORIALS

What is UNIX ?

UNIX is a command-driven operating system. Users interact with UNIX by entering written commands, which the operating system understands and obeys. Microsoft DOS and other early PC-computer operating systems were based on UNIX, and in fact, some of the command names are the same.

Over the years, many vendors who produce different versions of UNIX have developed graphical user interfaces to help make UNIX more intuitive to new users. Some UNIX workstations may present you with a graphical interface instead of the shell window we refer to frequently.

Unlike other operating systems, which focus on a single task from a single user, UNIX can focus on many tasks from many users. This feature was one of the things that separated UNIX workstations from desktop personal computers. Processors in UNIX workstations are faster and more powerful than those found in desktop PCs. Additionally, UNIX workstations have very different memory and file management schemes that allow the UNIX workstation to operate much differently than PCs do.

In UNIX, tasks that are given to the processor are called processes. Each task is a separate process. Processes are carefully controlled by the operating system, which makes sure that all users' processes have some access to the processor at some time. Since the processor is so powerful, even a small slice of the processor's time measured in microseconds or even nano seconds can be used for useful work. By dividing up the processor's time into these small slices, it appears as though all users are getting their work done quickly and efficiently.

The UNIX operating system
Initially, UNIX required a lot of processing power and UNIX workstations were expensive so as to pay $30,000 for a single unit and as a result Vendors searched for a way to make their user interfaces different and more desirable to the consumer.

The outcome of this desire works out to be quite positive for the consumer. Different flavors of UNIX have become adept at different things. While you might find Hewlett- Packard and IBM workstations in the engineering department, you may find Silicon Graphics workstations doing complex simulations in the design department. In the world of networking, you may find a Sun workstation or even an Intel-based PC doing the mundane work of serving Web pages and providing email access to users.

The desire to differentiate has made UNIX very flexible indeed. Regardless of what flavor you choose, however, the core of the UNIX operating system stays the same.

UNIX is what's called a "layered" operating system. It's built like an onion, with several layers. At the very center is the kernel. The kernel is the heart of the operating system. The programming code in the kernel is specific to the processor in the computer because the kernel talks directly to the processor.

An IBM workstation with an RS6000 processor will have a different kernel than an IBM workstation running a PowerPC processor, even though they may be running the exact same version of AIX, IBM's flavor of UNIX. The kernel has some built-in commands. These built-in commands are very basic to the operation of the system.
Once the kernel has been compiled, we find the utilities at the next layer. Utilities are collections of programs that do work.
A utility can take the form of a simple program, like a command or a more complex program, like an application. Utilities are not processor-dependent, like the kernel.

UNIX utilities are written in C. Utilities or programs may have to be compiled, or they may come in a previously compiled state, called a "binary." A binary is the executable form of a program.

Last but not least is the outermost layer, the shell. A shell is a user interface. This is the way that you communicate your instructions to the CPU. For the most part, you cannot communicate directly with the CPU, so the shell acts as the intermediary, translating your requests into instructions the CPU understands.

There are many different shells for UNIX. T
1) The C-shell, so named because it closely resembles the C programming language.
2) The Korn
3) The Bourne shells, named after the people who created them.
4) The Bourne-Again shell, a smartly named modification of the Bourne shell.
5) The restricted shell. A restricted shell is a special shell, set up by the system administrator.

Normally, shells are used to limit a person's access to the operating system. In a restricted shell, you are given a "false" file structure, which includes only the commands and programs you are entitled to run. The restricted shell will not allow a user to escape to the larger file system that surrounds it. By limiting users in this way, a system administrator can provide a greater degree of security than what's possible with one of the other shells.
UNIX shells
The Bourne Shell
The Bourne shell is the original UNIX shell program. It is very widely used in programming circles. Typically, you can start the Bourne shell—if it hasn't been set as your default startup shell—by typing "sh" or "/bin/sh" at the command prompt. This will not spawn a new shell window, but rather will just change your current shell to the Bourne shell.
The Bourne shell supports conditional branching in the form of if/then/else statements. The syntax for the conditional statement in a Bourne shell is:
if condition then instructions elseif instructions else instructions if
In addition, the Bourne shell supports case statements and loops (for, while, and until). For the most part, a person who uses the shell simply to interact with the CPU for services may not take advantage of the programming capabilities of the shell. The Bourne shell uses the $ as a prompt.

The Korn shell
The Korn shell is a much newer variation of the Bourne shell. It supports everything the Bourne shell does, and adds features not available in the Bourne shell. The Korn shell is not a standard offering in UNIX installations. If you have the Korn shell, you can run it by typing ksh or /bin/ksh at the shell prompt.

If you want to use the Korn shell and it is not part of your UNIX installation, you can download a public-domain version of the Korn shell, called pdksh. This version is widely available on UNIX FTP sites and you can find a link to one in the resource section for this topic.

The Korn shell was originally written by David Korn and is copyrighted by AT&T. There are two major releases of this shell—11/16/88 and 12/28/93. As you can see, the releases are identified by their release dates. The programming structure of the Korn shell is very similar to that of the Bourne shell. The Korn shell, however, is more interactive.
The C shell
The C shell is a very commonly used shell. Its programming structure closely resembles that of the programming language "C." The C shell uses the "%" as a prompt, so you can tell by looking what shell you're working with.

The C shell is a very comfortable shell to work with, especially if you like to program. The C shell supports all of the features that the Bourne shell supports, and has a more natural syntax for programming. The C shell is more interactive than the Bourne shell. Since the C shell is newer than the Bourne shell, there are features and additions you'll find here that aren't available in older shells.

The configuration of the C shell is controlled by the .rc and the .login files. If you wish to make a change to your shell environment and want to use the change in your current session, you must ask the shell to re-read its configuration files again. To do this, use the "source" command, followed by the name of the file you want the shell to reread. Don't forget that your "rc" file begins with a "." and that must be included as part of the file name.
The Bourne-Again shell
The Bourne-Again shell is a variation of the Bourne shell. It is commonly used in Linux, but is widely available in other standard UNIX distributions. The Bourne Again shell is another modification of the Bourne shell, and uses the $ as a prompt.

To start the Bourne Again shell, type "bash" at the shell prompt. The behavior and environment of the Bourne Again shell is controlled by the .bashrc file, which you'll find as a hidden file in your home directory.
The tc shell
The tc shell is a more modern variation of the C shell. In fact, it reads the same configuration files that the C shell uses. Tcsh contains command line editing keystrokes that the C shell is missing, and has more "modern" conveniences that the C shell lacks.

The restricted shell
The restricted shell is not a shell in and of itself, like the other shells we've discussed so far. The restricted shell is a variation of a shell that limits what the user can do. Restricted shells are often used by system administrators who wish to limit the functions that certain users can access.

With a restricted shell, the system administrator decides which commands and functions a user will have access to. This is a good set-up for situations where you have unknown users—such as on an anonymous FTP server or on public terminals. Anonymous FTP and login FTP are discussed in more detail in the section entitled "UNIX Internet Services."

The restricted shell is one that is used as a default, as opposed to being a shell you switch into when you'd like to use it. Different flavors of UNIX have different methods of designating a restricted shell, so consult your man pages or other references specific to your flavor of UNIX if you'd like to establish restricted shells.

The differences between shell programs

The differences between all shells are mainly qualitative. For most functions, the shells—regardless of the one you use most—operate similarly. The differences between the shells are most noticeable when you use the shells to write programs and shell scripts. All shells recognize a standard set of built-in commands, but among shells the programming syntax varies. Generally, all shells have a set of pre-defined variables, but these variables differ between shells. That is, each shell has its own set of pre-defined variables.

Additionally, the shells have configuration files, which are usually stored in the user's home directory. Configuration files usually are named with a "." in front of them to hide them from regular listings. To see your shell configuration files, use the ls -a or ls -al command to show you the hidden files in your directory.

You might find a "resource file" for your shell. This would be something like ".cshrc" or ".bashrc" and you should also find a ".login" file.

The ".rc" file is read before the .login file. These files control the setup of your shell when it is started. In these files, variables are defined, parameters are set up and preferences are established. You can modify your UNIX prompt, for example, or set up your default printer. You can also set your terminal type, your history file size and you can determine whether or not you use the “savehist” command.

Finally, the list of all shells that are loaded onto your UNIX computer is stored in a file called /etc/shells. To look at the shells you have available, type "more /etc/shells at the command prompt.

what's the difference between UNIX and any other operating system?

Basically two things:
1) Internal implementation and
2) The interface that is seen and used by users.

UNIX includes the traditional operating system components. In addition, a standard UNIX system includes a set of libraries and a set of applications.

FAQ

noreply@blogger.com (prathap) — Sun, 09 Mar 2008 05:14:00 +0000

· Can I work with registry from within T-SQL?

· How can I check from the SQL Server whether the file exists or not?

· How can I copy text or image into or out of SQL Server?

· How can I create extended stored procedures?

· How can I decrypt a SQL Server stored procedure?

· How can I delete duplicate rows?

· How can I edit the system tables manually?

· How can I enforce to use particular index?

· How can I export a query result set into file?

· How can I get only the specified number of rows from my query?

· How can I make database to be read only?

· How can I remove foreign keys through SQL Server 7.0/2000 Enterprise Manager?

· How can I return from within a T-SQL the list of all available OLE DB providers?

· How can I return from within a T-SQL the list of all character sets and code pages?

· How can I return from within a T-SQL the list of server's DSNs?

· How can I return from within a T-SQL the list of server's hard drives?

· How can I return from within a T-SQL the list of Windows NT/2000 groups?

· How can I select only date/time part of a datetime value?

· How can I send a message to user from the SQL Server?

· How can I set database to a single user mode?

· How can I use a variable for the columns/tables in the select statements?

· How do I add 'n' working days to the given date and get the result date?

· How do I delete a particular value for a key in the registry via Transact-SQL?

· How do I delete an entire key from the registry via Transact-SQL?

· How do I execute an operating-system command via Transact-SQL?

· How do I get the date the object was created?

· How do I get working days between two dates?

· How do I move tables from one filegroup to another?

· How do I perform the same actions for all databases?

· How do I perform the same actions for all tables in a database?

· How do I read from the registry via Transact-SQL?

· How do I return the first day of the month for the given date?

· How do I reset the identity column?

· How do I return the last day of the month for the given date?

· How do I run a DTS package from the Query Analyzer or stored procedure?

· How do I run a T-SQL script through SQL-DMO?

· How do I run SQL script located on the disk file, using Transact-SQL?

· How do I write to the registry via Transact-SQL?

· How to install SQL scripts and import data to SQL Server from the command line?

· Is it possible to work with COM objects from within T-SQL?

· Why SELECT INTO statement does not work?

Troubleshooting

noreply@blogger.com (prathap) — Sat, 08 Mar 2008 02:08:00 +0000

The troubleshooting part specifies the possible errors that could be encountered while implementing the project. The most common errors that could be encountered are explained below:
1. Hardware Error:
Being a network based project, the most common hardware error that one comes across is the connectivity problem.
a. To ensure proper connectivity first of all check whether all the Ethernet Card at the nodes and at the Server are working properly.
b. Next ensure that connectivity is achieved from each node to the server through the hub. For this one can try either ping command or one of the remote access commands such as rlogin, telnet, etc.
c. Also check whether the connection wires to all the nodes are fine, i.e. they are not damaged and check whether they are crimped properly.
2. Errors in starting rlogin daemon:
One of the most common errors encountered in implementing parallel processing is that the remote access to some of the nodes may show error.
a. For this ensure that rlogin daemon is properly installed at all the nodes.
b. If rlogin daemon is already installed at all the nodes then look for the presence of following files at their respective locations.
rexec : / etc / pam.d / rexec
rlogin : / etc / pam.d / rlogin
rsh : / etc / pam.d / rsh
c. Also ensure that the “rlogin” and “rsh” files are present at /etc/xinetd.d / If these files are present then ensure that they have the following activation status, i.e.,
disable = no
3. Errors in starting PVM daemon:
In order to distribute jobs at different nodes the most important point is to make sure that the PVM daemon is properly working at each node and the server. If it is not working properly ensure that the daemon is installed at the server and the nodes. Other errors that may occur while working with PVM are as follows:
a. A “loopback” error may be encountered while staring the PVM daemon. For this run the following command at the command prompt to stop the loopback.
# ifconfig lo down
b. If while starting the PVM daemon an error occurs specifying to insert the hostname in the “.rhosts” file, then ensure that the “rsh” daemon is working properly. Also check whether “rsh” access is allowed to the client. This can be done by running the following command at the command promp:
# rsh ls

TT FAQ

noreply@blogger.com (prathap) — Sat, 08 Mar 2008 02:03:00 +0000

FAQ

1. Which file gets executed when
winRunner is Activated
a. wrun.exe

2. How may default addins are provided
in WinRunner?
A 4 addin (Active X, PB, VB, Web test)

3. What is the default test type
associated with TSL Script
a. Main Test

4. What is the test type where
function decleartions are declared
a. Compiled Module

5. What type of test can be performed
with the help of WinRunner
A. GUI Regression, Bit Map Regression
and User Interface test (Functional)

6. Which GUI Checkpoint displays the
expected values in TSL Script
A. SOSP (Single Property)

7. Which GUI Checkpoint created .ckl
file which need not be executed in
update mode
A. Multiple Object (SMOMP)

8. Which GUI Checkpoint focuses on all
the objects in application under test
A. Object / Window Property (MOMP)

9. How many windows are displayed if
a bitmap checkpoint fails because of
change in the size of window
A. Expected and Actual

10. Which bitmap checkpoint focuses
portion of application bitmap placed
on object
A. Object / Window Bitmap

11. Which checkpoint focuses on data
and database
a. Runtime Record check

12. What is the file extension where
expected values of Runtime record
check is stored?
A. .cvr (Check and Verify Record)

13. Which option in WinRunner helps
in analysis of property and bitmap
to appear within time limits
A. Synchronization point

14. Which option in WinRunner helps
in inserting function with a reference
to application objects?
A. Object / Window option

15. Which option in WinRunner helps in
analysis of time taken by a specific
process
A. Declare Transaction, Start Transaction
and End Transaction

16. Which option in winrunner helps
in enhancing the performance of tester
A. TSL Options (Paste TSL, Execute
TSL and Parameterized TSL)

17. Which function helps in accepting
inputs from the tester?
A. create_input_dialog();

18. Which function helps in activating
application under test?
A. invoke_application() and system();

19. Which function helps in providing
list of options to be selected at the
time of playback?
A. create_list_dialog();

20. Which functions can be used to
interact with Text files in O/S?
A. file_open(), file_getline(),
file_close(), file_putline();

21. Which option in WinRunner helps
in Visualization of Application under
test at the time of playback?
A. Run Minimized >> From top

22. Which option in WinRunner helps
in analysis of Script Part by part
A. Playback with Brakpoints

23. What is the shortcut key to record
in analog mode?
A. Function key F2 twice

24. Which operation gives a temprory
break at the time of playback?
A. Pause

25. What key combination terminates
the playback process?
A. Ctrl(L)+F3

26. How is script analyzed line by
line?
A. (F6) or Debug >> Step

27 Which mode of playback helps in
analysis of TSL Script?
A. Debug

28. Which option in WinRunner executes
script from a given location till the
current cursor position?
A. Step to Cursor

29. When is call chain activated?
A. When there is a breakpoint in
User Defined functions or Brakpoint
in called script

30. Which mode of playback helps in
analysis of Expected and Actual values
A. Verify

31. What is the short key which helps
in inserting or removing breakpoint
A. F9

32. Which mode of playback helps in
recapturing the expected values
A. Update

33. Which mode of playback is required
if .ckl or .cdl files are altered?
A. Update

34. What are the two options associated
with GUI Map Editor?
A. Global and Per test

35. Which option in GUI Spy helps in
Inspection of application
A. Object / Window

36. TSL Script can be written without
any errors with the help of?
A. GUI Spy and Syntax Check

37. Object which are not identified
or detected by winrunner belongs
to which class?
A. No class

38. What are the required parameters
to configure the Virtual object?
A. Class Name, X,Y,W,H and Logical
Name

39. How are objects configured to
appropriate class if addins are not
provided
A. GUI Map Configuration

40. Which option in WinRunner helps
in integration of multiple GUI Files
into one single file?
A. Merge GUI Map file

41. Which function helps in
implementing integrated test?
A. call();

42. All the unwanted windows can be
ignored with the help of?
A. Recovery Manager

43. All the Plans prepared by QAM
can be accessed by selecting?
A. Quality Center connection option

44. Which file holds multiple inputs
by default?
A. default.xls

45. Which function helps in getting
the parameters from .xls file?
A. ddt_val();

46. How are static values replaced
with dynamic values?
A. Data Driven Test / Parameterized
Data

47. Which function is used to get
the details of application objects
in GUI Map Editor?
A. GUI_load();

48. What is the file extension for
script files (TSL)?
A. No file extension

49. How are changes in applicatin
title managed in WinRunner?
A. Regular Expressions

50. Which function clears the details
from GUI Map Editor?
A. GUI_close_all();

bid

noreply@blogger.com (prathap) — Thu, 06 Mar 2008 21:42:00 +0000

Upgrade from Windows 2000 Server to 2003 Server?

noreply@blogger.com (prathap) — Thu, 06 Mar 2008 02:10:00 +0000

Upgrade from Windows 2000 Server to 2003 Server?
I was recently asked by the owner here at the ISP that I work for about the advantages and disadvantages of upgrading from Windows 2000 Server to Windows 2003 Server.The immediate response I gave is that it may be wise to wait another year before upgrading because at the current time we have no use for the added features that 2003 offers to be cost effective enough to warrant a systemwide change such as this. Our operating only consists of a few computers performing different server operations and under 10 computers in the office. All that we do is provide a service to customers, being the Internet, webhosting (soon -- using SSH instead of FTP), and our own little internal network operations such as a Platypus database. You can't always convince someone with your word especially in this business. We all know you NEVER take the word of one techie. You consult professionals if at all possible. Even then those professionals are themselves techies so it is best to consult more than one.I did a little research and this is what I came up with.Article: "Big businesses can postpone Windows 2003 Server uprade." http://www.theinquirer.net/?article=9238"Analysts agree that there is norush for users to migrate to Microsoft's new Windows 2003 Server operating system and many can refrain from upgrading for at least another year".Just as I had suggested -- wait another year.I was then told by the owner here that he received a package for $300/year consisting of multiple 2000 Server, 2003 Server, Microsoft Office, and other program licenses along with the actual program in a package. I am not 100% sure what the package was called though -- something like Windows 2003 Server Power Pack or something similiar.So naturally I said if this pack was only $300 a year and you receive all these licenses and programs in the package then go for it. After all we will need a few more Windows licenses soon so I say go for this pack and spend $300 instead of spending lots of money on JUST licenses.Useful Links on this Subject:Weighing Your Options: Deploy Windows 2000 Now or Wait for Windows Server 2003? Big business can postpone Windows 2003 Server upgrade

noreply@blogger.com (prathap) — Sun, 02 Mar 2008 08:39:00 +0000

Recovering Data from Windows systems by using Linux

noreply@blogger.com (prathap) — Wed, 28 Nov 2007 09:59:00 +0000

Recovering Data from Windows systems by using Linux Well, If you don't know how to use any OS you wont be able to do what you want to.. Windows allow you to access data, corrupted data even..just like fancy smancy Linux.. which linux is not even AIX.. is basicly became a windows emulation... even Windows was a MAC OSX emulation to begin with.. but like Windows, Linux NOW(since 1995) allows GUI interface/point and click interface.. it isn't at all pure keyboard command line interface no more.. making it a emulation like windows.. even with the new POWERSHELL by Microsoft even gives Windows a edge over Linux.. and you saying windows can not access a Linux box is completely WRONG.. if you go to your features in your Add and remove programs selection from your control panel.. you can install A UNIX AIX interface to just be able to net work with a linux box and write applications FROM a Windows platform just for A lunix platform.. besides.. Linux is almost 100% open-source, which sure thats great allows people to keep in touch with the software they write for a linux.. which allows... AUTOMATIC DOWNLOADS FOR DRIVERS.. theres your whole reason.. linux has automatic downloads at the begining of its installation on loading up the platform IS BASICLY WHY you don't have much complications on driver instalation.. heh sounds like a school house rock song... Microsoft is stomping on Linux mainly with theyre new Virtual Machine in the security features.. sure on a windows.. Microsoft doesn't want to database a couple MILLION dlls so you can have webcams from different brand names automaticly installed.. Linux loves open source and databasing every lil dll configuration.. thats IS WHY YOU DONT HAVE MUCH ERRORS IN INSTALLATION.. Microsoft rules ;) besides all that linux open source automatic update is NOT SECURE ONE BIT .. PERIOD..

softwarelabs

Oracle Exadata Storage

BENEFITS

RELATED PRODUCTS

Oracle Database

Oracle Database 11g

Oracle Development

Oracle and SAP fail to settle

SAP (Systems, Applications and Products in Data Processing

Data replication

Oracle Database 11g Enterprise Edition

DBMS

oracle

oracle RDBMS

oracle

C TEST

sql 2005

sql 2005

c program

Data Processing (SI)

Unix Tutorials

FAQ

Troubleshooting

TT FAQ

bid

Upgrade from Windows 2000 Server to 2003 Server?

Recovering Data from Windows systems by using Linux