Get answers.  Share knowledge.  Collaborate with peers.




RPG /Free Local Data Area definitions
I am trying to define the LDA with an external definition in RPG /free. Any help?

Answer Question   |  December 1, 2010  3:11 PM
ILE RPG, iSeries, RPGLE, V5R4
asked by:
15 pts.

reformatting a multi-tab spreadsheet and access 2003
Hi,    I have an instance where I have an Excl 2003 spreadsheet and need to reformat it into a single record format using the data from each of the tabs but I also need to put additional data into the new record. Here is another twist I want to be able to trigger this from my access [...]

Answer Question   |  December 1, 2010  2:41 PM
Access 2003, Excel 2003, Excel worksheets, Record Format Level Identifier
asked by:
5 pts.

T-SQL with Recursion – Display top ID on all levels below (To: Kent Milligan)
Hell Kent, I read through “V5R4 SQL Packs a Punch” http://www-03.ibm.com/systems/resources/systems_i_software_db2_pdf_rcte_olap.pdf    I would need the query in figure 20 and the result in figure 21 which do not show up in the article.  I have a query similar to the example (parts of an iSeries Power5 server) that shows all the levels correctly, however, [...]

Answer Question   |  November 29, 2010  1:36 PM
Recursion, SQL Query, T-SQL, V5R4
asked by:
30 pts.

Exchange 5.5 receiving Exchange 2007 meeting requests
How to setup exchange 5.5 to receive meeting requests from exchange 2007?

Answer Question   |  November 24, 2010  12:03 PM
Exchange 2007, Exchange 5.5, Exchange interoperability, Exchange Meetings
asked by:
5 pts.

Exchange Server 2007 not receiving attachments over 4MB
We don’t receive emails with attachments greater than 4 MB. I’ve keep off all the marks restriction in send and received. THANKS

Answer Question   |  November 9, 2012  10:21 AM
Exchange 2007, Exchange 2007 error messages, Microsoft Exchange Rules, SBS 2008, Small Business Server 2008
asked by:
85 pts.

Is there are way to shrink sybase database to reclaim physical space at OS?
We have a database with 15GB freespace, we want to shirnk it and reduce device size so the physical space can be recliamed at the OS level also. Is it possible?

Answer Question   |  November 24, 2010  9:59 AM
Data storage, Data storage management, Sybase, Sybase 12.5.0.2, Sybase Databases
15 pts.

Outlook 2007 – cannot receive email on any computers
HII FRIEND, Office Version:Outlook 2007 Operating System:Windows  XP.   Cannot received my old & new mail from Outlook 2007 using my yahoo (yahoomail.co.in) account, but i send the mail. PLEASE help –  THANK YOU.

Answer Question   |  August 5, 2011  9:53 AM
Outlook 2007, Outlook 2007 error, Outlook Errors, Windows XP
asked by:
GSS
5 pts.

Converting Lotus Notes Documents to PDF
Hi, Would like to ask how can i convert multiple Lotus Notes Douments to PDF. An agent would be best as the filename of the pdf can be extracted from the different fields in the Notes Document.

Answer Question   |  May 3, 2012  9:46 AM
Lotus Notes, Lotus Notes 7.x, Lotus Notes document, PDF, PDF conversion
asked by:
15 pts.

IN and Exists in SQL?
What is the difference between IN and EXISTS IN SQL? I googled but I dint get good information. PLease provide me the exact deifference between them.

Answer Question   |  November 26, 2010  7:18 AM
Oracle 10g Express, Oracle SQL, SQL, SQL commands, SQL Server
asked by:
220 pts.

Blackberry POP3 not sending mail but receiving is ok
Our company has a BIS, all of a sudden sending emails from BB stop. It has a sent mark on BB but the messages didn’t go thru to the recepient.(connected using POP3). Suprisingly all incoming emails are going in. I tried to check the POP3 using outlook and doesnt have any problem. Kindly let me [...]

Answer Question   |  November 29, 2010  7:03 AM
BlackBerry email, Outlook, Outlook email, POP3, POP3 server
asked by:
40 pts.

Error with this Oracle 10g Express Edition query
SET HEADING OFF; SELECT ‘Song Name: ‘, S.TITLE FROM SONG S I don want to display heading in the result table. I need result like: Song Name: Mungaru Male Song Name: Titanic Song Name: Milana But the Statement “SET HEADING OFF;” results in a result

