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

Answer Question   |  April 18, 2006  3:21 AM
Database, DB2, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle Database Versions, Oracle development, Oracle Manufacturing, SQL, Windows

Error in Select Statement
I have connected VB to ORACLE by ADODB connection. When I am trying to access data from different schema it?s showing an error message ?[Oracle] [ODBC] [Ora] ORA-01013: User requested cancel of current operation? If I am querying by specifying the data in the field it?s not giving any error. The function I used for [...]

Answer Question   |  April 3, 2006  10:31 AM
Billing and customer care, Billing Support Systems, Career development, Data analysis, Database, DB2, Development, Lifecycle development, Oracle, Project management

Locate DB2 files on the iSeries
Henry wrote in with this question recently: “I work with Window-based platforms and know nothing about the iSeries. I need to locate DB2 files on the iSeries and copy or export them to a Windows XP machine where the data will be used with another application. Also, somewhere in the process, I need to convert [...]

Answer Question   |  March 28, 2006  5:45 PM
DB2 Universal Database

Issuance of CREATE ALIAS
Inna wrote in with this question recently: “Will the issuance of CREATE ALIAS statement lock the actual file member?” Do you know? – Deb Tart, associate editor

Answer Question   |  March 27, 2006  5:41 PM
DB2 Universal Database

System Setting For Created Libraries
Hi Everyone. An odd question, when we create new libraries on the 400 they are automatically flagged in the SETUPBCKUP screens for Daily/Weekly and Monthly backup. Where can I change this attribute for new libraries created on the system? Thanks, Rayden.

Answer Question   |  November 15, 2010  2:29 PM
Application development, AS/400, Backup & recovery, DataCenter, DB2 Universal Database, RPG, RPGLE

Oracle 9i Server and XP Pro
I have installed Oracle Server 9i on a Windows XP machine. It works well when connected to from the same machine. It is not possible to connect to from another machine (Win 2000)using Client 7i or Client 9i or Client 9i, as though the listener wouldn’t work. Is there any known issue with 9i Server [...]

Answer Question   |  March 22, 2006  4:49 AM
Database, DB2, Microsoft Windows, Oracle, Windows

Blocking pop access over http
Dear you, How can I exactly block the following: 1- Hotmail pop access over http 2- Block skype phone calls 3- Block sites like gotomypc.com etc 4- Block internet file share drives like yousendit.com google drive Thank you Kindi

Answer Question   |  March 22, 2006  12:37 AM
Access control, Application security, Browsers, Database, Encryption, Exchange, filtering, Firewalls, Forensics, Incident response, Instant Messaging, Intrusion management, Network security, Secure Coding, Servers, SSL/TLS, VPN, Web security, Wireless

Folder Security
We have a folder containing lots of confidential docs that supposedly accessible to all employees that should have read permission only. They should not be able to Print/Copy/SaveAs/E-Mail and do other docs stuff. Our IT staff had made the folder read only though people could still re-save the files elsewhere and print from there … [...]

Answer Question   |  March 23, 2006  6:54 PM
Application security, backdoors, Current threats, Database, Desktops, Encryption, Exchange, Hacking, human factors, Instant Messaging, Management, Microsoft Windows, Networking, OS, Secure Coding, Security, Servers, Spyware, SQL Server, Trojans, Viruses, worms

using QDBRTVFD to find SQL view create statement
Hello all. Just wanted to know if anyone out there knows how to use QDBRTVFD to retrieve the SQL view create statement. For our update process, I am scanning the customer’s libraries to find buisiness views. When I find them, I want to extract the SQL view create statement (like in DSPFD) and place it [...]

Answer Question   |  December 2, 2009  12:20 PM
Application development, AS/400, CLP, DB2, DB2 Universal Database, RPGLE, Tech support

Mainframe to SAP
Hi, I’m a cobol programmer working on Mainframes with a work exp. of 2 yrs. I’ve worked in technologies like JCL, COBOL, VSAM, DB2, IMS DB/DC, IDMS, FOCUS etc. I have an opportunity to get into SAP technical(ABAP/4) as a programmer in my organisation. Looking at the future prospects of the Industry, do you think [...]

