10-09-2018
Looks like your Main_table is not found, just like the error message said.
I assume you are using Sybase and have a created a database in Sybase, identified in $DBName
What is the value of $DBName and please post the data structure of that DB, or at least the structure of Main_table.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear all
I want to execute some isql command from unix shell script. Kindly suggest me. isql command mention below.
isql -U -P
use gdb_1
go
select count (*) from table_x
go (3 Replies)
Discussion started by: jaydeep_sadaria
3 Replies
2. UNIX for Dummies Questions & Answers
UNIX Shell Script
I'm in /home/suneel dirctory
in that directory need to check for a path for example com/src/resources
If Path exists need to copy the files from one directory
If path not exist need to create the folders and copy the files
UNIX shell script help required (3 Replies)
Discussion started by: suneelc
3 Replies
3. Shell Programming and Scripting
I have a file like this 07200900.SUP,in a windows directory I need to FTP this file to UNIX , the directory in unix is N:\orgs\Financial Aid\MIIS\0910\FTP
I am getting this error
miis_ftp.ELM_SUP.shl: =cd orgs/"Financial Aid"/"MIIS"/"0910"/"FTP" : not found
IN THE LOG FILE
Activities for Mon... (3 Replies)
Discussion started by: rechever
3 Replies
4. Shell Programming and Scripting
Hi I am trying to execute the following awk script in unix but getting
the following error
awk: syntax error near line 1
awk: bailing out near line 1
for i in `cat search`
do
grep -i -l $i *.sas | awk -v token=$i '{print token "\t" $0}'
done
Please let me know what could be the... (4 Replies)
Discussion started by: nandugo1
4 Replies
5. Shell Programming and Scripting
Hi All,
I'm niks and i'm a newbie here and newbie in shell, i'm just wondering what is the meaning of -U -P -S in the sample script below.
"-U iccbs_dbo -P iccbsdbo -S CCB_REO"
Thanks, (2 Replies)
Discussion started by: nikki1200
2 Replies
6. Shell Programming and Scripting
Hi Everyone,
newbie here, please help me i can't read the code i'm confused reading this code.
select c.net_svc_id, c.inst_st_dt into ${REO_RECON_USERID_LUZON_TEMP} from ${WO_INST_SITE_COMP_FIELDS} a, ${WO_INST_SITE_COMPONENTS} b, ${WO_INST} c where a.cust_ac_no = b.cust_ac_no and... (3 Replies)
Discussion started by: nikki1200
3 Replies
7. Shell Programming and Scripting
Hi Gurus,
I am very new in Unix,
I have 1 script, in which I am truncating the table , then BCP the data in Sybase table, and then loading the data from sybase table to sybase table.
every thing is working fine, but the problem is with Error.
I made some hanges in my insert statement so... (3 Replies)
Discussion started by: aksar
3 Replies
8. Shell Programming and Scripting
I am trying to run a unix script in my home directory.Snippet below
echo "`date '+%Y%m%d_%H%M%S'` Getting ProductList.dat"
if ( -f $DIR/ProductList.dat) then
cp $DIR/ProductList.dat MigratedProductList.dat
else
echo "`date '+%Y%m%d_%H%M%S'`ProductList.dat does not exist; Processing... (4 Replies)
Discussion started by: Mary James
4 Replies
9. Shell Programming and Scripting
need to create shell script to read the table's name from file and connect SQL SERVER using isql (odbcunix)
i 'm able connect to database with below command line syntex but i could not get working in shell script with SQL and storing the row count in variable.
isql -v DSN USERNAME PASSWD
... (6 Replies)
Discussion started by: pimmit22043
6 Replies
10. Shell Programming and Scripting
Hello Everyone,
Coming again for your help to solve the below error:
In a script, i had created a temp table (Temp_table) and loaded the data in it using bcp command (performed successfully) and I wanted to move it to the preferred table (called Main_table) for further use. hence I have added... (1 Reply)
Discussion started by: Suresh
1 Replies
LEARN ABOUT DEBIAN
sql::reservedwords::sybase
SQL::ReservedWords::Sybase(3pm) User Contributed Perl Documentation SQL::ReservedWords::Sybase(3pm)
NAME
SQL::ReservedWords::Sybase - Reserved SQL words by Sybase
SYNOPSIS
if ( SQL::ReservedWords::Sybase->is_reserved( $word ) ) {
print "$word is a reserved Sybase word!";
}
DESCRIPTION
Determine if words are reserved by Sybase.
METHODS
is_reserved( $word )
Returns a boolean indicating if $word is reserved by either Sybase ASE 12 or 15.
is_reserved_by_ase12( $word )
Returns a boolean indicating if $word is reserved by Sybase ASE 12.
is_reserved_by_ase15( $word )
Returns a boolean indicating if $word is reserved by Sybase ASE 15.
reserved_by( $word )
Returns a list with Sybase versions that reserves $word.
words
Returns a list with all reserved words.
EXPORTS
Nothing by default. Following subroutines can be exported:
is_reserved
is_reserved_by_ase12
is_reserved_by_ase15
reserved_by
words
SEE ALSO
SQL::ReservedWords
<http://infocenter.sybase.com/help/>
AUTHOR
Christian Hansen "chansen@cpan.org"
COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.8.8 2008-03-28 SQL::ReservedWords::Sybase(3pm)