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
[Webinar] How Hackers Steal Your Credentials
LVL 9
[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

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'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
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
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
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
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
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

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!