DB2 Tuning link or manual for AS400
Hi, In the company I work for we have a requeriment for tuning DB2 in as400. We still don’t know the server release, but I wanted to start searching for any documentation about that. I will appreciate any link or suggestions. Thank you. Regards.
Answer Question
| April 15, 2011 3:14 PM
AS/400, AS/400 DB2, DB2
Hi, In the company I work for we have a requeriment for tuning DB2 in as400. We still don’t know the server release, but I wanted to start searching for any documentation about that. I will appreciate any link or suggestions. Thank you. Regards.
Answer Question
| April 15, 2011 3:14 PM
AS/400, AS/400 DB2, DB2
SQL Update Set: Higlight Customers without Invoices, Update and join Tables?
Hello, I am not sure how to do this with an SQL Update Set statemet: I have a table customers and I have related invoices. I would like to set one field to “not active” in the customer table that did not receive invoices since 2008. I can “Select” the corresponding records in the customer table [...]
Answer Question
| March 28, 2011 2:03 PM
AS/400 DB2, DB2, SQL statement
Hello, I am not sure how to do this with an SQL Update Set statemet: I have a table customers and I have related invoices. I would like to set one field to “not active” in the customer table that did not receive invoices since 2008. I can “Select” the corresponding records in the customer table [...]
Answer Question
| March 28, 2011 2:03 PM
AS/400 DB2, DB2, SQL statement
Copying Test Cases from one Project to Another in QC
I am trying to copy test cases from one project to another in the same domain and it should work as I get questions about how I want to perform the copy, but when I try to execute I get an error. Has anyone had this problem? Copying test cases between projects was introduced a [...]
Answer Question
| May 31, 2012 4:40 PM
ALM, Application Lifecycle Management, HP Quality Center, Quality control
I am trying to copy test cases from one project to another in the same domain and it should work as I get questions about how I want to perform the copy, but when I try to execute I get an error. Has anyone had this problem? Copying test cases between projects was introduced a [...]
Answer Question
| May 31, 2012 4:40 PM
ALM, Application Lifecycle Management, HP Quality Center, Quality control
Crystal report when database is empty
Can you write a crystal report when the tables are empty?
Answer Question
| February 28, 2011 3:28 PM
Crystal Reports, Crystal Reports Database, Crystal Reports formulas
Can you write a crystal report when the tables are empty?
Answer Question
| February 28, 2011 3:28 PM
Crystal Reports, Crystal Reports Database, Crystal Reports formulas
Crystal Reports error message
When I try to install Crystal Report I receive error 2908. every time i hit ok and try again the number of error messages increase. My os is XP.
Answer Question
| March 7, 2011 2:36 PM
Crystal Reports, Crystal Reports error messages, Crystal Reports Errors, Windows XP
When I try to install Crystal Report I receive error 2908. every time i hit ok and try again the number of error messages increase. My os is XP.
Answer Question
| March 7, 2011 2:36 PM
Crystal Reports, Crystal Reports error messages, Crystal Reports Errors, Windows XP
Crystal Reports XI formula problem
Hi everyone, It’s been an while since I have used Crystal Reports and am having trouble with a formula… If paid by2/26/2011 12:00:00AM is what I see when I run my program, I don’t need the time, just the date. Here is the formula: “If paid by” & DateAdd (“d”,10,{TransactionTable.InvoiceDate}) Thanks for the help
Answer Question
| February 25, 2011 8:41 PM
Crystal Report XI, date, Date error, error, formula
Hi everyone, It’s been an while since I have used Crystal Reports and am having trouble with a formula… If paid by2/26/2011 12:00:00AM is what I see when I run my program, I don’t need the time, just the date. Here is the formula: “If paid by” & DateAdd (“d”,10,{TransactionTable.InvoiceDate}) Thanks for the help
Answer Question
| February 25, 2011 8:41 PM
Crystal Report XI, date, Date error, error, formula
set location of the database in the crystal report version 8.5 through vb 6.0 program
I have developed small system in vb 6.0 and using crystal reports 8.5 as reporting tool, if i have prepared the report format in crystal report the location of the database ( MS Access 2003 ) is set after selecting the database name. I would like to set the location of the database through vb [...]
Answer Question
| February 25, 2011 4:59 PM
Crystal Reports 8.5, VB 6.0
I have developed small system in vb 6.0 and using crystal reports 8.5 as reporting tool, if i have prepared the report format in crystal report the location of the database ( MS Access 2003 ) is set after selecting the database name. I would like to set the location of the database through vb [...]
Answer Question
| February 25, 2011 4:59 PM
Crystal Reports 8.5, VB 6.0
Open PDF with parameters
I want to open a PDF file with a #page= parameter. This works if I create a fetch link with the full folder string – http://ecm.domain.net/ecm/livelink.exe/fetch/2000/115075//GUIDE.pdf?nodeid=9948579#page=4 …but does not work if I “Open” the shortlink – http://ecm.domain.net/ecm/livelink.exe/Open/9948579#page=4 Is there a trick to this? THANKS!
Answer Question
| February 24, 2011 10:00 PM
Livelink, PDF, SQL Server
I want to open a PDF file with a #page= parameter. This works if I create a fetch link with the full folder string – http://ecm.domain.net/ecm/livelink.exe/fetch/2000/115075//GUIDE.pdf?nodeid=9948579#page=4 …but does not work if I “Open” the shortlink – http://ecm.domain.net/ecm/livelink.exe/Open/9948579#page=4 Is there a trick to this? THANKS!
Answer Question
| February 24, 2011 10:00 PM
Livelink, PDF, SQL Server
Master Data Management
Does anyone have any best pracrice information regarding implementation steps and business requirements needed to define and implement MDM? thank you
Answer Question
| March 3, 2011 3:42 PM
Master data management, MDM, SAP Master Data Management, SAP MDM
Does anyone have any best pracrice information regarding implementation steps and business requirements needed to define and implement MDM? thank you
Answer Question
| March 3, 2011 3:42 PM
Master data management, MDM, SAP Master Data Management, SAP MDM
Passing an array parameter from crystal reports to a sql stored procedure
Hi All, I am having a problem in Crystal Reports with an array parameter. The user can select one warehouse code or multiple warehouse codes. I just need to display the detail from each warehouse selected (one, multiple or ALL). Right now I’m getting duplicates. I’m not sure how to set this up in SQL [...]
Answer Question
| February 22, 2011 10:56 PM
Array Parameters, Crystal Reports, Crystal Reports 10, SQL, SQL Server
Hi All, I am having a problem in Crystal Reports with an array parameter. The user can select one warehouse code or multiple warehouse codes. I just need to display the detail from each warehouse selected (one, multiple or ALL). Right now I’m getting duplicates. I’m not sure how to set this up in SQL [...]
Answer Question
| February 22, 2011 10:56 PM
Array Parameters, Crystal Reports, Crystal Reports 10, SQL, SQL Server
Record Selection in Crystal Report 2008
I have a Crystal report 2008 that selects records from dynamic prompt based on Client field with status “Approved”. When i select records that i know have a staus of “Approved” I see all of the records, but if I select records from dynamic prompt that dont have a status “Approved” some other status like [...]
Answer Question
| February 23, 2011 7:32 PM
Crystal Reports, Crystal Reports 2008, Crystal Reports 2008 controls, Record Selection
I have a Crystal report 2008 that selects records from dynamic prompt based on Client field with status “Approved”. When i select records that i know have a staus of “Approved” I see all of the records, but if I select records from dynamic prompt that dont have a status “Approved” some other status like [...]
Answer Question
| February 23, 2011 7:32 PM
Crystal Reports, Crystal Reports 2008, Crystal Reports 2008 controls, Record Selection
Subfile in As400
Hi below pasted is my code which i am running but i am getting an error ‘Attemp to write duplicate records” DDS A* A CF03(03) A DSPSIZ(24 80 *DS3) A R RECSFL SFL A 30 SFLNXTCHG A UPC 20 B 9 3TEXT(‘UPC 2ND ITEM’) A 31 DSPATR(UL) A* A R RECCTL SFLCTL(RECSFL) A* A OVERLAY [...]
Answer Question
| February 22, 2011 9:20 AM
AS/400, AS/400 Subfiles, Duplicate records, OS/400
Hi below pasted is my code which i am running but i am getting an error ‘Attemp to write duplicate records” DDS A* A CF03(03) A DSPSIZ(24 80 *DS3) A R RECSFL SFL A 30 SFLNXTCHG A UPC 20 B 9 3TEXT(‘UPC 2ND ITEM’) A 31 DSPATR(UL) A* A R RECCTL SFLCTL(RECSFL) A* A OVERLAY [...]
Answer Question
| February 22, 2011 9:20 AM
AS/400, AS/400 Subfiles, Duplicate records, OS/400
Crystal Reports 8.5 export troubles
I have an older application which uses Cryst 8.5 and we use the viewer. We recently turned on the export button in the viewer. The export feature works on some machines but on others it works up to the point of displaying the window that allows the user to choose where to save the file. This [...]
Answer Question
| February 17, 2011 1:19 PM
Crystal Reports 8.5, Crystal Reports Export, Crystal Reports Viewer, Visual Basic 6.0
I have an older application which uses Cryst 8.5 and we use the viewer. We recently turned on the export button in the viewer. The export feature works on some machines but on others it works up to the point of displaying the window that allows the user to choose where to save the file. This [...]
Answer Question
| February 17, 2011 1:19 PM
Crystal Reports 8.5, Crystal Reports Export, Crystal Reports Viewer, Visual Basic 6.0
Designing a single query using SPUFI
Hi, I am new to Mainframe..using QMF.Instead of using multiple select queries,my TL told me to design a single query.How to execute the query in SQL execution engine SPUFI??? Please tell the steps involved in creating a dataset & import the results?
Answer Question
| February 16, 2011 11:17 AM
Mainframe, Mainframe SPUFI, QMF, SPUFI
Hi, I am new to Mainframe..using QMF.Instead of using multiple select queries,my TL told me to design a single query.How to execute the query in SQL execution engine SPUFI??? Please tell the steps involved in creating a dataset & import the results?
Answer Question
| February 16, 2011 11:17 AM
Mainframe, Mainframe SPUFI, QMF, SPUFI
AS400 DB2
How do I access the data in a journal receiver?
Answer Question
| February 9, 2011 9:17 PM
AS/400, AS/400 database, DB2, iSeries, Journal Receivers
How do I access the data in a journal receiver?
Answer Question
| February 9, 2011 9:17 PM
AS/400, AS/400 database, DB2, iSeries, Journal Receivers
Crystal Reports XI period in database name
SQL Server 2005 database has a period in its name. For example, data.12. I call a crystal report from VS2008. I use ConnectionInfo object to pass connection info to a report. I get errors in formulas. Renaming DB resolves the issue. How can I get it to work with names like data.12?
Answer Question
| January 13, 2012 12:12 AM
Crystal Reports, Crystal Reports XI, SQL Server 2005, SQL Server 2005 Database
SQL Server 2005 database has a period in its name. For example, data.12. I call a crystal report from VS2008. I use ConnectionInfo object to pass connection info to a report. I get errors in formulas. Renaming DB resolves the issue. How can I get it to work with names like data.12?
Answer Question
| January 13, 2012 12:12 AM
Crystal Reports, Crystal Reports XI, SQL Server 2005, SQL Server 2005 Database
Filtering Dates in Crystal Reports
Is there a way to get Crystal to filter dates showing the next 5 or 7 days? I know about filtering using “in the period” but none of those options are for future dates, except like next 30 or 60 days, but I don’t want to see all of that.
Answer Question
| March 11, 2011 9:10 PM
Crystal Reports, Crystal Reports Filter Formula, Crystal Reports Filtering
Is there a way to get Crystal to filter dates showing the next 5 or 7 days? I know about filtering using “in the period” but none of those options are for future dates, except like next 30 or 60 days, but I don’t want to see all of that.
Answer Question
| March 11, 2011 9:10 PM
Crystal Reports, Crystal Reports Filter Formula, Crystal Reports Filtering
Crystal report asks for parameter at runtime
Hello All, I have a problem with crystal reports at runtime…… I have a desktop application in which I have used crystal report… When I run the application, crystal report asks for parameter even though I have supplied it through code in C#. Not able to figure out why this happens….. My Report also contains [...]
Answer Question
| August 12, 2011 10:22 AM
.NET, C#, Crystal Report, Crystal Reports, Crystal Reports Conditional Parameters, SQL Server 2005
Hello All, I have a problem with crystal reports at runtime…… I have a desktop application in which I have used crystal report… When I run the application, crystal report asks for parameter even though I have supplied it through code in C#. Not able to figure out why this happens….. My Report also contains [...]
Answer Question
| August 12, 2011 10:22 AM
.NET, C#, Crystal Report, Crystal Reports, Crystal Reports Conditional Parameters, SQL Server 2005
Customizable IT software for examination process and question database
Thank you in advance for your helpful replies. I am interested in hiring an IT company to create a custom software that facilitates the examination process we offer at our school. However, I am unsure of what exactly is needed so I was hoping for assistance: The goal is to have an online secure web [...]
Answer Question
| February 1, 2011 3:10 PM
CMS, Content Management Systems, Custom software development, Database
Thank you in advance for your helpful replies. I am interested in hiring an IT company to create a custom software that facilitates the examination process we offer at our school. However, I am unsure of what exactly is needed so I was hoping for assistance: The goal is to have an online secure web [...]
Answer Question
| February 1, 2011 3:10 PM
CMS, Content Management Systems, Custom software development, Database
Problems with DB2 program
I have a COBOL program that calls a db2 stored proc program. I get corrupted o/p records when reading the input file from CARTRIDGE. The same records, when copied to DASD, come out fine. Same code, JCL, etc. WTH! Is there a parameter that I need to pass to the system with PGM=IKJEFT01 to solve [...]
Answer Question
| January 26, 2011 3:49 AM
AS/400 Parameters, COBOL, DB2, DB2 administration
I have a COBOL program that calls a db2 stored proc program. I get corrupted o/p records when reading the input file from CARTRIDGE. The same records, when copied to DASD, come out fine. Same code, JCL, etc. WTH! Is there a parameter that I need to pass to the system with PGM=IKJEFT01 to solve [...]
Answer Question
| January 26, 2011 3:49 AM
AS/400 Parameters, COBOL, DB2, DB2 administration
