Stack Overflow
Stack Overflow

Questions tagged [sybase-ase15]

120 questions
1
vote
1 answer

Return code for insert sql in Sybase

I have a bulk data which I'm planning to upload using simple SQL insert in Sybase. Now some of the sql's fail due to some constraint violation. Since I run all the sqls in one go, I can't find which sql has failed. The DB client console is just…
mani_nz
  • 4,522
  • 3
  • 28
  • 37
1
vote
3 answers

How to get list of all Check Constraints in database for all tables of specific schema together at once, in Sybase ASE

I am using following query to get the list of all constraints of a single table in my database sp_helpconstraint 'schema.tableName' and then I am extracting the "Check Constraints" from the result set and using it. But as I have to run the above…
Surabhi Agarwal
  • 93
  • 2
  • 10
1
vote
1 answer

How to import data from sybase by sqoop?

I am able to import data from oracle 11g by sqoop using following command import" , "-fs", "file:///" , "-jt", "local" , "-libjars", "/tmp/HELLO/tej01/EMP.jar" , "--connect",…
Parita Porwal
  • 180
  • 1
  • 3
  • 15
1
vote
1 answer

copy database structure without data in sybase 15.5 (with empty tables)

Is there any way to copy database structure without data in Sybase using ddlgen utility, so the new database will be the same as it is copied from, but with empty tables.
Mamta Vyas
  • 93
  • 1
  • 2
  • 9
1
vote
0 answers

How to enable the register button (which is greyed out) for new plug-ins in Sybase Central?

I want to register the plug-in for Replication Manager in Sybase Central but the register button is greyed out for new plug-ins. In Sybase Central's Help section; it says: "The Register button is disabled if the .screpository600 file is read-only.…
yakut
  • 47
  • 5
1
vote
1 answer

Poor query performance on an indexed string field when all values are NULL (SYBASE database)

I have a database table 'TABLE_A' with a nullable string field 'field_x' having non-clustered index on it. A query SELECT * FROM TABLE_A WHERE field_x = 'some value' executes quickly in most environments. In one client's environment all values of…
user2891742
  • 11
  • 3
0
votes
0 answers

Improve performance query on SYBASE ASE

I hope you could help me on the following problem. I have the below query which is taking too munch time (hours) and it is eating all the resources available ( currently I have 2 engines of sybase ase 15 and 4GB of memory assigned to them). The…
user3303852
  • 1
0
votes
0 answers

Problem with PDO ODBC, when using the fetchAll function, data is not returned

I encountered a problem when a PDO object in PHP stopped working properly in combination with an ODBC connection to a Sybase ASE 15.7 database. The problem occurred when changing the Sybase client on the server from version 15.0 to version 15.7. The…
user22107564
  • 1
0
votes
1 answer

How can I query ASE Sybase database to get all users with creation date and assigned roles?

Can someone please help me to get list of all users, created date and assigned roles to users in Sybase database? I tried all ways but no luck. Thank you. I tried to find in syslogins and sp_display but I am unable to find user created date.
Sanchit
  • 1
0
votes
2 answers

How to change the date format in SQL select script

In my Sybase DB I have a table called employee_leaves. So the select query statement is as shown below: SELECT EmployeeCode,EmployeeName,ApplicationDate FROM dbo.employee_leaves Where I have challenge is that the ApplicationDate comes in this…
Bami
  • 383
  • 1
  • 4
  • 10
0
votes
0 answers

Sybase Database Support on Node.js with SSL

I am working on this project that has been bugging me for a while and wanted to ask community's help on it. So basically we have an On-Prem Sybase database that needs to communicate with a cloud micro service running in Kubernetes in AWS. I am…
Sam
  • 57
  • 7
0
votes
1 answer

Sybase regexp, substr, instr function to split the string

I have the below data in a table. row_num desc 1 First Name/Last Name - Middle Name 2 FirstName/LastName - MiddleName 3 FirstName/LastName I am looking for the desired output as below row_num desc_1 desc_2 desc_3 1 First…
Bruce
  • 109
  • 8
0
votes
0 answers

How to ignore RAISERROR in Sybase ASE-15 T-SQL?

I have a loop which executes a proc. That proc can throw RAISERROR which, of course, stops the loop and the whole program. Is there any way to ignore that error and continue the loop? In normal languages I can CATCH the error, but what is possible…
Ursego
  • 141
  • 1
  • 6
0
votes
1 answer

Connecting to sybase ase with specific charset from a software

I need to connect a Sybase ASE database with a specific charset. I have data with a charset that cannot be read properly by the default charset of Sybase ASE. I know how to connect with "isqln -J" but what I need is a little more complicated. I have…
cserma
  • 1
  • 1
0
votes
0 answers

How to bulk insert into Sybase database with an auto incremented ID?

I have a table A which has Id = 0 for some 6k records, another table B in which these IDs are missing. I want to insert these IDs into table B with an auto incremented ID number and update these ID numbers into table A in no particular order. just…
olivia
  • 119
  • 1
  • 2
  • 9
1 2
3
4 5 6 7 8