Info
You are currently browsing the Ugly Programmer weblog archives for the day 6. June 2008.
Calendar
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « May | Jul » | |||||
| 1 | ||||||
| 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| 23 | 24 | 25 | 26 | 27 | 28 | 29 |
| 30 | ||||||
Categories
- CSS (2)
- Javascript (3)
- LANSA (21)
- SQL (8)
- Twitter API (1)
- Uncategorized (25)
Latest Postings
- 8. March 2010: American Express is Suing Me
- 28. January 2010: So frackin hard
- 1. September 2009: Twitter API STREAM Filter
- 15. June 2009: DOS Commands that work on Windows XP
- 14. April 2009: TWEATER CHEATER IS BORN
- 14. April 2009: Windows Keyboard Short Cuts - ALT F4 is my Favorite
- 11. April 2009: SELECT_SQL Examples
- 30. January 2009: My Recovery ID Idea
- 29. January 2009: Test Program to See what LANSA Services are Licensed
- 11. January 2009: glossary
Links
Archives
Archive for 6. June 2008
When inserting from another file using SQl
6. June 2008 by admin.
make sure you have matching fields selected (ignore timestamps)
INSERT INTO DC@DEVLIB/M@ACTMNT (AGENT, ACCTNO, POLICY, EFFDTE,
EDSNO, INSNAM, AGYTYP) SELECT * FROM masonm/webfl100 a WHERE not
exists (select agent from dc@devlib/M@actmnt b where
a.acctno=b.acctno)
83 rows inserted in M@ACTMNT in DC@DEVLIB.
Posted in Uncategorized | No Comments »
|