First, a little background. We haven't moved to ASP.NET yet, so I'm still using GetRows() to retrieve recordsets. We have search pages that bring back a certain number of records per page. Right now, ...
To update the data, you can specify view descriptors in the PROC SQL INSERT, DELETE, and UPDATE statements. Here is a summary of these PROC SQL statements: DELETE deletes records from a CA-DATACOM/DB ...
Determine when to use stored procedures vs. SQL in the code Your email has been sent Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one ...