CPYTOPCD
I have problem in CPYTOPCD command; I have on PF and one flat file, My RPG1 program dump data first in PF then RPG2 program dump data with (~) saprater  In Flat file, Then my CL program dump data from flat file to QDLS folder in TXT format, when I open the TXT folder in [...]

Answer Question   |  August 17, 2009  11:22 AM
CPYTOPCD, Crystal Reports

comparing variable to a field with comma-separated values
"m trying to compare a variable (@item) to a field which has multiple item numbers separated by commas. I've used "LIKE" and "IN" to no avail. I've also tried appending wildcard characters to the variable (@item2), which also hasn't worked. Full-text indexing is not activated on the DB (SQL Server 2000), so I can't use [...]

Answer Question   |  August 15, 2009  2:00 PM
Comma Separated Values, SQL Server 2000, SQL Server development

User Defined Field Setup Crystal Reports 8.5
How does one create a user defined field in Crystal Reports 8.5. I needed a field in IQMS to enter employee information so I created a user defined setup with a pull down menu, but I have to now add the field to the table that is being used in Crystal Reports but I don’t [...]

Answer Question   |  August 13, 2009  8:54 PM
Crystal Report 8.5, Crystal Reports, User report

IBMDB2 runtime issues with HP 2730p laptop
When displaying catalogue with IBM DB2 Runtime, a blank display appears.  It will not display the command windowl  This problem occurs only with the HP 2730p Tablet.

Answer Question   |  August 13, 2009  1:57 PM
DB2, HP 2730p, IBM DB2

Blobs and Memos in formulas
I need to use a field that is varchar2(2000) in the Oracle.  How do I use this field in a formula in Crystal Reports 8.5?

Answer Question   |  August 14, 2009  1:36 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports 8.x

Crystal Reports VII, viewing data while using select expert
Sorry if this duplicated, I thought I posted this but I can’t find it anywhere here goes I created a report with crystal 7 and I using the select expert  for a particular field/table. When I use the expert the drop drown menu does show me every thing in the table. Is there a limit [...]

Answer Question   |  August 12, 2009  5:20 PM
Crystal Reports, Crystal Reports 7

AutoCAD Civil 3D 2008 Block Insert Time
Why does it take so long to insert a block in Civil 3D 2008?

Answer Question   |  August 7, 2009  10:37 PM
AutoCAD, AutoCAD Civil 3D, Civil 3D 2008

Crystal Reports grouping by date
Hi, I’m trying to group single dates (eg. 1 Jan 09, 9 Jan 09, 11 Jan 09, etc) by weekly interval (e.g. 1-7 Jan 09, 8-14 Jan 09, etc). Any suggestions please?

Answer Question   |  August 11, 2009  2:17 PM
Crystal Reports

knowledge management
Explain the role of ERP in achieving optimum SCM

Answer Question   |  August 6, 2009  12:49 PM
ERP, Knowledge management, Knowledge management applications, Scm

Business Intelligence for Financial Module
I’m looking for a BI demo for EBS Financial Modules (AR, AP, GL, etc)

Answer Question   |  August 6, 2009  7:29 AM
BI, Business Intelligence, SAP

can not find database dll
How to fix “can not find database dll”

Answer Question   |  August 5, 2009  6:18 PM
Crystal Reports 8.5, Crystal Reports error messages, VB, VB6, Visual Basic

runtime error “server has not yet been opened”
Runs in Crystal IDE but not when run from VB. Access DB. Have 8 other reports using same code which work.

Answer Question   |  August 12, 2009  4:06 PM
Crystal IDE, Crystal Reports, Crystal Reports 8.5, Crystal Reports error messages

Crystal report Crosstab
I want to run the report for 2007,2008 and 2009 how to display this three year in the top by month

Answer Question   |  March 11, 2010  3:23 PM
Crystal Reports, Crystal Reports Crosstabs, Crystal Reports Projects

Crystal 8 & SQL problem
I created 80+ reports for the company intranet and they worked great. At the time the ODBC’s were set up for a general SQL connection of sa/blank password. Now the connection connects via windows login/password. The reports have stopped working. I rebuilt one from scratch and put in on the intranet but it still doesn’t [...]

Answer Question   |  August 5, 2009  2:19 PM
Crystal Reports, Crystal Reports 8, ODBC, SQL

COM Class DLL in Virtual Directory
Hi all, I created a COM Class DLL and was able to run my application on local. However, when I shifted everything to the virtual directory, it started giving problem. Particularly problems like, “Retrieving the COM class factory for component with CLSID {XXXX} failed due to the following error: 80070002″, and “Cannot create ActiveX component”. [...]

Answer Question   |  August 5, 2009  4:26 AM
COM, DLL, VB, VB.NET, Virtual directory

What’s a good, simple reliable way to log errors for later investigation?
I’m doing new work in an old old system. It’s built with a bit of everything you could use from System/34 onwards – except maybe WSU. Naturally, as I Put together new functions, I test return codes, record locks, database integrity as I go. Just spent a couple of hours finding out that a function [...]

Answer Question   |  August 5, 2009  12:42 PM
DB2, DB2 error logs, i5, Joblogs, Logging Operators

Build a Data warehouse end to end
Im asked to build a datawarehouse from end to end. I have already worked on datawarehousing projects. I need to prepare a proposal document. How do i prepare a proposal document that explains End-to-end development. Can I get a sample document? Thanks.

Answer Question   |  January 9, 2012  12:39 PM
Data Warehouse Planning, Data warehouses, Data warehousing

More than one level nesting in crystal reports
Hi, **************** Using: Crystal reports XI release 2 Database – DB2 **************** I have three screens(say A,B and C). When I click on an item in A screen then it should display screen B and when I click on an item in screen B then it should display scren C. Eg. screen A -> screen [...]

Answer Question   |  August 3, 2009  10:49 AM
Crystal Reports, Crystal Reports Nesting, Crystal Reports XI

CPYTOIMPF
i am new to as400 and i wanted to transfer file from as400 to pc using CPYTOIPMF as per advised here. BUt i am receiving an error File system error occurred. Error number 3025. whats wrong? thanks

Answer Question   |  December 13, 2011  7:41 AM
AS/400 error messages, CPYTOIMPF, DB2, Error number 3025

Automatic transfer of AS400 output file to PC folder
Is there a way to automatically transfer an output file to PC folder in an Excel form? My boss want me to create a CL program that every time the output file was created, it automatically convert that output file to Excel(numeric values in comma seperated) in a PC folder. I usually do this manually. [...]

Answer Question   |  August 3, 2009  2:09 AM
AS/400 output files, AS/400 Transfer, DB2