JMLABS INSTITUTE ONLINE: BSC
Business School Center
Instructor: Professor Steven Lopin
_____________________________________________
Databases: 
_____________________________________________
REPORTS:
	A report is just a listing of selected records of a one or more files, usually the results of a query.   This selection process or report generation is done in a similar fashion regardless of the software that's being used, like Oracle Database, Excel Database, Visual Basic Programming Language, or Unix Operating System with SQL modules for querying records or groups of records.  

OPTIONAL:
                                                                                                                                                                                                                              
ORACLE:
	Has hits own SQL language functions that can be operated with or w/o wizards.

VISUAL BASIC 6.0:
	VB's DATA REPORT - Very user friendly report generator.
	CLIENT/SERVER  Microsoft's access and other ODBC data servers support multiple queries and outputs.  Open & run MULTIQ.VBP visual basic project file.  When the Multiple Query report dialog box appears, connection is made to a data source.  then MS Word comes up and gets an OLE object to create the report.
	CRYSTAL REPORTS - Often included with visual basic. First select File/Options.
		1.  In the File Option dialog box set the New Report(tab) options.
		2.  In the File Option dialog box set the Reporting(tab) options .
		3.  In the File Option dialog box set the Layout (tab) options.
		4.  Then click File/New.  In the Create New Report dialog box select a wizard or expert to make
		     different kinds of reports.
		5.  When the wizard or Crystal Report Expert comes up select the database to use.  Links tab now
		     automatically comes up showing relationships between tables in the database.
		6.  Click next to Fields(tab) of the expert.  select fields you want in the report.
		7.  Then select Sort(tab) and make selections.
		8.  Then add Totals, Select filters, and Styles.
		9.  Finally, click the Preview Sample button to see your report.  then click on the DESIGN (tab)
		     of Crystal Reports to make titles, footers, field and fonts adjustment. 

UNIX:
	
	AWK - This most powerful utility can look for patterns in records, but can do complex programing 
		on  the data it finds.  it can do looping , ifs, etc..
		EX: awk '/soup/' sybase.  All lines with 'meat' in it are shown.
		EX: awk -f comfile1 sybase.  Executes the awk comands in the file named comfile1 upon sybase.

	SED - The Stream EDitor is used to update files.  Unlike most editing where the whole file is read 
		into a buffer, updated and then written back out,  sed edits line by line, in a stream.
		EX:  sed  '4 d' sybase.      This commands deletes line 2 and outputs the rest of the file. 

	GREP - Like awk it searches for patterns in records.
		EX: grep ot filez.  Looks for all lines containing 'ot'.
		EX: grep -w dog kennelfile.. Looks for the complete word 'dog' only in this file.

	SORT - Puts records into ascending, descending, and other orders

	JOIN - A utility program, used with relational databases,  whose output is matched data from 2 files
		 with the same join field.  By default, it uses the 1st field of all used input files as the joining 
		field.  Exceptions are made.
		EX: join factoryfile1 officefile6.  Creates a composite of these 2 files as output.

	SHELL PROGRAMMING - for  C-SHELL, BORNE and KORN scripts used to control operations 
		of the shell and it's utilities.
		EX: who | grep $title.  Tells shell to run who and give the output to grep and title to grep.