9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
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
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
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
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
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
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
cvm-pgsql(8) System Manager's Manual cvm-pgsql(8)
NAME
cvm-pgsql - PgSQL module
SYNOPSIS
cvm-pgsql
CREDENTIALS
Pass phrase
DESCRIPTION
This module queries a PgSQL database for the account name, compares the stored pass phrase with the given one using crypt(3).
CONFIGURATION VARIABLES
The server hostname, port, database, username, password, and additional options can be controlled by setting $PGHOST, $PGPORT, $PGDATABASE,
$PGUSER, $PGPASSWORD, and $PGOPTIONS respectively, which are parsed by the PgSQL client library.
CVM_MYSQL_POSTQ (optional)
The SQL query to execute after the credentials have been validated, see cvm-sql(7).
CVM_PGSQL_PWCMP (optional)
The password comparison module to use.
CVM_PGSQL_QUERY (optional)
The SQL query to issue to retrieve the row containing the account information from the database.
SEE ALSO
cvm-sql(7), cvm-mysql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8), cvm-benchclient(8), cvm-checkpassword(8), cvm-test-
client(8)
http://untroubled.org/pwcmp/pwcmp.html
http://untroubled.org/cvm/cvm.html
cvm-pgsql(8)