Load Look up In SQR

It’s common to join tables within SQRs to retrieve data from normalized tables. As SQL statements consume significant computing resources, such joins may be a hindrance to performance of the SQR. Further, as the number of tables that are used in the join increases, the performance decreases.

This rational makes us look for ways to reduce the number of tables used in the join as a means to tune the SQR. This is when Load-Lookup in SQR comes into picture. Using Load-Lookup is a two-step process – here’s how to make use of it in your SQR programs.

Load-Lookup
you start by loading the Load-Lookup. This can either be done within the setup section or within a procedure. While done within the setup section, it is only executed once. When within procedures, the execution happens each time the code is encountered.

The code snippet shows how this is used within the setup section. On execution of the below Load-Lookup, SQR creates an array containing a set of return values against keys.

Begin-Setup
Load-Lookup
Name = Product_Names
Table = PRODUCTS
Key = PRODUCT_CODE
Return_value = DESCRIPTION
End-Setup

Lookup
Once we have the first step in place, it’s time to utilize the lookup. The below code will essentially look up for a key (PRODUCT_CODE) in the array and return the return value (DESCRIPTION).

Begin-Select
ORDER_NUM (+1,1)
PRODUCT_CODE
Lookup Product_Names &PRODUCT_CODE $DESC
print $DESC (,15)
from ORDERLINES
End-Select

Multiple Keys / Return_values
Although Load-Lookup doesn’t support multiple keys or return_values, we can do this by concatenating the values using database specific concatenation operators. So if you are on Oracle DB, this would be how you can do it. The return values can later be separated using the unstring command.

Load-Lookup
Name = Product_Names
Table = PRODUCTS1
Key = 'PRODUCT_CODE||','||KEY2'
Return_value = 'DESCRIPTION||','||COLUMN2'

Using where clause in Load-Lookup
To limit the values that are populated in the Load-Lookup array, we can use a where clause as shown below.

Load-Lookup
Name = Product_Names
Table = PRODUCTS
Key = PRODUCT_CODE
Return_value = DESCRIPTION
Where = PRODUCT_CODE > 1000

Aborting an App Engine

How do you get an AE program to abort?

In certain situation, you want to stop processing and fail the program ?

There are certain places where you can accomplish this:

1. SQL Action with On Error set to Abort.
Other values are
Continue: Continue processing. It will continue processing the next action within the step.

Skip step: Skip this step and go to the next.
Section break: Stop processing the current section and pass control back to calling section.


2. PeopleCode Action with OnReturn set to abort and exit(1) fired within the PeopleCode on encountering the error condition.
3. SQL Action which returns no rows can be flagged to Abort.


Other possible values for People code OnReturn are Skip Step, Break.
With break, subsequent steps in section are not processed and control is returned to calling section.
With skip step, the existing step and (subsequent actions) are skipped and control is passed on to the subsequent step.

Standalone Rowsets

When any page in a component is opened, the system retrieves all of the data records for the entire component and stores them in one set of record buffers called the component buffer which is organized by scroll level and then by page level. However, if we need to access data in records that are outside of the component buffer, we need to use Standalone Rowsets. This post will take you through the steps involved in creating and manipulating data using standalone rowsets.

So what are Standalone Rowsets?
It’s a rowset that is outside of the component buffer and not related to the component presently being processed. Since it lies outside the data buffer, we will have to write PeopleCode to perform data manipulations like insert / update / delete.

Creating Standalone Rowset
We use the below PeopleCode to create a standalone rowset. With this step, the rowset is just created with similar structure to that of the record SAMPLE_RECORD. However, the rowset would be empty at this point..

Local Rowset &rsSAlone;
&rsSAlone = CreateRowset(Record.SAMPLE_RECORD);

Populating a Standalone Rowset
Now that we have created a standalone rowset, we need to populate it with date that we need to work on. We can use the below methods to populate data into a standalone rowset.

Fill Method
The simplest way to populate data into a standalone rowset is to use the Fill method. What the below code essentially does is, populate the standalone rowset with all rows from the SAMPLE_RECORD where the TRAINING_ID = ’12345'.

