Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

------------------------------
jerry ven
------------------------------

Dear Jerry

From your post, I suspect that you did the CALL from a 5250 session command line which does not support calling a DB2 stored procedure.  Since this is an SQL stored procedure, the best place for youto do the CALL for Db2 SP is from IBM i ACS - Run SQL Scripts tool session. 

------------------------------
Chance favors only the prepared mind.
-- Louis Pasteur
------------------------------
Satid S.

Original Message:
Sent: Sat February 03, 2024 12:39 PM
From: jerry ven
Subject: Regarding DSPPGMREF

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

------------------------------
jerry ven
------------------------------

Hi,

But previously I was able to call this procedure (from the command line) without 'Run SQL Scripts tool. ' and table containing references for the called programs was generated successfully.

This time why is it showing this error not sure?

Thanks

Dear Jerry

From your post, I suspect that you did the CALL from a 5250 session command line which does not support calling a DB2 stored procedure.  Since this is an SQL stored procedure, the best place for youto do the CALL for Db2 SP is from IBM i ACS - Run SQL Scripts tool session. 

------------------------------
Chance favors only the prepared mind.
-- Louis Pasteur
------------------------------
Satid S.

Original Message:
Sent: Sat February 03, 2024 12:39 PM
From: jerry ven
Subject: Regarding DSPPGMREF

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

------------------------------
jerry ven
------------------------------

Hi,

I just remembered that I was able to call it using STRSQL session and this time though CALL statement was successful inside from STRSQL session but when I checked table then found "it seems DSPPGMREF fails internally, *ERROR will appear in the three USES_* fields in the REFS file. If you get a lot of these check you have your library list correct."

also my lib. was correct i kept these table and stored procedure objects in my library and it was on top of library list and the program whose references i was looking to be summarized in this table was also in the library which was in the library list already still this happened this time.

Thanks

Hi,

But previously I was able to call this procedure (from the command line) without 'Run SQL Scripts tool. ' and table containing references for the called programs was generated successfully.

This time why is it showing this error not sure?

Thanks

Dear Jerry

From your post, I suspect that you did the CALL from a 5250 session command line which does not support calling a DB2 stored procedure.  Since this is an SQL stored procedure, the best place for youto do the CALL for Db2 SP is from IBM i ACS - Run SQL Scripts tool session. 

------------------------------
Chance favors only the prepared mind.
-- Louis Pasteur
------------------------------
Satid S.

Original Message:
Sent: Sat February 03, 2024 12:39 PM
From: jerry ven
Subject: Regarding DSPPGMREF

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

------------------------------
jerry ven
------------------------------

Aside from the library list, I would suggest using SET SCHEMA to your library as well.

Hi,

I just remembered that I was able to call it using STRSQL session and this time though CALL statement was successful inside from STRSQL session but when I checked table then found "it seems DSPPGMREF fails internally, *ERROR will appear in the three USES_* fields in the REFS file. If you get a lot of these check you have your library list correct."

also my lib. was correct i kept these table and stored procedure objects in my library and it was on top of library list and the program whose references i was looking to be summarized in this table was also in the library which was in the library list already still this happened this time.

Thanks

Hi,

But previously I was able to call this procedure (from the command line) without 'Run SQL Scripts tool. ' and table containing references for the called programs was generated successfully.

This time why is it showing this error not sure?

Thanks

Dear Jerry

From your post, I suspect that you did the CALL from a 5250 session command line which does not support calling a DB2 stored procedure.  Since this is an SQL stored procedure, the best place for youto do the CALL for Db2 SP is from IBM i ACS - Run SQL Scripts tool session. 

------------------------------
Chance favors only the prepared mind.
-- Louis Pasteur
------------------------------
Satid S.

Original Message:
Sent: Sat February 03, 2024 12:39 PM
From: jerry ven
Subject: Regarding DSPPGMREF

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

------------------------------
jerry ven
------------------------------

How can i set schema? 

Aside from the library list, I would suggest using SET SCHEMA to your library as well.

Hi,

I just remembered that I was able to call it using STRSQL session and this time though CALL statement was successful inside from STRSQL session but when I checked table then found "it seems DSPPGMREF fails internally, *ERROR will appear in the three USES_* fields in the REFS file. If you get a lot of these check you have your library list correct."

also my lib. was correct i kept these table and stored procedure objects in my library and it was on top of library list and the program whose references i was looking to be summarized in this table was also in the library which was in the library list already still this happened this time.

Thanks

Hi,

But previously I was able to call this procedure (from the command line) without 'Run SQL Scripts tool. ' and table containing references for the called programs was generated successfully.

