Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x

SAP

487

Solutions

751

Contributors

SAP makes enterprise software products, including Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), Supply Chain Management (SCM) and Supplier Relationship Management (SRM) titles, the database product Sybase, along with numerous other products specific to various industries, using a variety of platforms and frameworks.

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

Sign up to Post

Hi,

I have a cluster with two node with this version of OS and HACMP :

pp01:>oslevel -s
7100-00-06-1216

pp01:>lslpp -l | grep cluster.es.server.rte
  cluster.es.server.rte     6.1.0.14  COMMITTED  ES Base Server Runtime

I need to update both the OS and the PowerHA version, what procedure should i follow?
On the systems they know, there is a matrix of compatibility between sap versions and OS versions?
0
Free Backup Tool for VMware and Hyper-V
LVL 1
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Hi,

Can I separate the same column name two times?

Please refer below screen shot for better understanding.

If a single supplier is having two ports (As shown in image), then the supplier name is shown once. Can it be displayed twice
crosstab-supplier-name.jpg
0
Hi,

When a crystal report has a sub-report, then a tool tip is displayed on the report.

How to hide that tool tip?

Attached image is for more reference
Tool-Tip.jpg
0
I am trying to use "Suppress If Duplicated" on the cross tab's non summarized fields, but it is not working.

Attached is the screen shot for reference.
DuplicateValues.jpg
0
Can you please suggest me on can grow functionality w.r.t cross tab. For example, if the data in one cell is large, then it gets trimmed off instead of wrapping it and enlarging of cell.
Even while exporting cross tab to excel it's not the exactly what was designed in the crystal report. Any solution to achieve this?
While exporting to excel, I select Following steps to export crystal report cross tab to excel:
  • Export Report
  • Microsoft-Excel (97-2003)
  • In Excel Format Option I select "Show Gridlines" field
PurchasingExportAnalysisTabReport_34.xls
0
Hi Experts,
How to check the status of Sybase database are online or offline.
I know sp_helpdb , But is there any other better command which shows state of database.
Thanks.
0
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
Hello,

I am trying to achieve the conditional highlighting of a summarized fields in cross tab.

Basically, I want to compare which has the least value.

Attached image will give better understanding highlight-cross-tab.jpg
How can I find out which summarized field has the least value.
0
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
Free Tool: Subnet Calculator
LVL 10
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Hi,

I have a cross tab in a group header.

I want to sort cross tab according to the third row.

How to achieve this?

For example, the attached image.
LogBook.jpgI want to sort the cross tab as per Part 3
0
I am trying to start the Sybase Sql Anywhere Personal Database Server 16 and also start/connect/run a specified database file...

Does not work in shortcut (both of these START the DB Server but NOT the db file ???)
"C:\Program Files\SQL Anywhere 16\Bin32\dbeng16.exe" "C:\Data\MyFile.db"

"C:\Program Files\SQL Anywhere 16\Bin32\dbeng16.exe" C:\Data\MyFile.db

http://dcx.sap.com/1200/en/dbadmin/startexe.html
0
Hi,

I am studying the pros and cons of multi site architecture of MS SQL, oracle, MySQL and sybase. I know about MySQL and I am focusing on MS SQL now.

other than AOG, anything else can be good for MS SQL on 2 x data center MS SQL configuration/topology ?
0
Hi All
i'm looking to get SAP certification in "Finance controlling" module,   any advice?
and is ther any online programm
0
Hi,

Currently I am using SAP Xcelsius dashboards, I know these are outdated. would like to know what are best tools or applications similar to Xcelsius where the components can be dragged and dropped and build great visualization dashboards.

Objectives for this dashboards
get real time data from ERPs (SAP, Oracle, etc.,)
if it can send alerts to mail that would be great
get the dashboards on mobile/desktop/tablets
have user restrictions
build country/ Region wise data
0
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
Can the database password on the SAP Crystal Reports in SAP Business Objects Enterprise be updated using an API?

Is there an API .NET Framework available?

Where can the API be downloaded?

Does the API have to be installed on the both the client and server?
0
Does SAP BusinessObjects Business Intelligence 4.x. in Linux have any specific software requirements?   Also do the following products have any specific requirements running in Linux?

APOS Security Manager
APOS Insight
APOS Administrator
APOS Publisher
0
My extended family runs a small water sewage utility. I'm building apps that will allow us to increase customer service beyond the norm.

