• Synon/Cool:2E – internal/external func performance question

    I have a situation where I have to call a synon function multiple times (for each record in a file one after another) from another synon function. The called function does some calculatons. Will there be any performance improvement if I make the called func an internal function and have an external...

    Rituraj0 pointsBadges:
  • SYNON vs COBOL

    Hi All, This query is related to performance. I am currently in the process of changing an application from COBOL to Synon. The application uses a lot of I/O involving files. Upon converting the application to Synon, I find that the performance has declined - COBOL takes 8 minutes whereas Synon is...

    Rituraj0 pointsBadges:
  • CPYTOIMPF error code 3025

    I am new to AS/400 and I wanted to transfer a file from AS/400 to PC using CPYTOIPMF as per advised here. But I am receiving an error, "File system error occurred" (Error number 3025) What's wrong?

    Radycal45 pointsBadges:
  • SQLCOD = -7008 when doing an insert into file using SQLRPGLE

    Hi, I'm trying to insert selective records from one file into the same file in another library. I have to do this for many file. Am building the query dynamically using SQLRPGLE. Am using a PREPARE statement and an EXECUTE statement to run the query. While the PREPARE statement ends fine, am...

    SasiKumar0 pointsBadges:
  • iSeries DB2 – Have Physical File need to create Logical File to access Member

    I know very little about the iSeries (I can spell it is all). I am working with an ODBC connection to get to DB2 data on the iSeries. Everything is going extremely well other than 2 files that I need to access use members. These are the only ones that do on the entire system. I was told that I...

    mgrady15 pointsBadges:
  • 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 to get the syspunch file created first and...

    Ari200940 pointsBadges:
  • Export in db2 iseries

    i want to export query output to a csv file on iseries ..can anyone tell me how to do that

    Hn25 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • adding partition to existing non-partitioned table

    Hello all! I have a tables without partitions and I now want to partition it. How do I go about this? I tired alter table ... add partition... but it errors with "ORA-14501: object is not partitioned " So I tried to re-create the table with partitions: create table quote_header_test as select *...

    Skovac0 pointsBadges:
  • is there any process to store the data of dataqueue

    is there any process to store the data of dataqueue

    Siru15 pointsBadges:
  • Using two same files from different libraries in a RPGLE program.

    Hi All, Please guide me for the following problem. I got stuck into it. I want to operate same file from two different libraries in a RPGLE program. Remember we are taking the file names at runtime. So we don?t know the structure of files. Like the record format name etc. Again somehow I retrieve...

    navinnegi45 pointsBadges:
  • DB2 to Text File Conversion and Transfer

    I have created a Text File from my AS/400 DB2 table. I want to transfer this file from one iSeries system to another. How to do this?

    gvdsswami20 pointsBadges:
  • Reading a file twice in CL

    I declared a file in CL. I read all the records, i.e End Of File has reached. Now again i want to read he file from beginning within the same program.I tried with OVRDBF and POSDBF.But could not succeed.Can any body help me?

    Kumari0 pointsBadges:
  • Rookie using DSNTEP2 and IBM JCL – Need Help with JCL

    I'd appreciate some help here. My JCL background is HP3000 / MPEX and HP-UX, but my IBM mainframe JCL experience is over ten (10) years old. So I'm having problems creating a JCL - my brain can't remember command syntax's from that long ago. I need to create a JCL that will accept an input file of...

    Jonty Walker105 pointsBadges:
  • DB2/400 SQL Sub Query Performance?

    Here is the problem. Table INVEHH is a (Events header table) with about 500 records and INVEHD (Event Details) with about 22 million records. These tables are on a DB2/400 database. 1) Original Query that takes forever: select EVENT, INUMBR, ISTORE, EVHYY, EVHMM, EVHDD from INVEHD where EVENT in...

    Apothen0 pointsBadges:
  • Mainframe Performance Testing

    I am doing a research and would like to get answers to the following questions, I appreciate and value your experience and time: 1) What are the different types of mainframe applications? 2) What are the general performance issues that are expected? 3) What tools are used in performance testing...

    Iluvlearning0 pointsBadges:
  • Mainframe quality assurance testing tools

    I need to find a quick and cheap mainframe testing tool for an insurance application. The client will not spend the dollars till the concept is proven. I have looked for open source for the mainframe and found nothing. The client is running a batch system processing input are batch claims. Any help...

    Frankd0 pointsBadges:
  • Best Practices for Mainframe Testing

    I am looking for some tools and best practices which are best to be used for testing Mainframes especially batch. I have had list of tools namely Xpediter, Smartest,IBM's debugger, QA Hiperstation,CA Inter Test etc... Could anyone guide me as to which tool is best for Testing Mainframe Batch. The...

    Consultantmainframe0 pointsBadges:
  • RRN Max in a DB2 file

    Is there a way to allow more than 1 billion records in a DB2 File? We have reorged to file to get rid of deleted records, but are still out of room. The system will not allow one more record to be added because we have reached 999,999,999 records.

    Nay ray5 pointsBadges:
  • MS Excel 2007 load data into database

    I am using MS excel 2007 and would like to upload data into DB2 database. I could do this before on my older version of Excel. How do I do this with MS Excel 2007?

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

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

Following