Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
UPDATE updating too much
Downloaded it and took a quick look, very impressive. Thanks! -
UPDATE updating too much
Your suggestion worked great, thanks! I'm not familiar with "common table expression" so I'm off to google... Thanks for you assistance. -
UPDATE updating too much
I have two tables the main table, T1, has 1+ million rows and another table U1 with a few hundred rows. T1 has a primary key, K1 and a data column D1. Table U1 has updates to be applied to T1 and has columns K1 and D1 defined identically, except that U1 has an additional column D2 and the... -
Load Exception Table Use
I have a table with a primary key that I am using "LOAD" sql to populate the table and use the "for exception <exception table>" to capture any incoming records that have redundant primary keys. The tables are identical in form except that the exception table has two additional columns: the... -
CVS Archive Starting Fresh
I have a CVS archive of dubious content and want to start basically fron scratch. First want to save the current archive "just in case" then clear it out then load it from the code in production. I'm new to CVS and looking thru the docs I have is not really helping yet. Any suggestions on how to...- mad0dog
- Thread
- Replies: 1
- Forum: CVS: Concurrent Versions System
-
Changing print pitch
Both forms ("-p8" and "-p 8") result in the same error. -
New to DB2
Looking for suggestions for books on using DB2. I've been using relational db's for 15 yr. but only briefly DB2 and am looking for reference/how to docs. The kind of stuff I looking for is how to use "db2" utility, how to get a listing of a table's schema, etc. TIA -
Changing print pitch
when print a file with qprt and and set the pitch to "-p 8" I get an error: 0782-598 The value 1 specified in the validate op V in the limits field for _p attribute indicates failure The command line is: qprt -p8 -Pprinter1 file_name what am i doing wrong?
