Oracle 9i migration
How to migrate Oracle 9i from Windows 2000 server to Solaris and vice-versa?

Answer Question   |  August 3, 2009  6:26 AM
Database migration, Oracle 9i migration, Oracle interoperability, Oracle migration, Oracle on Solaris, Oracle on Windows 2000 Server

Database connectivity from Oracle Forms
We are having a legacy running running on Oracle Forms and Reports. I want to change the database connection to point to a different database, how do I do that? P.S: I am pretty new to forms and reports

Answer Question   |  April 18, 2012  9:17 AM
Database connectivity, Legacy applications, Oracle connectivity, Oracle Forms

QYKMIMPK Usage
Sorry if this shows up more than once, first time poster and I’m a tad confused about how to get my question to appear under a specific category. I’m trying to use the iSeries QYKMIMPK api to import a certificate into the *SYSTEM certificate store and encountering error CFPB006, which appears to be a system [...]

Answer Question   |  May 8, 2009  11:42 PM
AS/400, CFPB006, DCM, Import, iSeries, QYKMIMPK

Access IIF Statement Not Returning All Records based on Option Group
I’m using Access 2007 and have a query referencing an Option Group on a Form as a filter. The Option Group has 3 choices: Billable Manhours (value = 1), Non Billable Manhours (value = 2), All Manhours (value = 3). My query statement is: IIf([Forms]![FormName]![OptMHs]=1,True,IIf([Forms]![FormName]![OptMHs]=2,False,???)) When All Manhours is selected (value = 3), I want [...]

Answer Question   |  May 7, 2009  8:39 PM
Access 2007, IIF statement, Microsoft Access

MS Access 2002 Excessive Growth
I have an Access 2002 application that is running VB/DAO to manipulate data and have very few forms. When the application starts its size is about 20,000 KB. After completion of a run 4 hours later, it can grow in size to over 200,000 KB. And as the run progresses, it gets slower and slower [...]

Answer Question   |  April 21, 2012  3:23 PM
Access 2002, DAO, Microsoft Access, Microsoft Access Performance, Visual Basic

DateAdd Function
I have a dateadd function in a query Cdate:DateAdd(“yyyy”,[Length],[StartDate]). I need the year added from how long we give someone to complete certain courses. Example, Lenght = 2, StartDate = 1/2/2007, Cdate = 1/2/2009. This works and that’s not the problem. Now I need to run the query with the criteria stating <[Enter Date]. This [...]

Answer Question   |  May 12, 2009  4:38 PM
Access 2007, Access 2007 functions, DateAdd Function, Microsoft Access

empty fields in a query
I have a column with answers that people responded to different questions about themseleves. I have another column with the question id that the answer corresponds to. i want to display the answers in separate columns based on which question it corresponds to. Each column should be filled with the answers to the specific question. [...]

Answer Question   |  May 8, 2009  4:20 PM
CASE statement, NULL, SQL Query

Tables in DB2 z/OS
In which dataset will I be able to find the default tables of DB2 V9 in Z OS

Answer Question   |  April 26, 2011  4:28 AM
DB2, DB2 Everyplace, Mainframe Datasets, Mobile development, z/OS

Read/Write ability to MSSQL using FoxPro 2.6 for DOS
Hi All My company has a DOS Based Accounting system running under FPD 2.6 for DOS. We have purchased a project planning package that sits on a SQL server. I need to be able to transfer actuals from our DOS (dbase4) accounting data to MSSQL and also read from MSSQL for reporting purposes. Is this [...]

Answer Question   |  May 4, 2009  8:14 PM
FoxPro 2.6, FoxPro 2.6 for DOS, SQL

Dummying a dataset with a concatenated list of datasets
I have an input of 6 contactenated files and I wish to process with just the 4th file in the list. Will dummying the first 3 and last two still pull in the 4th dataset or by dummying the first in the list in effect dummy all of the inputs in the list? Does the [...]

Answer Question   |  August 4, 2010  6:16 PM
Concatenate, Database

A report that works in Crystal Reports client does not work in CMC
Oracle10g / Crystal Reports XIR2 / Central Management Console (CMC) Our Crystal Report fetches the last one week’s data from a big table. This report runs weekly, once. To tune this report, we created another table to maintain the primary key value(numeric sequence), of the latest viewed record. Through a stored procedure, we fetch this [...]

Answer Question   |  May 4, 2009  9:33 AM
Central Management Console, Crystal Reports XI, Oracle 10g, Primary keys

I want to select months from Jan to Dec using SQL query
I want to select months from January to December using SQL query. I will use this for list item note:- without using PL/SQL and less union.

Answer Question   |  April 19, 2013  9:04 AM
SQL development, SQL queries

Different Results on Insert Select than Select
I’m struggling, along with others, where I’m getting different results when doing an Insert select verses just the select. Lots of joins to get data from various tables. Only want the first record from the uniqfield table so created the tmp_uniqfieldid table with that item fielded, creation_ts thinking it would help matters….. Here is the [...]

Answer Question   |  May 4, 2009  11:36 PM
INSERT SELECT statement, SELECT statement, SQL, SQL query optimization, SQL statements

I want a job in server support can any one help me in this?
Why i am asking like this because today the job selection procrss is totally by reference only. I don’t have any refences. i have 3.7 years exp as desktop support Engineer jointly responsible for server also.

Answer Question   |  May 4, 2009  4:04 PM
IT careers, Support staff, Technical support

Can’t use database within Workgroup with Windows XP clients
I am in charge of 10 computers and a server, I have them all on a workgroup and i can only use the database application installed on the server on the older computers. I try to use the same program on win xp but it says that the program is outside of the local intranet [...]

Answer Question   |  May 1, 2009  10:57 PM
Database connectivity, Database permissions, Windows XP, Windows XP Workgroup, Workgroup

Send email to admin on table update in MySQL
hi, I have to send an email every time table in DB is updated. i have to do this because my anti virus is blocking 25 port. so how it is possible to send an email without unblocking of 25 port

Answer Question   |  April 30, 2009  9:53 AM
MySQL, Port 25, send email by database

Substract two fields SmallDateTime at SQL Server
Hii.. IT Professional Helper, may i asked 1 question and hope IT Professional Helper can help me to answer my question? The Question is : Cm.CommandText = “Update Reminder Set IsDatang = 0, IsValid = 1 Where TglReminder – TglDatangKembali > 7″ Cm.Execute If i get the error : Arithmetic overflow error converting expression to [...]

Answer Question   |  May 3, 2009  2:29 AM
SmallDateTime, SQL Server error messages, SQL Server Query

Automatically generating info into fields
I am working on a databaase in 07 and i have a drop down field with peoples names and i want to when i select their name the next field to automatically generate their phone number. is this possible?

Answer Question   |  April 30, 2009  12:16 AM
Microsoft Access

Microsoft Access database update question
So I have two Access databases that are linked together so that tables on one of the database can be updated offline but can update the main one when needed. I have ran into an issue though where my table isn’t recognizing the linked data from the other tables that it needs to. For this [...]

Answer Question   |  April 30, 2009  3:29 AM
Database programming, Linked database, Microsoft Access

Microsoft Access: Hiding form fields with Null values
Hello, I have a table that has Name F1 F2 F3 F4 Wes x Bob x x Mark x x and so on. Certain names have a check mark “x” and others do not. I need to be able to pull up someones name and see a summary of what they have “x”‘s in. I [...]

Answer Question   |  April 30, 2009  11:22 PM
Access VBA, Microsoft Access, Microsoft Access forms, NULL values, VBA, Visual Basic for Applications