Premium Essay

Db2 Concepts

In: Computers and Technology

Submitted By newuser
Words 30246
Pages 121
DB2 & SQL Concepts

1.2.1 What is SQL?

Structured Query Language (SQL) is a standardized language for defining and manipulating data in a relational database. In accordance with the relational model of data, the database is perceived as a set of tables, relationships are represented by values in tables, and data is retrieved by specifying a result table that can be derived from one or more tables.
DB2 transforms the specification of a result table into a sequence of internal operations that optimize data retrieval. This transformation occurs when the SQL statement is prepared. This transformation is also known as binding.

1.2.2 Static SQL

The source form of a static SQL statement is embedded within an application program written in a host language such as COBOL. The statement is prepared before the program is executed and the operational form of the statement persists beyond the execution of the program.

A source program containing static SQL statements must be processed by an
SQL precompiler before it is compiled. The precompiler checks the syntax of the SQL statements, turns them into host language comments, and generates host language statements to invoke DB2.

1.2.3 Dynamic SQL

A dynamic SQL statement is prepared during the execution of an SQL application, and the operational form of the statement is not persistent.
The source form of the statement is a character string passed to DB2 by an application program using the static SQL statement PREPARE or EXECUTE
IMMEDIATE. DB2 also uses dynamic SQL for system-directed access (1) .

1.2.4 Interactive SQL

In this book, interactive SQL refers to SQL statements submitted to SPUFI
(SQL processor using file input). SPUFI prepares and executes these statements dynamically.

1.2.6 Indexes


Similar Documents

Premium Essay

Data Warehouse

...Proposal – Data Warehouse Inventory What is data warehouse? It’s a simple assembling of data gathered from various sources and available to the global customers in a way they can understand to their business level. Statement of Problem: Our intention is to develop inventory application (User interface) so that client can easily track their warehouse. For creating interface we are using ETL and IBM Cognos. Methods to solve problem: * Creating Database for customer * Extract transform and loading the data * Data Mapping * Creating Package from Framework Manager using IBM Cognos * Developing Interface using IBM Cognos Report Studio Tools: IBM DB2, Informatica Power center, IBM Cognos 10.2 Resources: 3 Client: Volvo Trucks. Software Development Life Cycle 1. Requirements 2. Design 3. Development 4. Testing 5. User Signoff Requirements for data warehouse design: A. Goals: 1. To design the flexible data warehouse as per the client requirements. 2. Get the raw data into the centralized repository so that the users can access it in a flexible manner. 3. We should make sure the data cannot be edited by the users. B. Clients Requirements: 1. We need to get all the details of the client products available in their inventory. 2. We need to study the client environment and take down the end to end process. C. Business Questions: 1. Need to discuss about the design duration. 2. Number of resource required for the...

Words: 316 - Pages: 2

Free Essay


