Login or Register to Ask a Question and Join Our Community


Homework & Coursework Questions

Queries

Login to Discuss or Reply to this Discussion in Our Community

 
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

LEARN ABOUT PHP

socket_getpeername

SOCKET_GETPEERNAME(3)							 1						     SOCKET_GETPEERNAME(3)

socket_getpeername  -  Queries the remote side of the given socket which may either result in host/port or in a Unix filesystem path, dependent on
its type

SYNOPSIS

       bool socket_getpeername (resource  $socket, string  &$address, [int  &$port])

DESCRIPTION

	Queries the remote side of the given socket which may either result in host/port or in a Unix filesystem path, dependent on its type.

PARAMETERS

	      o $socket
		- A valid socket resource created with socket_create(3) or socket_accept(3).

	      o $address
		- If the given socket is of type AF_INET or AF_INET6, socket_getpeername(3) will return the peers (remote) IP address in appropri-
		ate  notation  (e.g.   127.0.0.1  or  fe80::1) in the $address parameter and, if the optional $port parameter is present, also the
		associated port.  If the given socket is of type AF_UNIX,  socket_getpeername(3)  will	return	the  Unix  filesystem  path  (e.g.
		/var/run/daemon.sock) in the $address parameter.

	      o $port
		- If given, this will hold the port associated to $address.

RETURN VALUES

	Returns  TRUE  on  success  or	FALSE  on  failure.  socket_getpeername(3) may also return FALSE if the socket type is not any of AF_INET,
       AF_INET6, or AF_UNIX, in which case the last socket error code is not updated.

NOTES

       Note

	      socket_getpeername(3) should not be used with AF_UNIX sockets created with socket_accept(3). Only sockets created  with  socket_con-
	      nect(3) or a primary server socket following a call to socket_bind(3) will return meaningful values.

       Note

	       For  having  socket_getpeername(3)  to return a meaningful value, the socket it is applied upon must of course be one for which the
	      concept of "peer" makes sense.

SEE ALSO

       socket_getsockname(3), socket_last_error(3), socket_strerror(3).

PHP Documentation Group 												     SOCKET_GETPEERNAME(3)