Shell Programming and Scripting

Hello Disedorgue,
In the similar case above, I need to write the output differently if I find a combination of columns. If the input table has a combination of columns(foo & boo), then the output has to be written differently if not just as above.

Here is the sample input and desired output.

Code:

CREATE  TABLE TBL_NM
(

        COL1               DECIMAL(18,0) NOT NULL,
        COL2               CHAR(2) NOT NULL ,
        foo                  CHAR(5) NOT NULL ,
        boo                 SMALLINT NOT NULL,
        COL3               SMALLINT
);

Desired Output:

Code:

REPLACE VIEW DB_NM.TBL_NM_special 
AS
COL1,
COL2,
dump.date as foo,
COL3
FROM DBASE.TBL_NM ss
JOIN DBASE.TBL2 dump
ON ss.foo = dump.foo;

As you see in the output, "boo" should not be displayed in this case. If these columns combination doesn't exist, then it should be like below

Code:

REPLACE VIEW DB_NM.TBL_NM 
AS
COL1,
COL2,
COL3
FROM DBASE.TBL_NM;

Could you please explain how I could do this.

Thanks,
V