File lock on DB2 AS/400
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
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
Open IT Forum: What are your thoughts on business intelligence?
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
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
redoing a report
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
Reports
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
Reports
Teradata Live Webcast: Creating an integrated BI and data warehousing architecture
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
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
Orientation Question
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 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
CR Formula For Adjusting Time
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
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
AS400 DB2 Server User Access Audit
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
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
Data acquisition of Pressure and Vacuum through PC Using DAQ Module
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.
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.
Multiple hard drive question
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
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
Processing scanned data that is delimited by ASCII code 029
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
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
Report design Access 2010 / 2007
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 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
Character delimited csv with double byte data
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
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
SAS 9.2
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
SAS 9.2
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
SAS 9.2
How do I put a bottom border on null fields?
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
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
Webdav repository between SAP EP 7.02 and MSS 2007
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
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
Create duplicate of first detail line
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
Crystal Report
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
Crystal Report
Importing a .dbf file into IBM DB2 table
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
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
How to specify printer in Crystal Reports XI
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
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
Viewports in AutoClad 2007
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
Autocad 2007
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
Autocad 2007
Summing shared data from a subreport
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
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
