Shell Programming and Scripting

I have around 200 tables need to check the following column sequence instead of checking manually every table ,if sequence is different ,
it should return the table name so that I can check that table and re-arrange the sequence.Any help it should be greatful.


NEW_Cd
Factor_Desc
Tab_name


Tab1.txt

CREATE SET TABLE xx1 ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
SECT_Cd CHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
NEW_Cd CHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
Factor_Desc VARCHAR(250) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
Tab_name VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
Code1 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,
Start_Dt DATE FORMAT 'YYYY-MM-DD' NOT NULL
)
PRIMARY INDEX ( Calculation_Factor_Cd )
;


CREATE SET TABLE xx2 ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
NEW_Cd CHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
Tab_name VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
Factor_Desc VARCHAR(250) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
Code1 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,
Start_Dt DATE FORMAT 'YYYY-MM-DD' NOT NULL
)
PRIMARY INDEX ( Calculation_Factor_Cd )
;




Thanks,
MR

I am getting the below error when executing the below one

awk ' /^CREATE SET TABLE/ { tablename = $4 } (/^DBS_ECC_Code_Table_Name/ && last != "DBS_New_Cd") || (/^Tab_name/ && last !"DBS_ECC_Code_Table_Name" ) { printf "Error: %s\n", tablename } { last = $1 } ' a.txt | uniq


syntax error The source line is 1.
The error context is
/^CREATE SET TABLE/ { tablename = $4 } (/^DBS_ECC_Code_Table_Name/ && last != "DBS_New_Cd") || (/^Tab_name/ && last >>> ! <<< "DBS_ECC_Code_Table_Name" ) { printf "Error: %s\n", tablename } { last = $1 }
awk: Quitting
The source line is 1.

Thanks,
MR

Hi

Please ignore my previous post .When executing the below one ,Its not giving any result even if sequence is not in order


awk '/^CREATE SET TABLE/ { tablename = $4 }(/^Factor_Desc/ && last != "NEW_Cd") ||(/^Tab_name/ && last != "Factor_Desc" ) { printf "Error: %s\n", tablename }{ last = $1 }
' a.txt | uniq

Thanks,
MR

First, when posting code, please enclose it in CODE tags.

Second, do not put your code all on one line. It makes it hard to read.

Third, the above script works for me when used with the data you supplied.

Hi cfajohnson

Sorry it is my mistake ,its working fine.Thanks for your great help .


I have one more query ,I want replace null value of end_dt field to default value "1999-01-01' in all my insert scripts(It has around 200 scripts).Any help it should be greatful.


insert into PRD_TYPE
(
Period_Cd,
Period_Desc,
Ind1,
IND2,
Start_Dt,
End_Dt
)
select
Period_Cd,
Period_Desc,
NULL,
NULL,
date '1900-01-01' as START_DT,
NULL
from PRD_TYPE_2;


I am expecting the below o/p


insert into PRD_TYPE
(
Period_Cd,
Period_Desc,
Ind1,
IND2,
Start_Dt,
End_Dt
)
select
Period_Cd,
Period_Desc,
NULL,
NULL,
date '1900-01-01' as start_dt,
date '1999-01-01' as end_dt
from PRD_TYPE_2;

Thanks
MR

I think its line number 16

try this

linenumber=16
sed -i "${linenumber}s/\<NULL\>/date '1999-01-01' as end_dt /g" file-name

Thanks,
Bash