09-03-2001
hi,
I resorted to creating one sql file with all table definitions in it. I then manualy load the file via sqlplus.
thanx everyone for your help.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
shell script for sorting,searchingand insertion/deletion of elements in a list (1 Reply)
Discussion started by: jayaram_miryabb
1 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I have a shell script in which I am calling a function from a different shell script. This functions executes the SQL and the results are stored in a log file.
If the result of the SQL is "no rows selected" then I need to exit the main shell script. My shell script is executing fine if... (5 Replies)
Discussion started by: shashi_kiran_v
5 Replies
3. Shell Programming and Scripting
:confused:
Hi,
I have written a script which calls a stored procrdure. The Stored procedure has 2 inputs and 6 outputs. I need to capture one of the outputs.
But I am not able to get any result from this simple script-
! /bin/ksh
echo "connect to dbau user etlbitst using anf1892;" >... (1 Reply)
Discussion started by: arnie_nits
1 Replies
4. Shell Programming and Scripting
hi,,
i have perl scipt with line :
system('./try.sh $t $d $m');
in shell scipt try.sh i have the line:
echo $1
its not printing value of $t that i hav passed..y is it so..i am running it from apache web server (2 Replies)
Discussion started by: raksha.s
2 Replies
5. Shell Programming and Scripting
hy,
i have a problem with shell script with sybase. if start single command this script working, but if run into file for example select.sh, the script doesn't create output. Can you help me please ??? thank's
USER=`cat $SYBASE/.asepwd | cut -d: -f2 | head -1`
PWD=`asepwd.sh $USER... (4 Replies)
Discussion started by: Dolcissimo76
4 Replies
6. Shell Programming and Scripting
Hello. I am trying to make this shell script bellow work on my server wich should take the names in newacc.cvs and add them to the system. For each user the script should ask me to enter a password for the user im adding and then add them to the system, however my current solution do not work atm... (7 Replies)
Discussion started by: ryzzaze
7 Replies
7. AIX
Hello, guys...
I'm new to IBM AIX server admin. Actuall, I administrate Oracle 10g on it.
*SYSTEM INFO
- IBM AIX 6 Powerpc
- Oracle 10g R2 (10.2.0.4.0 - 64bit)
I wrote a script like bellow...
DATE='date'
cp /oracle/product/10g/network/log/listener_temp.log... (4 Replies)
Discussion started by: daniel han
4 Replies
8. Shell Programming and Scripting
hi every body
this is my first thread in this forum, i hope find a solution for my problem
i have to write a script bt i still have some error and i don't know how to correct them
$ for i in `seq 500 505`; do ./generateur_tache $i tache$i.txt; nprocs=$i; copt$i=`cat tache$i.txt | ./copt.awk` ;... (10 Replies)
Discussion started by: ordo_ordo
10 Replies
9. Shell Programming and Scripting
Hello,
Ubuntu server 11.10
can anybody help what is problem with my shell script?
#!/bin/bash
#script to find out currently logged on user is root or not.
if ]
then
echo "You are super"
else
echo "You are awesome!"
fi
When I run script, I get following output
./uid: line 3:
I... (4 Replies)
Discussion started by: kaustubh
4 Replies
LEARN ABOUT DEBIAN
tangram::type::array::scalar
Tangram::Type::Array::Scalar(3pm) User Contributed Perl Documentation Tangram::Type::Array::Scalar(3pm)
NAME
Tangram::Type/Array/Scalar - map Perl array of strings or numbers
SYNOPSIS
use Tangram::Core;
use Tangram::Type/Array/Scalar; # always
$schema = Tangram::Schema->new(
classes => { NaturalPerson => { fields => {
flat_array =>
{
interests =>
{
table => 'NP_int',
sql => 'VARCHAR(50)',
},
lucky_numbers => 'int', # use defaults
}
DESCRIPTION
Maps references to a Perl array. The persistent fields are grouped in a hash under the "array" key in the field hash.
The array may contain only 'simple' scalars like integers, strings or real numbers. It may not contain references. For arrays of objects,
see Tangram::Type::Array::FromMany and Tangram::Type::Array::FromOne.
Tangram uses a table to save the state of the collection. The table has three columns, which contain
* the id of the container object
* the position of the element in the array
* the value of the element
The field names are passed in a hash that associates a field name with a field descriptor. The field descriptor may be either a hash or a
string. The hash uses the following fields:
* type
* table
* sql
Optional field "type" specifies the type of the elements. If the type is "string"Tangram quotes the values as they are passed to the data-
base. Not specifying a "type" is exactly equivalent to specifying "string".
Optional field "table" sets the name of the table that contains the elements. This defaults to 'C_F', where C is the class of the contain-
ing object and F is the field name.
Optional field "sql" specifies the type that deploy() (see Tangram::Deploy) should use for the column containing the elements. If this
field is not present, the SQL type is derived from the "type" field: if "type" is "string" (or is absent) VARCHAR(255) is used; otherwise,
the "type" field is interpreted as a SQL type.
If the descriptor is a string, it is interpreted as the value of the "type" field and all the other fields take the default value.
perl v5.8.8 2006-03-29 Tangram::Type::Array::Scalar(3pm)