Karthikeya Boyini has Published 2382 Articles

Getting a syntax error unknown fields in SAP ABAP

karthikeya Boyini

karthikeya Boyini

Updated on 18-Feb-2020 05:39:08

836 Views

You need to add spaces after or before braces as follows −SELECT  * FROM CNTRB WHERE AGE > 30 AND   CNTRB > 10000 AND NOT ( FUND1 = 'value' AND FUND2 = '0' )

Use decimal in where clause in SAP ABAP

karthikeya Boyini

karthikeya Boyini

Updated on 14-Feb-2020 10:05:41

132 Views

You are trying to use the user-specific setting in your queries, but ABAP does not support it. You need to use ‘.’ as the decimal separator instead of ‘,’.So the query would look something like −SELECT * FROM INTO WHERE amount = 10.15

Using GUI upload to attach a file to email in SAP

karthikeya Boyini

karthikeya Boyini

Updated on 14-Feb-2020 07:57:52

357 Views

You have to use parameters correctly in the function. You have to import the file length to an integer value.CALL METHOD cl_gui_frontend_services=>gui_upload_file ...     IMPORTING     filelength = fleng_i ...Next is to write to a character type variable and add parameter i_attachment_size to a class of add attachment.CALL ... Read More

C++ Program to Find Largest Element of an Array

karthikeya Boyini

karthikeya Boyini

Updated on 12-Feb-2020 06:57:29

6K+ Views

An array contains multiple elements and the largest element in an array is the one that is greater than other elements.For example.51724In the above array, 7 is the largest element and it is at index 2.A program to find the largest element of an array is given as follows.Example Live Demo#include ... Read More

What are local variables in C++?

karthikeya Boyini

karthikeya Boyini

Updated on 11-Feb-2020 09:55:53

315 Views

Variables that are declared inside a function or block are local variables. They can be used only by statements that are inside that function or block of code. Local variables are not known to functions on their own.ExampleLive Demo#include using namespace std; int main () {    int a, ... Read More

What are C++ Integer Constants?

karthikeya Boyini

karthikeya Boyini

Updated on 11-Feb-2020 08:13:31

2K+ Views

Integer constants are constant data elements that have no fractional parts or exponents. They always begin with a digit. You can specify integer constants in decimal, octal, or hexadecimal form. They can specify signed or unsigned types and long or short types.In C++ you can use the following code to ... Read More

How do we initialize a variable in C++?

karthikeya Boyini

karthikeya Boyini

Updated on 11-Feb-2020 07:54:11

129 Views

You can initialize a variable using the assignment operator or use its constructor when initializing it. For example, int i = 0; MyClass instance(1, "Hello");It will be automatically initialized ifIt's a class/struct instance in which the default constructor initializes all primitive types; like MyClass instance; You use array initializer syntax, e.g. ... Read More

How to build a java web application using SAP platform and HANA database?

karthikeya Boyini

karthikeya Boyini

Updated on 11-Feb-2020 06:33:18

301 Views

You would require to change the connection.properties file of your local Tomcat Server (Server > Java Web Tomcat 8 Server-config/config_master/connection_data), to point to the HANA database.Here are the usual parameters that need to be configured for HANA databasejavax.persistence.jdbc.driver=com.sap.db.jdbc.Driver javax.persistence.jdbc.url=jdbc:sap://:/?reconnect=true&autocommit=false javax.persistence.jdbc.user=db-user javax.persistence.jdbc.password=db-pass eclipselink.target-database=HANARead More

How number values be used as arguments in MySQL STRCMP() function?

karthikeya Boyini

karthikeya Boyini

Updated on 10-Feb-2020 06:30:48

95 Views

For the purpose of comparison, we can use number values as an argument in STRCMP() function. They are given as arguments without quotes. Following example will demonstrate it.Examplemysql> Select STRCMP(10, 10)As 'Equal Numbers', STRCMP(11, 10)AS '2nd Smaller', STRCMP(10, 11)AS '1st Smaller', STRCMP(10, NULL)As '2nd NULL', STRCMP(NULL, 10)AS '1st NULL', STRCMP(NULL, ... Read More

What MySQL returns, if the length of the original string is greater than the length specified as an argument in LPAD() or RPAD() functions?

karthikeya Boyini

karthikeya Boyini

Updated on 07-Feb-2020 10:10:28

80 Views

In this case, MySQL will not pad anything and truncate the characters from the original string up to the value of length provided as the argument in LPAD() or RPAD() functions.Examplemysql> Select LPAD('ABCD', 3, '*'); +--------------------+ | LPAD('ABCD', 3, '*') | +--------------------+ | ABC             ... Read More

Advertisements