Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

Sybase Database

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi Expert,
We are not sure what is the use of SID_AUDIT database, but i understood we will created this as part of post configuration
Can you please tell us what is the use of CMS and Audit database.
Some times database  fills up and we need to add 20gb of space.
Can you tell us how can we analyse this situation.
0
On Demand Webinar: Networking for the Cloud Era
LVL 10
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Hi Team,

I need to write a stored procedure to insert and delete a record in a table in sybase . Iam new to Sybase , below is the code I wrote in Oracle stored procedure
-- Oracle version
Create or replace procedure p1 (id number , status out number)
is
begin
insert into t1 values (id);

delete from t2 where empid=id;
commit;
exception
when others then
dbms_output.put_line(SQLCODE || SQLERRM);
rollback;
end;

I need to write the above logic in sybase , any help is really appreciated.  I have tried the below code  , need an help on the exception handling section

create procedure p1 (@id int , out @status int)
as
begin

insert into t1values (@id);
delete from t2 where empid=@id;
set @status=0;
commit;
-- Need help on how to write an exception block which can handle the error
end;
0
Hi

I am accessing in Access, using the sybase ase 15.7 driver, a sybase table that has date/time fieds. However, when accessing that table over an ADODB connection, the values returned are always only a date without time. If I use convert(varchar(8), <datetime field name>, 8) to get the time part, I invariably get a 00:00:00 time, although I KNOW that these fields all have a non-zero time value.

The weirdest is that, if I just open the table in Access (using the SAME ODBC driver to link the table), I see the time in these fields !

What is going on, and how can I get the time portion of these dates ?

Thanks for help.
Bernard
0
Hi Team,

I need to create a stored procedure which inserts rows from an Emp table into the Staging table

Stageing Table
Create table EmployeeStg
(
EmpID INT,
ENAME VARCHAR2(40),
Age INT);
go


Original Table

Employees
EMPID         ENAME                      Age
1               sam                              40
2               xyz                                 20
3              dfdf                               34


My question how can I insert rows EmployeeStg using Employees table from a Sybase stored procedure . Can I use Select into clause . What is the best way to achieve this .

Any sample code is reaaly appreciated. Since MSSQL and Sybase use T-SQL , Iam moving this under both MSSQLSERVER and Sybase database
0
Hi Team,

Iam new to Sybase  and unix , I need an help in writing a shell script which will  pass  the shell script parameters to the stored procedure .  The below code throws an error ,Any help is really appreciated

Procedure DeleteData
@Empid INT,
@empType VARCHAR2(40),
@status OUT INT
WITH RECOMPILE
AS
BEGIN

INSERT INTO TABLENAME VALUES (@EMPID,@emptype);

Delete from TempEMp where empid=@EMPID;

end;
go

I need to call this storedprocedure from the shell script

#!/usr/bin/ksh

EmpId =$1
EmpType=$2
Status=0
result=$(isql -usam -p sam123 -slocalhost << EOF

 DeleteData $EmpId, $EmpType , $Status
EOF)

If [ $Status -eq 0 ]
then
      echo "Success"
else
    echo "failure"
fi
0
Hi Team,

Iamm new to sybase , Need help on any tutorial for performance tuning in Sybase (like explain plan in oracle , hints etc) .
Any help is really appreciated.
0
Hi,

In sybase, table sysdatabases has column dumptrdate, what date does it indicates ?
It is the unix time stamp of that dmp stripes ?

If it unix time stamp, can I manually update that column ?

my problem is as below..

1. Copied the dmp from one server to another
2. Load the dmp
3. Still offline
4. loading trans dmp but failed due to date mismatch.
5. Checked the date in dumptrdate, it is showing wrong date
6. Made it online and checked the date inside database, it is showing correct date.
7. So I suspected that dumptrdate used unix timestamp so I loaded the dmp again..manually updated dumptrdate column and tried loading tran dmp, it is still failing.

Cant figure out where I am going wrong, need some expert advice on this.

Thanks
0
In sql server I can perform an INSERT INTO Table SELECT FROM to copy data from a source table to a target table. Where the target table might already have data in it. Is there a way to do this in SYBASE syntax?
0
I need to create a new column using an alter statement, and I need to add a column value which will default to a value of 0 upon completion. I have tried using the two alter statement seperately, however I get the error message shown below. Can anyone tell me what needs to be done so that I can create a default value of Zero?

EXECUTE (' ALTER TABLE dbo.TrtTable ADD Contag TINYINT DEFAULT 0')


EXECUTE (' ALTER TABLE dbo.TrtTable ADD Contag TINYINT NOT NULL DEFAULT (0) ')


