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
- 9870 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is rebind in db2?
What is scrollable cursor in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is the use of dclgen in db2?
What is the maximum number of columns in a db2 table?
List out the buffer pools in db2
What is ibm db2 client?
What is difference between isnull and coalesce?
Why do chiropractors use drop table?
How many databases are there?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
