Trying to transfer data from Prod region to Test
region.So,exporting data from Prod table(e.g xyz in prod)
into a temporary table(e.g abc) and then inserting into
Test table(e.g xyz in prod),but not able to insert data
from one db2 table to another,the error coming out
is 'foreign key vaue is not valid'
Answer Posted / laxman
insert into abc.tablename(select * from xyz)here xyz is
database1 abc is tempory database but here u select database
is xyz then only this query is excuted if u any doubt mail
me yhis is my mail id laxmanit08@gmail.com
any query u wnt just send a msg ok bye tc
laxman
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is the instrument that used in Mechanical Energy??
how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board
mount: mount to NFS server failed: System Error: Connection timed out
what is new g/l functionality
hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.