Easytrieve – Dynamically assigning collection id

How do I dynamically assign a collection id to an Easytrieve program? I have an Easytrieve program which is an input parm within a mainframe Proc. My SQL works fine when the collection ID is assigned on the “PARM SSID(xxxx)” statement. How can I get this value to be assigned at run type without coding…



Answer Question   |  June 27, 2012  3:15 AM
Easytrieve, SQL
asked by:
35 pts.

What is the difference between Hitachi ShadowImage, Hitachi TrueCopy and Universal Replicator?

What is the difference between Hitachi Shadow image, Hitachi True copy and Universal Replicator? What are the best scenarios where each of them can be implemented?



Answer Question   |  June 27, 2012  3:15 AM
Data Replication, Data Replication Software, Hitachi, Hitachi ShadowImage, Hitachi TrueCopy, Hitachi Universal Replicator, Mirroring, Remote data replication, Remote mirroring, Replication software
asked by:
215 pts.

I want to select some rows and show the average of columns of that rows in another row how can i do that in SPSS?

i want to select some rows and show the ave of colums of that rows in anaother row how can i do that ?



Answer Question   |  June 27, 2012  3:15 AM
Data analysis, Data Mining, Data mining/analysis, SPSS, SPSS Data Editor, Statistical analysis software
asked by:
5 pts.

jasper ad-hoc report takes more time

problem is that jasper ad-hoc reports take more time how to resduse it ,some time it take less time but some time it takes more than expected what is the solution of that . If may be any problem please tell me as soon as possible.



Answer Question   |  June 27, 2012  3:15 AM
Business intelligence software, Data mining/analysis, JasperServer
asked by:
10 pts.

Buffer error on Crystal Reports 11.5 Parameter

When I refresh the data on this report I’m building the report fails to get values. It list the cause of the error as “Buffer too small for string or missing null byte. UNKNOWN.RPT]” Isays that the errors source=prompt.dll and the error code is 0x8004380D. The field in the prompt is a date/time field. In…



Answer Question   |  June 27, 2012  3:13 AM
Crystal Report XI, Crystal Reports 11.5, Oracle 10g Database, Oracle 11g migration
asked by:
5 pts.

Summary of time in HH:MM:SS format in Crystal Report

How to display duration from DB in float value in cross tab report as HH:MM:SS format. Requirement as follows: Date     Abdul Anwer     Tiger Woods     Total 08-17                         00:00:25     03:15:58 07-21                         00:00:01     03:15:58 07-17   02:36:57         00:29:32     03:15:58 07-16                         00:02:34     03:15:58 07-06   00:00:45        …



Answer Question   |  June 27, 2012  3:11 AM
Crystal Reports, Crystal Reports Database, Crystal Reports XI
asked by:
40 pts.

Runtime error: server has not yet been opened Crystal reports

Hello everyone, I’m a novice programmer trying to display Crystal Report 8.5 report (C:Try.rpt) through my VB6 program. It is to be mentioned that the database that I’m useing is Oracle 9i installed on the same computer and Global Database Name/SID is ‘exim’. The report (C:Try.rpt) I’m trying to display is saved after unchecking the…



Answer Question   |  June 27, 2012  3:10 AM
Crystal Reports, Crystal Reports error messages
asked by:
20 pts.

How to view Crystal Reports in Internet Explorer?

when i deploy my asp.net website on windows 7 with oracle 11g database in backend.I am using sap crystal report version 13.0.2000.0 It gives error as Unsupported Operation. A document processed by the JRC engine cannot be opened in the C++ stack.Description: An unhandled exception occurred during the execution of the current web request. Please…



Answer Question   |  June 27, 2012  3:08 AM
Crystal Reports, Oracle 11g
asked by:
10 pts.

Sponsored Webcast: Active Decisions for the “Aware” Organization, 9/29

Organizations need systems that allow them to respond to fast changing conditions. These systems must be easy to change as requirements change and be able to respond to what is happening in real-time. Rules-based decision management systems are easy to change. Combining business rules with event-based processing ensures they respond to changing situations in real-time.…



Answer Question   |  June 27, 2012  3:07 AM
Business Intelligence, CRM, Oracle, SAP, Webcast
asked by:
16,755 pts.

I have a Cognos Inpromptu 7 report that works in Windows XP but gives me and error in Windows 7.

