Can I change column name in datawindow?

[Former Member]

Short of exporting/edit/import, can I change the column name that PB assigns to a selected column in a datawindow?  I have an application running in PB9 and PB12.  In PB9 some of the column names were truncated by PB.  I'm talking about the column names that appear in the "Column Specification" list.  I would like to truncate those names in PB12 so I can copy scripts from 12 to 9 and not have to edit them afterwards.

TIA

LAS

[Former Member · Accepted solution]

You can rename the columns to whatever you like, but not in the column specification list.  You have to do it in the dw painter, general tab of the properties for that column.

[Former Member · Accepted solution]

Thanks much.  I think I knew that once upon a time...

[Former Member]

Interesting. I would set the names on the column list in the Select, ie.

SELECT header.id_column as ID, header.description_of_the_record as Description

FROM header

Also, given that you can create/destroy columns dynamically, I'd think you can also modify the name, although I don´t know the correct syntax for that. You can do an edit syntax for your dw and play around with Modify function.

Regards.