General information
Category:
Coding, syntax and commands
Hi Naomi Thanks for replying.
So if I have
Source table as: FLDS_1 FLDS_2 FLDS_3
Destination Table as: FLDD_1 FLDD_2 FLDD_3
The names of the fields I require in the Output Into table are:
FLDS_1 FLDS_2 FLDS_3
FLDD_1 FLDD_2 FLDD_3
I.E. A L L the fields from both the input and output tables with exactly the same names ???
Regards,
Gerard
>>Hi
>>
>>If I use a SQL Merge with an Output Clause, If I dont specify an INTO, it works fine
>>However, If I use an INTO clause , it errors with a 'Column Name or number of supplied values does not match table...
>>
>>I cant seem to get the Column Names correct in the output table
>>
>>1. Does it matter what they are called
>>2. Do they have to be same as source
>>3. Do they have to be same as source with an old_ and a new_ prefixed
>>4. Does the Type matter
>>
>>I just cannot seem to get the column names correct
>>
>>Tia
>>Gerard
>
>Define your output table the same or similar as your source and target and explicitly list columns in the OUTPUT clause, don't use *
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only