Crystal Record selection
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

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   |  August 5, 2009  4:53 PM
COBOL, DB2, EDM Pool

Migration
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

EDI transactions
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

ORACLE DBMS vs. SQL sever DBMS
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

Problems from reindexing tables every day on a SQL Server
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

iDoc for a EDI X12 211 Message
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

Migrating from SQL Server 2000 to SQL Server 2005 on DTS packages
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

Extracting data from a DB2 table using IKJEFT01
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

How to calculate Shop Order due date in BPCS
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

Hardware Migration from 3.5 to 7.0
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

Data model used by SAP
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

Dynamic Database Path Change in C# .NET
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

Barcodes in RPG
How can I code EAN13 barcodes in RPG

Answer Question   |  October 17, 2008  8:27 AM
Barcode, EAN-13, European Article Number, RPG

RPG 3 duplicate record error handler
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

Querying a CSD VSAM file
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

Connect:Direct batch script and direct.exe run
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 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

Cross-platform tools for security, monitoring
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

releasing SSRS reports to clients
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