Sybase Database

4K

Solutions

2

Articles & Videos

3K

Contributors

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,
I'd like to update automatically the statistics for single table in SYBASE ASE every 3 days.

If anybody had tried updating automatically the statistics for single table in SYBASE, please share the procedure with me.

Thanks in advance!
0
On Demand Webinar: Networking for the Cloud Era
LVL 8
On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

I had this question after viewing how to automatically retrieve datawindow while the user types the matching char string on sle.

I want to have the user retrieve automatically names from the list by keying letters in a search sle.
I set up the code to filter the data but nothing is happening. I tried the pbm_dwnkey as event id but nothing. I cannot find the pbm_upkey in the event list. I am using PB 12.5.
Thanks
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
FromDateTime DATE;
   ToDateTime DATE;  
   S_DATE DATE;
   
     S_DATE:=TRUNC(NVL(D_DATE,SYSDATE));

   IF flag='1' THEN
   FromDateTime :=TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 00:00:01', 'DD-MON-YYYY HH24:MI:SS') ;
   ToDateTime := TO_DATE(TO_CHAR(s_date,'DD-Mon-YYYY') || ' 11:00:00', 'DD-MON-YYYY HH24:MI:SS');
   ELSIF flag='2' THEN
   FromDateTime :=TO_DATE(TO_CHAR(s_date,'DD-Mon-YYYY') || ' 11:00:01', 'DD-MON-YYYY HH24:MI:SS') ;
   ToDateTime := TO_DATE(TO_CHAR(s_date,'DD-Mon-YYYY') || ' 13:00:00', 'DD-MON-YYYY HH24:MI:SS');
   ELSIF flag='3' THEN
   FromDateTime := TO_DATE(TO_CHAR(s_date,'DD-Mon-YYYY') || ' 13:00:01', 'DD-MON-YYYY HH24:MI:SS') ;
   ToDateTime := TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 15:00:00', 'DD-MON-YYYY HH24:MI:SS');
   ELSIF flag='4' THEN
   FromDateTime := TO_DATE(TO_CHAR(s_date,'DD-Mon-YYYY') || ' 15:00:01', 'DD-MON-YYYY HH24:MI:SS') ;
   ToDateTime := TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 17:00:00', 'DD-MON-YYYY HH24:MI:SS');
   ELSIF flag='5' THEN
   FromDateTime := TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 17:00:01', 'DD-MON-YYYY HH24:MI:SS') ;
   ToDateTime := TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 19:00:00', 'DD-MON-YYYY HH24:MI:SS');  
   ELSE
    FromDateTime := TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 19:15:01', 'DD-MON-YYYY HH24:MI:SS') ;
    ToDateTime := TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 20:15:00', 'DD-MON-YYYY HH24:MI:SS');
   END IF;
0
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
Hi All,

In one of my PowerBuilder application there is an window which has 'Master' and 'Modified' list. Records present under 'Master' list are original and when any user makes any changes in any one of them or inserts new record then it will be shown under 'Modified' list, till the time it will be authorized by Authorizer.
There is only one datawindow: d_customer which is used for retrieving data in Master and Modified list, depending on the action ( 'I' (Insert), 'M' (Modify) ) performed details will be fetched in 'Master' / 'Modified' list.

My question is when any user updates/inserts any field it should be get highlighted and will be visible to Authorizer in Yellow color in 'Modified' list.
Could you please help me in implementing this problem statement, it will be great help. Thanks in advance.
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
On Demand Webinar: Networking for the Cloud Era
LVL 8
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.

Now that the 12 has a feature of the columnar tables, had anyone did the performance comparision of Sybase IQ to that of Oracle 12c.  Did you use the 12C columnar table feature or  the traditional tables used for the migration. I have 1.8 TB of data going out from IQ to Oracle but not sure on the performance.
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
How to find config id value from the below string? it can be any no of digits, but only digits. Essentially I want to find the value after --configId and  the space till the next space. That configId can be anywhere in the string and can have any no of digits.

String -->
/XX/XXXX/XXXXX/XX/XX -XX -- /xx/xxxx/xxxx/xxxx/xxxxxxx/xxx/xxx/xxxxxxxx.pl --configId 12107 --cfg /xx/xxxx/xxxxxxx/xxxxxx.xml

I am trying this but not working, not being able to get the length of the substring.
----------------------------------------------------------------------------------------------------------------------------------------
select substring(j.command, patindex('%--configId%',j.command)+9, PATINDEX('%[0-9][^0-9]%', j.command) - PATINDEX('%[^0-9][0-9]%', j.command)) from job j
0
Dears,

Is it right that the following 3 commands are not copies into the standby database:
•      select into
•      update statistics
•      Database or configuration options such as sp_dboption and sp_configure

*For select into, can we add this configuration : sp_setrepdbmode pdb, 'S', 'on'  ?
 If so, what about others? Do we have to apply them manually on standby database?
The same concern is about ALTER table in the active database, but for this I think it is replicated, isn’t it?
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
Dears, I was issuing my script for Sybase ASE database maintenance manually, which select some information from sysobjects and sysindexes relying on derived stats and insert those retrieved data into a temp table then iterate through it to rebuild index when it is needed, the details are in the attached file, please find it.

now, I want to execute this file automatically using a batch file, which calls the attached file but unfortunately the file doesn't execute cause the commands such as select into #temp, and select derived-stats and others.
is this right? or I miss some thing, please advice how can I run my script automatically???
rebuild-idx.sql
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
Hi,

