Recent content by gsdcrazy

Everyone, Thanks so much for your quick response. Sorry, I did not mention that the Word Documents are using VBA Macros. The Macros are working just fine. They are contained in a "dot" Word Template that creates the document (doc) through the Macros. The "quoting" of the "Add Template"...

Sometime in 2003/2004, I created Access/Word/Excel software for my wife's volunteer club. I really am not an Access or VBA programmer, but. . . Don't even remember what version of Windows was active at that time, but the Club managed to keep the same versions on two different laptops until...

Thanks for the response. I apologize for not being more specific in the request. I am running from a SQL*Plus script file, but am not running interactively. I was running a batch command from an UNIX script: { echo "${UID}" echo "@/home/walterg5/BetaFlows/data/NDWBTACPOSQL.sql " } |...

I am running a file in SQL Plus and can only get the "feedback" (how many rows updated or whatever). Can the DBA's turn off the "set echo on" command? The code I am running is: set linesize 80 set pagesize 0 set echo on set feedback on set termout on set heading on set verify on spool...

taupirho, Thanks. Guess I just wanted SQL*Loader to do something that it can not. I'll implement your solution. Thanks again, gsdcrazy

Gurus, This is probably a very elementary question, but I am frustrated. How to I set SQL*Loader to update existing rows, but not insert new rows when the record does not exist in the table? I have tried LOAD DATA REPLACE INTO TABLE ag_ma_indicator_trans (ENTITY_ID...

KevinADC, So simple when you know what to do. Thanks. I don't think I would have ever tried that. I am sure I missed it in the books I have, but really needed to move ahead with this. Thanks again, GSDCrazy

This should be simple, but I need to update a master file from a second file. The master file has all records and more than the second file. The second file never contains records that are not in the first file. The master file contains 2 million records. The second file contains from 1...

macropod, Thanks again. I seem to be doing more with Access for my church and my wife's volunteer groups. This type of formatting makes the documents look so much better. Your insight really has helped. gsdcrazy

macropod, This works great! Sorry for the slow response to thank you. I ended up with two "With Selection" statements and the Dog's Name was bolded and the reset of the text in the cell was not. Not ever trying to set up the "With Selection" with the "Set Table . . . With Row" syntax that I...

Gurus, I am building a Word document with a document template using information in an Access database. I use the "with" structure to define and populate the table cells. In certain cells, I need to BOLD specific words (column information from the Access database) that is concatenated to other...

Si M... Thanks for the direction. Probably a little late, but this is a sample of the code I was trying to convert from Oracle to Teradata: SELECT /*+ PARALLEL(t) USE_HASH(t, a) */ t.tran_code , a.agrmt_id ...

Gurus, We are converting existing Oracle applications to Teradata. We have some code that in Oracle SQL is using a window with the "FIRST_VALUE" function. This takes the result set of the window and returns the first value of the result set (always used in conjunction with an ORDER...

bi and KenCunningham, This is just what I needed. Never thought to search for "padding lines". Thanks for the help. Thanks, gsdcrazy

Gurus, I am hoping there is a simple way to add spaces to the end of each record in a file. The company has a standard compare facility that compares yesterday's and today's transaction files (taking into account keys, etc.), but it requires the records in the two files to be the same length...