Question: Print a simple report using SQL SPOOL your output to c:CS4210project2spool.txt Use COLUMN to set up appropriate column headings and formats for DDI.LEDGER_VIEW Field Heading

Print a simple report using SQL

SPOOL your output to c:\CS4210\project2spool.txt

Use COLUMN to set up appropriate column headings and formats for DDI.LEDGER_VIEW

Field Heading Format REGID RegID 99999999 REGDATE Date DATE NAME Name A20 ROOMNUM Room 99999999 ROOMRATE Rate 999,999.00

Set appropriate values for PAGESIZE (255), LINESIZE (80) and TTITLE

Add BREAK and COMPUTE for subtotal and total of ROOMRATE Break on ROOMNUM for the subtotal and REPORT for total

Run a SQL command to print records from DDI.LEDGER_VIEW where REGDATE < '08-JUN-15' and sort by ROOMNUM and REGDATE

Close spool

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Print a simple report using SQL SPOOL your output to c:\CS4210\project2spool.txt Use COLUMN to set up appropriate column headings and formats for DDI.LEDGER_VIEW Field Heading Format REGID RegID...

Q:

Set Student Name: 1. Answer true or false for each part, and if false, explain your answer. a. The point estimate for the population mean, , of an x distribution is x-bar, computed from a random...

Q:

Instuctor's Annotated Edition TENTH EDITION Understandable Statistics Concepts and Methods Charles Henry Brase Regis University Corrinne Pellillo Brase Arapahoe Community College Australia Brazil...

Q:

DAVID DOESN'T DELEGATE Overcoming an Individual's Immunity to Change AS ANY EXPERIENCED MANAGER will tell us, being an effective delegator is crucial to using everyone's time, skills, and knowledge...

Q:

Bash Scripting Homework - Hi, I've been working on this homework for countless hours and I was wondering if I could get some help. I'm so lost and I have no idea what to do. From what the rubric...

Q:

CH2-25 CH1-18. Which of the following accounts should be set up using the Equity account type? (Select all that apply.) A. Retained earnings B. Common stock C. Dividends D. Net income The A/R Aging...

Q:

c++ 2. Simple Cashier Program Note: This program can be written in many ways! Many computer programmers consider coding an art form. There is no right or wrong on how you code your program but try to...

Q:

I need help with this scripting lab - It should be done on linux terminal using bash scripting.. please help with and explain what you can . CS 3030 Scripting Languages Lab 3: Failed Login Report...

Q:

APPLICATION PROBLEM SET 3 Problem 3.1 Creating an Access Database Using an Excel File Each worksheet in the Company.xls file represents a different table in a simple company database. You are to use...

Q:

APPLICATION PROBLEM SET 3 Problem 3.1 Creating an Access Database Using an Excel File Each worksheet in the Company.xls file represents a different table in a simple company database. You are to use...

Q:

The shareholders' equity of Bodie Company on January 1, 2017, included the following: Common stock, $1.6 par; authorized, 800,000 shares; You will need to calculate the issued shared $229,238 Paid-in...

Q:

The heat required to raise the temperature of m (kg) of a liquid from T 1 to T 2 at constant pressure is in high school and in first-year college physics courses, the formula is usually given as (a)...

Q:

Riley is looking for a fully amortizing 3 0 year Fixed Rate Mortgage with monthly payments for $ 8 0 0 , 0 0 0 . Mortgage B has a 6 . 6 1 % interest rate and requires Riley to pay zero fees upfront....

Q:

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

Q:

Mitzi Johnson worked for XYZ Company, which had a code of ethics for employees. In the training session, employees received a card that included these tests to determine ethical behavior: Is it...

Q:

Explain the concept of viral advertising, and give an example of an advertisement that might fit this concept. (Objective 1)

Q:

Explain why you agree or disagree with this statement: Only a small percentage of business and professional people behave in unethical ways. (Objective 4)