Re: How do I convert a VARCHAR field to a CHAR field in a VIEW?

Nope, some folk have difficulty going to ILE.


On Thu, Aug 29, 2019 at 2:48 PM a4g atl <a4ginatl2@xxxxxxxxx> wrote:

By the way, I am about to try this but I think I cannot create a order by
on a view. Is it possible?

Thanks



On Thu, Aug 29, 2019 at 2:45 PM a4g atl <a4ginatl2@xxxxxxxxx> wrote:

Don't ask....

On Thu, Aug 29, 2019 at 1:40 PM Jon Paris <jon.paris@xxxxxxxxxxxxxx>
wrote:

I'm confused.

If you want to go from 10 character names down to 6 characters then:

a) Why are you selecting the long name?

b) What has char(70) got to do with anything ?

On Aug 29, 2019, at 2:35 PM, a4g atl <a4ginatl2@xxxxxxxxx> wrote:

I have to convert 10 character field names in a table to a 6 char field
name.

I have tried
Select long_field as char(70) from FROM_FILE.

I am getting an error that does not tell me what is does not like. I

cannot

find a solution on Google.

How do I format the command in a view?

TIA

Darryl Freinkel
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related

questions.

Help support midrange.com by shopping at amazon.com with our

affiliate link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com