10-25-2002
Dear,
Could you refrase your question cause I'm not sure what you want to do. Probably I can help.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i want to use multple sql count statements and store these count values in unix variable but in one connection only i.e. in only 1 time database should be hit ,which is the main requirement. (1 Reply)
Discussion started by: sw@pnil
1 Replies
2. Shell Programming and Scripting
HI all
I am calling a script "b" from script "a". In script "a", i connect to database and get month and year. I have to pass these same values to script b. How can i do that. How can i pass parameters from one script to another (3 Replies)
Discussion started by: vasuarjula
3 Replies
3. 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
4. Shell Programming and Scripting
This is for an Oracle journal import. I was using a pl/sql package and oracle API's. Oracle added invoker rights to their API's and now my package won't run. I didn't want to use their API's anyway. The only reason i was using pl/sql and the API's (just a package) was to utilize a cursor. How... (2 Replies)
Discussion started by: lmu
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
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
7. UNIX for Dummies Questions & Answers
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)
Discussion started by: zozoo
1 Replies
8. Shell Programming and Scripting
Hi,
I have a script where I make a sqlplus connection. In the script I have multiple sql queries within that sqlplus connection. I want the result of the queries to be stored in shell variables declared earlier. I dont want to use procedures. Is there anyway else.
Thanks in advance..
Cheers (6 Replies)
Discussion started by: gonchusirsa
6 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. UNIX for Advanced & Expert Users
Hi Guys,
i am having .sql script which inserts data from one table to another table based on date condition, i need to pass range on based on how many number of months, for e.g
set timing on;
whenever sqlerror exit failure;
spool myscript.log append
accept start_date... (7 Replies)
Discussion started by: rohit_shinez
7 Replies
LEARN ABOUT MOJAVE
net::dns::question5.18
Net::DNS::Question(3) User Contributed Perl Documentation Net::DNS::Question(3)
NAME
Net::DNS::Question - DNS question record
SYNOPSIS
use Net::DNS::Question;
$question = new Net::DNS::Question('example.com', 'A', 'IN');
DESCRIPTION
A Net::DNS::Question object represents a record in the question section of a DNS packet.
METHODS
new
$question = new Net::DNS::Question('example.com', 'A', 'IN');
$question = new Net::DNS::Question('example.com');
$question = new Net::DNS::Question('192.0.32.10', 'PTR', 'IN');
$question = new Net::DNS::Question('192.0.32.10');
Creates a question object from the domain, type, and class passed as arguments. One or both type and class arguments may be omitted and
will assume the default values shown above.
RFC4291 and RFC4632 IP address/prefix notation is supported for queries in both in-addr.arpa and ip6.arpa namespaces.
decode
$question = decode Net::DNS::Question($data, $offset);
($question, $offset) = decode Net::DNS::Question($data, $offset);
Decodes the question record at the specified location within a DNS wire-format packet. The first argument is a reference to the buffer
containing the packet data. The second argument is the offset of the start of the question record.
Returns a Net::DNS::Question object and the offset of the next location in the packet.
An exception is raised if the object cannot be created (e.g., corrupt or insufficient data).
encode
$data = $question->encode( $offset, $hash );
Returns the Net::DNS::Question in binary format suitable for inclusion in a DNS packet buffer.
The optional arguments are the offset within the packet data where the Net::DNS::Question is to be stored and a reference to a hash table
used to index compressed names within the packet.
name
$name = $question->name;
Internationalised domain name corresponding to the qname attribute.
Decoding non-ASCII domain names is computationally expensive and undesirable for names which are likely to be used to construct further
queries.
When required to communicate with humans, the 'proper' domain name should be extracted from a query or reply packet.
$query = new Net::DNS::Packet( $example, 'ANY' );
$reply = $resolver->send($query) or die;
($question) = $reply->question;
$name = $question->name;
qname, zname
$qname = $question->qname;
$zname = $question->zname;
Canonical ASCII domain name as required for the query subject transmitted to a nameserver. In dynamic update packets, this attribute is
known as zname() and refers to the zone name.
qtype, ztype
$qtype = $question->qtype;
$ztype = $question->ztype;
Returns the question type attribute. In dynamic update packets, this attribute is known as ztype() and refers to the zone type.
qclass, zclass
$qclass = $question->qclass;
$zclass = $question->zclass;
Returns the question class attribute. In dynamic update packets, this attribute is known as zclass() and refers to the zone class.
print
$object->print;
Prints the record to the standard output. Calls the string() method to get the string representation.
string
print "string = ", $question->string, "
";
Returns a string representation of the question record.
COPYRIGHT
Copyright (c)1997-2002 Michael Fuhr.
Portions Copyright (c)2002-2004 Chris Reinhardt.
Portions Copyright (c)2003,2006-2011 Dick Franks.
All rights reserved.
This program is free software; you may redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
perl, Net::DNS, Net::DNS::DomainName, Net::DNS::Packet, RFC 1035 Section 4.1.2
perl v5.18.2 2014-01-16 Net::DNS::Question(3)