[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
[ic] DB2/database interactions
hello all!
I've been playing around with interchange these past few days and
have really enjoyed working with it.. ;) A quick question: I'm trying to
simply import data from a DB2 database on another server that contains a
list of products. I'm having some trouble trying to figure out where
exactly that happens. I have a boo_cigars.db2 file that contains
something like:
Database boo_cigars boo_cigars.asc __SQLDSN__
Database boo_cigars UPPERCASE 1
#ifdef SQLUSER
Database boo_cigars USER __SQLUSER__
#endif
#ifdef SQLPASS
Database boo_cigars PASS __SQLPASS__
#endif
Database boo_cigars DEFAULT_TYPE VARCHAR(128)
Database boo_cigars KEY ID
#Database boo_cigars COLUMN_DEF "ID=INT PRIMARY KEY"
#Database boo_cigars COLUMN_DEF "VARIETY=VARCHAR(128) DEFAULT ''"
#Database boo_cigars POSTCREATE "CREATE INDEX boo_cigars_title ON
boo_cigars (VARIETY)"
#Database boo_cigars COLUMN_DEF "priceadf=INT"
#Database boo_cigars COLUMN_DEF "MANUFACTURER=VARCHAR(64)"
#Database boo_cigars POSTCREATE "CREATE INDEX boo_cigars_category ON
boo_cigars (MANUFACTURER)"
Database boo_cigars NUMERIC price
i don't think that format is correct. the table that contains my products
is called boo_cigars on a DB2 database on another system... Where exactly
do I place calls to retrieve this data?
Any help will be appreciated, If you can send replies directly to this
address that would be great,
Thanks,
Sriram
_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users