Experience applying SP4 to SQL 2005?
Hi, I have a Microsoft SQL 2005 SP3 database server with 2 instances (both patched to SP3.) The one instance (1a) includes 52 small production databases. The other instance (1b) includes 2 large production databases. Now I would like to upgrade the (1b) instance to the new Service Pack 4. The way I would to [...]

Answer Question   |  February 7, 2011  5:49 AM
Database Instances, SQL 2005, SQL Server 2005, SQL Server database, SQL Server multiple instances

Open IT Forum: How did you get into IT?
Have you always been curious with how things work behind the scenes, or did you realize later in your career that IT was where you belonged? We’d love to hear what inspired you to pursue whatever pocket of IT you’re in. We’ll give you 50 knowledge points just for sharing your story, which will be [...]

Answer Question   |  March 6, 2012  8:45 PM
Giveaways, iPads, IT career development, IT career planning, IT careers, Knowledge Points, Open IT Forum

Problems with DB2 program
I have a COBOL program that calls a db2 stored proc program. I get corrupted o/p records when reading the input file from CARTRIDGE. The same records, when copied to DASD, come out fine. Same code, JCL, etc. WTH! Is there a parameter that I need to pass to the system with PGM=IKJEFT01 to solve [...]

Answer Question   |  January 26, 2011  3:49 AM
AS/400 Parameters, COBOL, DB2, DB2 administration

Upgrading for database structure
hello everyone  Maybe my previous question was not the correct question to ask. I am in the middle of making an application upgrade which includes DB structure upgrade with keeping Data “data loss is not accepted here”. I have a complex DB structure in my application which depends “in some cases heavily depending” on database specific features. [...]

Answer Question   |  January 25, 2011  7:42 AM
Java/J2EE, JBoss application server, MySQL Database, Oracle, SQL Server, SQL Server 2005, WebLogic Server, WebSphere Application Server

Cumulative totals in Access 2003
I need to be able to calculate cumulative totals on groups of data in a query. Specifically I have a list of repair order numbers with associated part numbers required, dates the order was placed and the amount of the part needed for the repair. I need to be able to calculate a running cumulative [...]

Answer Question   |  July 12, 2011  1:01 PM
Access 2003, Access 2003 forms, Access Database, Access query

Application Upgrade and Data migration
Hello Sir/Mam We have a web application that has an intensive usage of Database operations. This application of course has some sort of sophisticated Database (tables, indexes, …)  structure according to Database engine used.  My question now is , what is the best practice to migrate old database structure to new one “including data of [...]

Answer Question   |  January 24, 2011  11:29 AM
Database, Development, Oracle, SQL Server, Web application development

Change password through JDBC
hi can any one help me .. how to change a password reset/ change password through JDBC connections specifications: 1)we are going to change password from front end URL 2)we need to connect through Db2 database through JDBC connections

Answer Question   |  January 25, 2011  10:19 AM
DB2, Java, Java Database, Java developers, JDBC

Sybase to Oracle
If I move a database from Sybase to Oracle with no coding changes what is the impact on the target database with respect to CPU, Memory, IO, etc?  Note that the OS will go from Solaris to LINUX also. 

Answer Question   |  January 21, 2011  4:18 PM
Linux, Oracle, Oracle Database, Solaris, Sybase, Sybase Databases

Database management advice
im an it student from tanzania currently im an intern in one of the united nation org. but im only doing user support activities. but i want to build my carrier in database management may  u give me some advice on where to start and what to study. ms ashura from tanzania

Answer Question   |  March 6, 2012  6:07 AM
Database management, Database Management Systems, IT careers

Excel 2007 – creating a graph from CSV data with a macro
I want to create a macro that will take a CSV file and remove the same columns each time. BUT the number of rows can vary.  Can I create a macro that will create a grapgh ? The problem is, like i said before, the number of rows can vary each time but the number [...]

Answer Question   |  January 26, 2011  4:31 PM
CSV, Excel 2007, Excel 2007 macros, Windows XP