https://www.experts-exchange.com/askQuestion.jsp#
> Script lines 111-138 ------
Neither the select into nor the 'full logging for alter table' database options are enabled for database 'CompEmp'. ALTER TABLE with data copy cannot be done.
0
I need help from a Sybase Expert.
I need to be able  to create a table in my database from scratch.  So I have a master script that creates all of the tables from scratch. For one of the tables, call it "EmpList" when I try to create that table from scratch I get the error message shown below. As a side note, I generated the sql to create the table by right clicking on the table in Aqua studio, and selecting "Script Object to File As : Create".

Why am I getting the error message below(See very bottom of post) when I try to create the table?
Here is my sql to create the table:

CREATE TABLE dbo.EmpList (
EmpId numeric(10,0) IDENTITY NOT NULL,
DtCreated datetime NOT NULL,
CONSTRAINT EmpList_pri PRIMARY KEY NONCLUSTERED(EmpId)
WITH max_rows_per_page = 0, reservepagegap =0
)
LOCK ALLPAGES
WITH max_rows_per_page = 0,
reservepagegap = 0,
identity_gap = 0
ON [default]
GO
GRANT SELECT, INSERT, UPDATE ON dbo.EmpList TO jeltem
GO
GRANT SELECT, INSERT, UPDATE ON dbo.EmpList TO admin
GO





> Script lines
dbo.EmpList not found. Specify owner.objectname or use sp_help to check wether the object exists (sp_help may produce lots of output)
0
Moving data to the cloud? Find out if you’re ready
LVL 3
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Hi,
I would like to know if there is any configuration parameter or procedure from which I could know how many CPUs or cores is used by ASE?
I am using Sybase ASE 16.0 & 15.7.
0
I can add a column to a table as follows. Is there a way to specify that the column can not be null?
Or am I already doing that implicitly.

My Sybase sql which works :
ALTER TABLE dbo.MaxPlayer ADD SmallScore tinyint DEFAULT  0


This does not work as I added NOT NULL:

ALTER TABLE dbo.MaxPlayer ADD SmallScore tinyint NOT NULL DEFAULT  0
0
I need to create a new column in a Sybase data table, but only if the column does not yet exists. Here is my query, below. My table is named BALANCE and the new column is named SAMP

When I run the query I keep getting an error message "Incorrect Syntax near bit". Can someone tell me what is wrong with my syntax. I know I am close, but I just can't figure it out.

