Intelligence Base

Power not come from knowledge kept, but come from knowledge shared.

10 August 2009

Informix: update from another table

update tabA
set tabA.col1 = (select tabB.col1
from tabB
where tabA.key1 = tabB.key1
and tabA.key2 = tabB.key2
and tabB.col2 = '2009-06-01')
Posted by Kittisak Boyd at 12:01
Labels: informix

No comments:

Post a Comment

Newer Post Older Post Home
View mobile version
Subscribe to: Post Comments (Atom)

Labels

  • datastage
  • db2
  • efficiency
  • entrepreneur
  • ETL Design
  • evaluation
  • google
  • Guy Kawasaki
  • HRM
  • informix
  • Leisure
  • management
  • oracle
  • shell script
  • Teradata
  • unix

Blog Archive

  • ►  2011 (2)
    • ►  May (2)
  • ►  2010 (39)
    • ►  October (2)
    • ►  August (5)
    • ►  July (7)
    • ►  June (5)
    • ►  May (5)
    • ►  April (14)
    • ►  January (1)
  • ▼  2009 (37)
    • ►  December (2)
    • ►  October (2)
    • ►  September (2)
    • ▼  August (2)
      • Informix: update statistics
      • Informix: update from another table
    • ►  July (4)
    • ►  June (1)
    • ►  May (5)
    • ►  April (1)
    • ►  March (4)
    • ►  February (4)
    • ►  January (10)
  • ►  2008 (20)
    • ►  December (4)
    • ►  November (1)
    • ►  October (4)
    • ►  September (3)
    • ►  August (8)

Data Warehouse Link

  • Teradata
  • IBM - Technical library view
  • Data Doghouse

DataStage Link

  • DSXchange Member Portal
  • IBM Software - IBM Information Server
  • DSXchange :: IBM Information Server Forum
  • DSXchange Learning Center
  • DSXchange Channel on YouTube
  • Getting DataStage Certification
Picture Window theme. Theme images by mammuth. Powered by Blogger.