&TRG_ID = '12345';
&rsSAlone.Fill("where TRAINING_ID = :1", &TRG_ID);

CopyTo Method
Another way to populate a standalone rowset it by using the CopyTo method. This method copies like-named fields from a source rowset to a destination rowset. To perform the copy, it uses like-named records for matching, unless specified. The below code copies the content of the above rowset &rsSAlone into &rsSAlone2.

Local Rowset &rsSAlone2;
&rsSAlone2 = CreateRowset(Record.SAMPLE_RECORD);
&rsSAlone.CopyTo(&rsSAlone2);

In case if we had NOT created both the above rowsets from the same record, we would have mentioned the complete record names in the fill method as shown below. The below code would copy the contents of similar fields in &rsSAlone into those in &rsSAlone2.

&rsSAlone.CopyTo(rsSAlone2, RECORD.SAMPLE_RECORD, RECORD.SAMPLE_RECORD_2);

Child Rowsets
We have seen a standalone rowset being created usign a single record. However, we can also create one using another rowset. This would be handy to setup parent-child relations. This is how this can be achieved.

Local Rowset &Lvl1, &Lvl2, &Lvl3;
&Lvl3 = CreateRowset(Record.SAMPLE_LVL3_REC);
&Lvl2 = CreateRowset(Record.SAMPLE_LVL2_REC, &Lvl3);
&Lvl1 = CreateRowset(Record.SAMPLE_LVL1_REC, &Lvl2);

The above can also be written as shown below.

Local Rowset &Lvl1;
&Lvl1 = CreateRowset(Record.SAMPLE_LVL1_REC,
CreateRowset(Record.SAMPLE_LVL2_REC,
CreateRowset(Record.SAMPLE_LVL3_REC)));

Parallel Processing by Application Engine(one of the technique)

This summary is not available. Please click here to view the post.

Installation of Peoplesoft BI publisher (XML publisher)

BI publisher(Formerly known as XML publisher).

 BI publisher is the latest reporting tool by peoplesoft and comes with great feature.

It primarily targets on segregation of report units in Data Logic, Layout Template, Translation as shown in below image which facilitates the maintenance of report with lot of ease.

Installation of XML publisher (BIP):

Navigate to below page and download the setup.

Click on Design Helper

Select your MS Word type.

If you are not sure about your word version, open a word document , go to file->Account.

Click on About Word.

As above you will see the version of Word installed in your machine.

Click on Download Now.

You will have zipped file after download completes.

Extract the file and install as you install any other executable file.

Before Installing BIP, close all office applications such as Word, Excel, and Outlook etc.

It takes few minutes to install.

Open the Word Document.

You will a tab has been added in word document :”BI Publisher” which will look something like below.

How to Remove mystartsearch.com Homepage (Removal Help)

Question.

I have something called mystartsearch.com that keeps coming on my screen when on Internet Explorer and even when I am in my bank Online it closes my bank page and takes its place. Could you do something with that? Please help me How to remove mystartsearch.com?  I shall send you a generous donation because then you will deserve it in my case. I sent you an attachment of this.

How to remove mystartsearch.com from Internet Explorer, Google Chrome, Mozilla Firefox.

                                                                                                                                                          

Explanation & solution

Sure, we’ll help you to remove mystartsearch.com  from your computer permanently. First, we would like to explain about mystartsearch.com so that everybody can know that process what is mystartsearch.com? And how and why it enters into the computer and what would be the its removal steps.

Mystartsearch.com is a browser hijacker. It works in your computer as a browser’s search engine and displays lots of advertisements and sponsored links while using its search engine. Mystartsearch.com set as homepage on your browsers so users forced to use the mystartsearch.com  search engine.

Now we are explaining here to let you know how it to come into the computer. It usually comes into the computer through 3rd party downloading websites or unwanted free softwares. Actually these types of Adware companies added their installer embedded with these type third party websites’s installers. So eventually, it’ll be automatically installed on your computer while downloading and installing  any software from 3rd party downloading websites.

