How do I make a file lock on a DB2 file before accessing it, to ensure that is is not updated while I’m acccessing it ?
Answer Question | September 18, 2012 1:42 PM
AS/400 - CL Command, DB2
LogiXML recently conducted a survey of 757 IT pros on how they view users of business intelligence and some of the more highly entertaining results included: 76% say users make BI needs known by “screaming like banshees” or assuming IT had “telepathy” 38% think users spend most of their time “checking Facebook comments on photos [...]
Answer Question | September 14, 2012 2:46 PM
BI, Business Intelligence
I must redo a report using a new query. How do I tell the report to use the new query?
Answer Question | September 13, 2012 3:08 PM
Sign up for the Teradata live webcast on September 19 at 1 p.m ET as industry analyst Lyndsay Wise will discuss the challenges companies are facing today by relying on traditional BI tools and systems alone and will highlight the benefits of adopting an integrated BI and data warehousing architecture.
Answer Question | September 12, 2012 5:10 PM
BI, Data warehouse
I have a Crystal Reports 2008 report in portrait format that has become too crowded. Is there a way to change the orientation to landscape so I can spread the fields out, without starting from scratch?
Answer Question | August 31, 2012 1:20 PM
Crystal Reports 2008, Crystal Reports Formatting
I’m looking for a formula that will adjust a timestamp if the current timestamp is not within business hours. If the current timestamp is after 5:00PM the timestamp should increment the date portion by the correct number of days (Depending on Day of Week) and the time portion should be set to 8:00AM. Similarly if [...]
Answer Question | August 27, 2012 9:50 PM
Crystal Reports, Crystal Reports 10
Is there any way to track “User Account” information on a DB2 server specifically when a users account is locked?
Answer Question | August 22, 2012 3:57 PM
AS/400, audit, DB2, logging, Security
Can I connect Pressure Transducers(Eg:UNIK5000) (0-600bar) and Vacuum guages(Pirani & Penning Guages-upto 10^-8 Vacuum) to Yokogawa MW100 DAQ Module for realtime data acquisition? If it is possible to connect,then is there any necessary interfacing device/unit required?
Answer Question | August 19, 2012 3:10 PM
DAQ, Data acquisition, Pressure acquisition, Vacuum acquisition.
I have two drives on my PC. A SSD and a HDD. If I install an application (arcGIS) on my solid state. is it okay to store data for that program(maps and files that the program with use in its database) on the HDD or will it be faster to keep them on the same [...]
Answer Question | August 18, 2012 3:02 PM
GIS software, HDD, SSD
Data that is provided by a vendor is to be scanned and processed, however instead of a fixed format, this data is “group separator” (ASCII Code 029) delimited. In the 5250 session screen field that the scanner writes to, the data is being loaded but the group separators are being stripped out. So it is [...]
Answer Question | August 10, 2012 5:07 PM
5250 emulator, ASCII 029, Barcode, RPGLE, scan
I do not know how to design a report that will display the data the way I need. It is hard to describe here, but I will try with a simple example. Each record is based on a date. On each date there are entries to 0-200 accounts for various $$ amounts. IE: on 1/1/12. [...]
Answer Question | August 3, 2012 3:46 PM
Access, Access 2007, Report format
I have a physical file on the iSeries (V7R1) that I am trying to send to the IFS using CPYTOIMPF. When I open the file on the IFS using Excel I expected to be able to parse the data using “Text to Columns” but the delimiter characters are missing and the text is garbled. Several of the [...]
Answer Question | August 3, 2012 2:50 PM
CCSID, DB2, DBCS, Japanese
Is it possible to temporarily deactivate a SAS liense from one PC and activate the SAS license on a different PC?
Answer Question | August 1, 2012 2:24 PM
In Format Formula Editor : Bottom_Line_Style, how do I put a bottom border on when the field is null.
Answer Question | July 26, 2012 12:49 AM
Crystal Report 8.5, Crystal Report formula
Hello, we need to set up a webdav connection between SAP EP 7.02 and MSS 2007 under http. I have done this several times, following the procedure in help.sap, but only between SAP systems. what is done: 1.SSO is created and tested 2.Memory and ACL cache are created 3.New http system is created and the URL [...]
Answer Question | July 24, 2012 3:26 PM
Knowledge management, WebDAV
Hi I extract data from our ERP to show an order detail, to use with printing bar codes. The bar code software always ignores the first line, ao I am looking for a method to duplicate the first detail line only. For example I want: DB100 x 10 DB100 x 10 DB101 x 12 DB103 [...]
Answer Question | July 23, 2012 3:58 PM
I have a .dbf database file I want to upload to our IBM i5 and into a DB2 table. Is there an easy way to do this or am I going to need to convert the .dbf file into a .csv file? I’ve tried using the CPYFRMIMPF command, but have had no such luck. Any [...]
Answer Question | July 19, 2012 3:02 PM
AS/400, CPYFRMIMPF, DB2, DBF file, i5, V5R4
When designing a report in Crystal Reports XI I am not able to set it to a specific printer. In previous version of Crystal Reports there was a Printer Setup section. Is there a way to assign a specific printer to a report in Crystal Reports XI?
Answer Question | June 26, 2012 1:32 PM
Crystal Report XI
in paperspace, how do you hide the viewport frame but still see what is in the viewport
Answer Question | June 26, 2012 1:12 AM
I have a report where I want to sum the value of a group. To get the correct number I first need to sum the multiple receipts and subtract the total receipts from the quantity required. This gives me the correct value which I multiple to the unit price. I have the correct unit price [...]
Answer Question | June 19, 2012 3:37 PM
Crystal Reports 10, Crystal Reports formulas