Database Management Systems

- DB2 - RPG

My question has two parts: 1- Is there any way to create DB2 at a PC similar to what is exist at IBM I-Series AS/400? 2- Is there any RPG Compiler that I can install and run it and PC?

Importing Data in SQL Server 2000. "Integrity violation error" in RowID column

Hi All, I have a table called Employees(RowID,EmpNo, Lastname, Firstname). Here RowID is autogenerated by the system. It is the primary key and DOES NOT allow NULL values. I CANNOT change the table structure. I am trying to import data from a text file through the Import Data Wizard in...

loading csv files into Oracle tables

THE ANSWER TO THE QUESTION POSED BELOW INDICATES THAT CSV FILES CAN BE LOADED INTO ORACLE DATABASES. DOES ANYONE KNOW HOW THIS PROCESS WORKS? WHICH TABLES DO I LOAD FOR THE VARIOUS APPLICATIONS? FOR EXAMPLE, IF I WANTED TO LOAD INVOICES INTO AN AP APPLICATION, WHICH TABLES WOULD I LOAD AND WHAT...

access website from as/400

Our as/400 is accessable from the internet. How can we assess a website from a command line or a CL program on the as/400?

Exporting Data to Text/CSV file in SQL Server 6.5

Hi, I would like to know how do we Export Data to Text/CSV file in SQL Server 6.5 Do we have something similar to DTS in SQL Server 2000? Thanks, Kruti

migration from 2000 to 2003 using ADMT v 2.0

We have multiple forests in our organisation.We are now planning to consolidate them into a single forest and a single domain.We have more than 200 different sites spread all across the world. We have now upgraded all our domain controllers to 2000 and 2003 servers.We have a proper test lab being...

SQL Server equivalent of Oracle's desc tablename command

Thank you all for the response to my previous query. What is the T-SQL equivalent of Oracle's desc command? I mean, what is the command in T-SQL to see the structure of a particular table? And what do we do in T-SQL if we want to see list of all the tables in a particular database?

Difference between SQL and T-SQL(Microsoft SQL Server 2000)

What is the difference between SQL and T-SQL(used by Microsoft SQL Server 2000)?

Oracle ./runInstaller problem

Dear Oracle Experts, I came across the following problem when trying to update my Oracle 9.2 to Oracle 9.2.0.4 When I typed > ./runInstaller for the Oracle 9.2.0.4 patch. I get the following error. "You do not have permission to write to the inventory /oracle/product/db/920/$ORACLE_HOME....

To go with RDBMS or OODBMS for a database to store textual excerpts

Hello, I am currently designing a database to store textual excerpts: quotations from certain genres of literature will be stored. Relations will exist between different types of quotes and quotes and their topic sentences etc. I am deliberating on whether to use an RDBMS or an OODBMS for this...

Convert date format from UTC to PST in SQL

HI Friends Is there any way to convert date format from UTC to PST? Thanks and Regards Ashu

Installation of Oracle9i client

How to install Oracle9i client to c:program filesoracle and not to c:oracle on Windows Server 2003?

CLOB - Fetch out of sequence

I am inserting into a table which has a CLOB field. I insert a blank_clob and then try and retrieve the clob field again directly after insert. When I execute the select to retrieve the CLOB field I am getting ORA-01002: fetch out of sequence. The query looks like: select XML_DATA from XML_TABLE...

F22 key on AS/400

Hello everyone, we have a couple of acountants onsite at a clients, and they are using an AS/400, they need to know how to access the F22 key, is this depending on the emulator they are using? or is there a way to access it?

Slow File sharing access in Win 98-2

Actually I have 2 questions: I have a small workgroup of 3 XP Pro systems, 2 win98 systems, 1 win 2000 server and a 16 port ethernet switch(100mbps). I have enabled the ICS in the server and each compter can access files/printers and internet with the help of DHCP. 1) When I access the win98...

Slow File sharing access in Win 98

Actually I have 2 questions: I have a small workgroup of 3 XP Pro systems, 2 win98 systems, 1 win 2000 server and a 16 port ethernet switch(100mbps). I have enabled the ICS in the server and each compter can access files/printers and internet with the help of DHCP. 1) When I access the win98...

Table Migration

I need to migrate Oracle8i table on Unix OS to Oracle9i on Window OS. Table and contents. 24x7 operation. Please Help!!!!!!! New DBA

Deleting journal receivers

HI, When I try to delete a journal receiver that hasn't been saved, I get the "never fully saved" message even though I'm using DLTOPT(*IGNINQMSG) Does anyone have a piece of code that will get rid of receivers no matter what? E.G. not saved, remote, attached...... Thanks

Database choice for web application

I am building web applications, using ASP.NET, each of which must store/retrieve data to/from a set of central databases. I basically have a choice between using MS Access or SQL Server and could use some advice about which to go for or what criteria to apply. Bear in mind that there will be...

Slow boot-up in win xp home edition

My notebook(40gb HDD, 256mb RAM)with win xp home edition has become dramatically slow in last 1-2 months. It takes more than 5 minutes to boot even after I removed everything from startup group using msconfig. The initial screen (win XP home) stays atleast 2-3minutes. How can I manage this? Is...