Get answers.  Share knowledge.  Collaborate with peers.




How can I make sure all new and changed objects are being backed up when using the SAVCHGOBJ command?

What is the SAVCHGOBJ command that you are running? What was the name of the library that wasn’t saved? It’s not necessary to save the library before running SAVCHGOBJ, but you do need to use the appropriate SAVCHGOBJ command parameters and have an appropriate library name. (By saving the library as CharlieBrowne recommends, you can probably fix your problem.)
.
Tom



View Discussion   |  June 15, 2013  12:39 AM
AS/400, AS/400 backup, SAVCHGOBJ
discussed by:
TomLiotta
110,035 pts.

Calling programs information in RPG

Are you needing to know “calling programs” or “called programs”? When do you need to know? Do you need to know when the program is running or are you simply analyzing the application?
.
Your question needs more explanation.
.
Tom



View Discussion   |  June 15, 2013  12:13 AM
AS/400, AS/400 commands, RPG Program
discussed by:
TomLiotta
110,035 pts.

SAVOBJ and SAVLIB to IFS

Any save to a savefile is a save “to IFS”. A save to virtual optical or tape is a save “to IFS”. If you write code to the QaneSava and QaneRsta APIs, you can save to and restore from wherever you can write code for. Benefits and drawbacks are whatever they happen to be for your environment.
.
Tom



View Discussion   |  June 15, 2013  12:10 AM
SAVOBJ SAVLIB
discussed by:
TomLiotta
110,035 pts.

Calculate Distance between cities using latitude and longitude
I’m not aware of anyone making this available, and the Google Maps APIs have restrictions described in Terms of Service agreements. I don’t believe a result is available outside of javascript and for purposes of displaying a map. (AFAIK, there is no legal HTTP interface.) For driving distances, you should closely review the The Google Distance Matrix API. There might be “business” contracts or agreements that you can make with Google to purchase access to their data.
.
If you want to do it in RPG (or any server programming language), you’ll need a database of roads and distances. You might be able to adapt The National Map databases from the USGS or related federal databases somehow. It is not a trivial task, though there might be libraries of functions that you can purchase. I’m not aware of open-source projects.
.
Other members might have better info.
.
Tom


View Discussion   |  June 15, 2013  12:01 AM
AS/400, RPG Program
discussed by:
TomLiotta
110,035 pts.

SQLRPGLE

Thanks for the feedback



View Discussion   |  June 14, 2013  9:32 PM
AS400 - Embedded SQL, CL Program, SQLRPGLE
discussed by:
philpl1jb
44,610 pts.

About my career

You should be asking this of employers in your community.



View Discussion   |  June 14, 2013  5:29 PM
IT career, IT career advice
discussed by:
philpl1jb
44,610 pts.

Calling programs information in RPG

I’m having a bit of confusion reading your request.
If you need to find what programs are called by a single program.

1. Try DSPPGMREF
2. Search the code for ‘ CALL ‘



View Discussion   |  June 14, 2013  5:25 PM
AS/400, AS/400 commands, RPG Program
discussed by:
philpl1jb
44,610 pts.

Converting a character to numeric

When in WRKQRY, go to the subfile option that allows you to create new fields.
Once their use the F1 key to display the HELP text.
This will give you an example of how to do it.



View Discussion   |  June 14, 2013  4:15 PM
AS/400, AS/400 FUNCTIONS, WRKQRY
discussed by:
CharlieBrowne
33,595 pts.

Calling programs information in RPG

Change management software does this for you.
Such as: ABSTRASCT, ALDON, HAWKEYE PATHFINDER, just to name a few.



View Discussion   |  June 14, 2013  4:12 PM
AS/400, AS/400 commands, RPG Program
discussed by:
CharlieBrowne
33,595 pts.

Why did the system crash?

I believe setting the MAXSTG would resolve this issue in the future.



View Discussion   |  June 14, 2013  3:02 PM
AS/400, PTF
discussed by:
CharlieBrowne
33,595 pts.

How can I make sure all new and changed objects are being backed up when using the SAVCHGOBJ command?

