• 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...

    Joshua55 pointsBadges:
  • SAVACTWAIT time on SAVLIB, etc.

    Hi, Has anyone experimented with the SAVACTWAIT time on the SAVLIB command. The default on 120 second seems rather long. What I am looking for is a realistic value based on fact such as that if an object does not become available after 5 second the change that it will become available after 120...

    JohnDavid5 pointsBadges:
  • “map drive” IFS

    Hello, We have a ?LAN without any server Windows OS in it? , so everybody is a client (with fixed IP). The only ?server? we have, is our iSeries i5 (V5R3) with iSeries Access(CA) installed (also on the clients). We cannot ?map drive? the IFS f.e. root with \QS6555A8Aroot (or anything else on the...

    Hahajokes5 pointsBadges:
  • Transfer Report from AS/400 to PC

    Is there any utilities/tools that can help me to create a program on AS/400 (CL program) to transfer the reports that are created at a certain output queue on AS/400, transfer them automatically to a specific folder at PC side so as to be opened with any application at MS Windows, keeping the...

    Qawasmeh0 pointsBadges:
  • Scanning network packets on Windows server 2003

    We need to capture network packets for analysis on our Windows server 2003. How can we achieve this and is there a guide to analyzing this data?

    TeachMeIT975 pointsBadges:
  • 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?

    Chuck3105 pointsBadges:
  • I want to select some rows and show the average of columns of that rows in another row how can i do that in SPSS?

    i want to select some rows and show the ave of colums of that rows in anaother row how can i do that ?

    Za905 pointsBadges:
  • 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....

    ITnavan0 pointsBadges:
  • Hi I am new for Data Analysis, I want to know how to start for this profile

    Hi I am new for Data Analysis, I want to know how to start for this profile. What are all basic requirements and start from? I know computer basics I am good in Excel. What else required?

    Minisharma5 pointsBadges:
  • CONTEXT DIAGRAM OF THE DFD

    HI, MY NAME IS PATRICK AND IAM TO DESIGN A CONTEXT DIAGRAM OF DFD FOR A HOSPITAL SYSTEM. THE PROCESS IS "ADMISSION SYSTEM" THE ENTITIES ARE: PATIENT, HOSPITAL,OUTPATIENT,DOCTORS/NURSES,HOSPITAL RECORD SYSTEM,MINISTRY OF HEALTH DEPARTMENT,RELEVANT WARDS. WHAT ARE THE DATA INPUT FROM EACH OF THESE...

    875431195 pointsBadges:
  • Data migration strategies

    Hi All I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel...

    Hazermark0 pointsBadges:
  • Performance Problem

    We are experiencing intermittant performance problems most likely related to the update of a file that saves emails sent to customers. The problem may be related to a 10,000 byte text field for the body of the email message and/or the size of this file (2 million records). The file has one index...

    Ashnirody100 pointsBadges:
  • Generating Excel spread sheets from Sequel on the iseries

    I produce an excel spread sheet from sequel on the as400 and e-mail it to a user. The user performs some data entry on the spread sheet. The spread sheet is then transfered to a AS400 Physical file and a program is called that updates a AS400 data base. The problem is when they enter 013, the...

    Johnd0155 pointsBadges:
  • numeric field check

    i have a file that has a numeric field that is being cleared early in a program if certain conditions are meet as the file is being made...i need to check later before that file is printed to see if those conditions have changed....the numeric field is the key....it's not having zeros put in...

    Cowboypgmr0 pointsBadges:
  • triggers

    i know you can attach a trigger to a physical file, but can you attach one to a print file or even a display file. thanks in advance

    Cowboypgmr0 pointsBadges:
  • How to combine variables

    In my data set, I have four variables that have the same codes in them. The four variables relate to the same question that was given four different times to the same people. How do I get all of their responses under one variable so that I can work with it

    Onw3320 pointsBadges:
  • AS400 configuration management tools

    I am new to AS400 platform, and looking for a tool that will allow me to monitor configuration changes on multiple as400 servers and report daily on configuration changes per box and per aome sort of baseline. Any help will be greatly appreciated.

    AWHITSTON0 pointsBadges:
  • STRQMQRY problem

    I've used STRQMQRY command to pass a numeric company code to the query. Unfortunately, everytime I execute the query, it prompts me to enter the company number variable. I would like to execute the query without having to prompt. Could someone in the AS400 development world assist me with this...

    hbrooks10 pointsBadges:
  • iSeries Access ODBC Driver Error

    I'm trying to run a stored procedure on MS SQL Query Analyzer but continue to get the following error: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'MSDASQL' reported an error. [OLE/DB provider returned message: [IBM][iSeries Access ODBC Driver][DB2...

    Sixpach0 pointsBadges:
  • OPNQRYF vs Logical files

    What are the advantages and disadvantages of logical files over OPNQRYF command??

    A1b2c3330 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following