How to Test for Numerics in AS/400
I need to test for Numeric. I have to check, If a variable contains Numeric values. I wanted to use TESTN opcode, but people are saying not to use it; as it does not work properly some times. Is there any other alternative to this? Has anybody done this before? Any help would be of...
| October 25, 2013 9:18 AM
Would you select SAP’s product or another OLAP tool?
In an effort to validate my opinion of SAP BW/Netweaver Capability – In terms of flexibility, KPI Development, and Predictive Analytics, If you had to decide, would you select SAP’s product or another OLAP tool and why? Situation: Global Manufacturing Company, multiple lines of business, 2 instances of SAP US & Europe, Growing data requirements,...
| June 27, 2013 4:19 PM
, SAP BI
, SAP BW
Parameter Manipulation – Turning ‘abc’ type string into a number
I have the following code being used in a parameter: SELECT OU1.OU_CODE AS PROCESS_LEVEL , RTRIM(OU1.OU_CODE) || ‘ – ‘ || AD1.DEPARTMENT_NAME AS Description FROM ODS_OWNER.POSITION_ASSIGNMENTS PE1 JOIN ODS_OWNER.ADMIN_DEPARTMENTS AD1 ON PE1.DEPARTMENT_ID = AD1.DEPARTMENT_ID JOIN ODS_OWNER.ORGANIZATIONAL_UNITS OU1 ON AD1.OU_CODE = OU1.OU_CODE WHERE PE1.POSITION_LEVEL = 1 AND COALESCE(PE1.END_DATE, CAST(’01/JAN/1753′ AS DATE)) = CAST(’01/JAN/1753′ AS DATE) –PE1.END_DATE...
| November 16, 2012 4:17 PM
Microsoft Visual Studio
Do until loop help!
I’m trying to figure out how to produce an error message if the person doesn’t enter an actual string when prompted to enter a product code. If they enter the empty string or push okay/cancel without entering the right product code a msgbox is supposed to pop up. I can’t figure it out! This is...
| October 29, 2012 10:40 PM
DO LOOP statement
, Input box Question
cloud computing middleware
hi dear as we know that data should be in encrypted form to preserve data privacy, in cloud computing we have a middleware that is installed on client machine to encrypt/decrypt data. in this case encrypted data is used in computation instead of unencrypted data. is it possible to implement such middleware at web-side rather...
| October 4, 2012 7:15 AM
OpenNTF Extension Library problems
I’ve installed the extension library to the letter but still am having no luck getting them to work on my server through a web browser. the Notes client works fine. I continue to get this error: “Cannot find the library com.ibm.xsp.extlib.library, required by the application /Demo/XPagesExt.nsf.” When I look at the server console I see...
| May 25, 2012 4:58 PM
Open source software
Restoring a MySQL database
Perhaps somebody can point me in the right direction. I have a MySQL database that I inadvertently deleted all records from. There is a regular backup I have which I can access, but I have no idea where the MySQL database tables reside in the system. I have the root password and complete access to...
| April 24, 2012 7:33 PM
, MySQL Restore