problem with sql command in pro*c

9 More Discussions You Might Find Interesting

1. 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...

2. 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...

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.

4. UNIX for Advanced & Expert Users

Problem on Pro*C compilation on HP-UX

Hi, This is my first post to this forum. I have been facing a strange compilation error message. When I try to make a pro*C file on HP-UX ( uname -a shows HP-UX aopc7449 B.11.11 U 9000/800 2416083493 unlimited-user license), ::: Linking... /usr/ccs/bin/ld: profls.o: Not a valid object file...

5. AIX

Pro C Compilation problem

Hi, I have AIX 5.3 and my code is written in proc . i am getting following error during compilation Please help?////..... [H[2J:-d: Compiling with RMS cc -w -q32 -qidirfirst -ISource/Header -I/usr/vacpp/include -q32 -DRMS -DDISEC -DDBG -DBIGENDIAN -DBIT32 -c -q32...

6. 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...

7. Shell Programming and Scripting

pro*c program for sql query

Hi all, I have sql query as follows. Please write a pro*c program for the following query. 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...

8. Shell Programming and Scripting

problem executed shell command from PL/SQL

i wrote plsql procedure that executed shell command using java class my problem is that in some reason the shell command ( liks Is -l , mv ... ) are not recordnize can someone help me with that 10x Alodvg

9. UNIX for Dummies Questions & Answers

domain logon problem - FreeBSD PDC w/ win2k pro and winxp pro

this is the seventh problem i'm having with samba. for some reason, i cannot logon to the domain. i've created user accounts... and i was able to establish a connection between the samba server (my PDC) and my workstations by logging in as "root." however now when i try to logon it gives...

LEARN ABOUT DEBIAN

swac-get

SWAC-GET(1)						      General Commands Manual						       SWAC-GET(1)

NAME

       swac-get - audio collections of words (SWAC) manager

SYNOPSIS

       swac-get [-t] [clear] [update] | [upgrade] | [select <url|packid>] | [deselect <url|packid>] | [list] | [list-sources] | [list-available] |
	       [sql <query>] | [--help] | [--version]

DESCRIPTION

       Swac-get is a simple command line program which allows to download and install audio collections of words (SWAC)  in  a	SQLite3  database.
       Audio  collections  can	be imported from the hard drive or directly from the Internet using the HTTP protocol.	Swac-get is designed to be
       used with swac-explore, a GTK+ interface which allows the browsing of the created SQLite3 database.  An important set of free audio collec-
       tions of words (SWAC) is available at: http://swac-collections.org/

       For more information, please, visit the Shtooka Project homepage at: http://shtooka.net/ .

COMMANDS

       clear  clear database

       deselect <url|packid>
	      delete records of the package <url|packid> from the database

       list   list installed packages

       list-available
	      list available packages

       list-sources
	      list source repositories

       sql <query>
	      execute a sql query in the database

       select <url|packid>
	      insert records of the package <url|packid> in the database

	      ex: swac-get select file:///home/<my directory>/
		  swac-get select http://packs.shtooka.net/<my package>/ogg/
		  swac-get select fra-balm-voc

       select source-delete <url>
	      delete <url> from the repositories list

       source-deselect <url>
	      deselect <url> from the repositories list

       source-select <url>
	      add <url> to the repositories list

	      ex: swac-get source-select http://packs.shtooka.net/
		  swac-get source-select file:///home/<my directory>/

       update update the list of available packages

       upgrade
	      upgrade installed packages

OPTIONS

       -t, --target <path>
	      set the SQLite3 database path (default path is ~/.swac/swac.db)

       -v, --version
	      print version information and exit

       -h, --help
	      print this help and exit

EXAMPLES

       swac-get source-select http://packs.shtooka.net/

       swac-get update

       swac-get select chi-balm-hsk1

       swac-get select fra-balm-voc

BUGS

       swac-get doesn't care about the version number for the upgrade command.

AUTHOR

       swac-get and this manual page were written by Nicolas Vion <nico@picapo.net>.

								   mai 25, 2008 						       SWAC-GET(1)

Programming