Number of records in the Flat file
I have a huge Flat file in the Mainframe. What is the quickest way (utility, TSO command or TSO function) to find the exact number of records in the file? Thank you for your help!

Answer Question   |  April 27, 2006  10:26 AM
390, Application development, Career development, Data analysis, DataCenter, DB2, DB2 Universal Database, Development, Mainframe, zSeries

End Program – explorer.exe-2
From last few days I am facing this problem. When I shut down my Win 2000 Server(SP4) at the end of the day the end program-exlorer.exe dialog box comes up twice and it shuts down only after I click on the 2 end now buttons. Both end program dialog boxes are same and comes one [...]

Answer Question   |  April 19, 2006  2:03 AM
Career development, Data analysis, Database, DataCenter, DataManagement, DB2, Desktop management applications, Desktops, DHCP, DNS, E-business, Exchange, Hardware, Management, Microsoft Office, Microsoft Windows, Network management software, Network monitoring, Networking, Networking services, Oracle, OS, Patch management, Security, Servers, Software, SQL Server, Systems management software, Tech support, Web site design & management

End Program – explorer.exe
From the last few days I am facing this problem. When I shut down my Win 2000 Server(SP4) at the end of the day the end program-exlorer.exe dialog box comes up twice and it shuts down only after I click on the 2 end now buttons. Both end program dialog boxes are same and comes [...]

Answer Question   |  April 19, 2006  7:24 AM
Active Directory, Backup & recovery, Cabling, Computer Associates, Corporate portal applications, Data analysis, Database, DataCenter, DB2, Desktop management applications, Desktops, DHCP, Disk drives, DNS, Exchange, Hardware, Hubs, Lotus Domino, Management, Microsoft Office, Microsoft Operations Manager, Microsoft Systems Management Server, Microsoft Windows, Mobile, Network applications management, Network management software, Network protocols, Networking, Networking services, Oracle, OS, Performance management, Routers, Security, Servers, Software, Spam, SQL Server, Storage, Storage products and equipment, Switches, Systems management software, Tech support, Web services, Web site design & management, WINS, Wireless

Trouble with package execution after Oracle upgrade
Our database was recently upgraded from Oracle 8.0.6 to 9.2.0.7 just before I started to work here. They have a package with a maximum of 32 input report parameters that was working very well under the 8.0.6 version that now is extremely SLOW [and in some cases never returns at all] under 9.2.0.7 – is [...]

Answer Question   |  April 12, 2006  6:07 PM
Database, DB2, Hardware, Oracle, Software

Synchronizing the values in the form with the record in Oracle
I am new to Oracle forms and am faced with a problem. For records of a certain type, instead of updating the current record with the values in the form items, I am creating a new record in the table with the same values, but with a new sequence number (the primary key is a [...]

Answer Question   |  April 12, 2006  6:22 PM
Database, DB2, Oracle

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

Answer Question   |  March 31, 2006  10:13 AM
Architecture/Design, Availability, Backup & recovery, Database, DB2, Installation, Migration, Oracle, Oracle 8i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, Security, SQL, Windows, XML

SQL Server restore job fails
I’ve created a Restore Job under SQL Server Agent. Job owner is sa, Run as User dbo. There are no users connected to the database or processes running. The job fails with: Msg 3101, Sev 16: Exclusive access could not be obtained because the database is in use. [SQLSTATE 42000] Msg 3013, Sev 16: RESTORE [...]

Answer Question   |  March 31, 2006  3:46 PM
Backup & recovery, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, Oracle administration, OS, Security, Servers, SQL, SQL Server

QSAM Buffer
We are writing to a QSAM output file which we will require in case of an abend. The problem we are faced with is – what happens if the job abends prior to all the records in the QSAM buffer being physically written to the QSAM output file. Are there any JCL statements that can [...]

Answer Question   |  April 4, 2006  12:51 PM
390, DB2, Mainframe

Capture User Name and Date
How do I capture the user name and date of when a specific field was last edited on my form? I know how to capture when the entire form is edited and saved.

Answer Question   |  March 30, 2006  5:09 PM
Database, DB2, Oracle

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

Answer Question   |  March 29, 2006  3:34 AM
7 and earlier, Database, DB2, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle Database Versions, Oracle development, SQL

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

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

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

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