Hi Folks I am automating the refresh of some view based, whose base tables have changed. The shell I run generates a DDL scripts show view $dbname$viewname ; the out put of this script has "create view" being changed to replace view
Replace view ( blah ...) -- Comments ...........once upon a time etc............... contd..............
the Problem is that when I feed this to bteq again it insert a new line when it is not needed.
e.g. Ideal :
Replace view ( blah ) --- Comment ...Once upon a time etc.......
(case when columnA= ) , Column2, Column3 et
The way bteq reads this : Replace view ( blah )
--- Comment ... Once upon a time etc....... ( split the line and then says error there is no column like Once upon a time )
(case when columnA=<expre ssion> ) , Column2, Column3 et
( split the line and then says error there is no column like "ssion>" )
Bteq settings are .width is max at 256 .export data file="foo.op"
I changed the settings around a bit to no avail. Is there a way where you can ASK BTEQ TO KEEP WRITING ON THE SAME LINE REGARDLESS EXACTLY AS IN SHOW VIEW AND NOT SPLIT THE LINE