uploading an excel spreadsheet to the as/400
I've seen a developer with an Excel spreadsheet on the iseries server, how do I upload an Excel spreadsheet to the iseries and populate it with data so I can then download the finished product to my PC?
View Answer
| May 5 2008 9:23 PM GMT
| asked by
Chuck310
Microsoft Excel, AS/400, Data analysis
How to create blocks in SPSS
I have a data file with 12,00 trial inputs. When I run my descriptives, I want to combine every 100 trials together as 1 block so instead of comparing 12,00 trials, I am looking at 120 blocks and comparing those.Is there anyway to do this without first going through and running the statistics on...
Answer Question
| May 2 2008 3:04 PM GMT
| asked by
Audreye
SPPS, Data analysis, Data mining/analysis
Crystal report
I just started a job as a data analyst and wanted to see if any want can help me build a report on crystal report.Claims billed by monthClaims outstanding by monthMonthly report showing write off ‘bad dept’Thanks
Answer Question
| Apr 4 2008 0:26 AM GMT
| asked by
Mosaidi
Crystal Reports, Data analysis
Define a field using a query
I'm trying to create a date field from a numeric field and can't seem to get the syntax correct and can't find any help on line.
View Answer
| Jul 26 2007 10:54 AM GMT
| asked by
Cbab1019
Data analysis
Need help for Dynamic tables
In a normal table all the field are defined before.. For example; let's say that we have a Cars Table, it probably will be like this:TABLE_CARSCAR_CODEBRANDMODELVERSIONSPEEDCOLORGEAR_TYPEPRICEIn such a table a single row contains all the data for a single car, so by querying any field of table we...
View Answer
| Jun 6 2007 9:45 AM GMT
| asked by
DetayMan
Data analysis
Select last 3 transactions
HelloCan someone help me to put together an SQL statement to select the last 3 transactions from a transaction file.In TransactSQL I would do something like this:select top 3 CustID, TransDate, Amountfrom Transwhere CustID= '12345'order by TransDate desc.I believe there must be a more effcient way...
View Answer
| May 22 2007 6:54 AM GMT
| asked by
SuhelAC
DB2 universal database, PC/Windows Connectivity, Data analysis
Updating one record with a field of another record where two other fields match
I have the followingTable: XREFGroup Projid id1 id2----- -------- ----- -----------AEEC SOCAL 71 442760CAG AWPE 71 442780CAG MONDPL 71 447585CAG PLANDI 71 442780CAG SMCECA 71 442780CAG AWPE 84 442781CAG MONDPL 84 ...
View Answer
| Mar 1 2007 3:53 PM GMT
| asked by
donnewbee
Data analysis, Database, Oracle
Data Center Builds
Does anyone have any ideas on how to get involved with build outs for data centers from a telecom perspective. My company is looking for opportunities to build out our network but I need to be able to present them with the scenario. I realize this might sound like a "sales" message or...
View Answer
| Jan 9 2007 4:48 PM GMT
| asked by
lejoneric
Budgeting, Business/IT alignment, Compliance
datamining SQL with access
I have been asked by the sales department to datamine our SQL database and pull the names and e-mails of all our guests for the last few years for a contact list. I am new to SQL but have worked with access in the past. Using access, how do I set things up so that access will see the database...
View Answer
| Jan 4 2007 4:29 PM GMT
| asked by
daiishi
Data analysis, Data mining/analysis, Microsoft Windows
how to create our own set up file in vb6.0
dear friends i want to know how to create setup file of our project in vb6.0wait i know how to create setup file using package and deployment toolbut i want to know how can i create a file in which we can include images, pictures, some animationsi mean setup file with our own ideas and designplz...
View Answer
| Dec 29 2006 6:19 AM GMT
| asked by
rajevinayak
Project management, Career development, Training
Windows Server 2003 connection problems
I am seeing converstions with my IIS6 server terminate after about 15 min during a download of a large file. A tcpdump shows the server is sending out a rst/ack packet (not good) followed by 20 more rst packets to the destination IP. I was able to capture the failure as it happened but I have no...
View Answer
| Dec 21 2006 1:08 PM GMT
| asked by
Fullerine
Data analysis, Networking, DataCenter
RUN TIME ERROR 339
I have an application written in Visual Basic. The application runs on windows XP system with oracle 8i and Crystal report 8.5The application suppose to interface with an oracle 8i database. In attempt to run the application it gives this error: 'Run-Time Error 339 component 'CRYSTL32.OCX' or one...
View Answer
| Dec 8 2006 11:42 AM GMT
| asked by
IdongesitDaniel
Data analysis, Oracle, Database
Excel Spreadsheets
We developed some kind of database with excel spreadsheets to draw monthly stats for diffrent departments. It works as follows: Individual spreadsheets(formulated)feeds into a master Link spreadsheets(data) we then use Pivots for our reports. The problem that I now expierence is that:1. The...
View Answer
| Nov 21 2006 2:42 AM GMT
| asked by
joshua5
Data analysis, DataCenter, Database
Mail sending error in certain domains through excahnge server 2003
Hi allRecently I have installed exchange server2003, and configured outside email also its working fine, I can send and receive mails form yahoo, hotmail, gmail, but some domain I can not send but I can receive mails from these domains. I am getting following error messageYour message did not reach...
View Answer
| Nov 16 2006 8:41 AM GMT
| asked by
management
Business/IT alignment, Data analysis, Exchange
Conversion Project
We are currently working on a project which will at a later date will require alof of data conversion on our existing system to fit the new file structures which are currently been developed. The project is been developed using COBOL on an iSeries, the old and new files will all be physical files.I...
View Answer
| Nov 15 2006 6:46 AM GMT
| asked by
ITnavan
AS/400, Application development, DB2 universal database
Problem while printing an outlook message
Hi,Hey I've one problem please any one help me out to solve this. The problem is while we are printing an outlook message then it prints date automatically in the footer. So is there any way to remove this date? If we remove it from header and footer then also it prints the date. So I am currently...
View Answer
| Nov 9 2006 8:20 PM GMT
| asked by
Prash786
Data analysis, Data mining/analysis, IBM
can strqmqry be run as remote command
I am trying to run strqmqry via a dos/cmd ftp session.command: QUOTE RCMD STRQMQRY QMQRY(lib/qry) ...where ... are other optionsI followed various instructions posted here and on as400 tech sites on how to create the query. I was able to do all of that via a dos/cmd ftp session (except for editing...
View Answer
| Nov 8 2006 4:52 PM GMT
| asked by
bdatadigger
AS/400, Application development, Backup & recovery
MS SQL Server 2000
Hi All,Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?
View Answer
| Nov 8 2006 0:53 AM GMT
| asked by
Sudh2k
Application development, Backup & recovery, CLP
OPNQRYF’s MAPFLD
I am trying to create an OPNQRYF and use MAPFLD.I need to place conitionally one of two fields into ALPHANAME, I defined in MAPFLD.These fields are conditionally placed as follows:LNAME ===> ALPHANAME if LNAME is filled.BUS_NAME==> ALPHANAME if LNAME is blankAPHANAME is defined this way in...
View Answer
| Nov 7 2006 1:25 PM GMT
| asked by
JohndeCoville
AS/400, Application development, DB2 universal database
security problem
Hello,I have small workgroup having 10 computers in my office. I do some personal work in office like using yahoo messenger, checking personal e-mails and some online banking site. But how does one of my senior knows it? I do everything lonely and securely so that nobody in the office knows it. But...
View Answer
| Oct 31 2006 3:44 AM GMT
| asked by
BinooDas1234
Backup & recovery, PC/Windows Connectivity, Security
