Peoplesoft Peoplecode Stuff

Search This Blog

Oracle SQL Update include CASE

Posted by Dino on June 09, 2011

Get link
Facebook
X
Pinterest
Email
Other Apps

update ps_table A set A.field = CASE A.field when 'D002' then 'E002' else A.field END
where A.emplid = '26562864'
and A.class_nbr = '2421'

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

SendMail with PT_MCF_MAIL (multiple attachments)

import PT_MCF_MAIL:*; /**** Send Mail ****/ Local PT_MCF_MAIL:MCFOutboundEmail &email = create PT_MCF_MAIL:MCFOutboundEmail(); &email.From = " PSCSMPRA@up.ac.za "; SQLExec("select EMAILID from PSUSEREMAIL where OPRID=:1 and Primary_email = 'Y'", %OperatorId, &Email_To); &email.Recipients = &Email_To; &email.Subject = %DbName | ": Update Dual Class Sections to English"; Local string &plain_text = "Please see report output attached for Class Section update from Dual to English (D100 to E100)."; Local PT_MCF_MAIL:MCFBodyPart &text = create PT_MCF_MAIL:MCFBodyPart(); &text.Text = &plain_text; &File_name_path = GetCwd() | "\files\Dual_UpdatedTo_English.csv"; &file_name_email = "Dual_UpdatedTo_English.csv"; &File_name_path2 = GetCwd() | "\files\English_ClassSection_Exist.csv"; &file_name_email2 = "English_ClassSection_Exist.csv"; Local PT_MC

BI Publisher little tricks

While creating a BI Publisher Invoice report for a client I had to google like a mad women. Here are some of the things I've learned: The template consists of 2 pages because one of the requirements was a remittance advice at the end of each invoice (per student) - almost like a footer but only on the last page. This was the final .rtf template: The body of the template looked like this: Tips: 1. Formatting the date: <?format-date:A.DATE_DUE;'dd/mm/yyyy';'UTC'?> 2. Formatting the amounts: <?format-number:A.TOT_FUTURE_AMT;'999G999D99'?> 3. Calculating the sum of the current group: <?sum(current-group()//EXPR64_64)?> 4. If statements: <?if:sum(current-group()//A.DEBIT_UFS)<0.00?><?sum(current-group()//EXPR64_64)?><?end if?> OR <?if:A.TOT_FUTURE_AMT!=0.00?> 5. Upper Case: <?xdofx:upper(A.NAME_TITLE)?> Because of the last page "footer" both pa

Date Format for Insert in DATAMOVER

to_date('19000101','YYYYMMDD')

Powered by Blogger

Oracle SQL Update include CASE

Comments

Post a Comment