AS400 call from dot net component

70 pts.
Tags:
.NET
AS/400
RPGLE
I have dot net system which calls RPGLE program interactively. the AS400 program processes stuff perfectly when called from AS400. however when called from dot net following happenes-

1. dot net componet doesn't return any error. end code is - 0. it runs successfully. - this means there is no wrong library issue, authority issue.

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

could this be an issue.. if not how would i debug this problem?

 



Software/Hardware used:
AS400, dot net

Answer Wiki

Thanks. We'll let you know when a new response is added.

I think you need to create the RPGLE pgm as an External Stored Procedure. It is just a one line command. There are several articles on the topic that you can google.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
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
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • slateken
    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...)
    230 pointsBadges:
    report
  • PierreArmand
    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
    30 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

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

REGISTER or login:

Forgot Password?
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

Thanks! We'll email you when relevant content is added and updated.

Following