Search Results

Hi Neutronscott,

Please find below code:



clear
DB_FIND()
{
IFS=$'\n'
set -f
echo "=================$BTEQ_NAME=================="
while read i; do
DB_Name=$i
...

Hi All,

I need to write Unix shell script. To star with : I need to do some file checking on unix file system, then based on file existance, I need to run diff SQL in Teradata Bteq. After that,...

Hi All,

As we are using SQLPLUS command to connect Oracle Database in unix:
Like below syntax:



sqlplus username/password@dbname << EOI
SET HEADING OFF
SPOOL MAX_DATE_VAL.txt
...

Hi All

I am trying to remove the line having specific pattern from a file by using sed command

I have the file named ODS_REP_SRCE_File.txt with content as:

...

Thanks Cragun,

By using /usr/xpg4/bin/awk.. my code is working fine :)

Hi Rossi,

Use below code:



awk '{A[(NR-1)%6]=A[(NR-1)%6]$0" ";next}END{for(i in A)print A[i]}' fileName

Thanks Aia for your response..
But now getting error as



awk: syntax error near line 1
awk: bailing out near line 1

Hi vbe

I am getting error when using variable under awk command


awk '{for(i=1;i<=NF;i++)if($i~/$DB_Name/)print $(i)}' $BTEQ_NAME > ${DB_Name}_TableList.txt



But able to get...

Hi All,

I am trying to find a word from a file in loop.



while read i; do
DB_Name=$i
awk '{for(i=1;i<=NF;i++)if($i~/$DB_Name/)print $(i)}' $BTEQ_NAME > $DB_Name_TableList.txt...

Hi All,

I am stuck in one step..

I have one file named file.txt having content:


And SGMT.perd_id = (SELECT cal.fiscal_perd_id FROM $ODS_TARGT.TIM_DT_CAL_D CAL
FROM...