I am trying to plot some long and lats from a Sybase 16 database into a SSRS Map report using SQL Server spatial query.

I am using the below code to generate the spatial data in Sybase:
ST_Geometry::ST_GeomFromText( 'POINT(1 1)' )

Open in new window


but when I click n next the wizard states that the dataset does not contain any spatial field.

Please help.

Thanks, Greg
0
On Demand Webinar - Networking for the Cloud Era
LVL 8
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Dears,
I was using sybase ASE 15.03 and sybase replication server on the same version, recently, we upgraded the ASE on our production server to 15.7, can we keep using of sybase replication 15.03 or we have to renew its license?
kindly note we  also installed sybase 15.7 on DR site

please advice
0
Could anyone please explain when to use clustered and non cluster indexes in sybase ase?

Thanks in advance.
0
hi,

i know how to select top 100 rows or bottom 100 rows from sybase sql statement but how can get only middle rows like from 501 to 1000 rows,

for top 100.. i use
select top 100 * from tablename

for last 100.. i use
select top 100 * from tablename order by columnA

how can i pull out all rows from 501 to 1000 rows?

thanks
0
I am using Sybase IQ select @@version SAP IQ/16.0.110.2014/10214/P/sp11/Enterprise Linux64 - x86_64 - 2.6.18-194.el5/64bit/2015-11-21 01:29:07

I need to build a tree on a table which consists more than Million records which links for every order_id. Need to find what it was replaced by existing order_id until the end and eventually need to find the various quantities of each of these order_id and get the max out of it.

Below is my sample data
create table #tmporder ( account_key varchar(50) not null, order_id varchar(50) not null, msg_type varchar(5) not null, repl_by_order varchar(50) not null, replaces_order varchar(50) not null, quantity numeric(12) not null, order_datetime datetime not null, order_status varchar(1) not null );

INSERT INTO #tmporder (account_key,order_id,msg_type,repl_by_order,replaces_order,quantity,order_datetime,order_status) VALUES ('123456','6473','PL','0','0',1000,{ts '2016-10-07 07:59:10'},'1');

INSERT INTO #tmporder (account_key,order_id,msg_type,repl_by_order,replaces_order,quantity,order_datetime,order_status) VALUES ('123456','6473','MO','6480','0',1000,{ts '2016-10-07 07:59:10'},'5');

INSERT INTO #tmporder (account_key,order_id,msg_type,repl_by_order,replaces_order,quantity,order_datetime,order_status) VALUES ('123456','6474','PL','0','0',1000,{ts '2016-10-07 08:16:05'},'1');

INSERT INTO #tmporder (account_key,order_id,msg_type,repl_by_order,replaces_order,quantity,order_datetime,order_status) VALUES 

Open in new window

0
Hi,
When I run sp_helpdb procedure I get the following information:

 device_fragments               size          usage                created                   free kbytes
 ------------------------------ ------------- -------------------- ------------------------- ----------------
 XX_data_01                       1024.0 MB data only            Nov 20 2015  2:08PM                  12400
 XX_data_02                       1024.0 MB data only            Nov 20 2015  2:52PM                  96432
 XX_data_01                       1024.0 MB data only            Nov 20 2015  3:26PM                 176784
 XX_data_02                       1024.0 MB data only            Nov 20 2015  4:05PM                 176800
 XX_data_01                       1024.0 MB data only            Nov 20 2015  4:54PM                 196720
 XX_data_02                       1024.0 MB data only            Nov 20 2015  5:08PM                 225680
 XX_data_01                       1024.0 MB data only            Nov 20 2015  5:19PM                 583200
 XX_data_02                       1024.0 MB data only            Nov 20 2015  5:34PM                 614080
 XX_data_01                       1024.0 MB data only            Nov 20 2015  6:00PM                 736784
 XX_data_02                       1024.0 MB data only            Nov 20 2015  6:29PM                 485808
 XX_data_01                       1024.0 MB data only            Nov 20 2015  7:06PM                 206848
 XX_data_02 …
0
I had this question after viewing SQL Query Producing decimal places when it shouldn't be.

Ok so now I have another issue....even though the DataGridView is showing the value correctly with 2 decimals, when I export the DataGridView to CSV, it STILL shows the 6 decimal places. Here is my export to CSV code:

  StreamWriter sw = new StreamWriter(file_path);

        if (headers)
        {
            for (int i = 0; i < dgv.Columns.Count; i++)
            {
                sw.Write(dgv.Columns[i].HeaderText);
                if (i != dgv.Columns.Count - 1)
                {
                    sw.Write(",");
                }
            }
            sw.Write(sw.NewLine);
        }       

        foreach (DataGridViewRow dr in dgv.Rows)
        {

            for (int i = 0; i < dgv.Columns.Count - 1; i++)
            {
                if (quotes)
                {
                    sw.Write("\"" + dr.Cells[i].Value.ToString() + "\"");
                }
                else
                {
                    sw.Write(dr.Cells[i].Value.ToString());
                }
                if (i != dgv.Columns.Count - 1)
                {
                    sw.Write(",");
                }
            }

            sw.Write(sw.NewLine);
        }
        sw.Flush();
        sw.Close();

Open in new window



I think it has to do with the .Value.ToString and the fact that it doesn't see the DefaultCellStyle.Format = "f2"

Thoughts?
0

Sybase Database

4K

Solutions

2

Articles & Videos

3K

Contributors

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
>

No Top Experts for this time period. Answer questions to earn the title!