rdbms and dbms
what is rdbms and dbms in oracle?

Answer Question   |  April 6, 2009  6:51 PM
DBMS, Oracle 9i, RDBMS

Trying to learn – How to filter dates…
I have a DB that lists a date in each column, so that when I run a simple query I can pull up only the dates that I need. I have tried (filtering by exculding dates not needed) but now my DB is too big to spend the time going through each date, to only [...]

Answer Question   |  April 13, 2009  2:27 PM
Access Database, Access Database Filters, Access Database Format, Microsoft Access

How do I write a SQL statement to get all data from a table called subscrib?
How do I write a SQL statement to get all data from a table called subscrib?

Answer Question   |  April 6, 2009  10:16 PM
SELECT statement, SQL, SQL queries, SQL statements

DB2/400 field to match an Oracle VARCHAR?
We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS [...]

Answer Question   |  May 18, 2009  9:03 PM
AS/400 interoperability, DB2 connectivity, DB2/400, DDS, Oracle development, Oracle interoperability, Oracle VARCHAR, VARCHAR

Need help with this Oracle Query
BPC_APPLICATIONS_TRANSACTIONS (Table) Application_no,Transaction_no,Transaction_date Step_id Dept_code Decision 20090045 1 01/14/2009 10:07:17 1 001 0 20090045 2 01/14/2009 10:07:17 70 007 0 20090045 3 01/14/2009 10:08:57 1 001 0 20090045 4 01/14/2009 10:08:57 60 006 0 20090045 5 01/14/2009 10:14:12 71 007 1 20090045 6 01/14/2009 10:14:41 61 006 1 20090045 7 01/18/2009 11:45:13 73 007 1 [...]

Answer Question   |  April 6, 2009  9:08 AM
Oracle queries, Oracle Query, Query optimization

Microsoft Access Report “Specific Printer”
Cannot get MS Access reports to let go of default printer. Selection of “Specific Printer” in page setup does not get saved. Also set .UseDefaultPrinter=False in code but it goes back to true no matter what. Have also tried every conceivable means of setting properties of both application.printer and report.printer objects. I must get this [...]

Answer Question   |  April 6, 2009  1:10 AM
Microsoft Access, Microsoft Access printing

Access 2003 using VBA
I am trying really hard to produce these tables. But when it came to populating the information into them, it was throwing up errors. Ive managed to sort most of them out, but this one for WeeklyUnitStaffRota table is annoying me. Can anyone have a look at the tables and see where I could have [...]

Answer Question   |  April 3, 2009  2:10 PM
Access 2003, Microsoft Access, RDBMS, VBA

Optimizing a SQL Server stored procedure
I want to optimize my stored procedure in SQL Server, as it takes some time to execute. It uses a temporary table to store some data, and then it uses a dynamic query that we execute using the EXEC statement. How can I remove temporary table or, in general, how can i improve performance of [...]

Answer Question   |  April 2, 2009  4:47 PM
EXEC, SQL Server stored procedures, SQL Server tables

SAP – Create CSV from Text format
I tried to convert the text format to CSV format by USing internal table and the FM isSAP_CONVERT_TO_CSV_FORMAT. But wn i download to CSV format the file contains fields serepared by ‘;’.So becuse of this Im unable to Up load this file.

Answer Question   |  July 20, 2010  4:11 AM
CSV format, isSAP_CONVERT_TO_CSV_FORMAT, SAP development, SAP Import/Export

Matching External lists to your Database?
Hello everyone, I work in a telco and manage the data in the company’s CRM. I’m often given lists of company names by our alliance team, and asked to match the list against our database to see which companies already exist in the CRM and which don’t. At the moment I can only accomplish this [...]

Answer Question   |  April 3, 2009  10:54 PM
Query optimization, SELECT statement, SQL, SQL queries

DoCmd.OpenReport not working right with WHERE clause
I have looked all over and seen hundreds of questions about this command, but no answers. It seems like the most basic thing you can do with combo boxes, so I’m baffled that it doesn’t work. Here is my VBA Code: Option Compare Database Private Sub cboFundNumbers_AfterUpdate() Const strFormName As String = “Fund Number 2″ [...]

Answer Question   |  March 18, 2011  10:20 PM
Access 2003, DoCmd.OpenReport, Microsoft Access 2003, VBA, Visual Basic for Applications, WHERE statement

Hosting multiple websites on IIS 6
I already have sharepoint services running in the default web site in IIS. How do I create another website to run without interfering with the sharepointsite?

Answer Question   |  April 2, 2009  10:07 PM
IIS, IIS 6.0, Internet Information Services, SharePoint, SharePoint Services, sp_helprotect

Resizing fields to see content in Microsoft Access 2003
In Access, to expand a field to view the field’s contents what can you press?

Answer Question   |  April 2, 2009  9:43 PM
Access 2003, Microsoft Access, Microsoft Access 2003

CSV to Access
I have multiple csv files in a folder with many lines of data in them. Every day new csv files get added to this folder. I want to write batchfile to copy certain rows from these files to the access database table everynight automatically. How can I do this?

Answer Question   |  April 1, 2009  7:56 PM
CSV, Microsoft Access

Creating Ref numbers from two fields
I want to create an ID code from the first 3 letters of a surname in the surname filed and combine it with a 3 digit number to create a unique ID code. Appreciate it if anyone could tell me how this is done in Access.

Answer Question   |  April 4, 2009  7:42 PM
Access Database, Microsoft Access, Microsoft Access Unique ID

Simple SQL server question?
I want to do something that WAS easy in my former world (a dBase environment) but I can’t figure out how to do it in MS Access/SQL Server 2000. I would GREATLY appreciate anyone’s help. This is what I want to do, in order: 1) Select the top # records of a table, “#” is [...]

Answer Question   |  March 31, 2009  9:00 PM
dBASE, Microsoft Access, SQL Server 2000

Update Access Databse
How do I set up web application, using classic Asp to update access 2002 database?

Answer Question   |  April 4, 2009  3:08 PM
Access 2002, Access Database, Microsoft Access

How to find out which embedded SQL taking more time in RPGIV program
Hi All, I have 4 Embedded SQLs in my RPGILE program. Can any one tell me how to find out which SQL taking more time to execute ? are there any commands/methods to find out ?

Answer Question   |  March 31, 2009  12:42 PM
Embedded SQL, RPG IV, RPGILE

Plausability of natural key as primary key
If you have a field in a table that is a natural key and meets all the criteria for a Primary key, is it advisable to use that natural key as your Primary? Or is it a better idea to assign a surrogate key (i.e. autonumber for TrainingProgramID instead of using TrainingProgramName)? Thanks in advance [...]

Answer Question   |  March 31, 2009  12:08 PM
Natural Keys, Primary keys, Surrogate Keys

Rename Clause
Hi, Can any one please tell me what is Rename Clause and the use of Rename clause? I know only we are using 66 level for Rename clause in Cobol Program. Thanks In advance. Suchi..

Answer Question   |  September 11, 2010  11:51 AM
COBOL, COBOL/400, Level-66, RENAME statement