×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.






Rob,

                         Additional Message Information                         
                                                                                
 Message ID . . . . . . :   CPD439A       Severity . . . . . . . :   40         
 Message type . . . . . :   Diagnostic                                          
 Date sent  . . . . . . :   09/25/19      Time sent  . . . . . . :   08:57:10   
                                                                                
 Message . . . . :   Parameter 1 of function DECRYPT_CHAR not valid.            
 Cause . . . . . :   Parameter 1 specified in function DECRYPT_CHAR is not      
   valid for use for reason code 8. The reason codes and their meanings follow:
     1 -- Parameter must be a string constant.                                  
     2 -- Parameter must be an integer constant.                                
     3 -- Parameter must be a numeric constant.                                 
     4 -- Parameter's length is too long.                                       
     5 -- Parameter's value is out of range.                                    
     6 -- Parameter must be a valid CCSID.                                      
     7 -- Parameter cannot be a parameter marker.                               
     8 -- Parameter's data type is not supported by the built-in function.      
     9 -- Parameter cannot reference a column with an active column mask since  
                                                                        More...
 Press Enter to continue.                                                       
                                                                                
 F3=Exit   F6=Print   F9=Display message details                                
 F10=Display messages in job log   F12=Cancel   F21=Select assistance level     
                                                                                

and

                         Additional Message Information                         
                                                                                
 Message ID . . . . . . :   SQL0171       Severity . . . . . . . :   30         
 Message type . . . . . :   Diagnostic                                          
 Date sent  . . . . . . :   09/25/19      Time sent  . . . . . . :   08:57:10   
                                                                                
 Message . . . . :   Argument 01 of function DECRYPT_CHAR not valid.            
 Cause . . . . . :   The data type, length, or value of argument 01 of function
   DECRYPT_CHAR specified is not valid.                                         
 Recovery  . . . :   Refer to the DB2 for IBM i SQL Reference topic collection  
   in the Database category in the IBM i Information Center for more            
   information on scalar functions. Correct the arguments specified for the     
   function. Try the request again.                                             
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                         Bottom
 Press Enter to continue.                                                       
                                                                                
 F3=Exit   F6=Print   F9=Display message details                                
 F10=Display messages in job log   F12=Cancel   F21=Select assistance level     
                                                                                
                                                                                
These errors occur at runtime, not at compile-time, and only on the V7R3 system that is "behind" on PTFs.


Mark





On Wednesday, September 25, 2019, 8:48:04 AM EDT, Rob Berendt <rob@xxxxxxxxx> wrote:





If you look at the joblog, what is the error in your joblog?  The return code is critical.

Rob Berendt

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.