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::Schema::Loader::DBObject::Sybase(3pm) User Contributed Perl Documentation DBIx::Class::Schema::Loader::DBObject::Sybase(3pm)
NAME
DBIx::Class::Schema::Loader::DBObject::Sybase - Class for Database Objects for Sybase ASE and MSSQL Such as Tables and Views in
DBIx::Class::Schema::Loader
DESCRIPTION
This is a subclass of DBIx::Class::Schema::Loader::DBObject that adds support for fully qualified objects in Sybase ASE and MSSQL including
both "database" and schema of the form:
database.owner.object_name
METHODS
database
The database name this object belongs to.
Returns undef if ignore_schema is set.
sql_name
Returns the properly quoted full identifier with "database", schema and name.
SEE ALSO
DBIx::Class::Schema::Loader::Table::Sybase, DBIx::Class::Schema::Loader::DBObject, DBIx::Class::Schema::Loader::Table,
DBIx::Class::Schema::Loader, DBIx::Class::Schema::Loader::Base
AUTHOR
See "AUTHOR" in DBIx::Class::Schema::Loader and "CONTRIBUTORS" in DBIx::Class::Schema::Loader.
LICENSE
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2012-05-05 DBIx::Class::Schema::Loader::DBObject::Sybase(3pm)