Answer Question   |  October 31, 2011  6:40 AM
390, ABAP, Application development, AS/400, AS/400 careers, Backup & recovery, Basis, Billing and customer care, Billing Support Systems, Career development, Certifications, CLP, CO, Database, DB2, DB2 Universal Database, Development, ED, Email, Enterprise Desktop, FI, Financials, IBM Marketing Sound Off, Industry solutions, IS-B, IS-H, IS-Ill, IS-P, IS-Retail, IS-T, Linux, Mainframe, MySAP, MySQL, NetWeaver, Oracle, PC/Windows Connectivity, RIVA, RPG, RPGLE, SAP, SAP APO, SAP careers, SEM, TR, Training, Upgrades / implementations, Windows, zSeries

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…

Answer Question   |  March 21, 2006  7:54 AM
Access, Brightmail, Budgeting, Cabling, Career development, Data analysis, Database, DataCenter, DB2, Desktops, E-business, Exchange, Instant Messaging, Management, McAfee, Microsoft Office, Microsoft Windows, Oracle, OS, Patch management, Power management, Project management, Remote management, Security, Servers, Spam, SpamAssassin, SQL, SQL Server, standards, Storage, Symantec, Thermal controls, Vendors

FTP
When I transfer a file (FTP) from one system to another using Get command numeric data comes as junk. Does anyone know how I can retrieve numeric data ? Thanks

Answer Question   |  March 20, 2006  11:25 AM
DB2 Universal Database

SQL server replication
We have diiference in two databases which are being replicated. What may cause the difference and how to find the differences. SQL sever 2003 is tha databse. Thanks

Answer Question   |  March 17, 2006  10:57 PM
Database, DB2, Oracle

Visual Basic
What is the difference between VBA and Visual Basic.Net…I want to learn how to write scripts to automate certain tasks.

Answer Question   |  August 8, 2006  10:54 AM
Database, DB2, Oracle, SQL, Web services, Web site design & management

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

Answer Question   |  March 10, 2006  1:31 AM
Database, DB2, Java/J2EE, Oracle, SQL, Windows

Capture screen w/scrolling marquee
My company uses a 3rd party software. There’s one screen that has a few graphs and a few lines that scroll across the screen. Similiar to a Screen Saver’s Scrolling Marquee. They redesigned the software and this screen will no longer exist. I would like to capture this screen w/scrolling marquee. It doesn’t really matter [...]

Answer Question   |  March 18, 2006  2:48 PM
Billing and customer care, Billing Support Systems, Call Centers, Career development, CRM, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DataManagement, DB2, Desktop management applications, Desktops, Development, E-business, Hardware, IBM, Lifecycle development, Management, Microsoft Windows, NCR, Networking, Oracle, OS, Project management, Sales force automation applications, Security, Servers, Software, Software Quality Assurance, SQL Server, Storage, Tech support, Web services, Web Services Standards

Explanation & remedy for Web-based Attack
Fully Patched fresh Windows 2003 with PLESK 7.5.6 Compromised again in 30 minutes after a CLEAN rebuild here is How attack occurs ========================== first we observe service.dll Nadeware.msi in system32 folder and a clone of srv-u FTP had run. then we observe an account named help added to administrators group ! we also found C:Program [...]

Answer Question   |  March 16, 2006  12:28 PM
Access control, Application security, backdoors, Browsers, configuration, Current threats, Database, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Secure Coding, Security, Servers, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms

Numeric values search from alphanumeric column of DB2
In DB2 I have the requirement of sorting only numeric values from varchar data type column by using some range criteria. The database table contains numeric as well as alphanumeric values. For ex. `1?, `2?, `6?, `13?, `34? ,?ABC123?, `POE?, `12IUY?, `FG23RF? etc. Using range search of 1 to 20, result should give `1?, `2?, [...]

Answer Question   |  March 7, 2006  6:18 AM
Database, DB2, Oracle

Updating Access Database Structure At Run-Time
I have an app that uses an access database for its back end. When a program update is issued someone has to manualy add the new fields, queries etc to the clients db file. Is there a way i can mimic the development database schema and update the database from the file upon installation of [...]

Answer Question   |  March 9, 2006  11:01 PM
Database, DB2, Development, Oracle, Visual Basic

Retrieving Job Info
I have a CL submitted from the Job Scheduler. In this job I need to kill an active job before processing, then strat it up again when processing is complete. For the active job I know the User ID and the Job Name and this is it, in addition there will always be more than [...]

Answer Question   |  December 1, 2009  5:19 PM
Application development, AS/400, CLP, DB2 Universal Database, RPG, RPGLE, Web development