Hello, I have a Cognos Inpromptu 7 report that works in Windows XP but gives me and error in Windows 7. I am checking my Event Viewer now to see what the problem may be. Can someone take a look at the below information and assist me with identifying a resolution to getting the report…



Answer Question   |  June 27, 2012  3:04 AM
Cognos, Event Viewer, Windows 7, Windows XP
asked by:
50 pts.

Change password through JDBC

hi can any one help me .. how to change a password reset/ change password through JDBC connections specifications: 1)we are going to change password from front end URL 2)we need to connect through Db2 database through JDBC connections



Answer Question   |  June 27, 2012  3:00 AM
DB2, Java, Java Database, Java developers, JDBC
asked by:
15 pts.

Agile Project Plan

Hello, I am looking for some information about Agile (DSDM Atern) project planing using Ms Project, It would be great help if you could provide a sample plan or any other resources for a novice.



Answer Question   |  June 27, 2012  2:58 AM
Agile development, Agile methodology, Agile Project Plan, Agile software development, DSDM Atern, Software development, Software project management
asked by:
5 pts.

Change password through JDBC

hi can any one help me .. how to change a password reset/ change password through JDBC connections specifications: 1)we are going to change password from front end URL 2)we need to connect through Db2 database through JDBC connections



Answer Question   |  June 27, 2012  2:57 AM
DB2, Java, Java Database, Java developers, JDBC
asked by:
15 pts.

Windows Server 2003 to Windows Server 2008 VPN tunnel

I need to have a Windows Server 2003 to a Windows Server 2008 VPN tunnel that will allow network users to use to transfer secure documents over. Can this be done native to Windows on both sides securely?



Answer Question   |  June 27, 2012  2:52 AM
File transfers, VPN, VPN security, VPN Tunnel, Windows Server 2003, Windows Server 2008, Windows Server Security
asked by:
1,110 pts.

File sort using qshell (this time with tags)

Hi, I’m trying to use qshell to do a sort of a (non-keyed) DB2 database file to remove duplicate records. I use the following command :- sort -u /QSYS.LIB/$1.LIB/$2.FILE/$3.MBR | cat > /QSYS.LIB/$1.LIB/$2.FILE/$3.MBR Where $1 = Library name, $2 = File name, $3 = Member name. The command does a sort, removing duplicate records, and…



Answer Question   |  June 27, 2012  2:51 AM
AS/400, Database, DB2, Linux, Qshell, Unix shells
asked by:
23,625 pts.

maxicode from spool file on pick list with labels

I need to present substitutes for some form software to a client. They need to create replace existing form software with form software that can creaate UPS shipping labels. The primary reason for switch is current forms software claims they can not make Maxicode from an AS400 spool file and require data files. Target printer…



Answer Question   |  June 27, 2012  2:51 AM
Forms software, Maxicode, Spool files
asked by:
5 pts.

EDM Pool Usage

I have a Cobol program which calls another DB2 program which in return executes a procedure. And this call happens more than thousands time…so EDM Pool getting filled up with pages which shuts down the DB2. Can you suggest what needs to be done to minimize the EDM Pool issue.



Answer Question   |  June 27, 2012  2:49 AM
COBOL, DB2, EDM Pool
asked by:
5 pts.

How to set up ISDN DTI on cms 1000

We are expanding and this is my first ISDN DTI installation. Can anyone just help me get my mind around the procedures. Thanks



Answer Question   |  June 27, 2012  2:48 AM
CMS, ISDN, ISDN Configuration, ISDN Equipment/Services, Nortel CS 1000
asked by:
10 pts.

Giving in Date Range in Crystal Reports 8.5

I am trying in Crystal 8.5 to get records for those who did not donate in a given date range, but did give in a different date range (i.e. did not donate 5/1/1985 thru 4/30/2009, but did donate 5/1/2009-4/30/2010). Those who meet the criteria are then marked as “new donor”. I am getting too many…



Answer Question   |  June 27, 2012  2:42 AM
Crystal 8.5, Crystal Reports 8.5, Date format, iMIS
asked by:
15 pts.

Batch Scheduling Of Jobs

Currently, we are creating 80-100 jobs for a complete batch schedule to execute against individual db2 regions (1 entire batch schedule per region). Is there a way to create one series of batch jobs and use that set against all regions? I apologize if this makes absolutely no sense.



Answer Question   |  June 27, 2012  2:37 AM
AS/400 batch jobs, Batch jobs, DB2, z/OS configuration
asked by:
5 pts.