Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

pro*c program for sql query

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting pro*c program for sql query
# 1  
Old 03-26-2008
pro*c program for sql query
Hi all,
I have sql query as follows. Please write a pro*c program for the following query.

Code:
select
         sp1.cost_change
||','||  sp1.cost_change_desc
||','||  sp1.reason
||','||  to_char(sp1.active_date,'DD-MON-YYYY HH24:MI:SS')
||','||  sp1.status
||','||  sp1.cost_change_origin
||','||  to_char(sp1.create_date,'DD-MON-YYYY HH24:MI:SS')
||','||  sp1.create_id
||','||  to_char(sp1.approval_date,'DD-MON-YYYY HH24:MI:SS')
||','||  sp1.approval_id
from     supp_prods sp1
where    sp1.cost_change   in (select sp.cost_change
                                from   supp_stat     dcp,
                                         sup_detail     spd,
                                        sup_prd         sp
                                where  sp.active_date       = to_date('02-feb-2008 00:00:00','DD-MON-YYYY HH24:MI:SS')
                                and    sp.cost_change       = spd.cost_change
                                and    spd.item              = dcp.item
                                and    spd.supplier          = dcp.supplier
                                and     sp.origin_country_id = dcp.origin_country_id
                                and    sp.unit_cost         = dcp.unit_cost)

Can any one please help me to write the pro*c code for this.

Thank you.
Kris
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk script to parse SQL from Pro*C program

Hello, I have a Pro*C program which contains SQL sentences, such as: .... Pro*C sentences .... /*SQL 1*/ EXEC SQL SELECT t1.field1, t1.field2 INTO :w_field FROM TABLE1 t1, TABLE1 t2 WHERE t1.field1 = t2.field1 AND t1.ID = :wl_id; .... Pro*C sentences .... /*SQL 1*/ EXEC... (11 Replies)
Discussion started by: mvalonso
11 Replies

2. Shell Programming and Scripting

