execution of multiple querries with SPUFI and QMF tools
hello, how can i execute multiple queeries with the help of tools- SPUFI and QMF respectively. thank you

Answer Question   |  June 19, 2010  8:51 AM
390, DB2, Mainframe

IMS conversational transactions
I am looking into IBM’s IMS SOAP Gateway to expose our IMS transactions as Web Services. 98% of our IMS transactions are conversational. I am looking for possible ways of exposing them as SOAP/Web services without acquiring WebSphere or IMS Connect for Java on the Mainframe

Answer Question   |  February 9, 2006  2:32 PM
390, DB2, Mainframe, Web services

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 * from quote_header [...]

Answer Question   |  February 8, 2006  1:00 PM
Database, DB2, Oracle, SQL

Sending email attachment from mainframe – MIME format
Hi, I need to email 2 flat files from mainframe as CSV files. (the data in the flat files already contains the delimiter ‘,’). The problem is, i get the 2 files attachements as CSV, but nothing in them! I feel I’ve got the MIME formatting wrong. I use IEBGENER, and the flat files are [...]

Answer Question   |  February 7, 2006  3:15 PM
390, DB2, Mainframe

Database Implementation
What is the best practice for implementation of a new Database software package (I.E. creating teams, or work with a Committee) My boss would like me to learn everyones job, is this really necessary to implement a new Database package…

Answer Question   |  February 8, 2006  9:26 AM
Database, DB2, Oracle, Project management

Oracle Sql Tuning
Hi everybody. I need some help with Sql Tuning. I have a query that returns information from many tables (let’s say 5 for the example). 2 of that tables are big tables (20 million rows each one). I usually write ‘where’ clauses putting first the join conditions and after them, the table specific conditions, but [...]

Answer Question   |  February 6, 2006  2:03 PM
Database, DB2, Oracle, Windows

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 session(“oApp”) = Server.CreateObject(“CrystalRuntime.Application”) End If Path = Request.ServerVariables(“PATH_TRANSLATED”) While (Right(Path, 1) <> “” And Len(Path) <> 0) iLen = Len(Path) – 1 Path = Left(Path, iLen) Wend If IsObject(session(“oRpt”)) [...]

Answer Question   |  February 7, 2006  1:29 AM
ActiveX, ASP, Crystal Reports, HTML, Software, SQL, VBScript, Web site design & management

List of Values in a SP Parameter
I need to pass a List of Values parameter from a Crystal Report to a Store Procedure. 1) How do I define the Parm? and 2) How do I code the WHERE clause? Example: Result Sets 1 Language SQL Begin Declare C1 Cursor with Return For Select * From Table1 WHERE Field1 in(‘Value1′, ‘Value2′,’Value3′, etc);

Answer Question   |  February 9, 2006  2:42 PM
Application development, Crystal Reports, DB2 Universal Database

Oracle boolean data type questions
Greetings, Since Oracle Table structures do not support a boolean data type, there is a choice (Make it a varchar2(1) or Number(1)), with contents of 0,1 or Y,N The questions I have are: 1) From a comparison perspective, which provides better performance? Comparison of a number (1,0) or string (Y/N) 2) Which method takes up [...]

Answer Question   |  January 28, 2006  4:15 PM
Database, DB2, Oracle

messaging and collaboration
What is messaging and collaboration,how does it works,how to set it up ,where can it be implemented and how

Answer Question   |  January 12, 2008  8:40 AM
AIM, Availability, Bandwidth, Billing and customer care, Billing Support Systems, Brightmail, Budgeting, Business Objects, Business/IT alignment, Career development, Certifications, Cognos, Compliance, CRM, Crystal Reports, Data analysis, Data mining/analysis, Data warehousing applications, DataCenter, DataManagement, Development, Enterprise Desktop, ERP, Exchange, Instant Messaging, Laws, Lifecycle development, Linux, MySQL, Network monitoring, Network protocols, Networking, Outsourcing, Regulations, Spam, standards, Training, Web development

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 servers. We would like any comparative views regarding AMD vs. Intel [...]

Answer Question   |  January 25, 2006  6:12 PM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server