This time why is it showing this error not sure?

Thanks

Dear Jerry

From your post, I suspect that you did the CALL from a 5250 session command line which does not support calling a DB2 stored procedure.  Since this is an SQL stored procedure, the best place for youto do the CALL for Db2 SP is from IBM i ACS - Run SQL Scripts tool session. 

------------------------------
Chance favors only the prepared mind.
-- Louis Pasteur
------------------------------
Satid S.

Original Message:
Sent: Sat February 03, 2024 12:39 PM
From: jerry ven
Subject: Regarding DSPPGMREF

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

------------------------------
jerry ven
------------------------------

SET SCHEMA <yourschema>

How can i set schema? 

Aside from the library list, I would suggest using SET SCHEMA to your library as well.

Hi,

I just remembered that I was able to call it using STRSQL session and this time though CALL statement was successful inside from STRSQL session but when I checked table then found "it seems DSPPGMREF fails internally, *ERROR will appear in the three USES_* fields in the REFS file. If you get a lot of these check you have your library list correct."

also my lib. was correct i kept these table and stored procedure objects in my library and it was on top of library list and the program whose references i was looking to be summarized in this table was also in the library which was in the library list already still this happened this time.

Thanks

Hi,

But previously I was able to call this procedure (from the command line) without 'Run SQL Scripts tool. ' and table containing references for the called programs was generated successfully.

This time why is it showing this error not sure?

Thanks

Dear Jerry

From your post, I suspect that you did the CALL from a 5250 session command line which does not support calling a DB2 stored procedure.  Since this is an SQL stored procedure, the best place for youto do the CALL for Db2 SP is from IBM i ACS - Run SQL Scripts tool session. 

------------------------------
Chance favors only the prepared mind.
-- Louis Pasteur
------------------------------
Satid S.

Original Message:
Sent: Sat February 03, 2024 12:39 PM
From: jerry ven
Subject: Regarding DSPPGMREF

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

------------------------------
jerry ven
------------------------------

Hi,

I did not find any such command exists.

Thanks

SET SCHEMA <yourschema>

How can i set schema? 

Aside from the library list, I would suggest using SET SCHEMA to your library as well.

Hi,

I just remembered that I was able to call it using STRSQL session and this time though CALL statement was successful inside from STRSQL session but when I checked table then found "it seems DSPPGMREF fails internally, *ERROR will appear in the three USES_* fields in the REFS file. If you get a lot of these check you have your library list correct."

also my lib. was correct i kept these table and stored procedure objects in my library and it was on top of library list and the program whose references i was looking to be summarized in this table was also in the library which was in the library list already still this happened this time.

Thanks

Hi,

But previously I was able to call this procedure (from the command line) without 'Run SQL Scripts tool. ' and table containing references for the called programs was generated successfully.

This time why is it showing this error not sure?

Thanks

Dear Jerry

From your post, I suspect that you did the CALL from a 5250 session command line which does not support calling a DB2 stored procedure.  Since this is an SQL stored procedure, the best place for youto do the CALL for Db2 SP is from IBM i ACS - Run SQL Scripts tool session. 

------------------------------
Chance favors only the prepared mind.
-- Louis Pasteur
------------------------------
Satid S.

Original Message:
Sent: Sat February 03, 2024 12:39 PM
From: jerry ven
Subject: Regarding DSPPGMREF

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

------------------------------
jerry ven
------------------------------

Hi Jerry,
I think these are the steps you're looking for:

STRSQL
SET SCHEMA yourlibrary
CALL yourprogram

Hi,

I did not find any such command exists.

Thanks

SET SCHEMA <yourschema>

How can i set schema? 

Aside from the library list, I would suggest using SET SCHEMA to your library as well.

Hi,

I just remembered that I was able to call it using STRSQL session and this time though CALL statement was successful inside from STRSQL session but when I checked table then found "it seems DSPPGMREF fails internally, *ERROR will appear in the three USES_* fields in the REFS file. If you get a lot of these check you have your library list correct."

also my lib. was correct i kept these table and stored procedure objects in my library and it was on top of library list and the program whose references i was looking to be summarized in this table was also in the library which was in the library list already still this happened this time.

Thanks

Hi,

But previously I was able to call this procedure (from the command line) without 'Run SQL Scripts tool. ' and table containing references for the called programs was generated successfully.

This time why is it showing this error not sure?

Thanks

Dear Jerry

From your post, I suspect that you did the CALL from a 5250 session command line which does not support calling a DB2 stored procedure.  Since this is an SQL stored procedure, the best place for youto do the CALL for Db2 SP is from IBM i ACS - Run SQL Scripts tool session. 

