There could be many reasons, and many solutions. 

I would recommend doing a deep inspection of the applications/processes that are running in the background to make sure that only what is really needed is running.  This would include reviewing the startup type of processes, and applications that are set to start on the machine’s startup. 

Also, I would recommend a complete scan with a good antimalware product.

If you must use WRKQRY, then create a new field named OVER10 for an example. Define it as SUBST(NAME,11,5). Then select the records where OVER10 is not blank.Try that.

You can come back you pst files owing to repair ost file outlook 2003

as a starting point for you to look into, read up on the use of the CL Command CPYFRMIMPF

I came across a post in Zend forum which states that zend looks for /usr/local/mysq/bin/mysql.sh. However, when i checked we didn’t have it.http://forums.zend.com/viewtopic.php?f=77&t=6793 

Perhaps there is a gap in our understanding 

   of what you’ve done.

Your program compiled successfully?  

   What did you do, how do you know this?

Your program ran successfully?  

   What did you do, how do you know this?

Your program didn’t add a record?  

  What did you do, how do you know this?

Is it a library list problem?

Any chance you can share how you discovered that obscure glitch? Sorry there weren’t any hints visible that I could help with. — Tom

Problem solved. The problem was that a file ‘mysql.sh’ was missing in mysql/bin but i cant understand why zend didn’t create it during installation or mysql itself for that matter. It took us about 5 days to figure that out. I did find the log file but that didn’t give any error message. If only it had mentioned that ‘mysql.sh’ was missing it would have made it a lot easier. Thanks for your responses Tom.

i am able to write a record successfully not sure why you are not able to do , for your information , i have given you the code which might help full to you.

Ravula

Fpf01      uf a e           k disk    usropn   
C                   open      pf01             
C                   eval      eno=100          
C                   eval      ename=’xyz’      
C                   eval      esal=40000       
C                   write     format           
C                   close     pf01             
C                   eval      *inlr=*on        

The program works for me with no significant changes. I created my SAMPLE1 table with SQL, so I did add a RENAME() keyword for the record format to get the REC format name. But it worked as written.
 
So, it doesn’t seem to be a problem with the program itself.
 
That means that the program didn’t run successfully (perhaps didn’t run at all), or it added a record to a copy of the file, or it ran under commitment control and didn’t commit the record, or…?
 
More info is needed. The file description might help, but you should verify that everything is configured as you think it is.
 
Tom

The best answer is to stop using Query/400. It’s old, almost obsolete, slow and can’t handle many of the system’s newer features. You should use QM Query instead.
 
One possible way with Query/400 would be to check a substring of the last five characters. If the last five characters are all blank, the length must be 10 or less.
 
Tom

Rumba is a non-IBM product. I don’t have it; so you need to look at Rumba documentation, ask Rumba support or test it. Or you can wait to see if some member can test it for you. It might be faster to do it yourself. — Tom

First, is it really “Client Access”? Or is it one of the later products, i.e., iSeries Access or System i Access? What is its version? And what is its service level? What is the OS on the PC? What is your server OS version? — Tom

Take Start-> Settings-> Control Panel-> System. On the ‘Advanced’ tab in ‘Performance‘, press [Settings]. On the ‘Advanced’ tab in ‘Virtual memory‘, press [Change]. In the ‘Paging file size for selected drive‘ section, how much is shown for “Space available”? In the ‘Total paging file size for all drives‘ section, what are shown for ‘Recommended’ and ‘Currently allocated’? — Tom

Impossible to say. What is the format of the .CSV? What is it supposed to be imported into? What product are you using? Answers to those might be enough to ask questions that could possibly lead to a solution. — Tom

If Support at HelpSystems says it’s because of job number rollover, tell them they need to fix it. It’s a bug in their product. Job number rollover is a system characteristic that’s been around since job numbers have first existed. There is no reason it shouldn’t be handled by any product that uses job numbers. In fact, job numbers (nor even full 26-character job names) should not be used if uniqueness is required for proper operation; they are known not to be unique. And if uniqueness isn’t at the heart of the problem, then rollover shouldn’t matter. — Tom

Will this code may work in RUMBA…..

You need a RCA-to VGA adapter, but they’re easily available, either through simple on-line searches or probably at a local Radio Shack or similar electronics retail store. — Tom