When you do your full system save, the last saved date in the object description for each library is updated with a current timestamp.
The SAVCHGOBJ uses that date to save objects within that library and saves objects changed after that date.
Since your new library was never saved, it did not save anything.
To resolve your problem, whenever you create a new library, do a SAVLIB right away, then the changed objects that library will be save during your M-F.
process. You can just do the save of the empty library to a *SAVF.
Remember to use RSTOBJ from a SAVCHGOBJ process, the library must exist.
So in this case, after the library was deleted, you would need to do a RSTLIB from the *SAVF before you could restore the changed objects.,



View Discussion   |  June 14, 2013  2:58 PM
AS/400, AS/400 backup, SAVCHGOBJ
discussed by:
CharlieBrowne
33,595 pts.

Why did the system crash?

Thanks a lot for the tips. The user was running an interactive WRKQRY when their VPN connection dropped. When our system came back up, with IBM’s help, they looked at the QHST log and found the job. They looked at the query and there was a file being created for them to import into Excel. It had, according to our ops manager, BILLIONS of records. Our ops manager writes a lot queries, more than she should. Mainly for users , VP’s and CFO’s. She said it looked fine and should not have created such a massive file. It would have been great to have the system call someone when the storage limit error messages came up but we don’t have that software or nobody wants the responsibility. I am no longer in that department sine I moved to the .NET side of our company but they still come to me for solutions.



View Discussion   |  June 14, 2013  2:44 PM
AS/400, PTF
discussed by:
ToddN2000
4,095 pts.

AS/400

Even if you purchase the Machine. How do you manage to get the clients.



View Discussion   |  June 14, 2013  2:14 PM
AS/400, AS/400 administration, AS/400 Server
discussed by:
boggula
10 pts.

What is SAP

It is not possible to describe here about SAP. It is better to search on the net and u will get tons of answers or buy some good books and learn properly.



View Discussion   |  June 14, 2013  12:25 PM
SAP, SAP administration
discussed by:
Subhendu Sen
22,125 pts.

Virus

I support all of 3 members comments CharlieBrowne, TomLiotta and ToddN2000. Yes, be a creator not to be a destroyer.



View Discussion   |  June 14, 2013  12:22 PM
Security, virus
discussed by:
rechil
22,125 pts.

AS/400 backup

Using “To sequence number . . . *FROMSEQ” doesn’t make any sense. You would almost certainly want *END instead. You would always want the second and third LPARs to write to the end of the physical tape, not to the sequence numbers of the virtual tape. If you write to the sequence numbers of the virtual tape, you’ll always start writing at the beginning of the tape because the virtual tapes will start at seq #1..
.
Tom



View Discussion   |  June 14, 2013  11:46 AM
AS/400 Administrator, AS/400 backup, AS/400 BRMS
discussed by:
TomLiotta
110,035 pts.

Network

Go to a local electronics store, describe your PCs and your home to a sales person, describe the networking you need, buy the appropriate equipment and install it according to equipment instructions. That’s what we’d do in our homes.
.
Tom



View Discussion   |  June 14, 2013  11:39 AM
Network administration, Networking
discussed by:
TomLiotta
110,035 pts.

SQLRPGLE

Thanks Philip for your valuable time , i am able to complete my requirement now

Thank you all !!!



View Discussion   |  June 14, 2013  11:38 AM
AS400 - Embedded SQL, CL Program, SQLRPGLE
discussed by:
ravula
615 pts.

Network card

Best advice is to bring a PC expert into the office to look at the PCs, the network and the environment.
.
Tom



View Discussion   |  June 14, 2013  11:34 AM
Fujitsu, Network Card
discussed by:
TomLiotta
110,035 pts.

QMQRY!

Please show actual examples of a sequence that you want to run. It doesn’t yet make sense to run multiples in a single QMQRY. If we see a sample that shows what you need, we might have suggestions.
.
Also, please explain why you want to do it with a QMQRY rather than with an alternative,
.
Tom



View Discussion   |  June 14, 2013  11:32 AM
AS/400, AS/400 Query, QMQRY
discussed by:
TomLiotta
110,035 pts.