------------------------------
Chance favors only the prepared mind.
-- Louis Pasteur
------------------------------
Satid S.

Original Message:
Sent: Sat February 03, 2024 12:39 PM
From: jerry ven
Subject: Regarding DSPPGMREF

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

------------------------------
jerry ven
------------------------------

even though this set command ran successfully in STRSQL session but main table entries show same *error and same message DSPPGMREF failed.

Thanks.

Hi Jerry,
I think these are the steps you're looking for:

STRSQL
SET SCHEMA yourlibrary
CALL yourprogram

Hi,

I did not find any such command exists.

Thanks

SET SCHEMA <yourschema>

How can i set schema? 

Aside from the library list, I would suggest using SET SCHEMA to your library as well.

Hi,

I just remembered that I was able to call it using STRSQL session and this time though CALL statement was successful inside from STRSQL session but when I checked table then found "it seems DSPPGMREF fails internally, *ERROR will appear in the three USES_* fields in the REFS file. If you get a lot of these check you have your library list correct."

also my lib. was correct i kept these table and stored procedure objects in my library and it was on top of library list and the program whose references i was looking to be summarized in this table was also in the library which was in the library list already still this happened this time.

Thanks

Hi,

But previously I was able to call this procedure (from the command line) without 'Run SQL Scripts tool. ' and table containing references for the called programs was generated successfully.

This time why is it showing this error not sure?

Thanks

Dear Jerry

From your post, I suspect that you did the CALL from a 5250 session command line which does not support calling a DB2 stored procedure.  Since this is an SQL stored procedure, the best place for youto do the CALL for Db2 SP is from IBM i ACS - Run SQL Scripts tool session. 

------------------------------
Chance favors only the prepared mind.
-- Louis Pasteur
------------------------------
Satid S.

Original Message:
Sent: Sat February 03, 2024 12:39 PM
From: jerry ven
Subject: Regarding DSPPGMREF

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

------------------------------
jerry ven
------------------------------

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            

Have you tried without commas (CALL mylib/mypgm ('driver'  'lib1'    '*ALL'   '0'))?

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

Yes just tried without commas as well now the error is with message ID SQL0104:-"Token  'mypgm'(the program whose references I have been trying to find out) was not valid. Valid tokens: ) '. 

Thanks. 

   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            

Have you tried without commas (CALL mylib/mypgm ('driver'  'lib1'    '*ALL'   '0'))?

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

Dear Jerry

Have you tried running this in Run SQL Scripts tool yet?   Do not stick to STRSQL because it has many limitations due to the fact that it has not been enhanced for several years now and there is no documentation explaining the difference support between STRSQL and Run SQL Script tool but the latter is definitely superior in all respects.  Sometimes when I have a problem running SQL from STRSQL and switch to Run SQL Script tool, it solves the issue.

Yes just tried without commas as well now the error is with message ID SQL0104:-"Token  'mypgm'(the program whose references I have been trying to find out) was not valid. Valid tokens: ) '. 

Thanks. 

   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            

Have you tried without commas (CALL mylib/mypgm ('driver'  'lib1'    '*ALL'   '0'))?

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

Thanks for all these suggestions.

Dear Jerry

Have you tried running this in Run SQL Scripts tool yet?   Do not stick to STRSQL because it has many limitations due to the fact that it has not been enhanced for several years now and there is no documentation explaining the difference support between STRSQL and Run SQL Script tool but the latter is definitely superior in all respects.  Sometimes when I have a problem running SQL from STRSQL and switch to Run SQL Script tool, it solves the issue.

Yes just tried without commas as well now the error is with message ID SQL0104:-"Token  'mypgm'(the program whose references I have been trying to find out) was not valid. Valid tokens: ) '. 

Thanks. 

   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            

Have you tried without commas (CALL mylib/mypgm ('driver'  'lib1'    '*ALL'   '0'))?

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

Thanks for all these suggestions.

Dear Jerry

Have you tried running this in Run SQL Scripts tool yet?   Do not stick to STRSQL because it has many limitations due to the fact that it has not been enhanced for several years now and there is no documentation explaining the difference support between STRSQL and Run SQL Script tool but the latter is definitely superior in all respects.  Sometimes when I have a problem running SQL from STRSQL and switch to Run SQL Script tool, it solves the issue.

Yes just tried without commas as well now the error is with message ID SQL0104:-"Token  'mypgm'(the program whose references I have been trying to find out) was not valid. Valid tokens: ) '. 

Thanks. 

   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            

Have you tried without commas (CALL mylib/mypgm ('driver'  'lib1'    '*ALL'   '0'))?

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

