Hyperion Business Rules Error with XP
We have recently gone on to XP and now we cannot connect to the Hyperion Business Rules designer. The error message is: You are unable to login to the server. com.ms.com.ComError: oracle/jdbc/driver/OracleDriver

Answer Question   |  January 25, 2008  10:04 AM
Drivers, error, Hyperion

DDS or SQL
We have an existing COBOL application using files defined in DDS format. We are considering to move from DDS to DDL for future development. What is the best strategy to take this approach?

Answer Question   |  January 24, 2008  8:52 PM
COBOL, DDL, DDS, SQL

Binary Field
How do I populate a binary field (field length of 9), buffer length of 4, with the value 10002- (right justified) I need to do this in an existing RPG ILE program. Help ?

Answer Question   |  January 23, 2008  8:48 PM
Binary fields, RPG ILE

Oracle 9i how to create dictionary managed tablespace
Hi, How can i create database with SYSTEM as dictionary-managed in Oracle 9i?. DBCA creates by default a database with locally managed system tablespace. How can i change it? Thanks in advance.

Answer Question   |  January 24, 2008  2:06 PM
Database, DBCA, Oracle 9i

Excel Formatting for 2007 Version
Hi. I have created a template form for our firms use. I was hoping that I could find a way to VIEW certain cells in a color of my choosing, but if I were to print the sheet, it would only print the text as usual in black and print no background colors as they [...]

Answer Question   |  November 25, 2008  9:49 PM
Database, Development, Microsoft Office

HOW TO INCLUDE LOG IN INFORMATION IN AN SQL SCRIPT
Please I have an SQL update statement which I want to put in an SQL script which users can run to update an oracle9i database running on a windows 2003 server.The statement is as follows: update jobs set JOBSTATE = 3 where APPID = 5 ; COMMIT; Exit I do not want users to be [...]

Answer Question   |  January 23, 2008  12:06 PM
Database, Oracle, Oracle 9i, Scripting, SQL, Windows Server 2003

Need your help with sql joins
Hi there, I have two tables named articles and writers. articles table looks like this : article_id writer_id translator_id article_text writers table looks like this: id writer_name date_joined A few of the articles could be translated but mostly self written articles. The writer_id and translator_id are from writers table. A writer could write an article [...]

Answer Question   |  January 22, 2008  8:33 PM
MySQL

ms acess trouble
i am having trouble with my vb programs. I have several vb programs that make data reports from access datatables. All of a sudden my datareports will not update until i close my program and reopen it. Any help would be greatly appreciated.

Answer Question   |  June 18, 2012  8:39 AM
Microsoft Access, VB

convert a query from access to sql server 2005
Ive recently been given the task of converting an application from an Access database to sql server 2005. One of the queries has this on the ORDER BY Clause ORDER BY not isdate(Obsolete), not isdate(not_relevant), isdate(assessed), isdate(published), isdate(implemented), not locally_adapted, guidanceType DESC, nice_ref DESC this wont work on sql server. Locally_adpated is a bit column [...]

Answer Question   |  January 29, 2008  3:47 PM
Microsoft Access, SQL Server 2005

How to use subselect in a case statement
Getting error… “Token EXISTS was not valid….” on case statement… ,case when g.GFGSTS = ’2′ and not exists (select a.GFTSEQ from GFTP010 a where a.GFCSQ# = g.GFCSQ# and a.GFGSTS = ’3′ ) then count(*) end as Void#

Answer Question   |  January 17, 2008  3:11 PM
CASE statement, SQL, SQL Subselect

MS Access – Count of parent table items in a report
I have an MS Access database with a parent table and a child table. Table A (the parent, an Order table) has a PartID field, an OrderDate field, and an CustomerID field. Table B (the child, Parts) has a PartID primary key field and a PartDescription field. A relationship joins the 2 tables on the [...]

Answer Question   |  January 18, 2008  8:43 PM
Access, Access multi-table reports, Access reports, Microsoft Access, Multi-table reports

File sort using qshell (this time with tags)
Hi, I’m trying to use qshell to do a sort of a (non-keyed) DB2 database file to remove duplicate records. I use the following command :- sort -u /QSYS.LIB/$1.LIB/$2.FILE/$3.MBR | cat > /QSYS.LIB/$1.LIB/$2.FILE/$3.MBR Where $1 = Library name, $2 = File name, $3 = Member name. The command does a sort, removing duplicate records, and [...]

Answer Question   |  January 16, 2008  3:12 PM
AS/400, Database, DB2, Linux, Qshell, Unix shells

Database connection problem
I am working on a japanese project. the DB is oracle8i. So I am using classes102 and nls_charset10 driver zip files. I am able to connect to db through SQL* but not through code. the error is: java.sql.SQLException: 20 at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:407) at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:152) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:214) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:193) please help me

Answer Question   |  August 28, 2009  4:13 AM
Java Database Connectivity, JDBC, Oracle 8i, SQL

What self study material would land me an Enterprise Architect job?
Which self study material would be beneficial to landing an Enterprise Architect job? I am using the TOGAF Version 8 Enterprise Edition study guide.

Answer Question   |  January 16, 2008  11:21 PM
Careers in networking, IT careers, Job training

Do I have to get an MCP or MCSE before getting into Cisco certifications?
I have been in the telecommunications field for seven years working for cable companies and now AT&T. I am A+ certified and working on Net+. I study a lot on backbone and network protocols ATM, MPLS, SONET, SNMP etc. I am wondering what path to take next. Do I have to get an MCP or [...]

Answer Question   |  January 16, 2008  11:17 PM
Career development, Certifications, Cisco certifications, CompTIA A+, CompTIA Network+, IT, IT careers, MCP, MCSE, Networking, Networking certifications

Access 2007 refrence look up
Ok this question might sound kind of elementary but i just seem to be missing something. I have a drop down box, within that combo box i want to display choices which consist of 3 cap letters then a “-” Then what the letters stand for. when i choose a selection from the combo box [...]

Answer Question   |  January 16, 2008  3:05 PM
Access, Microsoft Access, Microsoft Office, Microsoft Office 2007

oracle calculated item
hi ihave alist of variables some of them calculated from others i recieved them from certain source in certain date and i have alist of indicatores which are calculated from the variables (for the same date,& source) but every indicator has diffrent equation & the user need to modify the equation f needed and define [...]

Answer Question   |  January 14, 2008  1:12 PM
Database Management Systems, DB2, Oracle, Oracle 6i, USE DATABASE

Cannot end RGZPFM on V5R4 (Journaled file)
Batch job RGZPFM on V5R4 not complete after 3 days. I issued an ENDJOB, and job is not completely ended 1.5 days later. The file is journaled and is very large. SBMJOB CMD(RGZPFM FILE(MYLIB/MYFILE) KEYFILE(*NONE) ALWCANCEL(*YES) LOCK(*SHRUPD)) How can I end this job? If MYFILE is damaged, I can delete it and restore it from [...]

Answer Question   |  March 8, 2010  8:22 PM
AS/400, AS/400 performance, DB2 Universal Database, ENDJOB, Journaling (Exchange), Recovery, REUSEDLT, RGZPFM, RPG, V5R4

Data warehouse vs Database
What is the difference between a database and a data warehouse?

Answer Question   |  April 19, 2013  1:40 AM
Data base design, Data warehouse

Logical file
I created a logical file that used a select and values criteria. The file had duplicate records. When I created the same file with a higher security level, the file created without the duplicates. Does anyone know why I would have the duplicate records? The file was deleted ok so it didn’t just append the [...]

Answer Question   |  March 7, 2010  2:02 PM
Database issues, iSeries, Logical File