ButNewtonDidn’tHaveAProblemWithCarrageReturns.

I agree with Tom.I really don’t understand how a computer works .. there’s something happening in the transistor that’s electro-chemical-mechanical that I’ve never grasped.  Short of designing transistors it doesn’t seem necessary to grasp it.   I can continue to use my analogs to the cams and gears in Babbage’s machine to design and develop my programs.  His machine is in my cloud, what’s in yours.Newton could describe gravity but he didn’t understand it!Phil

thanks alot that worked….

Many ideas. Can you boot from CD and view OS boot logs? — Tom

Order by a column that will produce the desired results ..

select to_char(order_date,'mon-yyyy') "months", 
    sum(nob) "number of bags" 
from p_in 
where order_date between '1-apr-11' and '31-mar-12' 
group by to_char(order_date,'mon-yyyy')
order by to_char(order_date,'mon-yyyy')

will put the list in month name alpha order 
.. Apr 2011 folowed by Apr 2012 .. not the order you want
So you need the date in a format that can be sorted properly.

select to_char(order_date,'mon-yyyy') "months", 
     sum(nob) "number of bags",
     to_char(order_date,'yyyymm') "YearMM" 
from p_in 
where order_date between '1-apr-11' and '31-mar-12' 
group by to_char(order_date,'mon-yyyy'),
      to_char(order_date,'yyyymm')
order by to_char(order_date,'yyyymm')

Recover SQL server MDF file successfully and also restore SQL server corrupted Database with all original information with help of this SQL Server Recovery Software.

Add an ORDER BY clause after your GROUP BY clause. SQL never guarantees any sorted sequence if you don’t specify ORDER BY.
 
Related scenario:
 
You develop on a small, older development server that’s a fix-pack behind. You run your query 1000 times with all kinds of different WHERE clauses to test all reasonable requests. Your results come out perfectly every time.
 
You’re satisfied with testing, so you promote to the big, new production server. The big server is a 16-core system, and each core can run dual threads. The server has SMP enabled, and it runs with all of the latest fixes applied.
 
But the results always come out in a messed up sequence. Why?
 
In this case, SMP can assign different blocks of the table to different cores. Each core adds its results at slightly different times. But because they all come from different parts of the base table, they show in the final result in the order they were processed.
 
The query runs really fast on the production server compared to development, but it looks like it gives an incorrect result. But the result is exactly what was requested because no ORDER BY was specified. The order was allowed to be whatever happened.
 
The rule is “If you want an order, use ORDER BY.”
 
Tom

It might depend on what is meant by “application with built-in security”. I would expect that to mean that the application provides the authority because the user’s authority is insufficient. In such a case, there shouldn’t be anything to do about Crystal Reports.
 
But you wouldn’t be asking if that was the case. So can you clarify?
 
Tom

If nobody has a direct answer, you might try the Quicksilver community forum. I’m almost certain that BroadVision bought Interleaf many years ago. The Interleaf/WorldVision stuff turned into Quicksilver. — Tom

I’ll emphasize that QM Query has two user interface modes: SQL and ‘Prompted’. It’s not necessary to know SQL for QM Query if ‘Prompted’ mode is used. It is very similar to the Query/400 interface, but it has an option to convert prompted queries to access the underlying SQL. — Tom

When I run a wrkqry for itemsqry…
 
Since that doesn’t seem to have anything to do with this thread, I suggest that you open a new question of your own. Include details of your problem that would allow us to know how we might help.
 
Tom

System software can, of course, modify anything. Still, there are things that shouldn’t happen.
 
If a license key seems to have been interfered with, the DSPLICKEY command should be run with defaults to look through each registered key. If there are any differences from the intended values, it should be reported to IBM.
 
Nothing should be messing with keys. If it happens, IBM should know details in order to create possible PTFs. Or PTFs might already exist.
 
If multiple sites report the problem and IBM can get details from them, the likelihood of comprehensive fixes grows.
 
I run DSPLICKEY OUTPUT(*LICKEYFILE) to generate a license key file that can be saved, viewed, queried, reloaded or whatever is needed. Technically, if you have multiple systems, keys can be stored in the license repositories of multiple systems to help recovery. Keys can be entered and stored for different serial numbers on a single system. (Only matching keys actually have any effect.) A license key file can be input to the ADDLICKEY command.
 
Tom

A recent poll of 1,000 U.S. citizens by the European cloud company Webfusion said 25% had no understanding what ‘cloud’ means.
 
The linked article said that 25% had a ‘clear grasp’. I didn’t see a number for “no understanding”, but it might be inferred from other numbers. Personally, I find ”25%” for ‘clear grasp’ hard to believe unless the sample was chosen from a population of IT pros.
 
A few decades ago, I had few problems making many kinds of repairs in the engine compartments of my cars. By the time 1970s and later models became the norm, I started losing track of what all the stuff was under the hood. Now, I don’t even want to mess with anything that looks like it might be a ‘spark plug’. There was a time I did my own valve jobs.
 
Today’s engine compartments are less complex than an actual ‘cloud’ environment. The user interfaces in both cases can usually be grasped. But,… a ‘clear understanding’? It just doesn’t seem likely.
 
Tom

Dear CCNA:This may be theoretically possible, but it will take some serious looking around to find a job where you can remote in from one country to another. Most of the telecommuting jobs about which I’m aware require employees to be citizens of the country in which the job is offered. As to whether or not that job could be performed outside that country, you’d have to discuss this with the HR or hiring managers at the company with the telecommuting position.My gut feel is that such opportunties will be few and far between, and that it might be harder to land such a position than you might think. My advice is to approach and talk to HR professionals at companies that offer telecommuting jobs, and ask them if you can be hired out-of-country to fill such a position. I would bet that at least half the time, the answer would be “no.”You may want to try out this Google search to read some of the materials it turns up. In particular you might find these items helpful:1. 10 Top Telecommuting Jobs to Live Abroad (Yahoo Finance, Aug 2012)2. International Telecommute: How rare? (City-Data.com Sep 2010)3. Telecommuting Jobs (The Computer Nomad, undated)4. Global Telecommuting (WorldHum Sep 2006)5. Global HR Hot Topic: Cross Border Telecommuting Checklist (Feb 2009)HTH, and good luck in finding what you seek.–Ed–

I need the setting on lotus notes 8.5 to get and send mail to aol, how do I do this

When I run a wrkqry for itemsqry after Iam done query completes fine .I use Call loaditmcl to load the wrkqry I run call loaditmcl application error. cee9901 unmoitored by loaditmcal at statement 0000000600, instruction x’000 this does work in our production side but in test I need it to be fixed.
 

Have you tried to debug your program?  Check if there is another instance of your file in a different lib. Is your program running interactive or batch? Check the objects, pgm and file to see when they were last used. Get some more data the check back for more answers.

Tom, I’ve had a similar problem crop up after an unplanned system outage.  I agree that an abnormal IPL shouldn’t mess with the license key, but it does upon occasion.

Be very careful.  Many security incidents start with a user clicking on a link included in an e-mail message.  If you don’t know the sender it is probably a good idea not to open it, and if you know the sender but are unsure if the message is legit, it could be a good idea to contact him/her to ask about the message.

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.