I am trying to connect SQL SERVER VIA JDCB. Following is something I tried and will appreciate any help what I am doing wrong
Here's what I did, I tried several variations, but I keep getting this error:
Exception in thread "main" java.sql.SQLException: Unable to connect. Invalid URL
I... (1 Reply)
Hi,
I know in oracle a .sql file is called by @ <path> /<filename>.
But how to call in sql 2005, I am opening the sql sessionwith sqsh, is there any command to execute there a .sql file (query in sql 2005) in K shell script. (0 Replies)
Hi
I am new in unix. oracle and unix are installed in my sytem.i need the script
which could connect to the oracle using username ,password and schema and can run the select * from tab query.
Thanks
vijay (8 Replies)
Hi Friends,
I am using AIX version and sqlplus to connect to database while writing a shell script.
I have implemented three ways to connect to database :
1)
sqlplus -s <USERNAME>/<PASSWORD> <<!
@<SQL FILE TO EXECUTE>
exit
!
2)
sqlplus -s <USERNAME>/<PASSWORD> <<!
-----sql statemenets... (6 Replies)
Hi,
I need to pass 4 parameters from Oracle Procedure to Unix Shell script..
procedure signature :-
UNIX Shell script:
Problem: 1. Suppose pdffile and pdfresult has Null values in Oracle procedures but unix shell will read parameters by spaces so
I am getting wrong parameters... (7 Replies)
Hi,
I am unable to use parameter in sql script passed from unix script.
my sql script CREATE_SBI_LIST_GROUP.sql is like this -
-------------------------------
SELECT
SDS.ID "SO_ID",
SDS.SO a1,
sgp.sga__code SGA_CODE,
FROM
sga sga,sales_genl_provision sgp , comm_product_condn cpc... (2 Replies)
Hi all ,
I want to pass contents from a file say f1 as arguments to a sql query which has In statement using a script
example
select * from table_1 where login in ( `cat f1`) ;
will this work or is there any other way to do it. (1 Reply)
Hi Gurus,
I have a request which needs to pass string into sql.
dummy code as below:
sqlplus -s user/password@instance << EOF >>output.txt
set echo off head off feed off pagesize 0 trimspool on linesize 1000 colsep ,
select emp_no, emp_name from emp
where emp_no in ('a', 'b', 'c');
exit;... (4 Replies)
Hi All,
In this path /home/all_files
we have follwing files and direcotries
proc_edf_sot.sql
proc_ssc_sot.sql
func_dfg_sot.sql
sot
unic
cmr
sdc
under sot directory we have other directories
sql
pas
ref
under sql directory we have
sql_sot
sql_mat (6 Replies)
Hi Experts,
Need your support.
Not able to use sql query alias in shell script.
Could you please help me in finding right way to use alias with sql query in shell script.
Below is the code i am using.
#!/bin/bash
sqlplus -s abc/abc@abc << EOF> bcd.csv
set trimspool on
select zone_id... (4 Replies)
Discussion started by: as7951
4 Replies
LEARN ABOUT MOJAVE
glbeginconditionalrender
GLBEGINCONDITIONALRE(3G) OpenGL 3.3 GLBEGINCONDITIONALRE(3G)NAME
glBeginConditionalRender - start conditional rendering
C SPECIFICATION
void glBeginConditionalRender(GLuint id, GLenum mode);
PARAMETERS
id
Specifies the name of an occlusion query object whose results are used to determine if the rendering commands are discarded.
mode
Specifies how glBeginConditionalRender interprets the results of the occlusion query.
C SPECIFICATION
void glEndConditionalRender(void);
DESCRIPTION
Conditional rendering is started using glBeginConditionalRender and ended using glEndConditionalRender. During conditional rendering, all
vertex array commands, as well as glClear() and glClearBuffer() have no effect if the (GL_SAMPLES_PASSED) result of the query object id is
zero, or if the (GL_ANY_SAMPLES_PASSED) result is GL_FALSE. The results of commands setting the current vertex state, such as
glVertexAttrib() are undefined. If the (GL_SAMPLES_PASSED) result is non-zero or if the (GL_ANY_SAMPLES_PASSED) result is GL_TRUE, such
commands are not discarded. The id parameter to glBeginConditionalRender must be the name of a query object previously returned from a call
to glGenQueries(). mode specifies how the results of the query object are to be interpreted. If mode is GL_QUERY_WAIT, the GL waits for
the results of the query to be available and then uses the results to determine if subsequent rendering commands are discarded. If mode is
GL_QUERY_NO_WAIT, the GL may choose to unconditionally execute the subsequent rendering commands without waiting for the query to complete.
If mode is GL_QUERY_BY_REGION_WAIT, the GL will also wait for occlusion query results and discard rendering commands if the result of the
occlusion query is zero. If the query result is non-zero, subsequent rendering commands are executed, but the GL may discard the results of
the commands for any region of the framebuffer that did not contribute to the sample count in the specified occlusion query. Any such
discarding is done in an implementation-dependent manner, but the rendering command results may not be discarded for any samples that
contributed to the occlusion query sample count. If mode is GL_QUERY_BY_REGION_NO_WAIT, the GL operates as in GL_QUERY_BY_REGION_WAIT, but
may choose to unconditionally execute the subsequent rendering commands without waiting for the query to complete.
NOTES
glBeginConditionalRender and glEndConditionalRender are available only if the GL version is 3.0 or greater.
The GL_ANY_SAMPLES_PASSED query result is available only if the GL version is 3.3 or greater.
ERRORS
GL_INVALID_VALUE is generated if id is not the name of an existing query object.
GL_INVALID_ENUM is generated if mode is not one of the accepted tokens.
GL_INVALID_OPERATION is generated if glBeginConditionalRender is called while conditional rendering is active, or if glEndConditionalRender
is called while conditional rendering is inactive.
GL_INVALID_OPERATION is generated if id is the name of a query object with a target other than GL_SAMPLES_PASSED or GL_ANY_SAMPLES_PASSED.
GL_INVALID_OPERATION is generated if id is the name of a query currently in progress.
SEE ALSO
glGenQueries(), glDeleteQueries(), glBeginQuery()
COPYRIGHT
Copyright (C) 2009 Khronos Group. This material may be distributed subject to the terms and conditions set forth in the Open Publication
License, v 1.0, 8 June 1999. http://opencontent.org/openpub/.
OpenGL 3.3 03/08/2011 GLBEGINCONDITIONALRE(3G)