Search results for query: *

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...

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...

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...

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...

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...

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...

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...

Gurus, I have the code below that reads a row from an Oracle database and then sets a variable with the results. It works great when I run it from the $ prompt, but, when we schedule it through the Maestro scheduler, I get the following errors: /beta/nwdw/salesmi/bin/NDWY9017.sh: [[: not...

Gurus, I know this is probably a very elementary question, but I am at a loss. I have read in fields from two files. The format of the fields are inconsistent. They consist of a sign (+ or -) and a number. One file has a consistent format with decimals (period followed by two numbers). The...

Gurus, Someone in my office has written the SQL below: select a12.distrbtn_chnl_id ,max(a14.distrbtn_chnl) distrbtn_chnl ,a13.prod_type_id ,max(a16.prod_type) prod_type ,a11.month_id ,max(a15.month_name) month_name ,max(a15.year_id) year_id...

Gurus, I have been very successful using the following command to find files with a particular string in them, but have come into a situation where I need to search for a case insensitive string. There is no consistency as to how the string is typed in the files. Any ideas how I can modify...

Gurus, I have a UNIX ksh shell that initiates a SQL*Plus script. Whenever there are spaces in the parameter, the spaces are eliminated when the SQL*Plus script recieves/executes it. I have performed "echos" of the parameters just before initiating the SQL*Plus shell and just after...

Gurus, This is probably a rockie question, but, since I am a rockie, I don't feel bad about it at all. I have a form with a subform. When the form record equals a certain status, I want some of the fields in the form and all the fields in the subform to be disabled (.enable = false)...

Gurus, I am very new at Access Programming and really would appreciate some help. I have spent hours going through threads and just can seem to hit on the right key words. My situation is that I have a table that will be use to create a combo box. The table (among others) has two columns...