if not exists (select 1 from syscolumns where object_name(id) = 'BALANCE' and name = 'SAMP')
begin
execute('

 alter table BALANCE add column SAMP bit DEFAULT (0) NOT NULL

')
0
I have the following Sybase sql code that is within a stored procedure. When the code executes, an error message is dislpayed 2627 - "Violation of PRIMARY KEY constraint BUKO_PRIMARY". I don't actually have access to the data, so I have limited debugging capabilities right now. However I think that the error is occurring because of maybe an attempt to insert a duplicate record into the table stored in @BakName. Does that sound correct? How should I handle this in Sybase sql to deal with the attempt to insert a duplicate record?
Also does the command "INDEX" attempt to make a column as a unique value in the column?

SELECT queryString = 'SELECT b.* INTO ' + @BakName +
                       'FROM stageTable a (INDEX stageTable_pk) +
                       ' INNER JOIN ' + @PrxyName + 'b (INDEX BUKO_PRIMARY) ON a.ATO_ID = b.TO_ID '
0
I am using DBArtisan 9.1.2 and I want to recompile a Sybase stored procedure that exists because I have to modify the stored procedure. How would I do so?

The stored procedure starts out as ...

create procedure dbo.usp_CalculateImportedItems
as
declare @err                  int
BEGIN
declare @BalanceRecordCount int
declare @PendingRecordCount int
declare @WiredRecordCount int
declare @OpenItemsRecordCount int
declare @IntellimatchRecordCount int
declare @AutoImportDate datetime
declare @ManualImportDate datetime

BEGIN  TRANSACTION
0
hi
i am comparing the output of number of view from syscomments for specific tablename with sp_depends tablename output. i always get few extra views in syscomment output. is it correct way of comparing and why we get extra output from syscomments output.

1. select distinct sysobjects.name,
case
 when sysibjects.type = 'v'
..
  from sysobjects inner join syscomments on
sysobjects.id = syscomments.id
where syscomment.text like'%tablename'

2. sp_depends '%tablename%'

i am comparing above 2 output and find there is diffetence output..
0
Hi,

I'm working in the DATA WAREHOUSE PROJECT, Does anyone have the industry best practices on how to build a  TEST cases.

Such as Tools, Technique, the methodology used?
0
UNABLE TO CONVERT THE DLI_MAIN_CODE AND | CHAR

--SQL================================
CREATE TABLE #PROOF
(
    dli_barcode numeric NOT NULL,
    all_dli_main_code varchar(10) NOT NULL
)

DECLARE cur CURSOR for
    SELECT
       
        U.DLI_BARCODE,
        U.DLI_MAIN_CODE
        FROM OMPROD..PS_DLI_ITEM_UC U, #AD_DAILY_REPORT D
        WHERE U.DLI_MAIN_CODE IN  (7,8,89)
        AND U.DLI_BARCODE = D.CHILD_BARCODE
        AND U.SETID = D.SETID
         


DECLARE @curDLI_BARCODE NUMERIC
DECLARE @lastDLI_BARCODE NUMERIC
DECLARE @curDLI_MAIN_CODE varchar(30)
DECLARE @DLI_MAIN_CODE SMALLINT

OPEN cur
FETCH NEXT FROM cur INTO
      @curDLI_BARCODE, @curDLI_MAIN_CODE
SET @lastDLI_BARCODE = @curDLI_BARCODE
WHILE @@FETCH_STATUS = 0
BEGIN
    IF (@lastDLI_BARCODE != @curDLI_BARCODE)
    BEGIN
        INSERT INTO #PROOF(dli_barcode ,all_dli_main_code)
            VALUES(@lastDLI_BARCODE, @DLI_MAIN_CODE )    --<<<<+ '| '
        SET @lastDLI_BARCODE = @curDLI_BARCODE
        SET @DLI_MAIN_CODE = NULL
    END

    IF (@DLI_MAIN_CODE IS NULL)
        SET @DLI_MAIN_CODE = @curDLI_MAIN_CODE
    ELSE
        SET @DLI_MAIN_CODE = CONVERT(VARCHAR(10), @DLI_MAIN_CODE + N' '+ '| ' + @curDLI_MAIN_CODE) --<<<<20170428 PM

    FETCH NEXT FROM cur INTO
        @curDLI_BARCODE, @curDLI_MAIN_CODE
END

IF (@DLI_MAIN_CODE IS NOT NULL)
BEGIN
    INSERT INTO #PROOF(dli_barcode, all_dli_main_code)
        VALUES(@curDLI_BARCODE, CONVERT(VARCHAR(10), …
0
I had this question after viewing Backing up Sybase database Server using Veeam.

Hi,

I'm new in experts-exchange community. My company is on the way to use SAP Solutions. Right now I must choose backup concept for all VM's and databases. As far I know HANA backs up relatively automatic (dumps database and logs from RAM to storage). The issue what keeps me not sleeping is backup from Sybase ver. 11 databases, as database shouldn't be stopped at any time (24/7 availabilty) and this version have no support for VSS. I've readed that it's possible to HA (High Availabilty) and DR (Disaster Restore) only with VMWare solutions but I'm not sure - will consistency of database not be corrupted?...
Can someone give me a Tip what would be the best solution?
Database: Sybase 11
VMWare: vSphere 5.5
Veeam: 9.5.0.823
Many thanks for Your replies.
0
Learn how to optimize MySQL for your business need
LVL 3
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

i want to check if the Windows server has the following software installed on it.

IBM DB2
IBM IMS
Unisys RDMS
Unisys DMS
Sybase
Oracle

I believe we can check this if there are services running for each Software and need to know what service will indicate that the software is installed?
Any one please.
Thanks
0
Below is the output set I want from an SP. I will have count as input parameter to the  SP
so If count in 3 and I want the result to be c1, c2, c3, c4, c5,c6,c7,c8,c9
If the Count is 2, then c1,c2,c3, c4

Output of SP:
 
(OP)            C1            C2            C3           C4            C5            C6    C7          C8            C9

I know we can do like below, how do I do it dynamically?

SELECT '(OP)',           ' C1 ',   'C2', 'C3','C4','C5','C6', 'C7','C8',       'C9'
0
I have Needles as my case management software. It uses Sybase SQL Anywhere as the back end database.
I want to pull the data from Sybase into a SQL Server database so I can run query statements since I know SQL Server but not Sybase.
I am using a copy of the original database.
The company won't say how to do this. Their application has a very limited report writing tool and so we have to ask them to write repoerts for us. I want to get around this. Please advice. Thank you for your time.
Marina D.
0
when i am creating a temp table in sybase i am getting this error. Can advice which property is blocking and how can i increase this number. or how to resolve such sybase issues.

Error msg is

"Number = 1701, severity = 16, state = 1, Message = create table failed because the minimum row size would be 4066bytes. this exceeds the max allowable size of a row for this table."
0
hi,

as I know replication server is belongs to the Sybase server and any technology different between Sybase replication server( need a separate license I know) and MS SQL build replication.

why someone still use Sybase ASE replication server if MS SQL already has it and why don't simply migrate to MS SQL?

and it seems I never heard about Oracle replication server, how oracle handle replication ? all relies on data guard ?
0
I have a table in which one column(attribute) have multiple values on the coma seprated basis. Now i need to break them Or convert into 1nf, So please tell me how to do this.
EX-      name      phone        educaion
           abc          x                   10,12 ,14
          cde           e                    10


now it should be converted into....>
             name      phone          education    
              abc          x             10
              abc           x              12
              abc           x              14
              cde          e              10
0

Sybase Database

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.

Top Experts In
Sybase Database
<
Monthly
>