Re: SQL question

["Bart Verweijen" <bart.verweijen@xxxxxxxxxxx>]

Hi,

Your second solution is the one I'd go for. But I don't know what function I
can use to get those ean-codes with length = 13.

Any ideas ?

Thanks,
Bart
----- Original Message -----
From: "Benjamin Budai" <BENJI@ludens.elte.hu>
To: <MIDRANGE-L@midrange.com>
Sent: Monday, January 15, 2001 4:54 PM
Subject: Re: SQL question


>
>
> On Mon, 15 Jan 2001, Bart Verweijen wrote:
>
> > Hi all,
> >
> > I have a file with following kind of records:
> > Cmp = num field
> > Item= char field
> > eancode=char field
> > type=num field
> >
> > I need a SQL that copies all this data to a new type where the eancode
> > length = 13.
> >
> Hi Bart,
>
> The simplest way is using ALTER TABLE, but this doesn't copy your data,
> it simply changes the column definition:
>
> ALTER TABLE lib/file ALTER COLUMN eancode SET DATA TYPE CHAR(13)
>
> If you don't want to do this in place then CRTDUPOBJ the file first, and
> alter the copy. Another way to do this is to CREATE TABLE the file with
> the new layout, then do an INSERT with subselect like this:
>
> INSERT INTO newfile SELECT * FROM oldfile
>
> Hope this helps.
>
> Benjamin Budai
>
> > Is this possible ?
> >
> > Thanx for yer time !
> > Bart
> >
> > +---
> > | 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
> > +---
> >
> +---
> | 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
> +---
>

+---
| 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
+---