10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I had an issue in executing bcp command to connect to Sybase from Unix script for uploading the data from file to table.
I have a file called vrs_temp.txt (with two columns):
22055;20181001
21088;20181001
93840;20181001
30990;20181001
50990;20181001
50950;20181001Created a... (4 Replies)
Discussion started by: Suresh
4 Replies
2. Programming
Dear Team
I am using Sybase Adaptive Server Enterprise/15.7 (ASE). Trying my luck on SOUNDEX function to get unique records
Though the command works for characters and provides unique code for similar outputs.
But when i try with Starting numbers ( Followed with Street address ) , soundex... (1 Reply)
Discussion started by: Perlbaby
1 Replies
3. Programming
Hi Team -
I am using Sybase ASE 15.7 version. Below query is throwing an error
stating Error : incorrect syntax near the keyword 'OVER'
SELECT
EMPLOYEE_ID ,
EMPLOYEE ,
Department,
CAST( Salary as DECIMAL( 10, 2 ) ) AS Salary
CAST(AVG( Salary) OVER ( PARTITION... (3 Replies)
Discussion started by: Perlbaby
3 Replies
4. Shell Programming and Scripting
Hello all, just a quick little part of code i'm writing to check if the file i'm writing too in my automatic process is not being written too manually.
#!/bin/bash
FUSER=$(/sbin/fuser -s /toto.tmp >/dev/null 2>&1)
LSOF=$(/usr/sbin/lsof | grep -q "toto.tmp")
PGREP=$(pgrep -f "toto.tmp" >... (6 Replies)
Discussion started by: maverick72
6 Replies
5. Programming
I am opening a text file using open() system call in O_RDONLY mode.
open() returns me a valid handler but also sets errno to 13 i.e. EACCES(Permission denied).
Question is when open() is returning a valid handler then why does it sets the errno?
Should not errno be set only in case of error... (10 Replies)
Discussion started by: rupeshkp728
10 Replies
6. Shell Programming and Scripting
Help Please perl Gurus,
I am trying to add ungrouped passengers in a group and I creating a script however it fails on first step only I tried all the options it returns following error.
syntax error at junki line 4, near "open "
Execution of junki aborted due to compilation errors. ... (2 Replies)
Discussion started by: dynamax
2 Replies
7. IP Networking
As we are facing issue with this server connection. The error is:
The system function gethostbyname() failed to find the client's host name.
how can i check if the server "server1" is able to resolve the client hostname (hosts / dns)?
i can ping the client from server.
any... (1 Reply)
Discussion started by: jinslick25
1 Replies
8. Shell Programming and Scripting
I am trying to bcp in using sybase::bcp perl module. I can find we can give user, pwd and server name in the parameters.
How can I give database and table name? (1 Reply)
Discussion started by: Deei
1 Replies
9. Programming
If a process already has the entire file locked for read and write using newstruct.l_type = F_WRLCK; what would happen if another process would try to open it in read only mode using open(filename, O_RDONLY); ?
I want to check if the file exists and I want it to work even if another process has... (4 Replies)
Discussion started by: cyler
4 Replies
10. UNIX for Advanced & Expert Users
I need a decent SSH client which has column selection capabilities. The one I'm using now is about to expire. Its called IVT secure access. (3 Replies)
Discussion started by: nuggetz
3 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.18.2 2013-12-16 DBIx::Class::Storage::DBI::Sybase::ASE::NoBindVars(3)