RE: How to pass variable number of parameters in SQLRPGLE

It is working fine now.

As you all said the mistake is that, I was referring the parameter field
in the program even when no parameter is passed.

Now I am using a work variable to get the value of parameter field only
if it is passed else I am moving *BLANKS to it.

And I am using the work variable through out the program.

Now it is working well.

Thank you all for your time.

 

Thanks,

Satheesh

________________________________

From: Satheeshkumar_selvaraj 
Sent: Friday, September 30, 2005 12:06 PM
To: 'RPG400-L@xxxxxxxxxxxx'
Subject: How to pass variable number of parameters in SQLRPGLE

 

Hi All,

 

I want to call my SQLRPGLE program in two modes.

 

1.      From another program with one parameter (character type).
2.      From the Command Line with out any parameter.

 

I have coded it as follows,

 

* Prototype for calling this program (*ENTRY)          

DMYPGM        PR                   EXTPGM(MYPGM)                

DParam1                       10A   OPTIONS(*NOPASS) 

 

 * Procedure interface for this program (*ENTRY)        

DMYPGM         PI                                   

DParam1                       10A   OPTIONS(*NOPASS)

 

C                      IF   %PARMS > 0

C                      ........

C                      ELSE

C                      ........

C                      ENDIF

 

The *NOPASS works fine when I coded it in a subprocedure and used that
subprocedure in my main program.

When used in the main program it is working fine when I call it with a
parameter.

But it is giving "Pointer or Parameter error" when called without any
parameter.

 

Can any one please tell me what is wrong in my code?

I tried the same code with RPGLE type it is working fine. But why it is
not working with SQLRPGLE?

In RPGLE it is working fine even if I remove the *NOPASS option. !!!!

 

Thanks,

Satheesh

 



DISCLAIMER:
This email (including any attachments) is intended for the sole use of the 
intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE 
COMPANY INFORMATION. Any review or reliance by others or copying or 
distribution or forwarding of any or all of the contents in this message is 
STRICTLY PROHIBITED. If you are not the intended recipient, please contact the 
sender by email and delete all copies; your cooperation in this regard is 
appreciated.