Answer Question   |  November 24, 2010  6:07 AM
Oracle 10g, Oracle 10g administration, Oracle 10g Express, Oracle Query
asked by:
220 pts.

Launching a browser window from JBA Explorer 6.3.1
Ouside of the JBA Explorer build 6.3.1 (iSeries OS V5R3) I can launch a browser window via a CL on a commandline. Inside the JBA Explorer I cannot. Ideas anyone???

Answer Question   |  November 24, 2010  9:53 PM
CL Commands, JBA, JBA AS/400 STRPCCMD, OS V5R3M0
asked by:
15 pts.

Cooling a data center with 3 racks?
What should be used to cool a small data center that has 3 racks and generates a lot of heat in a small room? We have a budget to ventilate and cool the room. What should we do and how can we find out all our options?

Answer Question   |  February 17, 2011  9:42 PM
Data center cooling, Data center design, Data Center in 2010, Data Center management
asked by:
755 pts.

Updating common files in different document libraries in Sharepoint 2007
Is it possible to have two separate instances of one file in two different document libraries, but when one of them gets updated, have those updates pushed to the other copy in a different document library? If it is, could someone tell me how to accomplish this? Thank you.

Answer Question   |  November 24, 2010  9:39 PM
Duplicate records, SharePoint, SharePoint 2007, SharePoint 2007 interoperability
asked by:
5 pts.

What are people using for IP KVM?
What is everyone using for IP KVM’s? Can they work anywhere on the LAN? How about over the WAN? Is their a client to install?

Answer Question   |  December 6, 2010  9:37 PM
BIOS, Data Center in 2010, Data Center management, Data center operations, KVM, LAN, Switches, WLAN
asked by:
755 pts.

Rack up knowledge points for the Xbox 360 contest over the holiday!
Don’t let the holiday weekend be cause for you falling behind in the ITKnowledgeExchange Xbox 360 contest. Earn points the old-fashioned way by asking and answering questions over at IT Answers, or take advantage of some bounties around the site and get those numbers up! Tweet your favorite ITKE blog post to us @ITKE and [...]

Answer Question   |  November 24, 2010  8:42 PM
ITKE, ITKE Contests, Knowledge Points, XBOX Contest
asked by:
6,315 pts.

Our IP address is being blocked because of a network scanner
Hello We run a small business with about 20 clients on a lan and wlan architecture. We dont have a centralized management. We have about 10 engineers who are connected to a VPN. They are using a remote application located on a University Server. Today, I received a phone call from their IT manager. ”We [...]

Answer Question   |  November 25, 2010  7:58 PM
Access Points, Linksys RV042 VPN Router, Network Scanners, Network security, WLAN, WLAN access points
asked by:
5 pts.

Microsoft SQL Server BCP Utility password
I am executing a Microsoft SQL Server Job that runs a BCP Utility.  The utility loads a table from a file using the ‘in’ argument, a format file and an error file.  I have ‘hard coded’ the user name and password in the command line using the ‘U’ and ‘P’ arguments. I am looking for a [...]

Answer Question   |  November 23, 2010  7:42 PM
BCP Utility, BCP Utility password, SQL Jobs, SQL Server, SQL Server 2005, SQL Server 2005 Enterprise Edition, SQL Server Enterprise Edition
asked by:
20 pts.

Can a 4 bay external hard drive have different hard drive sizes?
I have a “Mediasonic 3.5-Inch USB 2.0 and eSATA Pro Box 4-Bay Enclosure HF2-SU2S2″ and it has 4 hard drive slots, can each hard drive be a different size or must they all be the same for it to operate. Im not trying to raid, I just want to access 4 hard drives with 1 [...]

Answer Question   |  November 4, 2011  7:30 PM
Data storage management, External Disk Drives, HARD drive, Hard Drive Installation, Hard drive space, HDD
asked by:
10 pts.

How to display Domino form field on the web
I have a text field which it’s string value has been separated by semicolon and displayed by new line. I want to display this field on the web the same way it displays in Notes. On the web the content of the field display as one block of 100 line with not break in read mode. Is there [...]

Answer Question   |  November 24, 2010  7:01 PM
Domino 7.0.2, Formula Language, Lotus Domino, Lotus Notes, LotusScript
asked by:
ALK
125 pts.