Line

Technical Article

RE: Insert daily records from one table to individual merchant tables

  • Reply

Hi,If it helps - yes you can do away with cursors and still step through everything:-  SET @PK = (SELECT MIN(PK) FROM #Values)   SET @MaxPK = (SELECT MAX(PK) FROM #Values)  WHILE @PK <= @MaxPK   BEGIN--Do whatever you are doingSET @PK = (SELECT MIN(PK) FROM #Values WHERE PK > @PK)   ENDThough i'm not too certain what […]

You rated this post out of 5. Change rating

2004-11-02

Technical Article

RE: Free OLEDB Provider for DB2

  • Reply

We have used the HIS to access our OS390 based DB2 database. This was the only possibility we've found. It's working fine, but only with DB2 as HIS (formal SNA Server) requires SNA. And we are operating IP now so I'm not able to access our VSAM files out of SQLServer. Bye Gabor

You rated this post out of 5. Change rating

2003-11-24

Blogs

Not Selected for the PASS Data Community Summit 2024

By

I got this in an email about a week ago from the PASS Data...

A New Word: Addleworth

By

addleworth – adj. unable to settle the question of whether you’re doing okay in...

Data Technology Learning Resources

By

Hey all! Quick one here. Tracy Boggiano, awesome person that she is, has put...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers