List/Grid

Archive: Page 7

Call UNIX from SQR

Calling UNIX scripts from SQR

It often requires us to invoke OS commands from within an SQR. Today we will see how to use the call system command from within the SQR to invoke a UNIX script.

Arrays in SQRs

Arrays in SQR

An Array, like a database record, is organized as rows and columns. But unlike a database record, Arrays exists only in memory and NOT in the disk. This post discusses the arrays in SQR in detail

SPARC T3 Servers: Record PeopleSoft Performance

This solution showcases an ideal environment for hosting complex multi-tier PeopleSoft Financial Applications for enterprise-scale customers.

PeopleBooks 9.1

PeopleBooks 9.1

Here’s a list of PeopleBooks 9.1 that are available online. We have also included the PeopleTools 8.50 PeopleBook so that all’s in one place.

PeopleSoft Cloud Solution from HP

Enterproses are increasingly moving towards the cloud model and HP is all set to enter the market with its ‘HP Private Cloud Solutions for Oracle Applications’.

Wipro wins Oracle Titan Award

Wipro Wins Oracle North America Titan Award

Wipro Technologies has announced that it has won an Oracle North America Titan Award for the Human Capital Management Solution category. The award was handed over at the North American Partner award ceremony held at Oracle Open World on 19th September 2010.

Oracle Fusion Launch by Q1 2011

The long wait for Fusion Apps is over … well almost; Oracle has confirmed that the Fusion apps would be available by Q1 of 2011. Fusions apps which took over 5 years in the making has as many as 100 modules that are highly configurable spread over seven product families.

Comments in SQRs

Comments in SQR

It’s always a good practice to comment your code. By doing this, your code become more understandable and thus maintainable. This holds good for all programming languages and SQR is no exception.

CherryRoad Technologies Plans Acquisition

CherryRoad Technologies Inc., a leading integrator of enterprise software and an Oracle PartnerNetwork Platinum Partner, announced today that it has signed a definitive purchase agreement to acquire the U.S.-based Oracle PeopleSoft ERP business of MAXIMUS, Inc. (NYSE:MMS), a leading provider of government services worldwide.

SQR Load-lookup

Load-Lookup 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.