SQL prepared statement

[Alan Shore <AlanShore@xxxxxxxx>]

Hi guys
I have a question with embedded SQL that my instinct says is not possible,
but I will go ahead and ask anyway
I have 2 files that are almost identical in their record formats
FILEA consists of the fields
Field1
Field2
Field3
Field4

FILEB consists of the fields
Field1
Field2
Field3

The difference is that FILEB does not have Field4

Using embedded SQL, can I create a prepared statement something like the
following

INSERT INTO FILEA    X.*, :progfield  from FILEB X
WHERE X.Field1 = ? and X.Field2 = ? and X.Field3 = ?

where progfield is a program defined variable.

Thanks in advance



Alan Shore

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