code_junkie

Database alias in Informix

Nov 13th, 2011
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.23 KB | None | 0 0
  1. INSERT INTO other_db:mytable ...
  2.  
  3. DATABASE old_db;
  4. CREATE SYNONYM table_name FOR new_db:table_name;
  5.  
  6. DATABASE old_db;
  7. SELECT tabname, nrows
  8. FROM systables
  9. WHERE tabtype = "T"
  10. AND tabid > 99 -- exclude internal tables
Add Comment
Please, Sign In to add comment