BASH SHELL VI COMMANDS

Inserting Text

i Insert before cursor
I Insert before line
a Append after cursor
A Append after line
o Open a new line after current line
O Open a new line before current line
r Replace one character
R Replace many characters

Motion

h Move left
j Move down
k Move up
l Move right
w Move to next word
W Move to next blank delimited word
b Move to the beginning of the word
B Move to the beginning of blank delimted word
e Move to the end of the word
E Move to the end of Blank delimited word
( Move a sentence back
) Move a sentence forward
{ Move a paragraph back
} Move a paragraph forward
0 Move to the begining of the line
$ Move to the end of the line
1G Move to the first line of the file
G Move to the last line of the file
nG Move to nth line of the file
:n Move to nth line of the file
fc Move forward to c
Fc Move back to c
H Move to top of screen
M Move to middle of screen
L Move to botton of screen
% Move to associated ( ), { }, [ ]

Deleting Text

Almost all deletion commands are performed by typing d followed by a motion. For example, dw deletes a word. A few other deletes are:
x Delete character to the right of cursor
X Delete character to the left of cursor
D Delete to the end of the line
dd Delete current line
:d Delete current line

Yanking Text

Like deletion, almost all yank commands are performed by typing y followed by a motion. For example, y$ yanks to the end of the line. Two other yank commands are:
yy Yank the current line
:y Yank the current line

Changing text

The change command is a deletion command that leaves the editor in insert mode. It is performed by typing c followed by a motion. For wxample cw changes a word. A few other change commands are:
C Change to the end of the line
cc Change the whole line

Putting text

p Put after the position or after the line
P Put before the poition or before the line

Buffers

Named buffers may be specified before any deletion, change, yank or put command. The general prefix has the form “c where c is any lowercase character. for example, “adw deletes a word into buffer a. It may thereafter be put back into text with an appropriate “ap.

Markers