We've recently realized with SAP B1 (Blue Oceans) we can provide customer service that is typically only offered by utilities with 1 million plus customers.

My cousin and I will probably get the B1 cert and I'll get the SDK cert. But we don't have my dad's business mind.

My dad simply does not have the time to learn a complex software like SAP so I was wondering if they would make him learn the software or just teach him ideal configuration so he can instruct us.

My dad went to law school and he has a better business mind than some MBAs. If he learned how it worked we could really improve our business.

Can you answer the question and also do you recommend any schools that have online programs that focus on ERPs for utilities (if that's a thing)?
0
[eBook] Windows Nano Server
LVL 1
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

I have a copy of SQL 2008 R2 on a customer site and I am trying to connect a Sybase database to it to query the Sybase tables.  I have tried to understand the Linked Server process.

Can someone tell me how this is done please
0
Microsoft provides a development SQL server that can run on your laptop or PC for developers to work against. I can put a Northwind database on such for example, and devise queries against it. I am looking for similar tools that I can do so for these database formats, if there is such an animal...

DB2
Oracle
SAP
AS400
0
I have the need to get a BOM with all components , currently using Tc. CK86 , but this doesn't give enough information, so I want to do this by SQL, I come from oracle background and dont know how could I get this done in DB2 R/3, I do not have access to query builder or quickview , but i do have read access via SQL, I'm currently trying to figure out a way of getting this info using tables :

MAST Material to BOM Link
STKO BOM Header
STPO BOM item

Does any of you  have a solution for this?

In Oracle I did something like the following:
SELECT DISTINCT LEVEL
	,sys_connect_by_path(msil.segment1, ' @ ') AS "BOM TREE"
	,msi.segment1
	,lpad(' ', LEVEL, '') || msil.segment1 Cod_Component
	,msil.item_type
	,msil.description Desc_Component
	,BIC.component_quantity
	,msiL.primary_unit_of_measure
FROM mtl_system_items msi
	,bom_bill_of_materials bom
	,BOM_INVENTORY_COMPONENTS BIC
	,MTL_SYSTEM_ITEMS MSIL
WHERE msi.organization_id = 332
	AND BOM.ASSEMBLY_ITEM_ID = MSI.INVENTORY_ITEM_ID
	AND BOM.ORGANIZATION_ID = MSI.ORGANIZATION_id
	AND bom.bill_sequence_id = bic.bill_sequence_id
	AND nvl(bic.disable_date, sysdate) >= SYSDATE
	AND BIC.component_ITEM_ID = MSIL.INVENTORY_ITEM_ID
	AND Bom.ORGANIZATION_ID = MSIL.ORGANIZATION_ID
	AND msil.inventory_item_status_code = 'Active'
	AND msi.inventory_item_status_code = 'Active' connect BY prior bic.component_item_id = bom.assembly_item_id
	START
                  WITH msi.segment1 = trim(:parte)
        ORDER BY 2

Open in new window

0
Hello,

I am using SAP BusinessObjects Crystal Reports 2013 Support Pack 4 Version 14.1.4.1327 CR Developer.

When I drag and drop the date field from my service it shows an incorrect date on the report.

As shown in the screen shot image


How to overcome this issue? Even if I enter different parameter it shows the same incorrect date. It doesn't display date in database.
IncorrectDate.jpg
0
Hi,

i have a code of SAP as below, in the below code instead of 11, i want to give the cell reference of excel ,for example the cell range is in sheet1 J3, how do i relate this SAP. This code is in excel vba.

Please suggest

session.findById("wnd[0]/usr/ctxtPAR_27").text = "11"
session.findById("wnd[0]/usr/ctxtPAR_28").text = "11"
session.findById("wnd[0]/usr/ctxtPAR_31").text = "2017"
session.findById("wnd[0]/usr/ctxtPAR_30").text = "0"

Thank you!
0
Why can not the provider increase the size of the tablespace much more? What does it depend on? According to the image only broadened by 2%
www.png
0

SAP

487

Solutions

751

Contributors

SAP makes enterprise software products, including Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), Supply Chain Management (SCM) and Supplier Relationship Management (SRM) titles, the database product Sybase, along with numerous other products specific to various industries, using a variety of platforms and frameworks.