Dear Jerry

Run SQL Script tool is good for running all kinds of SQL in DB2i and getting information relevant to tuning SQL performance of individual statement. Do a Google search and search in Youtube on "ibm i run sql scripts" and you will find more useful information on this great tool. 

I do not have sufficient experience to answer all your questions but I suspect you may get it by doing Metadata query (SELECT relevant columns) to DB2i Catalog Views in QSYS2 library such as shown in the picture below.    If you have further question relating SQL in DB2i, I suggest you ask your future questions in SQL group of this community.

Thanks for all these suggestions.

Dear Jerry

Have you tried running this in Run SQL Scripts tool yet?   Do not stick to STRSQL because it has many limitations due to the fact that it has not been enhanced for several years now and there is no documentation explaining the difference support between STRSQL and Run SQL Script tool but the latter is definitely superior in all respects.  Sometimes when I have a problem running SQL from STRSQL and switch to Run SQL Script tool, it solves the issue.

Yes just tried without commas as well now the error is with message ID SQL0104:-"Token  'mypgm'(the program whose references I have been trying to find out) was not valid. Valid tokens: ) '. 

Thanks. 

   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            

Have you tried without commas (CALL mylib/mypgm ('driver'  'lib1'    '*ALL'   '0'))?

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

Hi,

Thanks for all these answers.

I have couple of more questions with this respect to this utility as it uses stored procedure in this example and shows references of service programs as well..

1) Can we know all the stored procedure names as well  using this DSPPGMREF utility (this GITHUB program ?) , if not then how to know their names, how to idenify them and distinguish them from a normal RPGLE ,SQLRPGLE,CLLE or any other IBM i object ?

2) how to call them ? ( here it was called using RUNSQLSTM or right click on 'RUN SQL SCripts' options ) what is their object type ? ( here for this PGM_REFS it was found to be 'CLE' so is this the only object type of stored procedures always ( i mean for all type of stored procdures with in IBM i ?)

3) 

 If a service program is being reffered by any program object then is it mandatry that  it's being called from the main
program object or it's reference just exists (here in DSPPGMREF REFS Table) becuase it was just needed to compile that program object ?

Thanks

Dear Jerry

Run SQL Script tool is good for running all kinds of SQL in DB2i and getting information relevant to tuning SQL performance of individual statement. Do a Google search and search in Youtube on "ibm i run sql scripts" and you will find more useful information on this great tool. 

I do not have sufficient experience to answer all your questions but I suspect you may get it by doing Metadata query (SELECT relevant columns) to DB2i Catalog Views in QSYS2 library such as shown in the picture below.    If you have further question relating SQL in DB2i, I suggest you ask your future questions in SQL group of this community.

Thanks for all these suggestions.

Dear Jerry

Have you tried running this in Run SQL Scripts tool yet?   Do not stick to STRSQL because it has many limitations due to the fact that it has not been enhanced for several years now and there is no documentation explaining the difference support between STRSQL and Run SQL Script tool but the latter is definitely superior in all respects.  Sometimes when I have a problem running SQL from STRSQL and switch to Run SQL Script tool, it solves the issue.

Yes just tried without commas as well now the error is with message ID SQL0104:-"Token  'mypgm'(the program whose references I have been trying to find out) was not valid. Valid tokens: ) '. 

Thanks. 

   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            

Have you tried without commas (CALL mylib/mypgm ('driver'  'lib1'    '*ALL'   '0'))?

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

------------------------------
jerry ven
------------------------------

Hi,

When using code from a GitHub repository, you should ask for help on GitHub, not here. It is my experience, that the creators/maintainers of open source utilities are more than willing to help using their utility and fix any errors encountered using it.

So create an issue here: https://github.com/SJLennon/IBM-i-RPG-Free-CLP-Code/issues

and you will get expertise support from the creator himself.

------------------------------
Christian Jorgensen
IT System Administrator
Network of Music Partners A/S

Original Message:
Sent: Sat February 03, 2024 12:39 PM
From: jerry ven
Subject: Regarding DSPPGMREF

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

------------------------------
jerry ven
------------------------------

suppose i have created a file based on caller name and caller library using this program and then i want to compare it with the file (which is created as a out file of  using DSPOBJD  for all the *pgm objects in the system) then how to get the records (unique caller name, unique caller_library) matching from this out file whose last used date is with in 1 year from today's date ?

thanks

Hi,

When using code from a GitHub repository, you should ask for help on GitHub, not here. It is my experience, that the creators/maintainers of open source utilities are more than willing to help using their utility and fix any errors encountered using it.

