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 |
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
How to find the number of rows in a db2 table?
What is query_cache_limit?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
What are the three lock types?
What is the difference between dbm cfg and db cfg file in db2 ?
What are iseries servers?
How does db2 sample database connect?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
WHAT IS MEANT BY COMMIT COMMAND?
What is lock escalation in db2?