Integrating MS Outlook With iSeries
I have been asked to display a calendar such as what Outlook has showing dates of events that are stored in the AS400. Just to complicate things, the users would also like to reschedule appointments so we need to update the AS400! (I may be able to talk them out of this) Does anyone have [...]

Answer Question   |  July 13, 2010  5:30 AM
AS/400 date format, Data/Application Integration, iSeries V6R1, Outlook Calendars

Data Sources for SSAS 2000
I have a short term issue where I will need a SSAS2000 cube to be using data from a SQLServer2005 database. Can I do this directly? If not, can I Export MSSS2005 data directly to the MSSS2000 database? (Sorry for such a simple question- I am a newbie).

Answer Question   |  June 12, 2008  2:14 PM
Data warehousing applications, Data/Application Integration, Database, SQL Server 2005, SSAS 2000

‘m trying to verify that a SQL DATABASE is empty ,
I am modifying a VB program that is taking ALL the tables from an ACCESS Database and converting them to a SQL DATABASE. They VB Program opens the SQL DATABASE, but I want to verify the database is completely empty. Is there a function or call that can be added to the code??

Answer Question   |  February 8, 2008  7:12 PM
Data/Application Integration, Database, SQL

Count distinct rows on multiple columns
I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00 Dollars 104 Sarah 010C [...]

Answer Question   |  April 19, 2013  8:23 PM
Access, Data/Application Integration, Database, DB2, Desktops, Development, Management, Microsoft Windows, Oracle, Oracle Business Applications, Oracle development, OS, PeopleSoft, Programming Languages, Security, Servers, SQL, SQL Server, T-SQL, Windows

XML Publisher with Shipping Docs
We are trying to use rtf Templates for our shipping docs. When we launch the concurrent request individually they work great. But when we use Ship confirm (which launches the doc set automatically) the xml is generated but the pdf format is not. Looking at the submitted requests, the layout has not been applied so [...]

Answer Question   |  October 30, 2007  9:27 AM
Business Intelligence, Data/Application Integration, Oracle, Oracle development, XML

XML Publisher Issue
We can’t output a concurrent request via XML Publisher… We can create data definitions and link data templates (.rtf files) through the app, when we attach a data.xml preview file, we can preview the output correctly. When we actually attempt to run the concurrent request, the output shows the actual XML data, not the formatted [...]

Answer Question   |  December 4, 2006  3:09 PM
Business Intelligence, Data/Application Integration, Oracle, Oracle development, XML

ORA-12535
My database runs on 9i.There are remote databases that connected to it.Today all of them are failing to connect because of the error message ora-12535.I increased the CONNECT_TIMEOUT but error still persists.I even set it to zero (0) and the system hangs indefinately.tnsping to these remote databases is successful.Local users connected directly to the Live [...]

Answer Question   |  October 27, 2006  5:44 AM
Architecture/Design, Availability, Data/Application Integration, Oracle 9i, Performance/Tuning, Windows

Urgent Help: web-Forms 6i don’t work after Upgrading the db from 8i to 10g
Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we’re using now for the server B the alias we’ve used for [...]

Answer Question   |  November 1, 2006  11:28 AM
Architecture/Design, Backup & recovery, Data/Application Integration, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, SQL, Tech support, Windows

SQL update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.
Please I need an SQL command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype. My Oracle database is on Windows 2003 environment. Eg: The row in question reads ’063150987′ and I want to replace the fourth and [...]

Answer Question   |  April 19, 2013  11:26 AM
Data/Application Integration, Database, DB2, Oracle, Oracle 9i, Oracle administration, Oracle Business Applications, SQL

Running a script at specified runtime
I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks

Answer Question   |  July 11, 2006  12:23 PM
Architecture/Design, Availability, Backup & recovery, Business Intelligence, Data/Application Integration, E-Business Suite, Installation, Migration, Oracle, Oracle 9i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, Security, SQL, Windows