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 the following code:
Code:
isql -U$DBLogin -PPassed -S$DBName -e <<!
use $schema
go
if exists (select 1 from syscolumns where id = object_id('Main_table') and name = 'Column1')
begin
insert into Main_table select * from $db..Temp_table
end
else
begin
create table Main_table
(
Column1 char (5),
Column2 int
)
insert into Main_table select * from $db..Temp_table
end
go
DROP TABLE $db..Temp_table
go
!
But, I have got the following error message:
Code:
Msg 208, Level 16, State 1:
Main_table not found. Specify owner.objectname or use sp_help to
check whether the object exists (sp_help may produce lots of output).
Msg 208, Level 16, State 1:
Main_table not found. Specify owner.objectname or use sp_help to
check whether the object exists (sp_help may produce lots of output).
Please have a look and advise the error in my query.
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)
Hi Josh
Hope you are doing fine..I have a small requirement but unable to get a syntax for it.
Here is how it is.
There is a Server say ABC.From another Server i need to get records from Server ABC.
Now logic is written as follows.
It creates a file as per sysdate and append the... (1 Reply)
hi there
i write one awk script file in shell programing
the code is related to dd/mm/yy to month, day year format
but i get an error
please can anybody help me out in this problem ??????
i give my code here including error
awk `
# date-month -- convert mm/dd/yy to month day,... (2 Replies)
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)
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)
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)
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)
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)
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)
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... (7 Replies)
Discussion started by: Suresh
7 Replies
LEARN ABOUT CENTOS
error::pass1
ERROR::PASS1(7stap)ERROR::PASS1(7stap)NAME
error::pass1 - systemtap pass-1 errors
DESCRIPTION
Errors that occur during pass 1 (parsing) usually mean a basic syntax error of some sort occurred in the systemtap script. There are sev-
eral classes of problems possible:
plain syntax error
The systemtap script parser detects a large variety of errors, such as missing operands, bad punctuation. It tries to list what
kinds of tokens it was expecting to see, and will show the region of the source code with the problem. Please review the stap(1)
man page and/or the tutorial, to correct the script's syntax.
grammar ambiguities
There is at least one known ambiguity in the systemtap grammar. It relates to the optionality of ; (semicolon) separators between
statements, and the ++ and -- increment/decrement operators. If the parser indicates an error, consider adding some explicit ; sep-
arators between nearby statements and try again.
missing command line arguments
A systemtap script that uses the $N and @N constructs for substituting in command-line options may fail if not enough options were
given on the stap command line.
compatibility changes
Some versions of systemtap have changed the language incompatibly, for example by adding the try/catch keywords for exception han-
dling. In such cases, rerun systemtap with the --compatibility=VERSION option, substituting the last systemtap version where your
script was known to work. You may also check the release-history NEWS file for compatibility changes.
GATHERING MORE INFORMATION
Increasing the verbosity of pass-1 with an option such as --vp 1 can help pinpoint the problem.
SEE ALSO stap(1),
error::reporting(7stap)ERROR::PASS1(7stap)