hi ,
how to pass unix variable to oracle
code is .............
#! /bin/ksh
echo enter date vale
read date1
sqlplus x/y@oracle
select * from emp where statrt_date= $date1
is this is correct way... (1 Reply)
Hi All
I have a file for ex .log file which contain several lines within it.
I have to read that file contents & assing that to a variable. (2 Replies)
Hi, I hope the title does not scare people to look into this thread but it describes roughly what I'm trying to do. I need a solution in PHP.
I'm a programming beginner, so it might be that the approach to solve this, might be easier to solve with an other approach of someone else, so if you... (0 Replies)
Please help me how to pass some unix vairable to oracle. I have used below , but not displaying passed (inval) value.
calling()
{
sqlplus -s $1/$2@$3 <<EOF
begin
exec call_sql($4);
end;
exit
EOF
}
calling user pwd inst value1... (17 Replies)
I want output to be assigned to UNIX variables
echo "Enter RRS ID: "
read rrs
isql -SPROD_DDS -USYBUSER -PSYBPASS -b -osfg.out << EOF
use sip
go
set nocount on
select issuerId,
legalStructTxt,
productName,
issuerName
from sf_product
where rrsId = $rrs
go
EOF (1 Reply)
Hello All,
I need to export various variables in UNIX. But the values of those variables will come from Oracle.
Say i have Oracle query:
Select
file_id, file_desc, file_freq_cd, load_table_nm, load_stored_procd_nm, load_proc_typ_nm, err_rec_cnt_thrsld_nbr, file_expc_rec_cnt From Table1... (7 Replies)
Hi, I have the following command that parses an xml file to read a node <port>'s value. Hoever the output comes with spaces.
My requirement is to trim the spaces around the value and assign to a variable.
sed -n 's|<port>\(.*\)</port>|\1|p' ../cfg.xml
How do I go about it? (6 Replies)
Hi,
I am using the below code to get a numeric value from oracle to unix variable:
BD_RC_CNT=`sqlplus -s ${WMD_DM_CONNECT} <<EOF
set heading off
set pagesize 0
Select count(*)
from wmd_bad_data
where proc_id = ${PROC_ID}
and file_id = ${FILE_ID}
and file_dt =... (7 Replies)
Hi
I am new to UNIX. I am trying the below and getting the error.
I am trying to assign the variable with the value of the query result. I want this value to use in the next steps.
Created UNIX file (Batch.sh) as below
#!/bin/ksh
sqlplus callidus/callidus4u@attstcal @Batch.sql
... (2 Replies)
Discussion started by: KrishBalu
2 Replies
LEARN ABOUT HPUX
standards
standards(5) File Formats Manual standards(5)NAME
standards - UNIX standards behavior on HP-UX
DESCRIPTION
HP-UX conforms to various UNIX standards. In some cases, these standards conflict. This manpage describes the methods that programmers
and users must follow to have an application conform and execute according to a particular UNIX standard.
UNIX Standard Conformant Programmer Environment
The following table lists feature test macros and environment variables that must be defined while compiling an application. Both a fea-
ture test macro and an environment variable must be defined while compiling the application so that the application conforms and executes
according to a particular UNIX standard. Otherwise, the behavior is undefined.
Standard Feature Test Macros to be Environment variable
defined during compilation to be set
UNIX 95 _XOPEN_SOURCE_EXTENDED=1 UNIX95 or
UNIX_STD=95 or
UNIX_STD=1995
UNIX 2003 _XOPEN_SOURCE=600 UNIX_STD=2003
The compiler uses the feature test macros to obtain the appropriate namespace from the header files. The compiler uses the environment
variable to link in an appropriate object file to the executable. Using the environment variable customizes libc to match UNIX standards
for various functions.
If an application has already been compiled for default HP-UX behavior or for one particular standard, and needs to change to a particular
UNIX standard behavior, recompile the application as specified in the above table.
For an HP-UX command to conform to a particular UNIX standard behavior, the application has to set the corresponding environment variable
as specified in the above table before executing that command.
UNIX Standard Conformant User Environment
To enable a particular UNIX standard conformant user environment, set the corresponding environment variable as defined in the above table.
EXAMPLES
The following examples shows an application example. To have the system be conformant to UNIX2003 behavior, set the environment variable
to and define the feature test macro before compilation.
The following example changes the command to have UNIX95 behavior by setting one of the environment variables to or to before executing
that command. There are three ways of setting the environment variable for UNIX95:
or
or
SEE ALSO cc(1), stdsyms(5).
standards(5)