Friday, August 26, 2011


Below PeopleCode reference is used to send the HTML mail format.

&ContentType = "Content-type: text/html; charset=UTF-8";
SendMail(0, &strEmailTo, &strEmailCC, &strEmailBCC, &Subject, &Message, &strFileNames, &strFileTitles, &tempEmailReplyTo, ";", &ContentType);

Below SQL code reference is used to specify the thousands seperator automatically at database level.
SELECT TO_CHAR(2354867423595,'99G99G99G99G99G99G999') FROM PSCLOCK

Find file in the shell directory hierarchy


below reference shell command will find the file named ROLM.DAT in the directory tree specified.
find ./ -name 'ROLM.DAT' -exec ls -ltr '{}' \;

PepleSoft SQR Two- Tier Running Parameter reference


SQR Two- Tier Running Parameter reference

-iE:\psoft\SQR\ -xmb -xcb -ZIFE:\psoft\SQR\pssqr.ini -S -DEBUGX -PRINTER:PD
-EH_PDF -fE:\temp\genpdf1.pdf -oE:\psoft\setdbnam.log


-iC:\PSHOME\pcfls\ps89_pt84707\sqr\ -ZIFC:\PSHOME\pcfls\ps89_pt84707\sqr\pssqr.ini -PRINTER:PD C:\TEMP\