Queries

 
Thread Tools Search this Thread
Homework and Emergencies Homework & Coursework Questions Queries
# 1  
Old 02-23-2010
Queries

Any help on like where to get started on this? I'm just confused.

1. The problem statement, all variables and given/known data:
Enter text here.Queries to satisfy these two report requests (use your CCI database):
  1. Retrieve all rows of active inventory where current on hands is less than minimum level. Create a field in the results that computes the difference between the max and current on hands. Name this field "ReorderQuantity". Include vendor info to make reordering easier. --Hint: see page 110 in the Visual Quickstart textbook.
  2. Number of all Vendors that are not the preferred vendor that supply products for CategoryId 2. Exclude all disabled products and those introduced into the system prior to 2007.




2. Relevant commands, code, scripts, algorithms:
idk




3. The attempts at a solution (include all code and scripts):
dunno, need help start




4. Complete Name of School (University), City (State), Country, Name of Professor, and Course Number (Link to Course):
Kansas State, Manhattan, KS Brian Hucklebee CS146
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. IP Networking

RDNS Queries

Hey everyone, I have a question, I've been playing around with tcpdump, and noticed my machine making numerous rdns look ups. They are displayed like: 10.80.80.141.51234 > 10.80.80.1.domain: 9950+ PTR? 223.114.55.65.in-addr.arpa. (44) My question is, if dns works based on numerical... (0 Replies)
Discussion started by: Lost in Cyberia
0 Replies

2. Red Hat

NFS Queries

Hi, I would like to know on one server how many mouting can be done? wheather there is limitation on number of mounting? wheather it is possible to increase NFS Performance? if yes then which parameters needs to given while mounting? (3 Replies)
Discussion started by: manoj.solaris
3 Replies

3. UNIX for Dummies Questions & Answers

FTP Queries

Hi, 1) How to get exact permissions, group names for files while transferring with FTP 2) Is there any command to transfer entire directory and sub directories. Thanks (1 Reply)
Discussion started by: nag_sathi
1 Replies

4. Shell Programming and Scripting

Crontab queries

Hi Expert, How to schedule a job on last day of the month. Need your kind help. Regards, PK (3 Replies)
Discussion started by: pkrabi78
3 Replies

5. UNIX for Advanced & Expert Users

How many DNS queries

Is there any way to see how many queries come into our external DNS server? In looking at DNS providers, most of them base pricing on number of queries per month so I just wanted to see if you had any idea/way of gathering that data? A rough ballpark figure would even work. Our DNS server is... (1 Reply)
Discussion started by: raggmopp
1 Replies

6. Programming

Combine 3 queries

can these 3 be combined into 1 query? createtablea1as selecta.tps_Res_nb, b.tkt_prod_cd, b.tkt_prod_typ_nm, b.prod_intrnl_ds, b.tkt_prod_typ_nm AS TKT_ENTL_NM, casewhen b.tkt_prod_nm isnotnullthen b.tkt_prod_nm when b.tkt_prod_nm isnulland b.prod_intrnl_ds isnotnullthen... (1 Reply)
Discussion started by: dwr80
1 Replies

7. Shell Programming and Scripting

queries about exit

hi all, please tell me clearly the difference between exit 1 and exit 2 one more question i want to know the difference between some basic shells like bsh, csh, ksh, bash. i refered in net i get wast of text pages can any one give me any link to show the diff precisely or any blogs.... (2 Replies)
Discussion started by: Arunprasad
2 Replies

8. Shell Programming and Scripting

my queries

hi guys Well, i need to have a report generation script or any script which will show me all the content/information of a file when i run that script. Please help me on this isssue at the earliest.As i am little bit aware of scripting.Thanks in advance! regards ash (4 Replies)
Discussion started by: whizkidash
4 Replies

9. UNIX for Advanced & Expert Users

Some queries...

Guys need some advice on how to check some of the questions below? i'm running on an open VMS platform... which i am an idiot to... appreciate if anyone can give some hints or source on how to check on.. a script that is running on cron job... but doesn't run as the login user name.. 1. why... (6 Replies)
Discussion started by: 12yearold
6 Replies
Login or Register to Ask a Question
bc(1)							      General Commands Manual							     bc(1)

