Edit a text file with VBA
Cheers, I have large text file that needs to be edited to run a job but I would like to automate the process.  How do I open a file and replace line 132 of (which is about mid of the file) that file? Thanks, Bob

Answer Question   |  August 26, 2010  3:18 AM
Access 2007, Text manipulation, VB, VBA

Why does the keyword END is not accepted at the end of a stored proc ?
Hey guys,  I have thise error in SQL stored proc.  I’m on ISERIES and I use RUNSQLSTM to very my procedure. could you help ?  It’s seem I can’t put a END at the end! ———————     160            AND DUDGCT = CDCODE                                              161            AND SUBSTRING(CDCEL3,1,4) = (                                    162      SELECT CLSTHE FROM [...]

Answer Question   |  January 26, 2010  9:03 PM
DB2, iSeries, SQL

Data transfer from DB2 (AS400) TO SQL SERVER 2005
Data transfer from DB2 (AS400) TO SQL SERVER 2005

Answer Question   |  January 25, 2010  11:39 AM
AS/400 data transfer, DB2, DB2 Data Transfer, DB2 to SQL Server Data Transfer, send any detail help please, SQL Server 2005

is there any process to store the data of dataqueue
is there any process to store the data of dataqueue

Answer Question   |  January 21, 2010  7:32 AM
AS/400, DB2

can anybody tell me how to know max sal in db2/400 means in pf
can anybody tell me how to know max sal in db2/400 means in pf

Answer Question   |  January 20, 2010  1:07 PM
DB2, DB2/400, PF

Domino server R7 and DB2
Hi all, I would like to setup a Domino 7 server and DB2. Our environment has experience seperate server for Domino 7 and DB2 server. Does anyone know that is tht possible to install Domino 7 server and DB2 into one single powerful server? Kindly advise. Thank you.

Answer Question   |  January 18, 2010  7:37 AM
DB2, DB2 server, Domino 7, Domino Server

What Hardware is required for implementing a wireless lan for a convention center?
My name is Barry Novack I am with CBE Tex Solutions Consultants. We are representatives of The Society for the Promotion of Japanese Animation or S.P.J.A. We are trying to improve their wireless capabilities at the LA Convention Center. They would like to upgrade to newer equipment and be able to upload, and change events, [...]

Answer Question   |  January 23, 2010  10:41 PM
802.11, 802.11n, Network hardware, RFID, Wireless LAN, Wireless Network Implementation, Wireless networking, Wireless networks

String Field Comparisons
I am attempting to create a formula in Crystal Reports That will compare two string fields and print out an ID number. It seems as though it should be quite simple. Please help.

Answer Question   |  January 19, 2010  7:50 PM
Crystal Reports, String manipulation

DB2 Unload and Load JCL using IBM utility
Hi, Can anyone provide me a JCL to unload and load DB2 tables using IBM utility. I’m new to DB2 and need to unload the Syspunch dataset for a table, as I need to load a the table with data. I just only have the file with the data to be loaded. So I need [...]

Answer Question   |  April 19, 2013  2:47 AM
DB2, IBM Mainframe, JCL

copy files to a server
I have a windows C# form and copy files from the local drive to the server by using its IP address (//11.111.11.111c$test) I don’t know where to use the server’s username and password to be able to copy the files! Thanks.

Answer Question   |  January 14, 2010  5:59 PM
File transfers, Windows File Server, Windows Server

CRM on ESRI PLATEFORM
HI Can I build CRM Packeg on ARCGIS to work with layer and make analyst on this mapes. Best regard,

Answer Question   |  January 12, 2010  6:49 PM
ArcGIS Server, CRM, ESRI, Mapping software

IT evaluation
Should IT evaluation address wider issues, such as risks, implementability, flexibility, organizational impacts and links to strategy?

Answer Question   |  January 14, 2010  1:43 PM
ERP, IT Business Alignment, IT Business Alignment in 2010, SAP

Data Access Layer in RPG
Has anyone implemented a Data Access Layer in RPG-ILE, similar to what is discussed in these articles: http://www.itjungle.com/fhg/fhg072104-story01.html and http://www.itjungle.com/fhg/fhg011205-story01.html If so, can you share some of the positives and negatives of the experience? In hindsight, would you do it again? What would you do differently? Our organization is in the beginning stages of a [...]

Answer Question   |  January 7, 2010  5:23 PM
DB2, RPG, RPGILE

Stop crystal prompts for parameter value
Hi, I created a crystal report with SQL Server stored procedure. I passed the parameters using vb6, all parameters were fine except one of the DateTime data type, when I ran the report it kept coming up with the “Enter Parameter Values” dialog box, is there any way I can get rid of it? Software [...]

Answer Question   |  August 20, 2011  11:16 PM
Crystal Reports, VB 6.0, Visual Basic

Capacity information on Altosoft Insight
Does anyone have capacity information on Altosoft Insight?  Any expreiences or hard data would be greatly appreciated.

Answer Question   |  January 6, 2010  6:06 PM
Altosoft Insight, Business Intelligence, Capacity planning

Inventory
Hi, we acquired AS400 on IBM mainframe, we need to know all processes set and developed, objects and files, I’m newbie in this mainframe does anyone knows a simply tutorial? thanks in advance.

Answer Question   |  April 7, 2010  5:55 PM
Administration and maintenance, AS/400, File management programs

AutoCAD 2009 attributes
I have a block with 10 attributes, each an individual tag number. The prefix to these tag numbers is the zone number, which is identical on all tags. Can I create one attribute and use it in more than one place, such that I only have to type in the zone number once when placing [...]

Answer Question   |  January 6, 2010  12:48 PM
AutoCAD, AutoCAD 2009, AutoCAD Attributes

how to open crystal report in new window
Hi, I m new in crystal report please help me, How to open a crystal report in new window but i want to pass parameter on parent window (web page)?

Answer Question   |  February 1, 2011  9:30 AM
ASP.NET 2.0, C#, Crystal Reports, Crystal Reports XI

Test Cases/Documentation in Agile World
What type of test cases do others write or documnetation is created for testing in an agile world. Does anyojne have a template that works for them. we have been informed that what we currently create is too time consuming to create and update. too much overhead. I’m used to writing my test caes very detailed. [...]

Answer Question   |  October 19, 2010  7:01 PM
.NET development, Agile development, Agile methodology

Reporting Services 2005
Hello, I am running reporting services 2005. I created a subscrition for a report named “paid_claims” that will auto generate an excel file into a shared folder on the network. The “paid_claims” report has a link to another report named “sub_paid_claims” in the same folder. We recently renamed our server from MEDI01a to MEDI01, when [...]

Answer Question   |  January 13, 2010  4:23 PM
Reporting, Reporting Services, Reporting Services 2005, SSRS, SSRS 2005