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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
I am using Crystal Reports 2004, version 220.127.116.115. 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
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
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
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
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