How can I map a pc keyboard key to 5250 emulation and have a dup key
I have AS400 program doing data entry. The users want to use a dup key to duplicate data entry into a subfile from one line to next. How can I map a pc key to be a dup key?

Answer Question   |  July 30, 2008  3:31 PM
5250 session, AS/400 database, Data entry

Application transfering
Do you know how a system (a Veritas Cluster System to be exect) automatically transfers an application from the primary server to the standby server in the case of a failure in primary server? Does the target need to pay a license for both servers in this case?

Answer Question   |  July 30, 2008  2:40 PM
Cluster, License, License software, Primary Server, Standby Server, Transfer, Veritas

file transfer PC to z/OS Host large EBCDIC
I’m doing a file transfer from PC to Host 7M record size 24576 EBCDIC format. Failed after a few seconds. What type I should use and how to extend the time? Please help?

Answer Question   |  July 30, 2008  3:26 AM
EBCDIC, File transfers, z/OS

Report Query
Can I run a query in peoplesoft if I don’t have access to query manager?

Answer Question   |  July 28, 2008  7:59 PM
PeopleSoft, Query Manager, Reports

Explaining features in SQL Server 2005
I have a presentation to give on business intelligence using SQL Server 2005. Can you assist me by explaining the features Data Integration, Data Analysis, Data Reporting and Data Mining in SQL Server 2005?

Answer Question   |  July 28, 2008  3:42 PM
Data analysis, Data integration, SQL Server 2005

Passing Current Thread culture to Crystal Reports
I have an .net application which uses System.Threading. Thread.CurrentThread. CurrentCulture to set the right dateformats throughout the app, This culture which has date formats can be modified any time by the user. How can i pass this current thread culture date formats to Crystal report field objects. I have requirements not to use the Formula [...]

Answer Question   |  June 24, 2010  4:55 PM
.NET applications, Crystal Reports

How to restrict QMF to execute predefined queries only?
Hi, is there a way to restrict the usage of QMF/390 to predefined queries/procedures only? Some users should not be able to edit or create SQL statements on their own. Thank you very much. Regards Michael

Answer Question   |  July 29, 2008  8:01 AM
DB2, Mainframe, OS/390, QMF, Query Management Facility, z/OS

.NEt Cognos Connectivity
Hi, i need to connect Cognos with .Net how could i connect then generate reports and then save it in some other format like HTML or EXcel through .NET. Regards, Neha

Answer Question   |  July 25, 2008  7:29 AM
.NET, .NET applications, Application integration, Cognos, Interoperability

Spss data analysis
Hi, I am trying to find out the demographics (age, gender, ethnicity etc) of my final subject pool on SPSS. I used a survey type questionnaire, and want to know which subjects completed all the measures of interest. I f I do a cross tabs with ageXgender, for example, I don’t know which of THESE [...]

Answer Question   |  July 25, 2008  1:07 AM
Business Intelligence, Data analysis, SPSS

Informatica MAP creation to RESTART
I have to develop maps which execute extracting and loading data. If, because of any reasons MAP failed with any errors have to fix and restart the same MAP, this time it has to start processing data where it got failed. Please let me know how could I develop map satisfying in both situations.

Answer Question   |  July 24, 2008  11:41 AM
Data mining/analysis, Database programming, Informatica

Gentran 850
We are using Gentran into SAP 4.6. Where do you map the SHIPTO segment of an inbound 850 to? Is a Text Element the only way?

Answer Question   |  December 14, 2010  11:40 AM
850nm, EDI, Gentran, SAP 4.6, SHIPTO

Open Source ERP : Immediate Help would be highly appreciated
Could anybody give me insights about Open Source ERP, benefits over specific modules other than the cost implications/ Also, are there any risks involved? Does there exist any framework for the implementation process?

Answer Question   |  July 25, 2008  12:38 PM
ERP, Open Source ERP, Software

BDC and Batch Input
What is the actual difference between BDC and Batch input in ABAP? Is there any difference at all? -Gururpasad R

Answer Question   |  May 17, 2011  4:31 AM
ABAP, Batch Data Communication, BDC

Crystal Reports 6.0 and Windows Vista
Has anyone been successful at running Crystal Reports 6.0 under Vista? I get error File could not be opened: “filename”, at file location: “filename” OK to close followed by error – RptName – Run-time error 20535: Unable to connect: incorrect session parameters or just the 20535 incorrect session parameters. I had these issues trying to [...]

Answer Question   |  July 23, 2008  8:40 PM
Crystal Reports, Crystal Reports 6.0, Error 20535, Microsoft Access, Windows Vista

I want to know if it is possible to transfer data from Iseries to a web site and upload some back. This is for our bank and we do not want to use FTP
We need to send files to our bank and receive files back via a web site. What would be the best way. This is the only data we send out of the company now so we would like to do it with what we have and not spend money. We do have a new Iseries [...]

Answer Question   |  March 22, 2011  7:21 PM
Data transfer, iSeries, V5R4, WebSphere

How to stop GF1 info from disappearing
I am using Crystal Reports 2004, version 11.0.0.895. I am writing a report that groups by two fields Customer Name and Invoice Number. Customer Number is Group 1 and Invoice Number is Group 2. I am trying to just show the summary information from Group 1, which sums the information in Group 2. I hide [...]

Answer Question   |  July 22, 2008  6:54 PM
Crystal Reports, Crystal Reports 2004, Crystal Reports XI, Grouping

How to calculate my DataBase size
Dear all, I like to calculate my database size , can u tell me the views and formula to calculate my DB size please

Answer Question   |  July 22, 2008  1:24 PM
Data modeling, Database design

how to generate sequece number in an existing table
We are having two datamart one is GDM and other is IDM. Now what to do: 1)Establish a unique royalty_transaction_id in GDM.this should be assigned to every single sales record when inserted in Global_sales_table. 2)Established a reversed royalty transaction id in GDm.This should be assigned to reversed sales transaction and it should point to the [...]

Answer Question   |  July 21, 2008  4:20 AM
Data marts, Global Data Mart, International Data Mart, Sequence number generation

How to access and use subform data/calculations
Access 2007 Database; Employee Info; Form:Sick Days Docking/Pay. I created a form with a subform that keeps track of Employee sick days. It transfers totals from the subform onto the main form…Then the main form does a couple calculations on those amounts…But I need to access that information in a report for each employee. Reports [...]

Answer Question   |  July 29, 2008  1:23 PM
Access 2007, Calculations, Database programming, Form, Microsoft Access, Parameters, Reports, Subform, Variable fields

how to remove space b/w page footer and report footer in Crystal Report Question
hi im working on .net vs2003 im on working on crystal reports .how can i remove a space b/w page footer and report footer .Atually im not having nothing to display so i suppressed report footer but it is getting a large white space b/w report footer and page footer plz help me

Answer Question   |  September 8, 2008  11:16 AM
.NET Framework, Crystal Reports, Crystal Reports 9, Visual Studio 2003, VS 2003