Automatically Force User Disconnects via Scheduled Script
Greetings all … What is the most efficient automated script-based approach to terminate user connections for “particular” databases? Where: 1. Know name of database(s) 2. Know name of user(s) 3. Do not know name of user(s) 4. Server must always remain in production and user(s) must not be disconnected from other databases Thanks in advance.

Answer Question   |  May 16, 2005  12:09 PM
Backup & recovery, Database Management Systems, Security, SQL Server

Restoring a dtaq in iseries.
I need to know if there is a way to save a data queue with some entries in it, and then restore the data queue in the same or other library with its entries included. When i do that, the dtaq is empty. If someone knows how to do that, please tell me. Thanks.

Answer Question   |  October 25, 2009  6:08 PM
AS/400, Database Management Systems, DataCenter, DB2, Development, Hardware

Transfer Report from AS/400 to PC
Is there any utilities/tools that can help me to create a program on AS/400 (CL program) to transfer the reports that are created at a certain output queue on AS/400, transfer them automatically to a specific folder at PC side so as to be opened with any application at MS Windows, keeping the Layout(View) of [...]

Answer Question   |  October 24, 2010  10:30 AM
AS/400, Call Centers, Data analysis, Data mining/analysis, Data warehousing applications, Database Management Systems, DataCenter, Development, ERP, Exchange, Hardware, Help Desk, IBM, Knowledge management applications, Lifecycle development, Servers, Software, Tech support, Third-party services, Vendor support

Oracle 9i Query Time
What would be an expected time to run a query that will extract 1.4 million records? There are two tables involved. Customer and Address. And No Condition.

Answer Question   |  May 6, 2005  11:45 AM
Database issues, Database Management Systems, in use in organization, Oracle, s, Total size of the database, Very Large Databases

Inserting data into a vargraphic data type field
How to insert data into a vargraphic data type field. I have done the following CREATE TABLE TEST_TABLE (FLD1 VARGRAPHIC(20)) This is done succesfully INSERT INTO TEST_TABLE VALUES(‘TEST’) This gives a SQL error Please let me know how I can acheive it.

Answer Question   |  May 4, 2005  9:44 AM
Application software, Data center operations, Database Management Systems, DataCenter, DB2, DB2 administration, DB2 Everyplace, Development, Hardware, Help Desk, IT architecture, Migration, Modeling, Operating system platforms, Services, Tech support, Third-party services, UDB for iSeries/i5, Vendor support

Folders on AS/400
Whenever I try to access folders on the AS/400 using the WRKFLR command I get an MCH3601 error message. I need to be able to access the data in the folders to process the data in a PC application.

Answer Question   |  May 8, 2005  3:06 PM
Database Management Systems, Exchange, Hardware

DATABASE RECOVERY , WINDOWS 2000 , ORACLE 10G
Hi Brian, I am a student at West Virgibia University, and manage a database with tables. My problem is that my system has crashed, I can get it up and running but on a different partition, so that my files are intact on the original partition, but my database wont run, because it was installed [...]

Answer Question   |  May 24, 2005  4:25 PM
Database Management Systems, Microsoft Windows, Oracle, Oracle 10g

I am sending some zipped files to a server, using IBM FTP CS V1R4(exec pgm=ftp). Is it possible to FTP a file in PDF format or some other more printable format than text?
I am sending some zipped files to a server, using IBM FTP CS V1R4(exec pgm=ftp). I am executing cobol and ftp programs…Is there any possibility of returning the reports as PDF files (or some other more printable format than text). I mean when a user opens a zipped file they want to see PDF file, [...]

Answer Question   |  July 9, 2005  1:23 PM
Application software, Centrinity, COBOL, Database Management Systems, DataCenter, Development, E-mail applications, ERP, Exchange, Filemaker, HP OpenMail, Implementation, IT architecture, Knowledge management applications, Lifecycle development, Microsoft Windows, Planning, REXX, Sendmail, Software Quality Assurance

- 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?

Answer Question   |  April 14, 2005  9:15 AM
Business Objects, CA Ingres, Cognos, Data analysis, Data Junction, Data mining/analysis, Data warehousing applications, Database Management Systems, Development, Hardware, IBM, Information Builders, Instant Messaging, Microsoft Access, Microsoft Windows, MySQL, Servers, Software

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 the Enterprise Manager. The textfile [...]

Answer Question   |  April 8, 2005  7:18 PM
Database Management Systems, MySQL, Oracle

Loading CSV files into Oracle tables
I want to load data from the Microsoft Excel sheet to my Oracle 8i database. Can I achieve this using TOAD? This question posed on 10 March 2005 You cannot use TOAD to move your data from MS Excel to Oracle. You can save the Excel spreadsheet as a comma-separated-values (CSV) or text file. Then [...]

Answer Question   |  April 19, 2013  11:46 AM
Corporate Financial Applications, Database Management Systems, ERP, Financials, Human resource applications, Informix, iReceivables, Microsoft Access, Oracle, Payables, Procurement, Projects

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?

Answer Question   |  April 26, 2005  4:59 PM
AS/400, Data analysis, Database Management Systems, Development, Hardware, Web development tools

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

Answer Question   |  March 24, 2005  3:37 PM
Database Management Systems, SQL Server

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 setup for performining all [...]

Answer Question   |  March 16, 2005  6:32 AM
Data center operations, Database Management Systems, DataCenter, Disaster Recovery, Hardware, Microsoft Operations Manager, Servers, Systems management software, Tech support, Windows, Windows 2000 Server, Windows Server 2003, Windows tools/WSRM

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 [...]

Answer Question   |  March 17, 2005  2:13 PM
Database Management Systems, MySQL, Oracle, SQL Server

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)?

Answer Question   |  March 15, 2005  9:25 AM
Database Management Systems, DataCenter, MySQL, SQL Server

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. Installation cannot continue.: Permission denied” The following environment are set [...]

Answer Question   |  March 25, 2005  11:19 PM
Database Management Systems, Oracle, Oracle 9i, Standard Edition

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 project. I have read about the [...]

Answer Question   |  March 16, 2005  6:07 AM
Database Management Systems

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

Answer Question   |  March 10, 2005  3:30 AM
Database Management Systems, SQL Server, Standard Edition 2000, T-SQL

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

Answer Question   |  March 10, 2005  2:24 AM
Database Management Systems, Oracle