Hello,
I have a csh script that creates an environment variable. I want to pass the environment variable(CURR_TABLE_DATE) to an Informix sql script. Here is the csh:
#!/bin/csh -f
setenv INFORMIXSERVER market3_tcp
setenv CURR_TABLE_DATE 20090714
set DATABASE = gm_cdr
set SQL_DIR =... (0 Replies)
Please help. I got these error. I'm try to pass variable extract from data-file.txt to sql file(select.sql).
cat: cannot open select
cat: cannot open *
cat: cannot open from
cat: cannot open user
cat: cannot open where
cat: cannot open name=$list;
#!/bin/bash
list=`sed q... (3 Replies)
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)
hi all,
i am experiencing an error which i think an incorrect syntax for the where clause passing a variable was given. under is my code.
sqlplus -s ${USERNAME}/${PASSWORD}@${SID} << END1 >> $LOGFILE
whenever sqlerror exit
set serveroutput on size 1000000
declare
l_rc ... (0 Replies)
Hi,
I am using SYBASE database. in my script i am connecting to DB via using isql.
isql -U${S_USER} -S${S_SERV} -D${S_DB} -P${S_PWD} -b0 -w3000 -h0 -s"|" -i${MYDIR}/ABC.sql -oXYZ.txt << FINSQL
i am taking a ABC.sql file to use the queries written in it and storing the output in... (3 Replies)
Hi all,
Hereby wish to have your advise for below:
Main concept is
I intend to get current directory of my script file.
This script file will be copied to /etc/init.d.
A string in this copy will be replaced with current directory value.
Below is original script file:
... (6 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 all,
How to pass the command line argument to a sql file
Script:
#!/bin/ksh
if ] ; then
test.sql
fi
My Sql Informix DB:
echo "select * from table where col1 = 2234
and col2 = '$3'"|dbaccess ddname
But im getting `:' unexpected error (5 Replies)
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)
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)
Discussion started by: ROCK_PLSQL
6 Replies
LEARN ABOUT MOJAVE
apr::uuid
install::TempContent::Objects::mod_perl-2.0.9::docs::apiUserRContributed Perinstall::TempContent::Objects::mod_perl-2.0.9::docs::api::APR::UUID(3)NAME
APR::UUID - Perl API for manipulating APR UUIDs
Synopsis
use APR::UUID ();
# get a random UUID and format it as a string
my $uuid = APR::UUID->new->format;
# $uuid = e.g. 'd48889bb-d11d-b211-8567-ec81968c93c6';
# same as the object returned by APR::UUID->new
my $uuid_parsed = APR::UUID->parse($uuid);
Description
"APR::UUID" is used to get and manipulate random UUIDs.
It allows you to "create" random UUIDs, which when "formatted" returns a string like:
'd48889bb-d11d-b211-8567-ec81968c93c6';
which can be parsed back into the "APR::UUID" object with "parse()".
API
"APR::UUID" provides the following functions and/or methods:
"format"
Convert an "APR::UUID object" object into a string presentation:
my $uuid_str = $uuid->format;
obj: $uuid ( "APR::UUID object" )
ret: $uuid_str
returns a string representation of the object (.e.g 'd48889bb-d11d-b211-8567-ec81968c93c6').
since: 2.0.00
"new"
Create a "APR::UUID object" using the random engine:
my $uuid = APR::UUID->new;
class: "APR::UUID" ( "APR::UUID class" )
ret: $uuid ( "APR::UUID object" )
since: 2.0.00
"DESTROY"
$uuid->DESTROY;
obj: "APR::UUID" ( "APR::UUID object" )
ret: no return value
since: 2.0.00
Do not call this method, it's designed to be only called by Perl when the variable goes out of scope. If you call it yourself you will get
a segfault when perl will call DESTROY on its own.
"parse"
Convert a UUID string into an "APR::UUID object" object:
$uuid = APR::UUID->parse($uuid_str)
arg1: $uuid_str (string)
UUID string (.e.g 'd48889bb-d11d-b211-8567-ec81968c93c6')
ret: $uuid ( "APR::UUID object" )
The new object.
since: 2.0.00
See Also
mod_perl 2.0 documentation.
Copyright
mod_perl 2.0 and its core modules are copyrighted under The Apache Software License, Version 2.0.
Authors
The mod_perl development team and numerous contributors.
perl v5.18.22015-06-install::TempContent::Objects::mod_perl-2.0.9::docs::api::APR::UUID(3)