• Oracle – database link

    I've: -DB "D7" on Oracle 7.3, WinNT4 , Server "S7" -DB "D9" on Oracle 9i, Win2003, Server "S9" -A DB link "DL" in D7 to connect to D9 -Issued "desc TblEmp@DL" from sqlplus in D7 on S7 (TblEmp is a table in D9) When server S9 is UP: Output displayed within a second...so no problem. When server S9 is...

    Pagarkar0 pointsBadges:
  • Converting Upsized MS Access/SQL database and application to ASP.net for the web

    I have no experience wih ASP or web server based applications, but I have an Access program that I need to put on the web. What is the easiest route to full web implementation for a program that is currently using Access as the front end for a 200+GB db? The application needs to be secure. It...

    Rdotson1020 pointsBadges:
  • Remote system calls

    We have several AS/400's and I would like to call a command i.e. HLDJOBQ - holding a JOBQ on machine 'B', from a CLP running on machine 'A'.

    ErnieM0 pointsBadges:
  • Can you suggest an alternative to an IN statement?

    I'm running a query which contains an IN statement and even though the cost of the query is low, the performance is not ideal. Here is the problem: We categorize products by associating the items to branches on a taxonomy tree. Customers are able to browse products by category and in this case, a...

    smford20 pointsBadges:
  • C# sample code for copying a table from oracle to ms sql with ODP.NET needed

    I want to copy a table from an oracle database to a sql server using the odp.net provider. Because I just have the .NET Framework SDK and the Eclipse C#-PlugIn it is very difficult for me to figure out how I can code this in detail. I successfully read from an oracle table with a datareader object...

    Mt690 pointsBadges:
  • Extracting records from Oracle based on a created time of a Unix file

    I wish to extract updated records from an Oracle database using a scheduled PL/SQL based procedure run every 15 minutes. The last updated date/time is stored in a column, I am currently comparing using last_upd > (SYSDATE - 15/1440). However this meand that is the job fails and is re-run, some...

    TaliesinUK15 pointsBadges:
  • Data dictionary find time of long running query

    Howdi All, I'm trying to figure out a way to find queries running longer than X minutes in the data dictionary. It's been difficult to limit it to a specific query. Sessions are no problem. Here's the latest query I've come up with. SELECT sess.status, sess.username, sess.machine, sess.program,...

    Tmjimob0 pointsBadges:
  • PRM business case

    Building a PRM business case. Need help gathering case studies or silver bullets for implementing a PRM solution before rapidly expanding channel business becomes unbearable

    Simonsmind0 pointsBadges:
  • Client Access File Transfer in CL Program

    I have about 200 files to transfer from i series to our shared pc drive in .xls format each month. There's got to be a way to automate this is a cl program. I've tried the call to RTOPCB in the STRPCCMD command but can't get it to work. When I run the command I don't get any error messages, it just...

    Sasully560 pointsBadges:
  • Manipulating members using CL

    I'm trying to build a CL program that will read a physical file and check the creation date of each member against my criteria. Unfortunately, I have almost zero experience with CL and file handling, so I haven't the foggiest how to manage this. My questions are as follows: 1. Is there some syntax...

    Kyoojin0 pointsBadges:
  • Accessing a MySQL database using Visual Basic.

    I am trying to write an application in Visual Basic and need to connect to a MySQL database running on the same computer. I would like to use a Provider to connect to MySQL rather than use ODBC. The reason being this application will be deployed on 100 computers and I don't want to go to each one...

    Mlakhany0 pointsBadges:
  • Finalize

    Does Finalize on an object trigger in visual studio vb dot net debug mode when the session times out? I set a break point and it never showed up. Any thoughts?

    Ronisaac0 pointsBadges:
  • Datawarehouse building – datamart specification: how would you engage a scattered userbase?

    We are currently building a datawarehouse and will need to engage the customers in order to successfully specify the datamarts, a search functionality, etc. All of the technicalities are scoped and being put in place. The question hence directs itself to successfully engaging the customer base,...

    MrErik0 pointsBadges:
  • database design

    sir, i am developing the order-process mgt (3-tier intranet app)using jsp,java,javascript and mysql as backend. i have to store the data from the customer order-sheets. in this business, they organize the garments(product) according to the colour.then each color is divided in to sizes like...

    Msuresh270 pointsBadges:
  • Mpeg video streaming problem with Windows Media Player

    I have two mpeg video files on a web site (http://petrolrem.com). The problem is with Window Media Player and streaming the video file over the Internet. The Windows Media player plays the entire mpeg movie on a local machince but does not play the whole movie over the Internet from the web site....

    Bwconley0 pointsBadges:
  • Grpahs/Charts

    I am looking for a fast, free method to create graphs for a web page using javascript,java, html or applet or any thing that will work on a web page

    Domino6Hang0 pointsBadges:
  • Norton Antivirus/Internet Security 2005

    I have received several calls from users that their upgrade of Norton Antivirus or Internet Security 2005 fails. The natural reaction I had was to uninstall the previous version and install 2005. However after the 2005 upgrade even though the previous version is listed in Add/Remove programs, the...

    MCScrapE0 pointsBadges:
  • database design-2

    sir, i am developing the order-process mgt (3-tier intranet app)using jsp,java,javascript and mysql as backend. i have to store the data from the customer order-sheets. in this business, they organize the garments(product) according to the colour.then each color is divided in to sizes like...

    Msuresh270 pointsBadges:
  • Source code recovery from an object

    How can I recover source code from an object? Is there a utility that will convert an RPGLE *PGM object to an RPGLE source member in QRPGLESRC? Is there a utility that will convert a PRTF *FILE object to a PRTF source member in QDDSSRC? I lost the source for 3 objects during !!!!$%#@ ftp. I have 3...

    JTucker0 pointsBadges:
  • Software Development in Java

    Could someone please advise me (and my team) on which development tools and resources to use for rapid development of java (or java-based) business software packages such as inventory management systems, payroll packages etc. We have been developing using Oracle 6i Developer suite and now intend to...

    Tendy770 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following