We are giving you an example: Suppose, you want to download a flash player into your computer to play the games online. You go to online search engine like “yahoo search” and search there “download flash player” and click on search button then you get results and choose one result and click on them and download flash player and installed it. But you know where you did mistake? You did a mistake while clicking on found results. You clicked on the wrong website (3rd party downloading website). Actually, these types of websites’s installers are embedded with Adwares.

Once mystartsearch.com got installed into your computer, you’ll also get lots of other changes to your computer like: default search engine, default browser, default homepage, default URL search and DNS settings are redirected tohttp://mystartsearch.com.

It’s technically installs on your all the browsers as an extension and take over all the settings rights. After it installed on your computer you can’t be change most of settings of the browser because mystartsearch.com has changed all the setting of a browser.

Mystartsearch.com leaves lots of traces of files, folders and registry traces which had been created while installing it on your computer. Even, its own uninstall utility won’t be uninstalled. Intentionally it won’t uninstall adware exactly so that can come again through these remain traces.

Removal Instructions

Automatic Fixit

Download Adware Remover Tool v3.9 to remove Mystartsearch.com Automatically, It’s aFreeware utility specially designed for Adware Removal. This tool can remove most of the Adwares from Internet Explorer, Google Chrome and Mozilla Firefox. It can remove all the traces of Mystartsearch.com from registry as well.

Adware-Removal-Tool-v3.9.exe

                                                                                                                                                  

Manual Steps

Step 1: To Uninstall Mystartsearch.com from computer

• Click on Start button and then click on Control Panel.
• Now click on Programs –> Uninstall a program or Program and Features(Windows-7, 8, Vista). You also may click on “Uninstall a program”
  

Uninstall a program for Vista, 7, 8

• For Windows XP users click on Add/Remove Programs.

Uninstall a program for Windows xp

• You’ll get a window which has listed all the installed programs.
• Uninstall “Mystartsearch.com” from there.
  

  (Note: If you face any type of problem while uninstalling Mystartsearch.com” then you can use Revo uninstaller tool, it can it remove forcefully. Click here to download Revo Uninstaller Tool).

• Also do uninstall all the unwanted & unknown programs which are listed in “Suspicious Programs list”(See below for the list). You should uninstall them immediately if you found any into your computer.
  

  (Note: If you face any type of problem while uninstalling anything from control panel then you can use Revo uninstaller tool, it can remove any software forcefully. Click here to download Revo Uninstaller Tool).

• 
• Uninstall all unwanted programs

Suspicious Programs list

• Browser defender
• HD-Plus 1.8
• Vplay
• Browser protect
• Browser protected by conduit
• Delta search, Babylon
• LessTabs
• WebCake 3.0
• Yealt
• LyricsContainer
• VideoSaver
• AddLyrics
• privacy safe guard
• unfriend checker
• Price peep today
• Coupon amazine
• TidyNetwork.com
• DownloadTerms 1.0
• Yontoo
• Also uninstall all the unwanted & unknown programs which are not listed here.

__________________________________________________________________________________________

Step 2 : To Remove Mystartsearch.com from Internet Explorer.

Step 2.1: Remove Mystartsearch.com from homepage

• Open Internet Explorer then go to Tools menu (Press “F10” key once to active the menu bar) and then click on Internet Option a configuration page will be opened, then click on General tab. Now look into under HOME PAGE Edit Box you gotwww.Mystartsearch.com, replace it to www.google.com, then click on apply andclose.

Step 2.2: Remove Mystartsearch.com add-ons from Internet Explorer.

• Open Internet Explorer then go to Tools menu (press “F10″ key once to active menu bar) and then click on Internet Option a configuration page will be opened
• Click on Programs tab then click on Manage Add-ons, now you’ll get a window which have listed all the installed add-ons.
• Now disable the Mystartsearch.com add-on, also disable all the unknown / unwanted add-ons from this list. (As per below screenshot).

Step 2.3: Reset Internet Explorer

