I imagine there are numerous opportunities to do this type of work, especially given today’s remote access technologies. Still, you’ll likely come across scenarios where you’ll want or need to be onsite such as when you’re making network changes that would otherwise disconnect a remote connection. Overall, though, I don’t see why not. It just depends on the organization’s needs.

You might find more assistance on an autocad board.

We need more info ...

we know that the program LOADITMCAL is failing at statement 600 but we don't know why or how.

  1.  What is the statement that is failing

  2.  What error messages and their text that are in the joblog just before the cee9901 error.

What would you expect them to use? — Tom

“I really didn’t say everything I said” . by Yogi Berra

It’s almost certain that it has nothing to do with the security of your phone, and it’s also almost certain that no one is seeing anything you type except the person you send it to. It’s much more likely that there are flaws in your phone, either OS or hardware.
 
No matter what, it’s even more certain that there’s nothing that you can do except take it to an appropriate phone technician or professional. Perhaps send it to the vendor to get it fixed.
 
There is a very small chance that something you downloaded contained malware of some type. A professional could possibly track it down and even clean your phone. It’s very unlikely that any kind of prosecution would ever happen.
 
Tom

I would like to  learn QM query.
 
Ways to learn depend on whether you have the SQL Dev Kit installed on your system or not. If it’s installed, it’s fairly easy, especially if you already know Query/400.
 
Run the STRQM command to access QM. A menu with four options should appear. The options allow you to work with queries, forms, tables and profiles.
 
One difference that takes a little to get used to is that QM breaks its work into two parts. The first part is the query where tables and columns are selected and operated on. The output of a query is a result set. The second part is the form where printed output is defined. A result set is the input to a form. A form is essentially a report definition. Although you generally never see it, a result set effectively has a record format that fits it.
 
There is a default report for any query, so it’s often not necessary to define one. However, if two queries create output in the same format, they can be used as input for the same report form. A single form can be fed by any query that creates an appropriate result format. That means that a report form can be used over and over with different queries.
 
Also. a single query definition can be used with any report forms that accept its result set format. A query might be printed in many different ways, so it can be reused for many reports.
 
Finally, a query can be output to an outfile.
 
First learning attempt should be simple. If your system has common options installed, a query is easy.
 
Run STRQM, and take option 1 to work with queries. When the ‘Work with…’ display opens, make sure the creation mode at the top says PROMPT. If it says SQL, use F19 to switch the mode.
 
Now, enter option 1 to create a query named CUSTCDT, and press <Enter>. The query definition page should appear, and it should look a lot like Query/400′s page. Take option 1 against ‘Specify files’ and press <Enter>. Specify the QCUSTCDT file in library QIWS, and press <enter>.
 
(You can name your query whatever you want, and specify any file in any library. I’m only using names that should be available to almost everyone.)
 
After you pressed <Enter>, you should be back at the definition page. You now have a complete query that you can run. (It hasn’t been saved and compiled yet, but it’s available to run.) Press F5=’Run report’ to see what it looks like. On the Run Query page, set the output to 1=Display, and press <Enter>. Your query output should show on your display.
 
You can figure out how to exit from QM, so I’ll leave it there.
 
Details about using QM require a couple .PDFs. These can be accessed through the Queries and reports topic. The last one listed, Query Manager Use, is the one you’ll need first. It will probably be the only one you’ll use. But if you get seriously into programming around it, you’ll eventually want the Query Management Programming manual also.
 
Tom

Thanks group. The issue got resolved. As suggested by Tom I would like to  learn QM query. Please suggest good sites to learn.

“The problem with quotes on the internet is you never know if they are genuine.”
―
Joseph Stalin

ok .. Newton had an operational understanding of gravity ..

“I would imagine that if you could understand Morse code, a tap dancer would drive you crazy.”     Mitch Hedberg

There are degrees of understanding. I’d consider ‘clear grasp’ to indicate solid decision-making capability for an organization. An individual who’s heard that GMail, iTunes and similar apps have a basis in ‘cloud’ technologies wouldn’t qualify. But someone who can determine if various applications that exist in an organization can effectively be migrated to a ‘cloud’ environment and articulate the pros and cons could have a ‘clear grasp’, IMO. — Tom

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