• 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:
  • AMD vs. Intel: Data Warehouse Servers and Consolidated Database Servers …

    Hello everyone, Hope all is well ... Any help, opinions, direction to whitepapers, benchmarch reports, overkill/underkill comments, and the like would be greatly appreciated: We are in the process of spec'ing out hardware needs for our targeted new data warehouse and new consolidated database...

    Ericggordon0 pointsBadges:
  • DataBase Administration

    Hello everybody. We have an Oracle 8i DataBase of aprox. 30 GigaBytes. There are 3 big tables using about 50 % of that space, and our DBA is planning to move these tables to another database, to make the administration and backup procedure easier... but I'm not sure about that. Is that a good idea...

    carlosdl68,710 pointsBadges:
  • Developer to Data Architect

    Hi, I am currently working in Java/J2EE technologies and Oracle Technologies. I have very good knowledge of Oracle (SQL, PL/SQL and Performance Tuning). I want to tune my career as a Data Architect in the current Application. Please, guide me in this aspect. Regards, Viswanath

    Viswanatharaju0 pointsBadges:
  • read only user

    I've got an Oracle 9.2.0.5 database and I need to create a read only user that can view any table, view, package, etc. I've created the user but I can't figure out how to give it read only access to packages, procedures and functions. The only option seems to be granting execute any procedure. I...

    Skovac0 pointsBadges:
  • Educating database users

    Database administrators must always be prepared to handle users' database problems and concerns -- even if those users are quick to blame for every small thing that goes wrong and rarely praise when big things go right. It may be a lack of education; users just don't understand the work involved...

    RobynLorusso230 pointsBadges:
  • Oracle SQL – convert rows in a table to columns in a query

    Please forgive me for being longwinded. I am trying to pull data from 2 tables, there is a courseid field that is the primary key linking the tables. The first table contains the demographic and course name, the second table contains some detail information for the course - mainly number of...

    Aaron251770 pointsBadges:
  • Creating a destination file for exportation of MS Sql Server data

    I wish to create a csv file and import data into it, on a regular basis. I wish for the TSQL statement or DTS to create a new and uniquely identifiablecsv file(with specific text)each time the process is run. Anytime I have done something similar I have have to create a csv file with a static file...

    Stuey050 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