How do I read in the comma delimited files by SAS
How do I save an Excel File with 2 sheets into two comma delimited (.csv) files, first for the sheet tabbed “sheet 1″ and second for the sheet tabbed “sheet 2″? Also, how do I then read in the comma delimited files by SAS? *note: these are excel files that I am trying to read [...]

Answer Question   |  February 9, 2010  5:36 PM
CSV, Delimited function, Microsoft Excel, SAS

Knowledge management (KM) system for large organisation?
We are a large non-profit organisation (20,000+) with many individuals producing minutes and summaries from internal and external meetings, parliamentary debates, conferences, etc. We are considering to implement a Knowledge Management system, which should allow local users to enter summaries directly in a database and thereby make the summaries available to all members of the [...]

Answer Question   |  November 21, 2008  12:56 PM
Database, Knowledge management, Knowledge management applications, Knowledge Management Software

Crystal Report Query – Customers with Multiple Products
I work as MI Analyst for an insurance company and have a query regarding a Crystal Report I need to run. I have been provided with some MI requests from a supplier who we provide products for on a cost per acquisition basis. They require a monthly report containing the total number of sales that [...]

Answer Question   |  November 20, 2008  4:10 PM
Crystal Reports, Crystal Reports 10

Create Opening total in Crystal Reports
How create opening total ? and how to make it display only one time?

Answer Question   |  November 19, 2008  8:41 AM
Crystal Reports, Crystal Reports 9

Export Attachmets
How do you export all attachments for all records from Access 2007 database?

Answer Question   |  November 19, 2008  6:44 PM
Access 2007, Access Database, Access Database Attachments, Export, Microsoft Access

Update help needed
I need to perform an update as follows… Update LIBNAME.SDFILE Inner Join LIBNAME.DXFILE On SDPRDC = DXPRDC And SDSENO = DXSENO And SDORNO = DXORNO And SDLINE = DXLINE Set DXDNAM = ”, DXDAD1 = ”, DXDAD2 = ”, DXDAD3 = ”, DXDAD4 = ”, DXDPCD = ”, DXINVN = 0 Where SDIECD = ‘SO’ [...]

Answer Question   |  November 19, 2008  6:28 PM
DB2, i5, SQL, UDB for iSeries/i5

Write Lotus Notes records from a Lotus Notes database to a DataMart in Oracle
I’m new to LEI and I need to write Lotus Notes records from a Lotus Notes database to a DataMart in Oracle. Does anyone know where I should start on this, or if possible can anyone provide a code snippet? Thank you in advance.

Answer Question   |  November 18, 2008  4:53 PM
Data marts, Lotus Enterprise Integrator (LEI), Lotus Notes, Lotus Notes Database, Oracle

Crystal Reports – Control Breaks and variables
In my report I have 3 groups(Control Brekas): Bank1, Bank2, Branch. Bank1 is for the whole Bank Bank2 is for the District Branch is for the Branch within Bank2 At control break time for Bank2 the last Branch information is printed on the total page. This includes the Branch Name and Number. The Bank2 and [...]

Answer Question   |  November 18, 2008  3:27 PM
Crystal Reports, Crystal Reports printing

QMF
can we save the statements write in QMF?

Answer Question   |  September 23, 2009  2:14 PM
DB2, DB2 query tools, IBM DB2, IBM DB2 Query Management Facility, IBM Query Management Facility, QMF, Query Management Facility

Programming Software for Mazak NTX-48 Champ
I have a Mazak NTX-48 “Champ” laser cutter. We are currently using AutoCad 2004 and using “Auto Code” software to Generate Programs for the Mazak. We are planning on upgrading to AutoCAD 2009, but the company that created and supports Auto Code is no longer in existence. Does anyone any advice on other packages for [...]

Answer Question   |  November 14, 2008  6:42 PM
AutoCAD, Cam software, Mazak, Mazak NTX-48 Champ

DB2 update query giving error STRING REPRESENTATION OF DATETIME VALUE HAS INVALID SYNTAX.
The following sql query in DB2 is giving the exception. What can be the correct query for this in DB2? SQLQuery=update EMP set validityenddate=’01-JAN-07′ WHERE username=’XYZ’ Exception: msg=java.sql.SQLException: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]STRING REPRESENTATION OF DATETIME VALUE HAS INVALID SYNTAX.

Answer Question   |  December 4, 2008  1:24 PM
DB2, DB2 Universal Database, DB2 Update Query

DB2/400
difference between db2 and db2/400

Answer Question   |  September 23, 2009  7:38 AM
DB2, DB2/400, IBM DB2

ASP.NET web application QueryForm Connect to Crystal Reports 2008
Hello, I am developing a web based reports application with Visual Studio 2008, ASP.NET and C# language. The Crystal Reports 2008 is the Data Provider and gives data to XCelsius Visual Advantage to generate the reports based on the Xecelsius model developed. Now the Parameters for generating the new report each time are sent from [...]

Answer Question   |  November 12, 2008  10:12 PM
ASP.NET, ASP.NET Web applications, Crystal Reports 2008, XCelsius 2008

Issue with creating List of Values in Business View Manager
Hi, Could any one help me to figure out what this issue refers to? When i created a List of Values in Business View Manager, it is throwing the following error!!!! *The List of Values used by this parameter cannot be based on a Business View derived from the current Data Foundation or Business Element.* [...]

Answer Question   |  November 12, 2008  7:58 PM
Business View Manager, Crystal Reports XI, Dynamic LoVs

No iDoc creation on Cost Center deletion
When i delete the cost centre , i am not able to generate an Idoc as the cost centre data is physioccaly removed from master table. Kindly suggest a solution so that i can create an idoc pertaining to the deletion

Answer Question   |  December 2, 2008  11:39 AM
COSMAS, iDoc, SAP Cost Center Accounting, SAP FI, SAP FICO

Barcode printing and afp
Do i need barcode afp utility on as/400 to do barcode printing?

Answer Question   |  November 11, 2008  2:50 PM
AFP, AS/400 printing, Barcode, Barcode AFP Utility

MS Access & EDI
Is there a way to use MS Access to interface with a database that uses EDI? If so, what do I need to do to do this & where can I get more info on this?

Answer Question   |  November 11, 2008  1:32 PM
Access, Database Management Systems, DBMS, EDI, Electronic Data Interchange, Microsoft Access

How does Amazon.com use database management systems?
How does Amazon.com use database management systems?

Answer Question   |  June 20, 2010  3:21 AM
Amazon, Database Management Systems, DBMS, RDBMS, Relational database management systems

use of ftp for multiple files
I need to process a JOB in mainframe FROM CONTROL_M with FTP sending multiple files from HOST to a user server. The problem is that I need a name different that the original coming from host, even without ‘ . The execution ( IT’S ONLY A PROOF JCL ): +++++++++++++++ //PTCFTPES JOB (D,ING,4788),MSGCLASS=X,CLASS=A,PRTY=9, // REGION=0M [...]

Answer Question   |  November 7, 2008  8:22 PM
File transfers, FTP, JCL, Mainframe OS

Printing from Crystal Reports XI
I would like to create 2 labels in base of one filed information (this will be numeric information, usually the number 2). I would like to create these labels on base of field BOX# , this number is the number of labels I need to print. I use Crystal Reports XI. My question: Does this [...]

Answer Question   |  November 7, 2008  3:22 PM
Crystal Reports, Crystal Reports printing, Crystal Reports XI