Named markers may be set on any line in a file. Any lower case letter may be a marker name. Markers may also be used as limits for ranges.
mc Set marker c on this line
`c Go to beginning of marker c line.
‘c Go to first non-blank character of marker c line.

Search for strings

/string Search forward for string
?string Search back for string
n Search for next instance of string
N Search for previous instance of string

Replace

The search and replace
function is accomplished with the :s command. It is commonly used in combination with ranges or the :g command (below).
:s/pattern/string/flags Replace pattern with string according to flags.
g Flag – Replace all occurences of pattern
c Flag – Confirm replaces.
& Repeat last :s command

Regular Expressions

. (dot) Any single character except newline
* zero or more occurances of any character
[…] Any single character specified in the set
[^…] Any single character not specified in the set
^ Anchor – beginning of the line
$ Anchor – end of line
\< Anchor – begining of word
\> Anchor – end of word
\(…\) Grouping – usually used to group conditions
\n Contents of nth grouping
[A-Z] The SET from Capital A to Capital Z
[a-z] The SET from lowercase a to lowercase z
[0-9] The SET from 0 to 9 (All numerals)
[./=+] The SET containing . (dot), / (slash), =, and +
[-A-F] The SET from Capital A to Capital F and the dash (dashes must be specified first)
[0-9 A-Z] The SET containing all capital letters and digits and a space
[A-Z][a-zA-Z] In the first position, the SET from Capital A to Capital ZIn the second character position, the SET containing all letters
/Hello/ Matches if the line contains the value Hello
/^TEST$/ Matches if the line contains TEST by itself
/^[a-zA-Z]/ Matches if the line starts with any letter
/^[a-z].*/ Matches if the first character of the line is a-z and there is at least one more of any character following it
/2134$/ Matches if line ends with 2134
/\(21|35\)/ Matches is the line contains 21 or 35Note the use of ( ) with the pipe symbol to specify the ‘or’ condition
/[0-9]*/ Matches if there are zero or more numbers in the line
/^[^#]/ Matches if the first character is not a # in the line
Notes:1. Regular expressions are case sensitive2. Regular expressions are to be used where pattern is specified

Counts

Nearly every command may be preceded by a number that specifies how many times it is to be performed. For example, 5dw will delete 5 words and 3fe will move the
cursor forward to the 3rd occurence of the letter e. Even insertions may be repeated conveniently with thismethod, say to insert the same line 100 times.

Ranges

Ranges may precede most “colon” commands and cause them to be executed on a line or lines. For example :3,7d would delete lines 3-7. Ranges are commonly combined with the :s command to perform a replacement on several lines, as with :.,$s/pattern/string/g to make a replacement from the current line to the end of the file.
:n,m Range – Lines n–m
:. Range – Current line
:$ Range – Last line
:’c Range – Marker c
:% Range – All lines in file
:g/pattern/ Range – All lines that contain pattern

Files

:w file Write to file
:r file Read file in after line
:n Go to next file
:p Go to previos file
:e file Edit file
!!program Replace line with output from program

Other

~ Toggle upp and lower case
J Join lines
. Repeat last text-changing command
u Undo last change
U Undo all changes to line

So frackin hard

CREATE TABLE EMPLOYEE3 AS
   (SELECT PROJNO, PROJNAME, DEPTNO
    FROM EMPLOYEE
    WHERE DEPTNO = 'D11') WITH NO DATA


MUST USE "WITH NO DATA"  at the end of statement - bullshit fibm

	


	







	

		
		
DOS Commands that work on Windows XP
	


	
	
	

		


MS-DOS and command line overview





Below is a listing of each of the MS-DOS commands currently listed on Computer Hope and a brief explanation of what each of the commands do. The below commands are all MS-DOS commands, which means not all the below commands will work in your version of MS-DOS and/or Windows command line. Clicking on the command will open the help page for that command with full details about it.





Command
Description










Aansi.sys  ||  NSI.SYS Defines functions that change display graphics, control cursor movement, and reassign keys.

append  ||   Causes MS-DOS to look in other directories when editing a file or running a command.

arp  ||   Displays, adds, and removes arp information from network devices.

assign  ||   Assign a drive letter to an alternate letter.

assoc  ||   View the file associations.

at  ||   Schedule a time to execute commands or programs.

atmadm  ||   Lists connections and addresses seen by Windows ATM call manager.

attrib  ||   Display and change file attributes.

batch  ||   Recovery console command that executes a series of commands in a file.

bootcfg  ||   Recovery console command that allows a user to view, modify, and rebuild the boot.ini

break  ||   Enable / disable CTRL + C feature.

cacls  ||   View and modify file ACL’s.

call  ||   Calls a batch file from another batch file.

cd  ||   Changes directories.

chcp  ||   Supplement the International keyboard and character set information.

chdir  ||   Changes directories.

chdsk  ||   Check the hard disk drive running FAT for errors.

chkntfs  ||   Check the hard disk drive running NTFS for errors.

choice  ||   Specify a listing of multiple options within a batch file.

cls  ||   Clears the screen.

cmd  ||   Opens the command interpreter.

color  ||   Easily change the foreground and background color of the MS-DOS window.

command  ||   Opens the command interpreter.

comp  ||   Compares files.

compact  ||   Compresses and uncompress files.

control  ||   Open Control Panel icons from the MS-DOS prompt.

convert  ||   Convert FAT to NTFS.

copy  ||   Copy one or more files to an alternate location.

ctty  ||   Change the computers input/output devices.

date  ||   View or change the systems date.

debug  ||    Debug utility to create assembly programs to modify hardware settings.

defrag  ||    Re-arrange the hard disk drive to help with loading programs.

del  ||   Deletes one or more files.

delete  ||   Recovery console command that deletes a file.

deltree  ||   Deletes one or more files and/or directories.

dir  ||   List the contents of one or more directory.

disable Recovery console command that disables Windows system services or drivers.

diskcomp Compare a disk with another disk.

diskcopy Copy the contents of one disk and place them on another disk.

doskey Command to view and execute commands that have been run in the past.

dosshell A GUI to help with early MS-DOS users.

drivparm Enables overwrite of original device drivers.

echo Displays messages and enables and disables echo.

edit View and edit files.

edlin View and edit files.

emm386 Load extended Memory Manager.

ename Recovery console command to enable a disable service or driver.

endlocal Stops the localization of the environment changes enabled by the setlocal command.

erase Erase files from computer.

exit Exit from the command interpreter.

expand Expand a Microsoft Windows file back to it’s original format.

extract Extract files from the Microsoft Windows cabinets.

fasthelp Displays a listing of MS-DOS commands and information about them.

fc Compare files.

fdisk Utility used to create partitions on the hard disk drive.

find Search for text within a file.

findstr Searches for a string of text within a file.

fixboot Writes a new boot sector.

fixmbr Writes a new boot record to a disk drive.

for Boolean used in batch files.

format Command to erase and prepare a disk drive.

ftp Command to connect and operate on a FTP server.

ftype Displays or modifies file types used in file extension associations.

goto Moves a batch file to a specific label or location.

graftabl Show extended characters in graphics mode.

help Display a listing of commands and brief explanation.

if Allows for batch files to perform conditional processing.

ifshlp.sys 32-bit file manager.

ipconfig Network command to view network adapter settings and assigned values.

keyb Change layout of keyboard.

label Change the label of a disk drive.

lh Load a device driver in to high memory.

listsvc Recovery console command that displays the services and drivers.

loadfix Load a program above the first 64k.

loadhigh Load a device driver in to high memory.

lock Lock the hard disk drive.

logoff Logoff the currently profile using the computer.

logon Recovery console command to list installations and enable administrator login.

map Displays the device name of a drive.

md Command to create a new directory.

mem Display memory on system.

mkdir Command to create a new directory.

mode Modify the port or display settings.

more Display one page at a time.

move Move one or more files from one directory to another directory.

msav Early Microsoft Virus scanner.

msd Diagnostics utility.

msdex Utility used to load and provide access to the CD-ROM.

nbtstat Displays protocol statistics and current TCP/IP connections using NBT

net Update, fix, or view the network or network settings

netsh Configure dynamic and static network information from MS-DOS.

netstat Display the TCP/IP network protocol statistics and information.

nlsfunc Load country specific information.

nslookup Look up an IP address of a domain or host on a network.

path View and modify the computers path location.

pathping View and locate locations of network latency.

pause Command used in batch files to stop the processing of a command.

ping Test / send information to another network computer or network device.

popd Changes to the directory or network path stored by the pushd command.

power Conserve power with computer portables. 

print Prints data to a printer port.

prompt View and change the MS-DOS prompt.

pushd Stores a directory or network path in memory so it can be returned to at any time.

qbasic Open the QBasic.

rd Removes an empty directory.

ren Renames a file or directory.

rename Renames a file or directory.

rmdir Removes an empty directory.

route View and configure windows network route tables.

runas Enables a user to execute a program on another computer.

scandisk Run the scandisk utility.

scanreg Scan registry and recover registry from errors.

set Change one variable or string to another. 

setlocal Enables local environments to be changed without affecting anything else. 

setver Change MS-DOS version to trick older MS-DOS programs.

share Installs support for file sharing and locking capabilities. 

shift Changes the position of replaceable parameters in a batch program. 

shutdown Shutdown the computer from the MS-DOS prompt.

smartdrv Create a disk cache in conventional memory or extended memory.

sort Sorts the input and displays the output to the screen.

start Start a separate window in Windows from the MS-DOS prompt.

subst Substitute a folder on your computer for another drive letter. 

switches Remove add functions from MS-DOS.

sys Transfer system files to disk drive.

telnet Telnet to another computer / device from the prompt.

time View or modify the system time.

title Change the title of their MS-DOS window.

tracert Visually view a network packets route across a network.

tree View a visual tree of the hard disk drive.

type Display the contents of a file.

undelete Undelete a file that has been deleted.

unformat Unformat a hard disk drive.

unlock Unlock a disk drive.

ver Display the version information.

verify Enables or disables the feature to determine if files have been written properly. 

vol Displays the volume information about the designated drive. 

xcopy Copy multiple files, directories, and/or drives from one location to another.





Aansi.sysNSI.SYS
Defines functions that change display graphics, control cursor movement, and reassign keys.





Windows 2000 and XP xcopy syntax


XCOPY source [destination] [/A | /M] [/D[:date]] [/P] [/S [/E]] [/V] [/W] [/C] [/I] [/Q] [/F] [/L] [/H] [/R] [/T] [/U]

[/K] [/N] [/O] [/X] [/Y] [/-Y] [/Z] [/EXCLUDE:file1[+file2][+file3]…]







source
Specifies the file(s) to copy.





The switch /Y may be preset in the COPYCMD environment variable.

This may be overridden with /-Y on the command line.

	


	







	

		
		
Windows Keyboard Short Cuts – ALT F4 is my Favorite
	


	
	
	

		
Windows key + R = Run command box

Windows key + E = Windows Explorer

ALT + Tab = Switch between windows

ALT + Space + X = Maximize window

CTRL + Shift + Esc = Task Manager

Windows key + Break = System properties

Windows key + F = Search

Windows key + D = Hide/Display all windows

CTRL + C = copy

CTRL + X = cut

CTRL + V = paste

Alt + Esc = Switch between running applications(mnimized apps on task bar)

Alt + Underlined letter will Select menu item by underlined letter

Ctrl + Esc Open Start Menu

Ctrl + F4 or Alt + F4 Close active document or group windows (does not work with some applications)

Ctrl + Left and right arrow Move cursor forward or back one word

Ctrl + Up, Down arrow Move cursor forward or back one paragraph

F1 Open Help for active application

Windows + M = Minimize all open windows

Shift + Windows + M = Undo minimize all open windows

Windows + F1 = Open Windows Help

Windows + Tab = Cycle through the Taskbar buttons (In vista invokes 3d-flip)

Windows + Break = Open the System Properties dialog box

SHIFT+DELETE = Deletes selected item permanently without sending to recycle bin.

CTRL+SHIFT while dragging an item will create a shortcut of it.

F2 = Rename selected item.

CTRL+A = Select All items

F3 = Search for a file or folder

ALT+ ENTER = Show the properties of the selected file/folder.

ALT+SPACEBAR = Opens the shortcut menu of Active window.

F4 in Windows Explorer or Internet Explorer will show the addressbar list.

CTRL+TAB = Move forward through tabs.

CTRL+SHIFT+TAB = Move backward through tabs.

TAB = Move forward through options

SHIFT+TAB = Move backward through options

Windows key+M = Minimizes all window

Windows key+U = Opens Utility manager

CTRL+RIGHT ARROW = Move the insertion point to the beginning of the next word.

CTRL+LEFT ARROW = Move the insertion point to the beginning of the previous word.

CTRL+DOWN ARROW = Move the insertion point to the beginning of the next paragraph.

CTRL+UP ARROW= Move the insertion point to the beginning of the previous paragraph.

CTRL+SHIFT with any of the arrow keys = Will highlight a bloack of text.

SHIFT+ Any arrow key = Will select more than one item.


Some shortcuts for Windows Accessibility features:


Hold Right Shft key for 8 seconds to Invoke Filter keys settings window.

Tap on Shift key for 5 times will invoke Sticky keys settings window.

Left ALT +left SHIFT +PRINT SCREEN……. Switch High Contrast on and off.

Left ALT +left SHIFT +NUM LOCK……. Switch MouseKeys on and off.

Hold NUM LOCK key for five seconds will Switch ToggleKeys on and off.


Some shortcuts for FIREFOX Accessibility features:


CONTROL + CLICK on LINK ……OPENS a NEW TAB






	


	





	

		
		
SELECT_SQL Examples
	


	
	
	

		
SELECT_SQL FIELDS((#W_COUNT ‘count(*)’)) FROM_FILES((REQUEST )) WH

           ERE(‘CLIENT_ID = :RITAID AND STATUS_CODE = 4    AND  BA

           TCH_SEQ_NUM = 0’)                                      

ENDSELECT                                                         

SELECT_SQL FIELDS((#CRGUID ) (#CRTED ) (#CROBATCH ) (#CRBATCH ) (# 

           CRCCNO ) (#CREXPDT ) (#CRAMNT ) (#CRSWIPE ) (#CRQOVR )  

           (#CRRITAS ) (#CRRITAID ) (#CRTCN ) (#CRMUSR ) (#CRCCET  

           ) (#CRORIG ) (#CRFAIR )) FROM_FILES((CRTRAN )) WHERE(‘S 

           UBSTR(CROBATCH,1,2) = :XBFRGN AND CRSWIPE <> :WSWIPE AN 

           D (CRRITAS = 5 OR (CRRITAS = 200 AND CRAMNT < 0))’) ORD 

           ER_BY(‘CROBATCH,CRBATCH’)                               

********** OK to Mark for Completion                               

SELECT_SQL FIELDS((#W_COUNT ‘count(*)’) (#W_SUM ‘SUM(INT(TRANS_AMO

           UNT))’)) FROM_FILES((REQUEST )) WHERE(‘CLIENT_ID = :RIT

           AID AND STATUS_CODE = 4    AND  BATCH_SEQ_NUM = 0 AND C

           OMMAND =:COMMND’) IO_STATUS(#W_IOSTS) IO_ERROR(*NEXT)  

ENDSELECT                                                         

********** put decimal place in amount                            


SUBROUTINE NAME(GETRITASTS)                                       

**********                                                        

SELECT_SQL FIELDS((#INTRN0001 ‘INTRN_SEQ_NUM’) (#STATU0001 STATU00

           001)) FROM_FILES((REQUEST )) WHERE(‘ORIG_SEQ_NUM = :WRT

           AID’) ORDER_BY(STATU00001) IO_ERROR(*NEXT)             

LEAVE                                                             

ENDSELECT                                                         

**********                                                        

IF_NULL    FIELD(#INTRN0001)                                      

SELECT_SQL FIELDS((#INTRN0001 ‘INTRN_SEQ_NUM’) (#STATU0001 STATU00

           001)) FROM_FILES((REQUEST )) WHERE(‘INTRN_SEQ_NUM= :WRT

           AID’) ORDER_BY(STATU00001) IO_ERROR(*NEXT)             

LEAVE                                                             

ENDSELECT                                                         


SELECT_SQL FIELDS((#W_COUNT ‘count(*)’)) FROM_FILES((REQUEST )) WH

           ERE(‘CLIENT_ID = :WRITAI AND STATUS_CODE = :WRITAS  AND

             BATCH_SEQ_NUM = 0’)                                 

ENDSELECT                                                        

	


	





	

		
		
My Recovery ID Idea
	


	
	
	

		
Subscribers place SillyStickers on key chains, cellphones, iPods, cameras, binoculars, laptops, PDAs, etc. When an item is found, the finder accesses the website provided and notifies the owner with best means to get property back.  RECOVERYID.com Rewards all finders of Lost property automatically so you don’t have too. We believe the Best Lost and Found System is a SIMPLE one. They can call a toll free number

for instructions but this is really not needed because our system is so simple.















httpv://www.youtube.com/watch?v=6vkXRJzSE2U