• Open Internet Explorer. Click on Tools menu (Press “F10” key once to active the menu bar), click on Internet Option. A internet option window will open.
• For IE9, IE10 users may click on Gear icon . Then click on tools.

• Click on Advanced tab then click on RESET button.
• Now you will get a new popup for confirmation, tick mark on Delete personal setting then click on RESET button on that. (As shown on below screenshot)
• Now your Internet Explorer has been Restored to default settings.

• Now you will appear a popup stated “complete all the tasks”. After completion click on close button.

__________________________________________________________________________________________

Step 3 : To Remove Mystartsearch.com from Mozilla Firefox

Step 3.1 : Remove Mystartsearch.com from Mozilla Hompeage

• Open Mozilla Firefox, Click on Tools menu (If tools menu doesn’t appear then press “F10″ key once to active the menu bar) then go to Options, after that a configuration page will be opened, then click on General tab and then look on the very first section named as Startup. Under start-up you will see a HOME PAGE Edit Box, under this edit box you will see www.Mystartsearch.com, please replace it towww.google.com, then click on apply and close.
• Restart Firefox Browser

Step 3.2 : Remove Mystartsearch.com from add-ons

• Open Firefox and then go the Tools menu (Press “F10” key once to active Menu bar) click on Add-ons, you’ll get a page click on extensions from the left side pane. now look on right side pane you’ll get all the installed add-ons listed on there. Disable or Remove Mystartsearch.com add-on, also disable all the unknown / unwanted add-ons from there. (As per below screen shot)

Step 3.3: Reset Mozilla Firefox

• Open Firefox and then go the Help menu (Press “F10” key once to active Menu bar)
• Go to Help menu then click on “Troubleshooting information”
  Note: you can also open this page in this ways, open Firefox then type this command in the address bar “about:support” (without quote) and then hit enter or OK.
• You will get a page “Troubleshooting information” page, here you will get “Reset Firefox” option in the right side of the page.
• Click on Reset Firefox option and then follow their instructions to reset firefox.
• Mozilla Firefox should be Restored.

                                                                                                                                                  

Step 4 : To Remove Mystartsearch.com from Google Chrome

Step 4.1: Remove unwanted homepage & search engine from Google Chrome

• Start Google Chrome, click on options icon (Located in very top right side of the browser), click on Settings. You will get a configuration page.
• Under configuration page find a option named as “Open a specific page or set of pages” click on its Set Pages. Another window will come up. Here you will appear the bunch of URL’s under “Set pages”. Delete all them and then enter only one which you want to use as your home page.

Google Chrome Homepage Reset step1

Google Chrome Homepage reset step 2

• In the same configuration page click on Manage search engines button. Delete allthe search engines from there, just keep only www.goole.com as your default search Engine.

Google Chrome search engine step 3

Google Chrome search engine step 4

Google Chrome search engine Step5

Step 4.2 : Remove unwanted extensions from Google Chrome

• Start Google Chrome, click on options icon (Located in very top right side of the browser), then click on Tools then, click on Extensions. (As shown on below screenshot)

• You will get a configuration page which have listed all the installed extensions, remove Mystartsearch.com extension. Also remove all the unknown / unwanted extensions from there. To remove them, click on remove (recycle bin) icon (as shown on screenshot)

Step 4.3 : Reset Google Chrome – Restore to default setting.

• Open Google Chrome, click on menu icon  and then click on settings (Note:menu icon is located right side top corner it is look like this:  ). (See the below screenshot for better understand)
• Scroll down and click on “Show advanced settings…”option, after click on that you’ll appear some more options in bottom of the page. Now scroll down more and click on “Reset Browser setting” option. (See the below screenshot for better understand)
• Now, Close all Google Chrome browser’s window and reopen it again.

________________________________________________________________________                 _

Step 5 : Remove Mystartsearch.com infection from Windows shortcuts.

Follow the following steps for all browser’s shortcuts like: Internet Explorer, Firefox, Internet Explorer and Safari as well.

