Renaming columns in SQL92

[rpenridge]

Hi All,

Am simply trying to rename a column in an sql query in Progress 9.2 (from the tracks):-

The following query:-

select pt_part as part from pt_mstr.

...gives me:-

** Invalid datatype -- sample types are: char, integer, date, logical (222)

And this query:-

select pt_part, 1 as part from pt_mstr.

...gives me:-

** AS or LIKE phrase not allowed with expressions. (591)

What's going on?

Thanks,
Rob

 

[knarf]

Think Progress don't think SQL

This works for me:

select pt_part Label "My Part" from pt_mstr

 

[rpenridge]

Thanks but unfortunately that only labels the column - it doesn't actually change the field name.

 

[StefGay]

Hi,

KB#P6718. You can't use SQL92 syntax under the procedure editor, use the sql explorer tool or another 3rd party product.

Stéphane.