Run SQL thru shell script: how to get a new line when run sql query?

Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database. I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :( What should I do? I'm not sure that... (2 Replies)
Discussion started by: Kapom
2 Replies

3. Programming

Sql Procedure in Pro C file

Hi, Can any one help me how to write a sql procedure in a pro *c file for selecting the data from a database and inserting the rows into a queue in a .pc file. thanx in advance. (1 Reply)
Discussion started by: jhon1257
1 Replies

4. Programming

Do pro*c program need to recompile

hi, I have pro*c program running on sunsolaris 5.9.Currently the same program has been migrated to solaris 5.10.But the program is not giving the desired output.Do i need to recomplie the source code again. Regards, Megh (4 Replies)
Discussion started by: megh
4 Replies

5. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies

6. Programming

Compiling Pro*C program under unix

Hello, I am trying to compile a Pro*C program under unix: proc iname=test.pc works fine but then I am not able to compile the test.c file : gcc test.c -o test.o -L $ORACLE_HOME/lib -l clntsh /usr/bin/ld: Object file format error in: /u01/app/oracle/product/10.1.0.2.0/lib:... (1 Reply)
Discussion started by: nsmrmd
1 Replies

7. Programming

problem with sql command in pro*c

In a pro*C program, I use query follow: INSERT INTO radacct_wk SELECT (select psid from cscterminfo where cscterminfo.TELNO = username), nasipaddress, acctstarttime, acctstoptime, acctsessiontime, acctinputoctets, acctoutputoctets, acctterminatecause, framedipaddress FROM radacct@DBSV_B;... (7 Replies)
Discussion started by: quynhtrang
7 Replies

8. UNIX for Dummies Questions & Answers

PRo*C program for SQL queries using threading concept

Hi All, I have written 4 SQL queries. I want to write PRO*C program for this. I want to put these 4 queries in a single PR*C program using threading concept. Please guide me to write the pogram. the queries are as follows. 1. select * from head; 2. select * from details; 3. delete from head... (0 Replies)
Discussion started by: user71408
0 Replies

9. Shell Programming and Scripting

Still unable to compile pro*c program

I am unable to compile the programs, I am able to compile .pc to .c but later part of the compilation from .c to executalbe i am unable to do. Here is the way i am doing make -f $LIB_LIB/makefile.templ sample I am getting the following errors, which environment and where to set to point... (1 Reply)
Discussion started by: satvd
1 Replies
Login or Register to Ask a Question

LEARN ABOUT PHP

sqlsrv_query

SQLSRV_QUERY(3) 														   SQLSRV_QUERY(3)

sqlsrv_query - Prepares and executes a query.

SYNOPSIS

       mixed sqlsrv_query (resource  $conn, string  $sql, [array  $params], [array  $options])

DESCRIPTION

	Prepares and executes a query.

PARAMETERS

	      o $conn
		- A connection resource returned by sqlsrv_connect(3).

	      o $sql
		- The string that defines the query to be prepared and executed.

	      o $params
		- An array specifying parameter information when executing a parameterized query. Array elements can be any of the following:

		     oA literal value

		     oA PHP variable

		     oAn array with this structure: array($value [, $direction [, $phpType [, $sqlType]]])

	       The following table describes the elements in the array structure above:

	      Array structure

	      +----------------------+---------------------------------------------------+
	      |       Element	     |							 |
	      | 		     |							 |
	      | 		     |			  Description			 |
	      | 		     |							 |
	      +----------------------+---------------------------------------------------+
	      |       $value	     |							 |
	      | 		     |							 |
	      | 		     | A literal value, a PHP variable, or a PHP by-ref- |
	      | 		     | erence variable. 				 |
	      | 		     |							 |
	      |$direction (optional) |							 |
	      | 		     |							 |
	      | 		     | One of the following  SQLSRV  constants	used  to |
	      | 		     | indicate    the	  parameter    direction:   SQL- |
	      | 		     | SRV_PARAM_IN,	   SQLSRV_PARAM_OUT,	    SQL- |
	      | 		     | SRV_PARAM_INOUT.   The	default  value	is  SQL- |
	      | 		     | SRV_PARAM_IN.					 |
	      | 		     |							 |
	      | $phpType (optional)  |							 |
	      | 		     |							 |
	      | 		     | A SQLSRV_PHPTYPE_* constant  that  specifies  PHP |
	      | 		     | data type of the returned value. 		 |
	      | 		     |							 |
	      | $sqlType (optional)  |							 |
	      | 		     |							 |
	      | 		     | A  SQLSRV_SQLTYPE_*  constant  that specifies the |
	      | 		     | SQL Server data type of the input value. 	 |
	      | 		     |							 |
	      +----------------------+---------------------------------------------------+
	      o $options
		- An array specifing query property options. The supported keys are described in the following table:

	      Query Options

	      +-----------------------+--------------------------------------+---+
	      | 	Key	      | 				     |	 |
	      | 		      | 				     |	 |
	      | 		      | 	       Values		     |	 |
	      | 		      | 				     |	 |
	      | 		      | 	    Description 	     |	 |
	      | 		      | 				     |	 |
	      +-----------------------+--------------------------------------+---+
	      |     QueryTimeout      | 				     |	 |
	      | 		      | 				     |	 |
	      | 		      |      A positive integer value.	     |	 |
	      | 		      | 				     |	 |
	      | 		      | Sets the query timeout	in  seconds. |	 |
	      | 		      | By  default,  the  driver  will wait |	 |
	      | 		      | indefinitely for results.	     |	 |
	      | 		      | 				     |	 |
	      |SendStreamParamsAtExec | 				     |	 |
	      | 		      | 				     |	 |
	      | 		      | 				     |	 |
	      | 		      | TRUE or FALSE (the default is TRUE)  |	 |
	      | 		      | 				     |	 |
	      | 		      | Configures the driver  to  send  all |	 |
	      | 		      | stream data at execution ( TRUE), or |	 |
	      | 		      | to send  stream  data  in  chunks  ( |	 |
	      | 		      | FALSE). By default, the value is set |	 |
	      | 		      | to TRUE. For more  information,  see |	 |
	      | 		      | sqlsrv_send_stream_data(3).	     |	 |
	      | 		      | 				     |	 |
	      |      Scrollable       | 				     |	 |
	      | 		      | 				     |	 |
	      | 		      | SQLSRV_CURSOR_FORWARD,	 SQLSRV_CUR- |	 |
	      | 		      | SOR_STATIC,   SQLSRV_CURSOR_DYNAMIC, |	 |
	      | 		      | or SQLSRV_CURSOR_KEYSET 	     |	 |
	      | 		      | 				     |	 |
	      | 		      | See  Specifying  a  Cursor  Type and |	 |
	      | 		      | Selecting Rows in the Microsoft SQL- |	 |
	      | 		      | SRV documentation.		     |	 |
	      | 		      | 				     |	 |
	      +-----------------------+--------------------------------------+---+
RETURN VALUES

	Returns a statement resource on success and FALSE if an error occurred.

EXAMPLES

       Example #1

	      sqlsrv_query(3) example

	      <?php
	      $serverName = "serverNamesqlexpress";
	      $connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password" );
	      $conn = sqlsrv_connect( $serverName, $connectionInfo);
	      if( $conn === false ) {
		   die( print_r( sqlsrv_errors(), true));
	      }

	      $sql = "INSERT INTO Table_1 (id, data) VALUES (?, ?)";
	      $params = array(1, "some data");

	      $stmt = sqlsrv_query( $conn, $sql, $params);
	      if( $stmt === false ) {
		   die( print_r( sqlsrv_errors(), true));
	      }
	      ?>

NOTES

	For  statements  that you plan to execute only once, use sqlsrv_query(3). If you intend to re-execute a statement with different parameter
       values, use the combination of sqlsrv_prepare(3) and sqlsrv_execute(3).

SEE ALSO

       sqlsrv_prepare(3), sqlsrv_execute(3).

PHP Documentation Group 													   SQLSRV_QUERY(3)