Archive for November, 2007

ctrl+J command to show database name

November 29, 2007 1 comment

By default the ctrl+J command in any peoplesoft online page gives you the following details

Browser IE/6.0
Operating System WINNT
Browser Compression ON (gzip)
Tools Release 8.45.18
Application Release Financials/SCM
Service Pack 1
Component VNDR_ID

If you want to add the following more details to the above screen,

Database Name FIN88T
Database Type MICROSFT
Application Server //

Open the file on your webserver and set “connectionInformation=true” as shown below.

# If set to true, the database name and other potentially sensitive connection information
# will appear in the HTML generated for use in a help display.
# Default: false

Save the file and reboot your webserver. Now the ctrl+J command will show the userid, database name, database type and application server name.

From People Tools 8.48 onwards, we can do this online.

Go to  PeopleTools > Web profile > Web Profile > Web Profile Configuration

Choose apporpriate Profile Name like PROD for production. On Web Profile Configuration, click on Debugging tab, and then check radio button for ‘Show Connection & Sys Info’. Save the Page.

Categories: PS Admin Tags:

Windows OS commands

November 29, 2007 Leave a comment

Few common windows operating system related commands

To know windows IP configuration go to command propmt and type ipconfig /all  – this shows detailed information about the IP configuration of the the server you have logged in.

To know the connection status to another IP address, use ping  ipaddress  command

To trace all the IP address that is between your current server to the destination IP address use tracert  ipaddress command

To know the hostname use hostname command, it will show the host name.

To know all the prots on the server use the following command

C:\> netstat -an
The Netstat command can list currently used ports, which might be helpful if you suspect an application is clashing with another one on an active port. The -an switch is used to show all connections and listening ports in numeric form.

Categories: PS Admin Tags: ,

Carriage Return in PeopleCode

November 29, 2007 2 comments

Sometime back, I was writing an application engine using PeopleCode and I needed to insert a carriage return between two long strings getting concatenated so they look like two sentences one after the other. The below code explains how I achieved it.

&string1 = ‘Emplid xyz123 is terminated on 01/01/2008’
&string1 = ‘Emplid abc456 is terminated on 01/02/2008’

&mailString = &String1 | &String2;

/* This concatenation would lead &mailString look as shown below
Emplid xyz123 is terminated on 01/01/2008Emplid abc456 is terminated on 01/02/2008

/* To put a CR/LF (both unix and DOS style linefeed, safe for all platforms), you would change the above line to read like this: */

&mailString = &String1 | char(10) | char (13) |&String2;

/* Now the &mailString will look like as shown below

Emplid xyz123 is terminated on 01/01/2008
Emplid abc456 is terminated on 01/02/2008

Categories: PeopleCode Tags: ,