So create an issue here: https://github.com/SJLennon/IBM-i-RPG-Free-CLP-Code/issues

and you will get expertise support from the creator himself.

------------------------------
Christian Jorgensen
IT System Administrator
Network of Music Partners A/S

Original Message:
Sent: Sat February 03, 2024 12:39 PM
From: jerry ven
Subject: Regarding DSPPGMREF

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

------------------------------
jerry ven
------------------------------

Hi,

I tried below SQL queries to get the count of such records but none of these worked , could someone please share the corrected SQL query to get the desired result here?

1) SELECT COUNT(*)                                                    
FROM (                                                             
  SELECT DISTINCT t1.CALLER_NAME, t1.CALLER_LIBRARY                
  FROM lib2/f2                                                       
  INNER JOIN lib1/f1                                        
  ON testfile.ODOBNM = t1.CALLER_NAME AND f1.ODLBNM =        
f2.CALLER_LIBRARY                                                  
  WHERE DATE(                                                      
    SUBSTR(testfile.ODUDAT,5,2) || '-' ||                          
    SUBSTR(testfile.ODUDAT,1,2) || '-' ||                          
    SUBSTR(testfile.ODUDAT,3,2)                                    
  ) >= CURRENT_DATE - 365                                          
) AS temp                                                          
****************

2)

SELECT COUNT(*)                                               
FROM (                                                        
  SELECT DISTINCT f2.CALLER_NAME, f2.CALLER_LIBRARY           
  FROM lib2/f2                                                  
  INNER JOIN lib1/f1                                    
  ON f1.ODOBNM = f2.CALLER_NAME AND testfile.ODLBNM =   
f2.CALLER_LIBRARY                                             
  WHERE DATE(                                                 
    CONCAT('20', SUBSTR(DIGITS(testfile.ODUDAT),5,2)),        
    CONCAT(SUBSTR(DIGITS(testfile.ODUDAT),1,2),               
    CONCAT(SUBSTR(DIGITS(testfile.ODUDAT),3,2))               
  ) >= CURRENT_DATE - 1 YEAR                                  
) AS temp                  

Note :- f1 is a file created using DSPOBJD for all the program objects in the system in a library let's say in 'lib1'.

and f2 is the file created in a library let's say 'lib2' when I ran this DSPPGMREF program (GitHub link) which has this caller_name,caller_library etc. details in it.

Thanks                      

suppose i have created a file based on caller name and caller library using this program and then i want to compare it with the file (which is created as a out file of  using DSPOBJD  for all the *pgm objects in the system) then how to get the records (unique caller name, unique caller_library) matching from this out file whose last used date is with in 1 year from today's date ?

thanks

Hi,

When using code from a GitHub repository, you should ask for help on GitHub, not here. It is my experience, that the creators/maintainers of open source utilities are more than willing to help using their utility and fix any errors encountered using it.

So create an issue here: https://github.com/SJLennon/IBM-i-RPG-Free-CLP-Code/issues

and you will get expertise support from the creator himself.

------------------------------
Christian Jorgensen
IT System Administrator
Network of Music Partners A/S

Original Message:
Sent: Sat February 03, 2024 12:39 PM
From: jerry ven
Subject: Regarding DSPPGMREF

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks                                              
                                                                              
                                                                              

------------------------------
jerry ven
------------------------------

Hi,

When testing this :-IBM-i-RPG-Free-CLP-Code/PGM_REFS/Readme.MD at master · SJLennon/IBM-i-RPG-Free-CLP-Code · GitHub

CALL  mylib/mypgm ('driver'  'lib1'  '*ALL'  0)
******************************************************
                                Command Entry              
                                                          R
Previous commands and messages:                            
   > CALL mylib/mypgm ('driver', 'lib1' ,   '*ALL' ,  '0')       
     Character ',' not valid following string ''driver'  '.
     Character ' ' not valid following string ',         '.
     Character ' ' not valid following string ',         '.
     Error found on *N command.                            
                                                   
****************************************************************************
                        Additional Message Information                        
                                                                              
Message ID . . . . . . :   CPD0020                                            
Date sent  . . . . . . :   02/03/24      Time sent  . . . . . . :   11:12:01  
                                                                              
Message . . . . :   Character ',' not valid following string ''driver'  '.    
                                                                              
Cause . . . . . :   A delimiter is missing between two values or a delimiter  
  that is not valid was found.                                                
Recovery  . . . :   Change the character that is not valid or if a delimiter  
  is missing insert one. More information on delimiters can be found in the   
  Information Center.          

what i am doing wrong to call to test this procedure , how to correct this error so that i could get the desired call stack in the table defined inside this procedure?

Thanks