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

Zebra printer will not print CORRECTLY through Oracle application(s)
Glad to see that some of you all have experience with Zebra printers!!! My problem is that I cannot get my custom Oracle application to print correctly to a Zebra TLP 2742 printer. The problem started when an (older) hand held “pistol” scanner failed. Connected to a laboratory balance via Omnilink box and two “Y” [...]

Answer Question   |  March 1, 2006  9:19 AM
Aspen Technology, Baan, Billing and customer care, Billing Support Systems, Database, DataCenter, DB2, Desktop management applications, Desktops, Development, Distribution/logistics applications, Hardware, i2 Technologies, IBM, Interoperability, Management, Manufacturing applications, Manugistics, Microsoft .NET, Microsoft BizTalk Server, Microsoft Internet Information Server, Microsoft Windows, NCR, Online transaction processing, Oracle, Oracle Application Server, Oracle Manufacturing, OS, PeopleSoft, Printers, QAD, SalesLogix, SAP, SAS Institute, SDRC/EDS, Security, Servers, Siebel, SQL Server, Supply chain management applications, Tech support, Windows

Batch FTP Question – Server to Mainframe
I recently tested a batch FTP which gets a file from a Unix server and downloads to a flat file on an IBM mainframe. When I run this on our test box, it creates a fixed block flat file of 128 bytes. When I run the exact same batch FTP on our production box, exact [...]

Answer Question   |  February 28, 2006  8:24 PM
390, DB2, Development, Mainframe

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

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

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

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