• Right click on the shortcut of Internet Explorer and then do left click on theproperties option. You’ll get a shortcut’s properties.
• Click on shortcut tab and then delete the “www.Mystartsearch.com/?utm” string from target field.
• Need to delete this URL:

Repeat the above steps on all browser’s shortcuts like: Internet Explorer, Firefox, Internet Explorer, Safari in all location Desktop / Taskbar / Startmenu.

• Remove Mystartsearch.com infection from startmenu’s shortcuts.

• Remove Mystartsearch.com infection from taskbar’s shortcuts.

___________________________________________________________________________________________

Step 6 : To Remove Mystartsearch.com from Registry

• Press “window key + R” (Flag sign key + R) you will get Run box then type “REGEDIT” into the run box then click on OK. You’ll get a registry editor window.
• In the registry editor, click on Edit menu and then click on find option, you’ll get edit box to search any string into registry editor
• Type “Mystartsearch.com” into the find box and then click on Find Next.
• The search result will highlight the key or value which have contains theMystartsearch.com string.
• Now delete the Registry Key/Value/Value-Data if any one contains “Mystartsearch.com” string (must see the example screenshot below)
  Note:- Do not delete the complete value data, just delete the Mystartsearch.com path only (for example see screenshot3 below)
• Use F3 key to find Next. and do the last step to all results.
• We are giving you the example on “Conduit” Adware.

Screenshot 1

Screenshot 2

Screenshot 3

__________________________________________________________________________________________

Step 7 : To Remove Mystartsearch.com from Autorun Tasks

• Click on Start button and then do Right-Click on the computer and then do left-click on Manage. A manage window will appear.
• In the manage window click on Tasks Scheduler from right side pane, then click on “Task Scheduler Library“, Now look on left side pane and Remove all the Tasks which have contains Mystartsearch.com string and also remove all the unknown / unwanted tasks from there (As per the screenshot below).

__________________________________________________________________________________________

Step 8 : To Remove Mystartsearch.com from Startup

• Press “window key + R” (Flag sign key + R) you will get Run box then type “MSCONFIG into the run box then click on OK. You’ll get a msconfig window.
• In the msconfig window click on Startup tab, here you’ll get all the startup entries, so look on the list and then do Un-check the entries which is containsMystartsearch.com. Also Un-check all the others entries which you found unwanted. then click on OK to apply all the changes.

__________________________________________________________________________________________

Step 9 : To Remove Mystartsearch.com from Services

• Press “window key + R” (Flag sign key + R) you will get Run box then type “MSCONFIG” into the run box then click on OK. . You’ll get a msconfig window.
• In the msconfig window click on Services tab, here you’ll get all the start-up services list, click on “Hide Windows Services” all the windows related services will be hidden. now it’s only display the 3rd party installed services, now look on the list and then do Un-check the service which have contains Mystartsearch.com. Also Un-check all the unknown / unwanted services. then click on OK to apply all the changes.

__________________________________________________________________________________________

Step 10 : To remove Mystartsearch.com registry entries withAdwcleaner.exe

10.1 : Download AdwCleaner from the below link.

Click Here to Download: Adwcleaner.exe

10.2 : Run that downloaded file (Adwcleaner.exe).

10.3 : When you get it started, click on scan button to search the Mystartsearch.com files and registry entries (As shown below screenshot).

10.5 : When scanning process will be finished, click on Clean button to delete all the Mystartsearch.com files and registry entries (as shown on below screenshot)

                                                                                                                                                                   

Step 11 : To remove Mystartsearch.com with Hitman-Pro

Click here to Download Hitmanpro_x32bit.exe

Click here to Download Hitmanpro_x64bit.exe

                                                                                                                                                                   

Step 12 : To remove Mystartsearch.com with Malwarebytes.

12.1 : Download Malwarebytes Anti-Malware Free, then double click on it to install it.

Click Here to Download Malwarebytes.exe

12.2 : Update online Virus Definition

12.3 : Tick mark on “Perform quick scan” then click on Scan

12.4 : When the scan done click on “Show results”

12.5 : After clicking on Show result it will you a another window where you will get thefound threats. Click on “Remove Selected”