Using a ksh script, I'm dumping the data from our sybase database into an output file. This output file is for what ever reason cut at 2GB.
There is enough space on the unix machine and as there is no error message is received I have no clue to start looking for a solution.
#!... (1 Reply)
#!/bin/ksh
file="/pkgs/roots/scripts/ISQL_op.txt"
isql -H 11.11.11.111:1111 -U myUser -P myPwd -o $file << eof
go
select * from Table1
go
eof
my cron entry
00 08 03 11 * /pkgs/roots/scripts/testc.ksh
file permission of the script is correct, i have used absolute path everywhere.
... (2 Replies)
hi all
i m running following code
# set up environment
. /u/pimms/pimms_global.ksh
echo "Get record from database"
#echo ${PIMMS_ID}
#echo ${PIMMS_PWD}
#echo "1"
isql -U${PIMMD_ID} -P${PIMMS_PWD} -S$SRV << eof > /sybase/applications/pimms/bin/automate1.txt
use pimms
... (6 Replies)
Hi
I am formatting informix isql output(vertical) to horizontal format. Suppose I have the following content in the flat file from isql output -
item_nbr 0
usfn_label Subscriber Class
usfn_name SBCLASS
usfn_value bl5
item_nbr 1
usfn_label Switch Name
usfn_name switchName... (2 Replies)
isql output comes as below,
(0 rows affected)
(1 row affected)
(7 rows affected)
How to extract the resultset number alone from the particular line ??
such as
0
1
7 (3 Replies)
Hi all,
I have wrote a script to redirect the output of Sybase query to a file.
Its a single XML message i am fetching with sybase query.
The problem i faced here is the XML message line crosses the normal line limit in unix.
Could some please help me how to get complete xml message... (1 Reply)
I am using below code to validate the source file,code working fine but if any column contains null value then below code throwing error actually it should not.how to customize the below code to handle null null values also.
When I run the script with below source data getting “date error”, as... (2 Replies)
I am trying to run a query which returns a sum value(a number).
I want to get it in a variable so that i can refer to that variable in different places.
when i am running the following command
variable=`isql -Uuser -Sserver -Ppassword
1> select sum(count(*)) from xyz..abc where clm_id... (2 Replies)
Hi Guru's,
I'm new at Unix. I am tasked to monitor the filesystem utilization on OS level (Unix) and DB (Sybase) for multiple systems. I am thinking to use vi editor and make a file, execute that file and all the file systems I need to monitor will be be shown.
My script inside vi goes in... (8 Replies)
DBIx::Class::Storage::DBI::Sybase::ASE::NoBindVars(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::Sybase::ASE::NoBindVars(3)NAME
DBIx::Class::Storage::DBI::Sybase::ASE::NoBindVars - Storage::DBI subclass for Sybase ASE without placeholder support
DESCRIPTION
If you're using this driver then your version of Sybase or the libraries you use to connect to it do not support placeholders.
You can also enable this driver explicitly using:
my $schema = SchemaClass->clone;
$schema->storage_type('::DBI::Sybase::ASE::NoBindVars');
$schema->connect($dsn, $user, $pass, \%opts);
See the discussion in "Using ? Placeholders & bind parameters to $sth->execute" in DBD::Sybase for details on the pros and cons of using
placeholders.
One advantage of not using placeholders is that "select @@identity" will work for obtaining the last insert id of an "IDENTITY" column,
instead of having to do "select max(col)" in a transaction as the base Sybase driver does.
When using this driver, bind variables will be interpolated (properly quoted of course) into the SQL query itself, without using
placeholders.
The caching of prepared statements is also explicitly disabled, as the interpolation renders it useless.
AUTHORS
See "CONTRIBUTORS" in DBIx::Class.
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.16.2 2011-05-23 DBIx::Class::Storage::DBI::Sybase::ASE::NoBindVars(3)