Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
DATA breas.art; INFILE '/apps/dataapps15/projects/dinhch/artfile.txt' DELIMITER=',' dsd lrecl=400 pad missover; INPUT ICN :$14. ICN_VRSN :8. DOC_ID :$15. ADJKEY :$8. TTL_CHRG :13.2 PDATE :$8. ADJ_TYPE_CD :$2. ADJ_RSN_CD :$3. UPD_USER :$8. TTL_PAID_AMNT :13.2 FUND_CODE :$13. FUND :$154.; Group by the ADJKEY , count the ICN and sum up the TTL_Paid_amnt Print it out example, the result file would be ADJKEY Count Sum
|Creating a record in a database with static data from MVC to SQL (Entity)||2||37|
|changing page verifacation||1||62|
|user database (login sql or login windows)||3||28|