NAME
bc - Provides a processor for arbitrary-precision arithmetic language SYNOPSIS
bc [-cl] [file...] The bc command is an interactive program that provides unlimited precision arithmetic. It is a preprocessor for the dc command. STANDARDS
Interfaces documented on this reference page conform to industry standards as follows: bc: XCU5.0 Refer to the standards(5) reference page for more information about industry standards and associated tags. OPTIONS
[Tru64 UNIX] Compiles file, but does not invoke dc. Includes a library of mathematical functions. Also sets the number of digits retained after the decimal point (the scale) to 20; by default the scale is 0. OPERANDS
Pathname of a text file containing program statements. After file has been exhausted, standard input is read. DESCRIPTION
[Tru64 UNIX] The bc command invokes dc automatically, unless the -c (compile only) option is specified. If the -c option is specified, the output from bc goes to the standard output. The bc command lets you specify an input and output base in decimal, octal, or hexadecimal (the default is decimal). The command also has a scaling provision for decimal point notation. The syntax for bc is similar to that of the C language. The bc command takes input first from the specified file. When bc reaches the end of the input file, it reads standard input. In the following description of syntax for bc, letter means one of the letters a-z. Comments Comments are enclosed in /* and */. Names Simple variables: letter Array elements: letter[expression] The words ibase, obase, and scale Other Operands Arbitrarily long numbers with optional sign and decimal point. Number of significant decimal digits Number of digits to right of decimal point Operators + - * / % ^ (% is remainder; ^ is power) ++ -- (prefix and suffix; apply to names) == <= >= != <> = =+ =- =* =/ =% ^= += -= *= /= %= Statements expression {statement;...;statement} if (expression) statement while (expression) statement for (expression;expression;expression) statement (null statement) break quit Function Definitions define letter ( letter,...,letter ) { auto letter,...,letter statement;...statement return ( expression ) } Functions in -l Math Library sine cosine exponential log arctangent Bessel function General Syntax All function parameters are passed by value. The value of a statement that is an expression is displayed, unless the main operator is an assignment. A semicolon or newline character separates statements. Assignments to scale control the number of decimal places printed on output and maintained during multiplication, division, and exponentiation. Assignments to ibase or obase set the input and output number radix, respectively. The same letter may refer to an array, a function, and a simple variable simultaneously. All variables are global to the program. Auto- matic variables are pushed down during function calls. When you use arrays as function parameters, or define them as automatic variables, empty brackets must follow the array name. All for statements must have all three expressions. The quit statement is interpreted when read, not when executed. EXIT STATUS
The following exit values are returned: Successful completion. An error occurred. EXAMPLES
When you enter bc expressions directly from the keyboard, press the End-of-File key sequence to end the bc session and return to the shell command line. To use bc as a calculator, proceed as follows: Enter: $ bc 1/4 The system responds as follows: 0 Enter: scale = 1 /* Keep 1 decimal place */ 1/4 The system responds as follows: 0.2 Enter: scale = 3 /* Keep 3 decimal places */ 1/4 The system responds as follows: 0.250 Enter: 16+63/5 The system responds as follows: 28.600 Enter: (16+63)/5 The system responds as follows: 15.800 Enter: 71/6 The system responds as follows: 11.833 Enter: 1/6 The system responds as follows: 0.166 You may type the comments (enclosed in /* */), but they are provided only for your information. The bc command displays the value of each expression when you press <Return>, except for assignments. To convert numbers from one base to another, proceed as follows: Enter: bc obase = 16 /* Display numbers in Hexadecimal */ ibase = 8 /* Input numbers in Octal */ 12 The system responds as follows: A Enter: 123 The system responds as follows: 53 Enter: 123456 The system responds as follows: A72E To write and run C-like programs, proceed as follows: Create the following file prog.bc: /* compute the factorial of n */ define f(n) { auto i, r; r = 1; for (i=2; i<=n; i++) r =* i; return (r); } Enter: bc -l prog.bc This interprets the bc program saved in prog.bc, then reads more bc command statements from standard input (the keyboard). Starting the bc command with the -l option makes the math library available. This example uses the e (exponential) function from the math library, and f is defined in the program prog.bc. Enter: e(2) /* e squared */ The system responds as follows: 7.38905609893065022723 Enter: f(5) /* 5 factorial */ The system responds as follows: 120 Enter: f(10) /* 10 factorial */ The system responds as follows: 3628800 The statement following a for or while statement must begin on the same line. To convert an infix expression to Reverse Polish Notation (RPN), enter: Enter: bc -c (a * b) % (3 + 4 * c) The system responds as follows: lalb* 3 4lc*+%ps. This compiles the bc infix-notation expression into one that the dc command can interpret. The dc command evaluates extended RPN expressions. In the compiled output, the lowercase l before each variable name is the dc subcommand to load the value of the vari- able onto the stack. The p displays the value on top of the stack, and the s. discards the top value by storing it in register . (dot). You can save the RPN expression in a file for dc to evaluate later by redirecting the standard output of this command. ENVIRONMENT VARIABLES
The following environment variables affect the execution of bc: Provides a default value for the internationalization variables that are unset or null. If LANG is unset or null, the corresponding value from the default locale is used. If any of the internationalization vari- ables contain an invalid setting, the utility behaves as if none of the variables had been defined. If set to a non-empty string value, overrides the values of all the other internationalization variables. Determines the locale for the interpretation of sequences of bytes of text data as characters (for example, single-byte as opposed to multibyte characters in arguments). Determines the locale for the for- mat and contents of diagnostic messages written to standard error. Determines the location of message catalogues for the processing of LC_MESSAGES. FILES
Mathematical library. Desk calculator proper; uses bc as preprocessor. SEE ALSO
Commands: awk(1), dc(1) Standards: standards(5) bc(1)