NOC engineer career
Career confusion?? Hi, I am a trainedin mcse,ccna guy but being a fresher did not find one job in networking field. I came across this opening of NOC Engineer – solaris at a company and they are hiring freshers, I got the job as NOC engineer, I have not much knowledge about linux/solaris but they [...]

Answer Question   |  February 10, 2011  6:46 AM
CCNA, CCNA Certification, IT careers, MCSE

Converting from Access 2003 to Access 2007
hi, everyone i have 3 desktop with Access: one have Access 2003 two of them have Acess 2007 so i divide my Access database in two parts on of them have tables an other a form queries, etc. My problem is, is possible link tables for these three desktop’s. because of that diference i convert [...]

Answer Question   |  January 17, 2011  5:05 PM
Access, Access 2003, Access 2007, Access Database

Virtualize SCO OpenServer 5.0.6
Hi, [span title=”Clique para obter traduções alternativas” class=”hps”>I [span title=”Clique para obter traduções alternativas” class=”hps”>recently inherited an old machine with [span title=”Clique para obter traduções alternativas” class=”hps”>SCO OpenServer [span title=”Clique para obter traduções alternativas” class=”hps”>5.0.6 that is working with some Informix application and DB’s for which I don’t have the sources.   Since the hardware [...]

Answer Question   |  July 12, 2011  11:13 PM
Informix, RAID 1, Server virtualization, Virtualization

IT Knowledge Exchange’s iPad Contest Starts Today!
Today marks a new contest around IT Knowledge Exchange. The Lowdown (i.e. The Rules**) Every member who earns 500 knowledge points in the next 4 weeks (between today and Wednesday, February 16th) will be entered into a drawing for 5 names. You must have a completed profile including a photo or avatar to be eligible [...]

Answer Question   |  January 20, 2011  4:55 PM
AS/400, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, iPads, ITKE Contests, Linux, Lotus Domino, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows, Windows Server

The future of PHP
Big companies are not working in php. so what is the future of php?

Answer Question   |  January 14, 2011  5:13 AM
MySQL, Open IT Forum, PHP, PHP Coding

Rename file in CL
Hi all. I need to check if the file exist, and rename it. t How do I check file existing in CL? Thank you.

Answer Question   |  January 12, 2011  10:08 PM
CL Procedure, CL Program, RENAME statement

Sending -/+ Number from VB.NET to COBOL
Is it possible for someone on the VB.NET side to send a -120 to a COBOL program? The COBOL program LINKAGE SECTION is WS-AMOUNT PIC S9(3). The only way I got it to work is having the VB.NET person to send “12}” in char field. Just figured there was a way they could send like [...]

Answer Question   |  January 13, 2011  8:20 PM
COBOL, OLE DB, VB.NET, Visual Basic, Visual Basic .NET

Creating Access Form
I have a table where I want to query partial phrases or words and cannot figure out a simple way to accomplish this. I used the brackets [] in the underlying query but cannot figure out an easy way to retrieve data with partial info.

Answer Question   |  January 10, 2011  7:37 PM
Access Database, Access forms, Access Forms Database, Access query

Alter proc to fetch a table structure from SQL Server 2005 database
hi please segest me… what is the problem in this proc. CREATE Procedure sp_tab @tablename nvarchar(517), @flags int = 0, @orderby nvarchar(10) = null, @flags2 int = 0 As if @flags is null select @flags = 0 if (@tablename = N’?') begin print N” print N’Usage: sp_table_struct @tablename, @flags int = 0′ print N’ where [...]

Answer Question   |  January 7, 2011  9:59 AM
FETCH statement, SQL 2005, SQL 2005 Database, SQL Server 2005, SQL Server tables

Create “if then” formula in Access 2003
Hello, I’m new with access. I have a table with article numbers in one column. and intro and outro dates in 6 columns. the intro and outro dates come from 3 tables, so that’s why the 6 columns (2 columns per table) However, I would like to combine the six columns into 2 columns, one [...]

Answer Question   |  August 17, 2011  8:41 AM
Access 2003, Access 2003 date query, Access 2003 forms, Access forms