SQLPlus dump to flat file
Example of sqlplus script to dump tables to flat file
Author: admin
Restart IIS
http://www-01.ibm.com/support/docview.wss?uid=swg21452589
LEAD & LAG analytic function
Example of LEAD and LAG analytic functions used to determine previous and next records
Oracle: Select PARTITION name
Example of how to select data along with name of the partition that the data is stored in
Oracle: add many columns
–Add new columns to <TABLE> if not already present SET ECHO OFF SET SERVEROUTPUT ON SIZE 1000000 SET FEEDBACK ON DECLARE P_TABLE_NAME VARCHAR(30 CHAR):='<TABLE>’; BEGIN FOR ICP IN ( SELECT FLIST.ORDR, FLIST.COLUMN_NAME, FLIST.DATA_TYPE, USER_TAB_COLS.COLUMN_NAME AS XCOL_NAME FROM ( SELECT 1 AS …
UNIX validate date
Validates a date in YYYYMMDD format # EOM_DATE debug echo “$(now): Validating EOM_DATE: $EOM_DATE” CHK_YEAR=${EOM_DATE:0:4} CHK_MON=${EOM_DATE:4:2} CHK_DAY=${EOM_DATE:6:2} debug echo “$(now): CHK_YEAR: $CHK_YEAR” debug echo “$(now): CHK_MON: $CHK_MON” debug echo “$(now): CHK_DAY: $CHK_DAY” cal $CHK_MON $CHK_YEAR 2> /dev/null | grep -q …
DataStage: Handle quotes in a parameter
http://www.dsxchange.com/viewtopic.php?p=280909&sid=7f01f681cfdf54b57c1dc7c1b9b8670b My job was being called from a sequence. In the parameter value expression I used the following: “\’”:Ereplace (pParam, “,”, “\’,\’”):”\’” It looks a bit confusing because of the mixture of double and single quotes, but essentially it is …