Creating Views through Queryman

[ma2329]

I am using Queryman V 5.2 for Teradata querying. For some reason when I create a view, it concatenates all of the information together when you run a show view. But if you run it through a BTEQ on the mainframe, it looks just like you format you entered.(Note: This is only for creating views not tables) Is this some sort of setting for Queryman or just a flaw?

REPLACE VIEW MYDATABASE.VTEST
AS
SELECT X
FROM MYDATABASE.TABLE;

Thank you so much for the help! This forum rocks!

 

[RogerCruse]

I'm still using QueryMan v 5.1 and I've not come across this problem.

Try using this earlier version to see if the same problem occurs.

Roger...

 

[Sridharan]

ma2329,

I use QuerymanV5.2.0 and it jus shows perfectly the way u entered the create view statement.... I didn't come across your problem.... If u create a view like this....

REPLACE VIEW MYDATABASE.VTEST
AS
SELECT
X
FROM
MYDATABASE.TABLE;

when u run a show view it shows exactly the way u entered it one statement per line....

regds,

sridharan