Interested to Buy Any Domain ? << Click Here >> for more details...
insert into tablename a
column1,
column2
select column1,
column2
from tablename b
i am getting abend -104..can any one help?
- 3 Answers
- 9629 Views
- Syntel, I also Faced
- E-Mail Answers
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 |
Plan has the optimized access path in it. But is that optimized access path is attained or known
What is PRIME TABLE and what are the uses of it
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
What is a page in db2?
What is the function of logging in the db2 database?
Explain the benefits you can get from mainframe connect?
What is dclgen (declaration generator)?
What is clone table?
Can you define an Index if the table size less than 10 PAGES?
what are extents?
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
What is read-only cursor?
COBOL 
