• Parsing string from a single column to multiple columns (address data)

    I have TEMP_TBL which I am using as a staging area to clean up data before inserting it into EMPLOYEE table. One of my big issues is with the column ADDRESS which contains all address components. I need to parse out the address components into the following columns: STREET1, STREET2, CITY, STATE,...

    Tinatsunami0 pointsBadges:
  • Sage/MIP Server Printing Problems

    hi! i have a problem of course. my financial department uses Sage Software/MIP from our windows 2003 server. suddenly, all the accountants are not able to print any checks from MIP. or print anything from MIP for that matter. although the printers will print from MS Word or do a print test page....

    Thecheyguy0 pointsBadges:
  • Configuring isql *plus

    Hi, I want to configure isql *plus in my oracle server. Can any one give me the configuration steps to invoke the isql * plus in my oracle server. Thanks in advance, Regards, P. Karthik

    Oraworld0 pointsBadges:
  • server components do not install !

    hi i tried to install ms sql server 2005 enterprise edition on win xp media center,but it doesn't install server components,and when installed,it doesn't find any server on my computer , and mycomputernameSQLEXPRESS do not work . but my friends installed the same version of ms sql server,on the...

    Sadegh0 pointsBadges:
  • inserts through a database link

    Hello every body. Here I go again... Do you know if there is a restriction about performing inserts through a database link ? We are experiencing the following situation: We have two Oracle 8i instances running on a win 2k3 server, and a Forms applications needs to insert data from one instance to...

    carlosdl70,220 pointsBadges:
  • Difference between length and vsize functions

    Hi I have got same results for both the vsize and length functions. Why the two functions are giving the same result? Can any one clarify this? Thanks in advance, Regards, P. Karthik

    Oraworld0 pointsBadges:
  • Using optimizer hints in Forms

    Hello everybody. A few weeks ago I posted a question about Sql Tuning in Oracle, and I have been experimenting with optimizer hints and execution plans (all this in Sql Plus), but now, a doubt arises to me. Can I use the optimizer hints in Forms 6i (program units or triggers) ? Since they look like...

    carlosdl70,220 pointsBadges:
  • ISeries ODBC Error SQL0104 using DB2 UDB (Replicating Notes data to AS/400)

    Does anyone know why I get these ODBC errors or what these errors mean while trying to replicate some fields in Notes to a db on the AS/400 Rel 5.2? Starting Replication: REP_POTEST101 03/23/2006 08:00:34 AM Replicating Documents from <LNK_PURCHREQ.NSF: test POReq> to...

    huskymom0 pointsBadges:
  • Start-up Needed for DB design for workflow for BPO company

    Can any one give some usefull and urgent tips about database design example where i get for designing BPO company work flow parts...

    Malaikanirr0 pointsBadges:
  • PL/SQL REF CURSOR

    Hi, In the ORACLE DATABASE 10G: DEVELOP PL/SQL PROGRAM UNITS Student Guide, Volume 1, (in case anyone has the book), the following code example is on page 6-12: CREATE FUNCTION annual_sal(emp_id NUMBER) RETURN NUMBER IS plsql varchar2(200) := 'DECLARE '|| ' emprec employees%ROWTYPE; '|| 'BEGIN '||...

    Midolci0 pointsBadges:
  • SQL Database update of “char” field

    Hi, I need to update a field (datatype "char") in the SQL database. The field contains a network path, e.g. S:OfficeData... which needs to be changed to e.g. S:DataSheets... I have tried a number of options but ran into problems because of the data type, etc. Thanks!

    Renetjie0 pointsBadges:
  • Doubts regarding speed in data access

    y name is Yahya. I am working as a Project Leader in an IT Industry in India I am working on a new project with J2EE technology. I am using Weblogic Application Server and Iplanet Web server for this project. It is for a bank. I will have to write a program in the server which will read a text...

    Cmyahya0 pointsBadges:
  • Message 8163 – Trying to remove duplicate rows.

    I am trying to remove duplicate rows with the following SQL: SELECT DISTINCT r.ReqName AS "Requirement Name", r.ReqDescription AS "Requirement Description", r.ReqID AS "Requirement ID", r.ReqReviewed AS "Requirement Reviewed", r.ReqCoverageStatus AS "Requirement Coverage Status", t.TestName AS...

    Captnskirk0 pointsBadges:
  • Replicating data between I-series and Ms-CRM using Scribe?

    We are implementing MS-CRM on an Ms-SQL server. We need to replicate data from our business system (I-Series) to CRM, and similarly from MS-CRM to I-Series. Our Ms-CRM provider proposes using a product called Scribe to do this but has no experience of using this with I-series. Has anyone used...

    Peterax0 pointsBadges:
  • backup on standby

    Hi, We have a DR site about 1000km away from our primary site, so full backups of the databases can' be shipped on WAN (size @ 13gb). Hence I want to take backup on standby server. We have configured log shipping. Is it possible to stop log shipping for some time, open standby database in normal...

    Indobob0 pointsBadges:
  • Update does not work in stored procedure

    I have an update statement that works fine straight up, but fails when included in a stored procedure. Can you help? SET Deny_Cd = (SELECT Deny_Code FROM CPSA_CIS_Edit_Processing WHERE claim = x.Claim AND Edit_Code = (SELECT...

    CaKars0 pointsBadges:
  • Filegroups in SQL Server

    I have created many filegroups for each of my databases in SQL Server. Now I am moving to a different server.I have backed up all the databases of this existing server of mine. If I delete these filegroups then will I be able to recover these backed up databases? Or do I need to backup these files...

    Bakash0 pointsBadges:
  • adding partition to existing non-partitioned table

    Hello all! I have a tables without partitions and I now want to partition it. How do I go about this? I tired alter table ... add partition... but it errors with "ORA-14501: object is not partitioned " So I tried to re-create the table with partitions: create table quote_header_test as select *...

    Skovac0 pointsBadges:
  • Passing parameters from .ASP (VBSript) to Activex object in date format

    I have inherited the following: <%@ LANGUAGE="VBSCRIPT" %> <% dim adoconn set adoconn = server.createobject("adodb.connection") adoconn.open Application("DSN"),Application("UID"),Application("PWD") reportname = "traininghrsbyemployee.rpt" If Not IsObject (session("oApp")) Then Set...

    Avdberg0 pointsBadges:
  • generate calender with SQL or PL/SQL

    I am trying to create a calender with people in a department, which must be printed monthly by the department head. The user must enter the month and department and calender must be generated and printed. I want to know if this is possible with SQL. I tried a few options, but cannot get the dates...

    Ws8oBPSQ15 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following