Recent content by CVENOM

Thanks, that's kind of what I had figured....

I'm trying to create a trigger that that will reference a table in DBC, and insert rows into a table outside of DBC. The problem I'm running into is an error saying "Failure 3524 The user does not have CREATE TRIGGER WITH GRANT OPTION access to database DBC." I'm not creating the...

Thanks, to both of you.

Maybe someone will know the answers to these questions. We've found recently that there are a few differences in syntax between Queryman and BTEQ. The two most recent ones being: 1. Queryman does not support a "with" clause: examp: sel some_nbr from some_tbl with sum(some_nbr)...

This is a kind of cheesy way to do it, but it works... Create a one column table that has just the letters in it from a to z. Create table Charz (Charz char(1)); insert into Charz values ('a'); insert into Charz values ('b'); .... insert into Charz values ('z'); Do your select against the...

That's what I was afraid of. We are using Group1 for the addresses. I'll see if we can get soundex to work for our purposes. Thanks for the responses, Rich

What is the easiest way to find rows with a similar value? Examp: Tablename = customer columns = name, address1,city. Sample data: Bob's plumbing | 1234 Oak St | Kalamazoo Bob's plumbing Inc | 1234 Oak St | Kalamazoo Bob's plumbing | 1234 Oak St, Ste 123 | Kalamazoo Chuckie's Toys | 1111 Coral...