Re: SQL insert

AAAAAARRRRRRGGGGGGHHHHHH
Give myself 24 dope slaps
Never mind
When I was trying to insert FILEB into FILEA, I really SHOULD have been
inserting FILEB into FILEC
Sorry guys
My apologies.
Ignore the man behind the curtain



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill




Alan Shore
<AlanShore@xxxxxx
om> To
Sent by: Midrange Systems Technical
midrange-l-bounce Discussion
s@xxxxxxxxxxxx <midrange-l@xxxxxxxxxxxx>
cc

07/17/2007 03:38 Subject
PM SQL insert


Please respond to
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>






Afternoon guys
I have an SQL problem
I have 2 files that the data from one needs to be inserted into the other.
They both have the same number of fields
here are the 2 layouts

FileA FileB
Field
Name Type Length Dec Loc Type
Length Dec Loc
SDCAT A 2 1 A 2
1
SDITEM A 6 3 A 2
1
SDSKUNO A 6 9 A 6
9
SDSUFIX A 4 15 A 4
15
SIZE A 10 19 A 10
19
SDVPRC P 7 2 29 S 7 2
31
SQTY P 5 0 33 S 5 0
38
PORDMX A 5 36 A 5
43
SDORGC A 2 41 A 2
50
SDORGP P 7 2 43 S 7 2
54
SDORG# A 4 47 A 4
61
SDVPKODE A 1 51 A 1
67

When I try the following

INSERT INTO FILEA
SELECT * FROM FILEB

I get the error
Statement contains wrong number of values.

The only thing that I can think of is that FILEA has PACKED numeric fields
while FILEB has ZONED numeric fields
Anyone any ideas how to circumvent this within SQL

Thanks in advance



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.