insert into tablename a
column1,
column2
select column1,
column2
from tablename b
i am getting abend -104..can any one help?
Answers were Sorted based on User's Feedback
Answer / guna
insert into tablename(column1,column2)
select column1,column2 from tablename
Alias names 'a' and 'b' should not be used.In case u want
to use alias names, specify the column names with prefix as
a.column1,b.column2 like that.
Also, brackets must be given in an insert statement.
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / amala
A 104 error indicates that either a field that is defined
as integer is specified with quotes or an Char value in
insert that needs to represented with quotes is not
represented so...Hope this helps to solve your issue
Is This Answer Correct ? | 2 Yes | 4 No |
What is the physical storage length of date data type?
what is SMP/E? and what are the major steps of it? thanks...
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
What is a db2 cursor?
how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token
how to unload different table data into different gdg files/ vsam files.
What are column-name qualifiers used?
List out the buffer pools in db2
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
What can the SET option of the Repair Utility accomplish?