Database Questions and Answers
161 - 180 of 2115

How would be the opportunities for AS400 in future

Hi, I've been working as an AS400 Professional in one of India's largest MNCs for the past 2 years. Now i have a chance of shifting into MAINFRAMES in same organization. Most of my friends telling me that MAINFRAMES had lot of opportunities compared to AS400. Can anyone please suggest me how...

View Answer   |  Jul 13 2009  8:42 AM GMT
AS/400 careers, Career development, IT careers
asked by Mohan K

  470 pts.

Inner join Solution

i write the following Query to execute against the 1500000 in SQL Server 2000 DECLARE Cur_Prefix CURSOR FOR SELECT PrefixNo,PrefixLen,AfterPrefixLen FROM NoSeriesMaster_Prefix WHERE PrefixType='SMS' order by ID OPEN Cur_Prefix FETCH NEXT FROM Cur_Prefix INTO...

View Answer   |  Jul 11 2009  2:51 PM GMT
INNER JOIN statement, SQL
asked by Mxaxyogesh2002

  30 pts.

Need Help Regarding Network Security Certifications?

Hi guys I have just finished my graduation and i am looking for a certification course in Network Security but don't know where to start. Any Help would be great. Thanks.

asked by Deepeshs

  15 pts.

networking

hi my name is udit gupta m a student of t.y. computer engineering , i would like to know that student not intrestead in programing field can jump to another feilds like networking & what course they should do that may help such student in final year .let me inform you that my interest field is...

View Answer   |  Jul 10 2009  5:05 AM GMT
IT education, Networking careers, IT careers
asked by Udit

  10 pts.

php and mysql

How can we create a family tree map using php and mysql?

Answer Question   |  Jul 9 2009  12:45 AM GMT
MySQL, PHP
asked by Sanasher

  5 pts.

How do I overcome the "Could not find installable ISAM. Excel 2007" Error? Ex

I got the "Could Not find installable ISAM error" while uploading an Excel file in my application.This seems to be happening at the "connection.Open()" code line. -- Web Application -- .Net 2.0 -- Testing using IIS 7.0 on Vista Ultimate -- Office 2007 Enterprise Installed on machine. Code works...

asked by Donnybrasco

  10 pts.

Access Subform Blank

Subform doesn't appear in either form view or design view. Can move database to another computer running Access 2003 and subform works perfectly linked to the same tables.

asked by Billa

  15 pts.

how delete 12,33,200 rows in oracle table

how delete 12,33,200 rows in oracle table

View Answer   |  Jul 8 2009  9:04 AM GMT
DELETE statement, Oracle Table
asked by Shindetanaji

  10 pts.

dba deleting data

Is part of a DBA's job to delete production data using SQL scripts?

View Answer   |  Jul 7 2009  7:49 PM GMT
DBA, Database Administrator, SQL scripts
asked by Biker01

  5 pts.

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.

asked by ShSyed

  5 pts.

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, and trying to add any more...

View Answer   |  Jul 7 2009  2:47 AM GMT
Accumulators, Counters, LOOP statement
asked by Norphes

  5 pts.

conversion from FileMaker Pro to Microsoft Access database

How do you convert filmaker pro 7 database to an access 2007 database file

View Answer   |  Jul 6 2009  8:16 PM GMT
Filemaker Pro, Microsoft Access, Access Database
asked by Ccardona

  5 pts.

dlookup

how does dlookup work?

View Answer   |  Jul 6 2009  1:43 PM GMT
DLookup, Microsoft Access
asked by Davva

  10 pts.

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?

View Answer   |  Jul 6 2009  11:02 AM GMT
solutions architect, IT careers, Systems analysts
asked by David71

  25 pts.

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

View Answer   |  Jul 6 2009  4:11 AM GMT
Microsoft Access, Database design, Access 2007
asked by Swd144

  20 pts.

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 average) or has hung.

Answer Question   |  Jul 5 2009  9:39 PM GMT
Backup servers, Backup, Database Backup
asked by Jayeshmb

  15 pts.

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

View Answer   |  Jul 4 2009  5:42 PM GMT
Storage careers, Storage certifications, IT careers
asked by Wipvish

  10 pts.

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 RRN does DB2 have any...

View Answer   |  Jul 3 2009  10:46 AM GMT
AS/400, as400/DB2, DB2/400
asked by RJES

  45 pts.

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

View Answer   |  Jul 2 2009  12:51 AM GMT
IFS, CPYTOIMPF, CSV
asked by VGP

  35 pts.

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

View Answer   |  Jul 1 2009  1:02 AM GMT
Lotus Domino Server 6.x, IT careers, LotusScript
asked by RLakmi

  25 pts.

161 - 180 of 2115