03-29-2003
thanks for the help.
I would try this out and get back to you in case any more help or clarification required.
Cheers !!
Mehul Doshi
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I cannot figure out how to run a SQL script, or just a sqlplus query, from a shell script (bash or ksh). Basically, I need to su - oracle from root and run a query, then test the exit status. (3 Replies)
Discussion started by: 98_1LE
3 Replies
2. Shell Programming and Scripting
Hi ALL,
I need an help in connecting to oracle database, executing a select query and printing it on the screen. Can any one please write a simple code or psuedo code and let me know.
select query returns multiple values( say select name from emp)
Thanks in advance
LM (1 Reply)
Discussion started by: lijju.mathew
1 Replies
3. Shell Programming and Scripting
Hi I am getting this error while connecting to sql through a shell script, whereas i am able to connect to sql directly.
It was working properly earlier, no clue why i am getting this.
Please find the log below:
FTP to <IP> completed Wed Apr 30 11:42:01 BST 2008
Program ended. Wed Apr 30... (1 Reply)
Discussion started by: nehak
1 Replies
4. Shell Programming and Scripting
query sql using shell script, is it possible?
my friend told me to do a file.sql and link to my shell script, but can i query sql using shell script?
thanks in advance! (2 Replies)
Discussion started by: kingpeejay
2 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
In a Shell scriipt with a SQL block I want to issue a query against a local DB and a remote DB on a remote server. The shell script is running locally.
This is how I connect to the local server. But I want the query to reference remote table in the join. Question can I specify a... (1 Reply)
Discussion started by: daveu7
1 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I have one SQL file prepared in UNIX and one script that is executing that.
In SQL i have Update and create queries.
I want to introduce conditions in SQL file (in UNIX) that if either of the create or update query failes whole transaction should be rollback.
I just have 1 create... (2 Replies)
Discussion started by: abhii
2 Replies
7. Red Hat
hey , i am using this code to store value of a sql query and and then use
it in other query but after some time , but it is not working. please help
#!/bin/bash
val_1=$( sqlplus -s rte/rted2@rel76d2 << EOF
setting heading off
select max(stat_id) from cvt_stats;
exit
EOF
)
nohup... (5 Replies)
Discussion started by: ramsavi
5 Replies
8. Shell Programming and Scripting
Hi All,
I have a query with output below
select 'create synonym "'||TABLE_NAME||'" for '||Table_owner||'."'||table_name||'"'||chr(59) from user_synonyms;
==================
create synonym "RV_SBC_SIG" for WFCONTROLLER_TE."RV_SBC_SIG";
create synonym "AQM_TASK" for AWQM_TE."AQM_TASK";... (2 Replies)
Discussion started by: pvmanikandan
2 Replies
9. Shell Programming and Scripting
Hi I would like to embed a sql query in my shell script.
Also, before any the sql query is executed, i would like to validate username and password. (1 Reply)
Discussion started by: arghadeep adity
1 Replies
10. Shell Programming and Scripting
Hello All,
I'm trying to put together a shell script that will:
1. connect to an oracle database
2. execute a query
3. save the output to a csv file
I know that I can execute the sqlplus -s user/pass @dbsid and get logged in. What I would like to do is have my query in a separate text... (9 Replies)
Discussion started by: bbbngowc
9 Replies
LEARN ABOUT REDHAT
gldrawbuffer
GLDRAWBUFFER(3G) GLDRAWBUFFER(3G)
NAME
glDrawBuffer - specify which color buffers are to be drawn into
C SPECIFICATION
void glDrawBuffer( GLenum mode )
PARAMETERS
mode Specifies up to four color buffers to be drawn into. Symbolic constants GL_NONE, GL_FRONT_LEFT, GL_FRONT_RIGHT, GL_BACK_LEFT,
GL_BACK_RIGHT, GL_FRONT, GL_BACK, GL_LEFT, GL_RIGHT, GL_FRONT_AND_BACK, and GL_AUXi, where i is between 0 and
``GL_AUX_BUFFERS'' -1, are accepted (GL_AUX_BUFFERS is not the upper limit; use glGet to query the number of available aux buffers.)
The initial value is GL_FRONT for single-buffered contexts, and GL_BACK for double-buffered contexts.
DESCRIPTION
When colors are written to the frame buffer, they are written into the color buffers specified by glDrawBuffer. The specifications are as
follows:
GL_NONE No color buffers are written.
GL_FRONT_LEFT Only the front left color buffer is written.
GL_FRONT_RIGHT Only the front right color buffer is written.
GL_BACK_LEFT Only the back left color buffer is written.
GL_BACK_RIGHT Only the back right color buffer is written.
GL_FRONT Only the front left and front right color buffers are written. If there is no front right color buffer, only the
front left color buffer is written.
GL_BACK Only the back left and back right color buffers are written. If there is no back right color buffer, only the
back left color buffer is written.
GL_LEFT Only the front left and back left color buffers are written. If there is no back left color buffer, only the
front left color buffer is written.
GL_RIGHT Only the front right and back right color buffers are written. If there is no back right color buffer, only the
front right color buffer is written.
GL_FRONT_AND_BACK All the front and back color buffers (front left, front right, back left, back right) are written. If there are
no back color buffers, only the front left and front right color buffers are written. If there are no right color
buffers, only the front left and back left color buffers are written. If there are no right or back color buf-
fers, only the front left color buffer is written.
GL_AUXi Only auxiliary color buffer i is written.
If more than one color buffer is selected for drawing, then blending or logical operations are computed and applied independently for each
color buffer and can produce different results in each buffer.
Monoscopic contexts include only left buffers, and stereoscopic contexts include both left and right buffers. Likewise, single-buffered
contexts include only front buffers, and double-buffered contexts include both front and back buffers. The context is selected at GL ini-
tialization.
NOTES
It is always the case that GL_AUXi = GL_AUX0 + i.
ERRORS
GL_INVALID_ENUM is generated if mode is not an accepted value.
GL_INVALID_OPERATION is generated if none of the buffers indicated by mode exists.
GL_INVALID_OPERATION is generated if glDrawBuffer is executed between the execution of glBegin and the corresponding execution of glEnd.
ASSOCIATED GETS
glGet with argument GL_DRAW_BUFFER
glGet with argument GL_AUX_BUFFERS
SEE ALSO
glBlendFunc(3G), glColorMask(3G), glIndexMask(3G), glLogicOp(3G), glReadBuffer(3G)
GLDRAWBUFFER(3G)