ms sql command reference Post: 25878

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sql insert command

Hi, sqlplus -s / <<EOF > /dev/null insert into table1 (a1, a2, a3) values ('a',1,'b'); commit; EOF in the above code can i pass the values to the insert command from shell script like this: insert into table1 (a1, a2, a3) values ('$a',$b,'$c'); If yes, how is it passed?? Any...

2. Solaris

solaris command reference

is there any good doc which explains the systems command reference manual for sun solaris for ex: related to memory disk space booting rsh enabling restarting LOM etc etc pls help...

3. HP-UX

command reference sheet reqd.

hi everybody, i m AIX guy.... due 2 some reason i was also askd 2 work in HP-UX so i think all d concepts r same as AIX.... so i thought it s easy to learn by comparitve study.... if so then wr can i get the materials???????? thanks in advance........

4. Shell Programming and Scripting

sql command question

Hi, Table1 ====== Code1 Field1 Table2 ====== Code1 Field1 Would anyone be able to help me know what's the best sql command to delete the entry in Table1 if its Code1-Field1 combination is already existing in Table2. I used this one - delete from Table1 where Code1 in (select...

5. AIX

Required AIX Simulator \Command reference book

Sir, Iam required AIx simulator If any send the download link I required it for practice

6. SuSE

my SQL Info command

Is there a command that will output all mysql details. eg. host name, port etc? Cheers Paul

7. Shell Programming and Scripting

Perl de-reference code reference variable

Guys, May i know how can we de reference the code reference variable.? my $a = sub{$a=shift;$b=shift;print "SUM:",($a+$b),"\n";}; print $a->(4,5); How can we print the whole function ? Please suggest me regarding this. Thanks for your time :) Cheers, Ranga :)

8. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

Hi All, I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise. Eg : Select 'Query 1 output' from dual; Select 'Query 2 output' from dual; I want to...

9. Shell Programming and Scripting

sed - use back reference in 2nd command

I have data that looks like this: <Country code="US"><tag>adsf</tag><tag>bdfs</tag></Country><Country code="CA"><tag>asdf</tag><tag>bsdf</tag></Country> I want to grab the country code save it, then drop each new "<..." onto a new line with the country code added to the beginning of each So,...

LEARN ABOUT OSF1

whereis

whereis(1)						      General Commands Manual							whereis(1)

NAME

       whereis - Locates files for programs

SYNOPSIS

       whereis [-bms] [-u] [-BMS directory... -f] program...

       The whereis command locates source, binary, and/or reference page files for the specified program program.

OPTIONS

       The -b, -m, and -s options can be used in combination to restrict the search.  Searches for an executable program.  Searches for the refer-
       ence page for a program.  Searches for the sources of a program.

       Use the -B, -M, and -S options to change or limit the places whereis searches.  Specifies the binary directories to search.  Specifies  the
       reference page directories to search.  Specifies the source directories to search.

       The  other options that can be used with whereis are as follows: Terminates the last directory list and signals the start of program names.
       Used with other options to indicate when there is no file for program in the default or specified directory or directories (source, binary,
       or reference page).

DESCRIPTION

       The  whereis  program  locates source, binary, and reference pages for the specified programs.  When looking for a match, the program names
       are stripped of leading pathname components and any trailing extensions of the form (for example, s.  resulting from the use of the  Source
       Code Control System see sccs(1), are also handled.

       The default directories searched by the whereis command are as follows: /etc /etc/nls /sbin /usr/bin /usr/lbin /usr/lbin/spell /usr/ccs/lib
       /usr/lib /usr/local /usr/hosts /usr/sbin

EXAMPLES

       To find files matching cat in the default source, binary, and reference directories, enter: whereis cat To search for reference	pages  for
       app13  in the directory /usr/local/man, enter: whereis -M /usr/local/man -f -f appl3 To find the programs in /usr/bin that do not have ref-
       erence pages in /usr/share/man/man1 with source files in /usr/src/cmd, enter: whereis -u -M /usr/share/man/man1 
	       -S /usr/src/cmd -f /usr/bin/* To find which files in the current directory either have no reference pages in the default  reference
       directories or have more than one, enter: whereis -m -u *

FILES

       Default binary directories.  Default binary directories.  Default reference directories.  Default source directories.

SEE ALSO

       Commands:  apropos(1), find(1), man(1), which(1), catman(8)

																	whereis(1)