Query Regarding Crystal Reports
Hi, I need to produce a flat file in fixed length format as output of Crystal Report. Wanted to know if crystal report supports exporting data into a Flat file fixed lenght format. If yes, would like to know how to go about it.

Answer Question   |  January 13, 2010  5:23 PM
Business/IT alignment, Database, DB2, Development, Oracle

Is there an IBM Tool to Rebind Plans/Collections
I am an applicaiton developer, (analyst) resonsible for ensuring four test regions (and sometimes the produciton region) performs as effieciently as possible. We have approximately 1000 programs that have not accurate statistics (run stats are not updated, another question). Our DBA’s tell us it is our responsibility to rebind the applicaitons (one at a time) [...]

Answer Question   |  January 20, 2006  5:36 PM
390, Database, DB2, Mainframe, Oracle

Data Extraction into SQL Server Database from Cache ODBC Database
Hi.I am trying to extract data from an intersystems cache database into a sql server database for storage and reporting purposes, on behalf of my company. I have not succeeded so far for the last couple of months as it keeps bringing back far more than the expected number of rows, and is inconsistent with [...]

Answer Question   |  May 31, 2011  6:58 AM
Data analysis, Data warehousing applications, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server

finding webmail access site
Hello, Is there any way one can find out the webmail access site using only the email address? Actually my friend was out of town and wanted to check her email using webmail but she had forgotten the webmail access site provided by her hosting service provider. She told me find this out but I [...]

Answer Question   |  March 10, 2010  5:09 AM
BroadVision, Content management applications, Corporate portal applications, DHCP, DNS, IPv4, Microsoft Windows, Network protocols, Networking, Networking services, TCP, Tech support, Web services, Web Services Standards, Web site design & management

Compressing Old Files
Hello, I would like to know the option(Compressing Old Files) which comes up during disk cleanup in win XP and win 2000. Is it good or bad? I mean, If I do the compression regularly will that effect my system/files in a long run? Is it same to that option (compress drive to save space) [...]

Answer Question   |  January 26, 2012  6:37 AM
Access, Adapters/Interfaces, Administration, Backup & recovery, Business/IT alignment, Career development, Certifications, CRM, Data analysis, Data management and storage, Data mining/analysis, Database, DataCenter, DB2, Desktop management applications, Desktops, Disk drives, E-business, Ecommerce applications, Exchange, Exchange security, Fax and print management, File, Hardware, Hardware selection and management, Management, Microsoft Windows, Monitoring, Online transaction processing, Oracle, OS, Patch management, PC/Windows Connectivity, Performance and availability, Project management, Replication, Sales force automation applications, Security, Servers, Software, Spam, SQL Server, Storage, Storage management, Storage products and equipment, Storage servers, Systems management software, Tape drives/Libraries, Tech support, Training, Web development

Partitioning a large financial table
i hv a large table (GL details that is abt 30-50mb) that contains financial data. i want to partition it by these fields 1) company code 2) Quarter (based on the financial periods) 3) Year Eg, data Select GLCO, GLYEAR, (TO_CHAR(GLYEAR) ||’/'||TO_CHAR(GLMNTH)) As Yrmth, GLMNTH, GLAMT FROM GLPGL; GLCO GLYEAR Yrmth GKMNTH GLAMT 110 2004 [...]

Answer Question   |  January 16, 2006  3:20 AM
Database, DB2, Oracle

Oracle Developer 6i and 9i database connection problems
I cannot connect to a 9i database patched to 9.2.0.6 (I can if the server is patched to 9.2.0.5) from a 6i Developer client on XP. Tnsping80 is OK but not SQL. I get kicked out of SQL and the error report references ora805.dll. When I install the 9i client I can connect with it [...]

Answer Question   |  January 14, 2006  9:08 AM
Database, DB2, Oracle

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

Answer Question   |  January 12, 2006  9:04 AM
Database, DB2, Oracle, SQL

problem related paper size (Crystal Report 9)
My project (in VB & Crystal Report 9) needs different shaped bills (10?X12?, 6?X12?, 15?X12?) to print through DMP. But I am facing problem to control paper size through code.

Answer Question   |  January 11, 2006  5:15 AM
Data analysis, Database, DB2, Oracle