execution of multiple querries with SPUFI and QMF tools
In SPUFI, end each query with a ; select * from tab1;

View Answer   |  February 16, 2006  7:22 AM
390, DB2, Mainframe

File Transfer
If you are using Client Access then an Add-In is provided (but must be registered) to upload directly to your iSeries through Excel. To check if it is registered in Excel check Tools->Add-Ins. This will display a window with all installed Add-Ins. Make sure that Client Access Data Transfer is checked. If it is not [...]

View Answer   |  February 15, 2006  12:42 AM
ERP

IMS conversational transactions
It is not trivial to do what you are looking for without buying some kind of adapter. Apart from the IBM products you mentioned, Attunity, Neon, Labrados and iWay come to mind. If you want to write your own,then in a nutshell, you would need to write a TCPIP socket listeners that would receive incoming [...]

View Answer   |  February 9, 2006  9:56 AM
390, DB2, Mainframe, Web services

adding partition to existing non-partitioned table
Hello: The ‘AS SELECT…’ clause should be the last part of the CREATE TABLE … PARTITION. Try this: create table quote_header_test partition by range (ordered_date) partition less_jul2004 values less than (to_date(’01-JUL-2004′,’MON-DD-YYYY’)) as select * from quote_header; Good Luck

View Answer   |  February 8, 2006  6:42 AM
Database, DB2, Oracle, SQL

Database Implementation
In order for you to decide on a Database Software Implementation requires that you fully understand the business needs and what the Database should provide to them. I would recommend that you try to understand the general aspects of business needs before you actually implement a Database Software or Project. Be careful, More functions and [...]

View Answer   |  February 8, 2006  4:53 AM
Database, DB2, Oracle, Project management

Sending email attachment from mainframe – MIME format
I would suggest installaing and using XMITIP. This excellent free tool can be found at http://www.lbdsoftware.com/tcpip.html Hope this helps…

View Answer   |  February 7, 2006  6:30 AM
390, DB2, Mainframe

Oracle Sql Tuning
This linke will provide some useful informaton: http://asktom.oracle.com/pls/ask/f?p=4950:8:8488073385483584370::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:8764517459743

View Answer   |  February 3, 2006  2:39 PM
Database, DB2, Oracle, Windows

List of Values in a SP Parameter
Is there a way you could write the value list to a temporary table every time you call the SP? Then you wouldn’t have to pass the value list, but call it in you WHERE clause like: WHERE Field1 in (Select * from table_temp)

View Answer   |  February 3, 2006  11:37 AM
Application development, Crystal Reports, DB2 Universal Database

Passing parameters from .ASP (VBSript) to Activex object in date format
Reformat the string to universal date format, i.e. ’20060203′. I’m assuming MS SQL, not sequal!

View Answer   |  February 3, 2006  7:14 AM
ActiveX, ASP, Crystal Reports, HTML, Software, SQL, VBScript, Web site design & management

Oracle boolean data type questions
> 1) From a comparison perspective, which provides better performance? Comparison > of a number (1,0) or string (Y/N) It won’t make a difference. > 2) Which method takes up less storage? They both take 1 byte. > 3) Results will be mapped into a J2EE data structure supporting a boolean datatype. > Which method [...]

View Answer   |  January 26, 2006  6:35 PM
Database, DB2, Oracle

AMD vs. Intel: Data Warehouse Servers and Consolidated Database Servers …
We manage several DBs of the size you are discussing. Although the intel based platforms are OK, for the size and performance you are mentioning for the DW, we run all of ours on Sun systems. We use V880s for this application. A V400 series might do the trick with only 200 to 400 users. [...]

View Answer   |  January 25, 2006  9:01 AM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server

Query Regarding Crystal Reports
If you are running Crystal Reports client you can export to what they call Record Style (Column with Spaces) format. File — Export — Select the export format. It is worded a little differantly depending on the version of Crystal Reports. Just look for it. This may not be an option depending on how you [...]

View Answer   |  January 21, 2006  10:49 AM
Business/IT alignment, Database, DB2, Development, Oracle

Is there an IBM Tool to Rebind Plans/Collections
Unless I misunderstood, it is easy. Just run this job step to rebind all packages in a collection: //BATCHDSN EXEC PGM=IKJEFT1B,PARM=’DSN S(DB2P)’ //SYSTSPRT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSTSIN DD * REBIND PACKAGE(collection.*.(*)) The first * means “all packages”, the second “all versions” within this collection. In fact, you can replace collection by * as [...]

View Answer   |  January 20, 2006  7:07 AM
390, Database, DB2, Mainframe, Oracle

Data Extraction into SQL Server Database from Cache ODBC Database
It sounds like the query is not correct. You should query against the base tables and not the view. I expect you are joining the view to some number of tables and returning one or more rows from the child tables resulting in the views rows being returned multiple times. Use Right and Left joins [...]

View Answer   |  January 17, 2006  10:11 AM
Data analysis, Data warehousing applications, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server

finding webmail access site
Many small ISPs use Plesk to manage their user accounts, the default is for the web mail for joeuser@domain.com to be http://webmail.domain.com/ login name joeuser and the password is the same as their POP3 password. That’s what I’d try, anyway

View Answer   |  January 17, 2006  5:50 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

Oracle Developer 6i and 9i database connection problems
Unless you’ve read some official Oracle document that said it should work, it sounds like they have finally broken the backward compatibility. Perhaps you should consider that you’ve gotten your money’s worth, at this point, and it’s time to upgrade? Seems odd that they’d break it on a minor revision, but it might have been [...]

View Answer   |  January 13, 2006  10:44 AM
Database, DB2, Oracle

Partitioning a large financial table
RDBMS used? version? if that’s using Oracle financials there are partitioning schemes in the Apps that Oracle recommend using because of the way the applications access the data cheers

View Answer   |  January 13, 2006  8:33 AM
Database, DB2, Oracle

read only user
Try granting select on dba_source.

View Answer   |  January 11, 2006  10:36 AM
Database, DB2, Oracle, SQL

problem related paper size (Crystal Report 9)
See this article: http://support.microsoft.com/?id=129397 or just Google “PrtDevMode”

View Answer   |  January 11, 2006  7:50 AM
Data analysis, Database, DB2, Oracle

VS COBOL-II (FILES)
Try this: After you read a record: ADD 1 to WS-RECORDS-READ-COMP DIVIDE 5000 INTO WS-RECORDS-READ-COMP GIVING WS-QUAT REMAINDER WS-REMAINDER IF WS-REMAINDER = 0 MOVE WS-RECORDS-READ-COMP TO WS-RECORDS-READ-DISP DISPLAY WS-RECORDS-READ-DISP ‘RECORDS PROCESSED’ END-IF

View Answer   |  January 6, 2006  9:43 AM
390, DB2, Mainframe