2. at the AS400 side, I see that no processing has happened by AS400 program as expected.

What could be the gap?

3. i have another program which when called from dot net compoent runs perfectly and does the processing.. so i compared this good object with my bad object.. the only difference i see is that... the good one has some Authorization list .. and for the bad one, the authorization list is *none

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your response...

Discuss This Question: 4 &nbspReplies

There was an error processing your information. Please try again later.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

dot net system which calls RPGLE program interactively
That's a contradiction. Dot.net can't make an interactive call to RPG because dot.net programs can't run interactively under i5/OS.
However, if it might be an authority error, review your audit journal for entry type "AF" to see if any Authority Failures happened during the time range when the dot.net process ran.
Tom

A stored proc definition will need to be added to the database if (1) a SQL CALL is being made to the program and (2) any parameter values are to be returned from the program back to the dot.net function.
If it's a non-SQL call or if parameters are all only input to the RPG program (or there are no parms at all), then no stored proc definition is needed.
Tom

What type of program are you calling? CL / RPGLE / SQLRPGLE...? If you run the .Net call 1st thing in the morning, does the date last used change on your i5 program object? If it is an SQLRPGLE update program, is your commit level set ? (Could the changes be rolling back after a successfull run due to the jobs default commit...)

Is your program embeded within a store procedure ? it might help
I have no problem at all, calling any type of program from Visual Studio, as long as the program is in a store procedure. You can check and dowload our product i5_dotnet for free, a set of store procedure tutorial is included, with a VB project exemple.
Let me know if you find it useful

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy