how delete 12,33,200 rows in oracle table
how delete 12,33,200 rows in oracle table

Answer Question   |  May 3, 2012  9:04 AM
DELETE statement, Oracle Table

dba deleting data
Is part of a DBA’s job to delete production data using SQL scripts?

Answer Question   |  August 26, 2010  7:49 PM
Database Administrator, DBA, SQL scripts

Data integration
I want to import a table from dbase III to Sql server 2005. I also want to automate this process and run it after ever one hour. Is there a simple way to do this task.

Answer Question   |  July 7, 2009  4:10 PM
Data integration, dBASE III, Importing dBASE to SQL, SQL Server 2005

DO…LOOP and IF ELSE THEN statements
I am writing a basic program where two types of data are added: 1. a salespersons ID and 2. an amount of cars sold within a month from that salesperson. I have found out how to set the code where the numbers will go where they need to, but adding extra ones does not work, [...]

Answer Question   |  July 12, 2009  2:47 AM
Accumulators, Counters, DO LOOP statement, IF ELSE statement, LOOP statement

conversion from FileMaker Pro to Microsoft Access database
How do you convert filmaker pro 7 database to an access 2007 database file

Answer Question   |  July 7, 2009  8:16 PM
Access 2007, Access Database, Filemaker Pro, FileMaker Pro 7, Microsoft Access

dlookup
how does dlookup work?

Answer Question   |  July 6, 2009  1:43 PM
DLookup, Microsoft Access

What does a Solutions Architect do?
Can anyone please help me with a basic description of what a Solutions Architect does. I have been told that this role could also be similar to a Systems Analyst and that other job titles may involve similar work – can anyone advise me?

Answer Question   |  July 6, 2009  11:02 AM
IT careers, solutions architect, Systems analysts

With an Access form based on 1 table, can I have info from a related table automacially appear based on linked field?
With a form based on 1 table, can I have info from a related table automacially appear based on linked field? For example, let’s say I have two tables linked by a Vendor ID number. On a form that is based on the Purchase Order table, I’d like the Vendor name to automatically appear on [...]

Answer Question   |  July 11, 2009  4:11 AM
Access 2007, Access Database, Access forms, Database design, Microsoft Access

DB backup is hung
What are the different ways to know if DB backup & archive log backup process have hung. How can we know the average run time of db backup & archive log backup ? What are the advisable checks to be performed / steps to be taken if we observe the backup is slow (determined by [...]

Answer Question   |  July 14, 2009  9:39 PM
Backup, Backup servers, Database Backup

Storage Career Info. needed
Hi this is vishal…I am currently working as product support engineer for emc symmetrix storge box with experience of approx 18 months….. my job profile is to remotely trouble shoot the storage drives or director related issues… basically its a L1 technical support i want to move towards Storage networking side which storage certifications i [...]

Answer Question   |  July 20, 2009  5:42 PM
IT careers, Storage careers, Storage certifications

Delete OLD files from Table not having date or timestamp
Hi, In DB2, Is it possible to get the insert date of a record in a table which doesn’t have a seperate field for creation date or timestamp. I have a task where I have to delete record older than 1 year from a table, but the files doesn’t have creation date field. So, like [...]

Answer Question   |  July 30, 2009  10:46 AM
AS/400, as400/DB2, DB/400, DB2, DB2/400, delete sql, DELETE statement, SQL

cpytoimpf CSV file showing garbage
I have an application that does 3 CSV files to import to Excel. All three use the same cpytoimpf program/command, 1 is working correctly and 2 are not. I debugged and do not see a difference. I can view the data just fine with dsplnk on the iSeries/AS/400 but the Excel is all @@@@@@. Does [...]

Answer Question   |  July 2, 2009  12:51 PM
CPYTOIMPF, CSV, IFS

To be back in the IT career
Hi, I have 8 plus years of experience in the IT industry doing development using Lotus script, Javascript & HTML. Did Project Management to become a Porject Manager. But currently I can’t find job with my background. I am trying to upgrade my skills but not sure where to start. I need some advise. Thank [...]

Answer Question   |  May 28, 2010  1:02 AM
HTML, IT careers, IT jobs, JavaScript, Lotus Domino Server 6.x, LotusScript, Web development

Career matchmaking – program development
I am interested in making software that allows potential employees to find employers who are offering what they are looking for in a job (be it salary, benefits, location, a specific job, etc). I also would like to have the vice versa of the scenario where the employer can look for a specific type of [...]

Answer Question   |  July 1, 2009  8:14 PM
Database, Database Management Systems, Software development

data copy – paste from the same table not showing in a subform
I have an Access 2007 application for recording employee skills and competencies in a medium business. We have recently duplicated the application with a view to recording other employee skills of each employee. Normally, I would add each employees details via a form and an embedded subform, however to save time, I have tried to [...]

Answer Question   |  July 16, 2009  3:50 AM
Database programming, Microsoft Access, Microsoft Access 2007

Microsoft Access Audit Report
I have an audit with an “Action Taken” field and all of the fields in the original table. If the action is “Changed From”, the action in the very next line will be “Changed To”. I want the Audit Report to show ‘before’ and ‘after’ values for only those fields that changed, with all else [...]

Answer Question   |  July 14, 2009  8:56 PM
Access Database, Access reports, Audit Reports, Audits, IT audits, Microsoft Access

Access Reports to PDF file
Greetings, I have an objective that’s been driving me in circles…. Windows XP Office 2007 I need to figure out how to convert “multiple” Microsoft Access reports into one pdf file through vba. Access 2007 has easy way to convert one report at a time to pdf, however, I cannot figure out how to access [...]

Answer Question   |  June 29, 2009  7:22 PM
Access 2007, Access reports, Microsoft Access, Microsoft Office, Office 2007, PDF, VBA, Windows XP

Filtering a Subform
How do I filter a form based on a value contained in the subform?

Answer Question   |  June 29, 2009  3:16 PM
Microsoft Access, Microsoft Access Filters, Microsoft Access subforms, Subform

0 Row affected
Could you please assist with the following? UPDATE dbo.[Elution_Report_Template] SET [Elutriation_Set_SqM] = dbo.[Elution_Report].[Elutriation_Set_SqM], [Elutriation_Pump_SqM] = dbo.[Elution_Report].[Elutriation_Pump_SqM],

Answer Question   |  June 29, 2009  5:32 AM
Database engineering, Query, rows affected, SQL, Update

Pictures in a DB
In my DB I have a picture in each record but it now says I have no more space available…How do I get round this?

Answer Question   |  June 29, 2009  3:26 AM
Binary data, Database administration, Image databases