unix_shell_script_standards_for_powercenter_713

《unix_shell_script_standards_for_powercenter_713》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、StandardsforETLUNIXShellScriptsforusewithPowerCenter7.1.3ScriptingStandards(forPowerCenterversion7.1.3):ScriptingstandardsincludetheuseofaUNIXshellscript,whichtheschedulingtoolusestostartthePowerCenterjob,andaseparatefilewhichcontainstheusernameandpa

2、sswordfortheusercalledinthescript.Thefollowingisatemplatethatshouldbeusedtocreatescriptsfornewscheduledjobs.Followingisthescriptandexplanation.Thisscripthasbeenprovidedasanexampleandisnamedetl_unix_shell_script.sh.#Program:etl_unix_shell_script.sh#Au

3、thor:KevinGillenwater#Date:7/24/2003#Purpose:SampleUNIXshellscripttoloadenvironmentvariables#neededtorunPowerMartjobs,passusernameandpasswordvariables#andstartthejobusingthepmcmdcommandline.##$1=ProjectIdParameter(ie.ud,hr,dss,siq,etc.)##Exampleusage

4、:etl_unix_shell_script.shdss##NOTE:EntertheProjectIDparameterthatisdesignatedinthe#directorystructureforyourteam#(ie.dsswouldbeusedfortheDWDASteamasthe#directoryis/usr/local/autopca/dss/)#--------------------------------------------------------------

5、---#CallthescripttosetuptheInformaticaEnvironmentVariables:#-----------------------------------------------------------------./usr/local/bin/set_pm_var.sh#-----------------------------------------------------------------#ReadETLconfigurationparameter

6、sfromaseparatefile:#-----------------------------------------------------------------ETL_CONFIG_FILE=$JOBBASE/$1/remote_accts/test_etl.configETL_USER=`grepETL_USER$ETL_CONFIG_FILE

7、awk-F:'{print$2}'`ETL_PWD=`grepETL_PWD$ETL_CONFIG_FILE

8、awk-F:'{print$2

9、}'`#-----------------------------------------------------------------#Startthejob#-----------------------------------------------------------------$PM_HOME/pmcmdstartworkflow-u$ETL_USER-p$ETL_PWD-s$MACHINE:4001-fDWDAS_LOAD_dssqa–waits_m_CENTER_INSTIT

10、UTE#-----------------------------------------------------------------#Trapthereturncode#-----------------------------------------------------------------rc=$?if[[$rc-ne0]]then     exit$rcfiNotesRegardingtheScript/Standards:1.Thebeginningofeachscripts