I need to eliminate duplicate records by comparing two fields, if the data is the same, I only want it to appear once. “Select Distinct” report option compares the complete record. Please help
Answer Question | October 30, 2008 5:22 PM
Crystal Reports, Crystal Reports Record, SELECT statement
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 | August 5, 2009 4:53 PM
COBOL, DB2, EDM Pool
Can any one share migration of content experience from Livelink to documentum?
Answer Question | March 7, 2009 5:29 PM
Documentum, Livelink, Livelink to Documentum Migration
what happens if a transaction file arrives at the wrong destination? And will the payer trll you what is wrong with your transmission?
Answer Question | October 29, 2008 4:39 PM
EDI, EDI Transactions
What are some key differences between Oracle DBMS versus an SQL server DBMS? Also, What are factors that would make someone want to use an Oracle DBMS versus an SQL server DBMS?
Answer Question | October 29, 2008 7:59 PM
Data base management, DBMS, Oracle, Oracle DBMS, SQL Server, SQL Server DBMS
We have a daily job running to reindex all the tables for all the databases on our SQL Server. If I reindex selective reporting tables everyday, take a transaction log backup right after reindexing and check if the transaction log is greater than 1GB, I think I should invoke a stored procedure to shrink the [...]
Answer Question | October 28, 2008 5:58 PM
Indexing (information management), SQL Server, tables
What IDoc is used for the EDI X12 211 Transaction?
Answer Question | October 23, 2008 9:49 PM
EDI, EDI X12 211, Electronic Data Interchange, iDoc
Could someone help me with a SQL Server 2000 migration to SQL Server 2005 on DTS packages? I have a Dynamics GP integration that uses the DTS package, but I don’t know SQL or DTS packages well enough.
Answer Question | December 9, 2008 7:57 PM
DTS packages, Dynamics GP, Microsoft Dynamics GP, SQL Server 2000, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server migration
I’m trying to extract data from a DB2 table via an SQL query and use IKJEFT01 to create a flat file. However, one of the non-key fields contains characters that are not nulls but non-printable. Whenever IKJEFT01 extracts these characters it changes them to nulls in the flat file. Is there an alternative IBM utility [...]
Answer Question | September 22, 2009 12:30 PM
DB2, DB2 Table, IKJEFT01, SQL Query
On Shop order release (SFC500) of BPCS, when I put shop order release date and leave blank for due date, program will automatically calculate due date. I don’t understand the method of calculation. I don’t have data in shop calendar. How Run hour ,set up hour ,machine hour of routing concern with calculation? Does Available [...]
Answer Question | October 21, 2008 11:24 AM
BPCS, Enterprise Resource Planning, ERP, Infor Global Solutions, SFC500, SSA BPCS
We recently upgraded to 7.0. Two days later, the scripts are just hanging and had to kill them after 24 hours. No changes were made in R3 nor BW tables. Are we missing a critical step after the upgrade?
Answer Question | October 20, 2008 11:10 PM
Enterprise Resource Planning, Migration, SAP 3.5 to 7.0 Migration, SAP R/3
Does SAP retail moduels support the ARTS IXRetail data model or does it use its own proprietary format. Thank you
Answer Question | October 19, 2008 10:39 PM
Data models, Schema
The Crystal Reports templates that our software uses are on the C: drive. The Crystal Reports templates selected database tables have a C: drive path. If the databases used by the report and the report templates are both on the C: drive, the reports appear correctly. If the databases are on the E: drive and [...]
Answer Question | October 29, 2008 10:08 PM
.NET, Crystal Reports, Crystal Reports 9, Crystal Reports Templates, Dynamic Database Path
How can I code EAN13 barcodes in RPG
Answer Question | October 17, 2008 8:27 AM
Barcode, EAN-13, European Article Number, RPG
The physical file has a field keyed and unique. If i want to update these to RPG 3 program it is showing a duplicate record error. Does anybody have solution? tell me the command to handle this error only for RPG 3.
Answer Question | August 27, 2010 5:23 AM
Duplicate records, Error handling, Physical File, RPG
How do i query a CSD VSAM file? This query is for the validation of the programs which we have already defined using ceda. If the same program name exists in the file it will throw an error message.
Answer Question | October 16, 2008 5:22 PM
CSD VSAM, Mainframe, queries
Hi, How do i create a batch file that I can schedule in order to start a DWP PROCESS at a given time, even when using Direct.exe.
Answer Question | October 16, 2008 4:03 PM
Connect:Direct, DWP PROCESS, File transfers
What is referential integrity in DB2/400? & What is field reference file in DB2/400?
Answer Question | August 31, 2010 3:37 AM
Data quality, DB2/400, Referential integrity
What would be some good cross-platform administration tools to use for an environment running Windows OS X and Debian’s test release lenny? It is a small business (<200 employees) and the main concerns are being able to perform secure file transfers throughout the system and keeping track of everything going on on the different operating [...]
Answer Question | December 8, 2008 3:09 PM
Debian, Integration, Linux monitoring and troubleshooting, Monitoring, Network monitoring
we have clients that have ssrs installed on their servers and we would like to supply them with reports we have created using ssrs. what is the best way to go releasing our reports to our clients?
Answer Question | October 15, 2008 11:43 AM
Release management, Reports, SSRS