Re: substringed key field?

[John Hall <jhall@xxxxxxxxxxx>]

I have used the following;

CODE6A      I     SST(CODE6 1 6) to convert numeric to alpha in a
logical view

'I' means input only field and is required (or was) to substring a
numeric

John

> Chris,
> 
> Sorry to correct one little oversight:
> 
> SST can only be use don character fields, not numeric ones.
> 
> Martin,
> 
> If the field is signed, you can change the data type in the LF to alfanumeric 
>and
> use SST on that field.
> 
> I do not know,  if that works, I have never tried it.
> 
> Regards,
> 
> Carel Teijgeler
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---