How can I get an sap fico demo cd's or download for training?

Hi

Is there any issue if we setup 'abort tran on log full' for primary database? Does sybase try to kill repagent process in case replication marker is blocking the transaction? Kindly advise.

thanks
Chan

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

Hello,

I am working with VS2015 C#. Trying to execute a stored procedure from a Sybase db.

It seems to be not receiving the parameters I am trying to send it. I attached the code I'm using with the error msg that I'm receiving.

I'm using this connection string:
Data Source={Adaptive Server Enterprise};server=ppw.amgreetings.com; db=db_cis00;uid=cis;pwd=hotstam;

I am able to receive data back from this db by using embedded sql, but the sp is having issues.

Do you guys see anything I could try differently?

Thanks,
David
DevError1.png

We are looking to replace our current SAP systems with a new one.  We were thinking of pointing using a friendly URL to point to the database such as  prodcutionSQLDB.ACME.com  and  productionOracleDB.ACME.com instead of using DB Server name.

This way our application servers just get this FQDN to point to the database.  THis would simplify our DR planning and future migrations.

The question is, does SAP require certificates or something similar where the application servers would not be able to communicate with the DB  (SQL or Oracle).  My understanding is SQL and Oracle use username\pass to authenticate,  or does SAP rely on certificates to communicate with the DB servers?

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

I have a server hp-ux with :
[root@csapdev01 ~]# swlist -l bundle|egrep -i "qpkbase|qpkapps|hwenable11i|feature11i"
  FEATURE11i            B.11.31.1209.383a Feature Enablement Patches for HP-UX 11i v3, September 2012
  HWEnable11i           B.11.31.1209.383a Hardware Enablement Patches for HP-UX 11i v3, September 2012
  QPKAPPS               B.11.31.1703.429a Applications Patches for HP-UX 11i v3, March 2017
  QPKBASE               B.11.31.1703.429a Base Quality Pack Bundle for HP-UX 11i v3, March 2017

With SAP installed, i want know the version of SAP kernel for verify there is patches (sap) which must be installed ?

Thks

This is for my web assessmet SAP S/4 Hana Sales: which steps need to be performed for existing customers to migrate to SAP S/4 HANA? enablement of digital transformation, verification of all data layers, techincal migration, implementation of additional high security measures. In my opinion there are available all the answers, but i`m not sure; without a digital transformation you cannot migrate to S/4HANA, you must verify all the data but I don`t know what all layers means; you  it will be a technical migration, and the experte say there are additional security measures implemented. I really don`t know if my answer is correct because I have multiple choises, but I don`t know the number of correct answers; Thanks a lot! Best regards, Cris!

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

Hello experts,
I'm quite struggling with a date-time problem at Universe (IDT 4.1 SP7)&BO Webinar (14.1.7).

Let's start with customer request:
He needs a Webi report where he can filter by prompt -date and time in separately

For example, if he filters:
Date between 01/01/2016-30/02/2016
Time between 11:00-15:00
He wants to see all data between these dates and time 11:00-15:00

The problem -
In universe -Data Foundation I'm getting from EVENTS table a date-time filed (SQL server) - for example "04:26:47 24/07/2017"
So, on the Data Foundation level (in the EVENTS table) I created 2 "calculation columns"
Date filed - "toDate(@catalog ('RC_Control')."Control.dbo"."EVENTS"."EVENT_TIME_UTC")
Time filed - "toTime(@catalog ('RC_Control')."Control.dbo"."EVENTS"."EVENT_TIME_UTC")

In the Business Layer I created 2 dimentions (date&time)that brings these calculated columns.
Their DataType -Date
On the date filed I'm getting just the date-as I need.
On the Time dimention, on the "Advanced" tab- "Edit display format"-I costumed the format as customer need - "hh:mm"
When I create a query I'm getting the "he:mm" as I need.
Now on BO Webi I created the 2 prompts and here are my problems:
Problem no. 1 : "Time" prompt - I'm getting date only (!!!!). It doesn't recognize the costume I made on the IDT.
I need it to be filtered by "hh:mm" only
Problem no.2 : when I display chosen date filter (by - userResponse("psEnter Value for date (start):") I'm still getting the …

#option3
                                update top(10) ud_$REAL_TABLE_NAME
                                set $UD_FIELD_NAME=@id
                                where $$UD_FIELD_NAME is NULL

                                while @@rowcount > 0
                                begin transaction
                                update top(10) ud_$REAL_TABLE_NAME
                                set $UD_FIELD_NAME=@id
                                where $UD_FIELD_NAME is NULL

                                     if @@rowcount > 0
                                       begin
                                            print 'Successfully update @@rowcount no of rows'
                                            commit transaction
                                       end


                                end

                                go

                                set rowcount 0
                                go