I am using ISQL command in my script like below
I used the if condition so that when there is an error i can exit the script with a message.
But this is not happening,instead i am getting the error printed in my output file.Like this:
I wonder how the return value of ISQL is 0 when i am getting error instead of proper Output.
Hi,
Below shell script executes based on liasted data files parameters.But small problem need to avoid ,If any empty line occures in dat files it's throwing oracle error .Need to ignore empty lines (means does not ready by script).Please advice.
#/bin/sh
adsts=`cat... (2 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)
Hi
Am making connection to oracle using ISQL as shown in the code.
This code is just a minor part of a big code.
I want to capture the error if the password/login is wrong or if connection is not made.
I need to capture the error code also.
Also, If such an error occurs, i need to exit out... (4 Replies)
Hi,
I am using RHEL4 and Oracle11g , my application requires odbc connection
hence I modified ODBC.ini file and when I exceute isql commande I got the following error.
isql: error while loading shared libraries: /opt/nastel/apwmq/odbc/lib/libodbc.so.1: requires glibc 2.5 or later dynamic... (1 Reply)
Hi,
I am using RHEL4 and Oracle11g , my application requires odbc connection
hence I modified ODBC.ini file and when I exceute isql commande I got the following error.
isql: error while loading shared libraries: /opt/nastel/apwmq/odbc/lib/libodbc.so.1: requires glibc 2.5 or later dynamic... (4 Replies)
Hi Guys,
I am using simple ls command to find out whether the dir exist there or not. If dir found than remove. But the problem is I don't want the error shown on the terminal window that "dir not found" on the terminal window everytime i execute it. The code I am using is:
set x = `/bin/ls... (4 Replies)
mkdir logs
mkdir: Failed to make directory "logs"; File existsTo avoid this error i use the -p argument so it creates a folder only if it is does not exists like you see below.
mkdir -p logs In the similar manner i wish to avoid this error with ln command
ln -s /tmp/myfolder var
ln: cannot... (4 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... (1 Reply)
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 SUSE
apache::session::store::sybase
Session::Store::Sybase(3) User Contributed Perl Documentation Session::Store::Sybase(3)NAME
Apache::Session::Store::Sybase - Store persistent data in a Sybase database
SYNOPSIS
use Apache::Session::Store::Sybase;
my $store = new Apache::Session::Store::MySQL;
$store->insert( $ref );
$store->update( $ref );
$store->materialize( $ref );
$store->remove( $ref );
DESCRIPTION
Apache::Session::Store::Sybase fulfills the storage interface of Apache::Session. Session data is stored in a Sybase database.
SCHEMA
To use this module, you will need at least these columns in a table called 'sessions':
id CHAR(32) # or however long your session IDs are.
a_session IMAGE
To create this schema, you can execute this command using the isql or sqsh programs:
CREATE TABLE sessions (
id CHAR(32) not null primary key,
a_session TEXT
)
go
If you use some other command, ensure that there is a unique index on the id column of the table
CONFIGURATION
The module must know what datasource, username, and password to use when connecting to the database. These values can be set using the
options hash (see Apache::Session documentation). The options are:
DataSource
UserName
Password
Example:
tie %hash, 'Apache::Session::Sybase', $id, {
DataSource => 'dbi:Sybase:database=db;server=server',
UserName => 'database_user',
Password => 'K00l',
Commit => 1,
};
Instead, you may pass in an already-opened DBI handle to your database.
tie %hash, 'Apache::Session::Sybase', $id, {
Handle => $dbh
};
Additional arguments you can pass to the backing store are:
Commit - whether we should commit any changes; if you pass in an already-open database handle that has AutoCommit set to a true value, you
do not need to set this. If you let Apache::Session::Store::Sybase create your database, handle, you must set this to a true value,
otherwise, your changes will not be saved
textsize - the value we should pass to the 'set textsize ' command that sets the max size of the IMAGE field. Default is 32K (at least in
Sybase ASE 11.9.2).
AUTHOR
This module was based on Apache::Session::Store::Oracle which was written by Jeffrey William Baker <jwbaker@acm.org>; it was modified by
Chris Winters <chris@cwinters.com> to work with Apache::Session 1.5+ with changes from earlier version of Apache::Session::DBI::Sybase from
Mark Landry <mdlandry@lincoln.midcoast.com>.
SEE ALSO
Apache::Session
perl v5.12.1 2007-09-28 Session::Store::Sybase(3)