...1 On Demand Business Volkswagen’s world-class procurement strategy produces breakthrough productivity gains. Based in Wolfsburg, Germany, Volkswagen AG ( is Europe’s largest auto manufacturer with worldwide revenues approaching $110 billion and manufacturing facilities on every continent. While perhaps best known for its VW and Audi brands, Volkswagen is also the company behind such storied brands as Bentley, Bugatti and Lamborghini. Amid the everincreasing competition in the worldwide auto industry, Volkswagen has long set itself apart through the design and Volkswagen is the company behind such storied brands as Audi, Bentley, Bugatti and Lamborghini. Overview Challenge Faced with rising complexity within its supplier-facing processes, Volkswagen needed to make its employees more productive to stay ahead of the competition Why Become an On Demand Business? Volkswagen needed to integrate its information and processes to speed decision-making and become more responsive to a rapidly changing supplier environment Solution An On Demand Workplace that includes an enterprisewide portal for employees and suppliers whose sensing, analytic and workflow capabilities have radically streamlined the way employees access and act on information Key Benefits • 20% increase in procurement staff productivity • Expected 100% payback within one year • Significant decreases in materials purchasing and inventory costs “We......

Words: 2558 - Pages: 11

Premium Essay

Being Me

...SELECT e.firstName,c.CompanyName  FROM Employees e  JOIN Orders o ON e.employeeID=o.employeeID  JOIN Customers c ON c.customerID=o.customerID  ORDER BY e.firstName,c.CompanyName |     | Compelling, but we see that there's many repeated entries in the list.  We'd like to count up how many sales are at the intersection of each distinct customer and salesperson.  To do this we'll add in a COUNT function and GROUP BY clause. SELECT e.firstName,c.CompanyName, COUNT(o.orderID)  FROM Employees e  JOIN Orders o ON e.employeeID=o.employeeID  JOIN Customers c ON c.customerID=o.customerID  GROUP BY e.firstName,c.CompanyName  ORDER BY e.firstName,c.CompanyName |     | Now the real fun begins as we transition this into a query that uses PIVOT.  Because we're grouping by not one but two columns, this query is a good candidate for PIVOT.  We'll start simple with a query that doesn't JOIN anything, but just references the Orders table.  We'll choose to have Employee data put into columns since there are only 9 employees.  Much more manageable.  In this case the numbers 1 through 9 refer to the ID of employees: SELECT * FROM Orders  PIVOT (COUNT(employeeID) FOR employeeID IN ([1],[2],[3],[4],[5],[6],[7],[8],[9])) p In the result set notice that the specific columns returned come from the result of the PIVOT clause and not directly from the Orders table!  And that PIVOT clause brings up every column from the Orders table except for employeeID, which gets weeded out since it...

Words: 1353 - Pages: 6

Free Essay

Business Model

...Enterprises-Storefront BTC Model WebSphere 5.0 and Amazon Affiliate Website Integration Managerial Applications of Information Technology – IS535 Devry University, Keller Graduate School of Management May 22, 2014 Enterprises Business to Customer Model, WebSphere 5.0 and Amazon Affiliate website components Topic Enterprises, a small computer repair and IT Consultation Company is proposing a new design for its corporate website. The owner wishes to utilize the Amazon Affiliate model leveraging Amazon’s rapid, real-time processing components connecting to a new storefront engineered with IBM’s WebSphere Storefront software. Problem Enterprises is a low budget start-up with no access to a full-time development staff. The design for the new website needs to be easy to use, easy to maintain, and automated as much as possible without cutting down on the customer experience. The new storefront promises speedy response times with a limited set of services geared towards basic laptop repair, parts ordering, and answers to commonly asked question. The design needs to utilize the Amazon website and WebSphere out-of-the box components as much as possible to eliminate unnecessary coding and maintenance. The website needs to be scalable as the owner anticipates branching out into iPods and other new media technology. Approach IBM offers several out-of-box designs for business startups. The McDonald Deyo Enterprise team members will evaluate several......

Words: 508 - Pages: 3

Free Essay

Virtualization Implementation

...this document, please direct them to the author at Author is not responsible for errors in this document that may result in any kind of inaccuracies. Acknowledgements Thanks to John R Hock, IBM Certified IT Specialist – System p - Advanced Technical Support Americas (ATS) for reviewing this White Paper. Thanks to the customer and IBM team for their contribution and support to this project. Trademarks The following terms are registered trademarks of International Business Machines Corporation in the United States and/or other countries: AIX, AS/400, DB2, IBM, Micro Channel, MQSeries, Netfinity, NUMAQ, OS/390, OS/400, Parallel Sysplex, PartnerLink, POWERparallel, RS/6000, S/390, Scalable POWERparallel Systems, Sequent, SP2, System/390, ThinkPad, WebSphere. The following terms are trademarks of International Business Machines Corporation in the United States and/or other countries: DB2 Universal Database, DEEP BLUE, e-business (logo), GigaProcessor, HACMP/6000, Intelligent Miner, iSeries, Network Station, NUMACenter, POWER2 Architecture, PowerPC 604,pSeries, Sequent (logo), SmoothStart, SP, xSeries, zSeries. A full list of U.S. trademarks owned by IBM may be found at NetView, Tivoli and TME are registered trademarks and TME Enterprise is a...

Words: 6610 - Pages: 27

Free Essay


...Mart Design, ETL, BI and Client/Server applications. * Certified in ICS PowerCenter Data Integration Developer Specialist 9.0 and Teradata 12 TE0-121 Certified Professional Program. * Extensively worked on Data Extraction, Transformation and Loading of data from various sources like Oracle, SQL Server, Flat files and COBOL Sources. * Worked extensively with Slowly Changing Dimensions. * Working knowledge of Teradata as a Developer with proficiencies in Teradata SQL Assistant utilities like Fastload, Multiload, BTEQ, FastExport, and Tpump. * Experience in Teradata Data Warehouse architecture. * Proficient in application development and support, for batch processes hosted on an IBM mainframe, with a core focus in COBOL, DB2, JCL and VSAM. * Hands on experience in performance tuning, resolving on-going maintenance issues and monitoring of production runs. * Data modeling using Erwin, Star Schema, Snowflake, FACT and dimension tables. * Hands on experience in UNIX shell scripting. * Excellent communication and interpersonal skills. TECHNICAL SKILLS Frameworks | Informatica Data Director (IDD), Informatica System Integration Framework (SIF), Teradata version 12, Mainframe z/OS | Application Modules | UNIX, Informatica Application Designer, Workflow Manager, Workflow Monitor, Repository Manager, Informatica B2B...

Words: 1062 - Pages: 5

Free Essay

Business Intelligence

...IBM DB2 Universal Database ® ™ Business Intelligence Tutorial: Extended Lessons in Data Warehousing V ersion 8 IBM DB2 Universal Database ® ™ Business Intelligence Tutorial: Extended Lessons in Data Warehousing V ersion 8 Before using this information and the product it supports, be sure to read the general information under Notices. This document contains proprietary information of IBM. It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties, and any statements provided in this manual should not be interpreted as such. You can order IBM publications online or through your local IBM representative. v To order publications online, go to the IBM Publications Center at v To find your local IBM representative, go to the IBM Directory of Worldwide Contacts at To order DB2 publications from DB2 Marketing and Sales in the United States or Canada, call 1-800-IBM-4YOU (426-4968). When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any way it believes appropriate without incurring any obligation to you. © Copyright International Business Machines Corporation 2000 - 2002. All rights reserved. US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. Contents About......

Words: 7362 - Pages: 30

Premium Essay

Database Management

...While reviewing the four different databases such as the Oracle 11G, MySQL, IBM DB2, and Microsoft Sql Server 2008 which are all impressive databases, I chose to implement the IBM DB2 database system for Wildwood apartments. The key features that IBM DB2 has are table partitioning, database portioning, massively parallel processing (MPP), Continuous Ingest, Multidimensional clustering (MDC), Aggregates, Multi-Temperature Data Management, Mixed Workload Management, and Control over Workloads. DB2 has a number of performance optimization capabilities that give you the insight and ability to optimize workload execution. (DB2 for Linux, UNIX, and Windows) IBM DB2 meets the requirements for Wild Wood Apartments database so the managers can input the lease information, rent payment, maintenance request and with ease complete there quarterly reports. These capabilities can save you money and lower your risks by helping you to do more work with your existing hardware, ensure Service Level Agreements (SLAs) are met or exceeded and increase DBA productivity. (DB2 for Linux, UNIX, and Windows) The database is user friendly and the apartment managers should have no problem navigating through the system to input the information. This is essential DB2 transparently splits the database across multiple partitions and uses the power of multiple servers to satisfy requests for large amounts of information. (DB2 for Linux, UNIX, and Windows) Another reason why I chose IBM BD2 I......

Words: 628 - Pages: 3

Premium Essay

Conceptual Framework of Accounting

...them? And list the importance of conceptual framework to financial report prove my view. NEED FOR A CONCEPTUAL FRAMEWORK Why do we need to develop a conceptual framework? Of course, it is be useful, the body of concepts should to make rules and relate to financial report; a soundly developed conceptual framework enables the IASB to issue more useful and consistent pronouncements over time. It means a coherent standard should result. So, if framework have no a soundly development, the guidance by it will influent standard-setting based on individual concepts. In other words, standard-setting cannot base on personal conceptual frameworks; it will lead to wrong conclusions about identical or similar issues than it did previously. As a result, past decisions is not treat as future ones, standards cannot be consistent with one another. Furthermore, the conceptual framework should be paying attention to users’ understanding about financial reporting. On the other hand, the development of conceptual framework should solve new or emerging problems quickly. Development of a conceptual framework Conceptual framework has a different definition for IASB and FASB, IASB’s conceptual framework usually is described in the document, FASB’ conceptual framework is a series of concept statements. Both of them are working to develop an improved...

Words: 1223 - Pages: 5

Premium Essay

The Concept of Administration and Organization

...THE CONCEPT OF ADMINISTRATION AND ORGANIZATION A: WHAT IS ADMINISTRATION First definition: “Administration can be defined as the activities of groups cooperating to accomplish common goals”. There are particular key elements of administration. Cooperative: the word cooperative is the first key element in this definition. Human activity is cooperative if it has the effects that would be absent if the cooperation did not take place. * Group Activity: Administration includes activities of more than one individual. * The term ‘cooperative’ is defined in terms of the results of the human activity. When two men together roll a stone which neither of them could roll alone they are cooperating. * Thus the essence of administration is the utilization of cooperative action for the accomplishment of common goals. * Common goal: the second key element of the above definition is the goal or purpose. * It is the common goal which encourages members to come together. Cooperation among members is possible when they share a common goal. The idea of goal is central to the concept of administration in the sense that if there was not a goal, the members of the group would not come together and cooperate with each other. * Without the formulation of an objective or goal, no one within the group would know what to do and they would not get involved in any activity. * When someone determines the objective and the group is formed, than the group......

Words: 633 - Pages: 3

Premium Essay


...None Coms 2 Professor Reams 2/7/2013 Reading Response for Chapters 1-2 The one concept that I feel that I can apply best to my life is what Wayne Brockriede describes some arguers as rapist, seducer, and lover. In my own words rapist arguers are just people who attack and do not let people get their words out or their point across. These kinds of arguers are people who feel that what they are saying is right and cannot be wrong no matter what. The seducer is someone similar to the rapist but just in a smoother, sneakier way. He will listen to your side but he will not take it into consideration. The rapist is more about power than about reasoning. The seducer wants you to see things his way and he will do that by trying to sweet talk you or seeming to be extremely nice. His tactics are the same as the rapist but just are delivered differently. The seducer is about power but not as much as the rapist. Now the lover, he is absolutely different from the rapist and the seducer. The lover wants your opinion and will actually make it into consideration. The lover considers you as an equal and not as someone who is lesser than he is. They do not mind their views being changed unlike the rapist and the seducer. The lover is all about sharing the power; he is all about equality in arguing. I have experience this when my friends and I argue about something. We all have been the rapist, the seducer, and the lover in are arguments. We argue about everything and anything every day.......

Words: 534 - Pages: 3

Premium Essay


...math homework. I strongly advise you to do your math homework everyday, not for just a grade, but it also helps you when it comes time for quizzes and tests. She rarely checks homework, but when she does, she will not tell you. It is also a great review for tests and quizzes. Ms.Hull’s tests and quizzes are not the easiest things you will take. The quizzes take new concepts and apply to the quiz. Also, her tests are usually always hard. It is a good idea to practice new concepts and review old ones from previous units, so you can get a good grade on the tests. I also advise you to be organized throughout the year. Organization is the key to success especially in math class. Tool kits are an extremely helpful resource to use. There are going to be a lot of conjectures and theorems that will be new, and it would be hard to just memorize them. My overall geometry year was not exactly the way I hoped it would turn out. It was extremely had, and it moves at a very quick pace, so keeping up was hard for me personally. If I could have done something differently, it would have been practicing math more often. Each concept was hard, and I did not have anytime to review it, because I have a lot of honors classes which require a lot of work too. The key to being successful in this course is to pay attention, practice a lot outside of class, and do ALL of your homework. If you do that, I am sure your year...

Words: 361 - Pages: 2

Free Essay

Crm Is Referred to as an "Enabler of Great Marketing." in What Specific Ways Does Crm Enable Great Marketing? That Is, What Can a Marketing Manager Do Better Because Their Firm Effectively Practices Crm?

...* In what ways does leadership at HCL Technologies use new-era concepts such as shared leadership and collaboration to change culture, structure, and processes to support and sustain innovation? Leadership at HCL Technologies has used new-era concepts in numerous ways to support and sustain innovation. Instead of having everything fall on the CEO’s shoulders, Nayar decided to create a section in the “U&I” portal called “My Problems”, which consisted of issues, questions, and concerns that were challenging to him. Many employees reached out to him to with their different ideas and offered suggestions that allowed for him to look at problems differently, and think outside of the box. On many instances, Nayar engaged in a back and forth dialogue with the portals contributors with questions like, What is the fundamental nature of the problem and how does it really affect us? (Nayar, 2010). By having these discussions with the contributors, it began to shift the responsibility of actions from the CEO to the employees. Another concept that was implemented, were employee communities called “Employee First Councils”. This idea was based upon trying to figure out things such as: What are the employees about and who are they? What are their ethics and what are they passionate about? Nayar felt as though if he was able to engage people around their passions and comfort areas, they’d be more inclined to take responsibility, and they’d be more passionate about their jobs. By......

Words: 325 - Pages: 2

Premium Essay


...Enterpreneur Goals Enterpreneurship is the way an enterpreneur creates or undertakes business in an effort to transform them into economic goods, this may result in new organizations or may be part of getting a mature organization in response to good opportunity. the most relevant form of enterpreneurship is that of starting a new business, in recent years the term has been extended to include social and political forms of enterpreneur activities. when enterpreneurship is describing activities witin a firm or a large organization, it is refered to as intra preneurship and may include corporate venture. what leads to a person to get his or her business is a proactive response to a negative situation. perhaps a person has been laid off once or twice. sometimes a person is furstrated with his or her current job and doesnt see any better carrer prospects on the horizon, sometimes a person realizes that his or her job is in trouble. a firm may be contemplating cutbacks that could end a job or limit carrer prospect. perhaps a person already has been passed over for promotion, or a person sees no oppurtunity in existing business for someone with his or her interest and skills. Some people are actually repulsed by the idea of working for someone else. they object to a system where rewards are often based than acomplishment. other people decide to become enterpreneurs because......

Words: 450 - Pages: 2

Premium Essay

Lexmark Canada Case Study

...Lexmark Canada Case Study The Lexmark Corporation is a financially strong organization that was spun off from the IBM Corporation to be a standalone business and this has caused some restructuring within the company. The sales department underwent a major shift from individual compensation packages to a team compensation concept that was not immediately embraced by everyone in the organization which led to some defections and put the company in a position to be short staffed. This raised questions about the concept itself and whether it was a workable plan and also if the compensation is an adequate motivator and measure of personal performance. The analysis of this case really comes to the point of do they have the right people to make this team work? And thru continuing education can the company get and retain the right people? Is the compensation package correct? These questions and more will be addressed. The problem started by being short staffed almost from the start when two account managers quit due to lack of control of their earnings as they saw it and disappointment from not being chosen as team leader. Getting the right people on board quickly and effectively would be a key, but “As difficult as it is, resist the temptation to hire for the short-term because bad hires are poison.” (Tao, 2012) This is true in this case because they were worried about making quotas, but if they hire the wrong person then it only sets the company farther behind. This is all a...

Words: 1524 - Pages: 7