01-19-2016
Thanks, can you guide me how i can achieve that
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am trying to close of multiple users in an Oracle database. Each users has records in multiple tables what I need to do is use a script that call each SQL seperately passing either CLI arguments or gathered arguments from the users during run time.
## Accept variable(s) from the command line... (1 Reply)
Discussion started by: jagannatha
1 Replies
2. Shell Programming and Scripting
Hi all, I have a shell script which invoke a sql script using command
db2 -tf /home/me/db_housekeep.sql -z /home/me/db_housekeep.log
however, this mentioned sql script requires several input arguments, I wonder if one can pass variables from shell script to sql script? thanks! (0 Replies)
Discussion started by: mpang_
0 Replies
3. Shell Programming and Scripting
Hello,
i am using '#!/bin/bash', i want to make a loop in pl/sql, this loop takes values from a table according to some conditions, each time the loop choose 3 different variables. What i am not able to do is that during the loop i want my shell script to read this 3 variables and run a shell... (1 Reply)
Discussion started by: rosalinda
1 Replies
4. Shell Programming and Scripting
Hi Guys,
I like to pass a variable to a sql file in a unix script..
I tried a below code..
var=200903
db2 -vf test.sql 200903
test.sql is as below.
select * from db2.users where quarter = $1;
Please tell me where i go wrong..
Thanks in advance,
Magesh (2 Replies)
Discussion started by: mac4rfree
2 Replies
5. UNIX for Advanced & Expert Users
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)
Discussion started by: apskaushik
2 Replies
6. Shell Programming and Scripting
Hi Guys,
Can someone please help me on adding/inserting a variable date to an sql scipt? Basically I want to assign a 7 days date range. As shown below..
#!/usr/bin/perl
use strict;
use Env qw(ORACLE_HOME);
my $SQLPLUS='/opt/oracle/product/10.1.0/db_1/bin/sqlplus -S... (1 Reply)
Discussion started by: pinpe
1 Replies
7. Shell Programming and Scripting
There are 4 parameters that I have to pass from korn shell to sql script.
1) I have to check if $1 , $2 , $3 and $4 are null values or not .
How can I do that ?
2) Once its determined that these values are null (in the sense they are empty) how can I pass null values to sql script... (11 Replies)
Discussion started by: megha2525
11 Replies
8. Shell Programming and Scripting
Hello,
i`m looking for some way to add to some date an partial number of months, for example to 2015y 02m 27d + 2,54m
i need to write this script in php or bash or sh or mysql or perl in normal time o unix time
i`m asking or there are any simple way to add partial number of month to some... (14 Replies)
Discussion started by: bacarrdy
14 Replies
9. Shell Programming and Scripting
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Discussion started by: a1_win
7 Replies
10. Shell Programming and Scripting
Hi All,
I am new to shell script. I am trying to pass value from .sh file to .sql file .
But I am able to run the .sql file from .sh file with values in sql file.
But I am unable to pass the values from .sh file. can some one please help to resolve this.
here is my .sh file
s1.sh
... (4 Replies)
Discussion started by: reddy298599
4 Replies
LEARN ABOUT OPENDARWIN
exspline
exspline(3alleg4) Allegro manual exspline(3alleg4)
NAME
exspline - Constructing smooth movement paths from spline curves. Allegro game programming library.
SYNOPSIS
#include <allegro.h>
Example exspline
DESCRIPTION
This program demonstrates the use of spline curves to create smooth paths connecting a number of node points. This can be useful for con-
structing realistic motion and animations.
The technique is to connect the series of guide points p1..p(n) with spline curves from p1-p2, p2-p3, etc. Each spline must pass though
both of its guide points, so they must be used as the first and fourth of the spline control points. The fun bit is coming up with sensible
values for the second and third spline control points, such that the spline segments will have equal gradients where they meet. I came up
with the following solution:
For each guide point p(n), calculate the desired tangent to the curve at that point. I took this to be the vector p(n-1) -> p(n+1), which
can easily be calculated with the inverse tangent function, and gives decent looking results. One implication of this is that two dummy
guide points are needed at each end of the curve, which are used in the tangent calculations but not connected to the set of splines.
Having got these tangents, it becomes fairly easy to calculate the spline control points. For a spline between guide points p(a) and p(b),
the second control point should lie along the positive tangent from p(a), and the third control point should lie along the negative tangent
from p(b). How far they are placed along these tangents controls the shape of the curve: I found that applying a 'curviness' scaling factor
to the distance between p(a) and p(b) works well.
One thing to note about splines is that the generated points are not all equidistant. Instead they tend to bunch up nearer to the ends of
the spline, which means you will need to apply some fudges to get an object to move at a constant speed. On the other hand, in situations
where the curve has a noticeable change of direction at each guide point, the effect can be quite nice because it makes the object slow
down for the curve.
SEE ALSO
END_OF_MAIN(3alleg4), SCREEN_W(3alleg4), acquire_screen(3alleg4), alert(3alleg4), allegro_error(3alleg4), allegro_init(3alleg4), alle-
gro_message(3alleg4), calc_spline(3alleg4), circlefill(3alleg4), clear_keybuf(3alleg4), clear_to_color(3alleg4), desktop_palette(3alleg4),
fixatan2(3alleg4), fixcos(3alleg4), fixed(3alleg4), fixmul(3alleg4), fixsin(3alleg4), fixsqrt(3alleg4), fixtof(3alleg4), fixtoi(3alleg4),
font(3alleg4), ftofix(3alleg4), install_keyboard(3alleg4), install_mouse(3alleg4), install_timer(3alleg4), itofix(3alleg4), key(3alleg4),
keypressed(3alleg4), line(3alleg4), makecol(3alleg4), mouse_b(3alleg4), mouse_x(3alleg4), mouse_y(3alleg4), palette_color(3alleg4),
poll_mouse(3alleg4), readkey(3alleg4), release_screen(3alleg4), screen(3alleg4), set_gfx_mode(3alleg4), set_palette(3alleg4),
show_mouse(3alleg4), spline(3alleg4), textout_centre_ex(3alleg4), textprintf_centre_ex(3alleg4), textprintf_ex(3alleg4), vsync(3alleg4),
xor_mode(3alleg4)
Allegro version 4.4.2 exspline(3alleg4)