• SQLRPGLE Error in UPDATE Query

    Hello, I have a SQL Statement in SQLRPGLE which Updates a 3 fiels in a file with 30 fields. SQL Statement is as below. UPDATE TABLE1 SET TXDATE = :SYSDATE, TXTIME = :SYSTIME, SETFLAG = :w_Set, MSG = :w_ERR, Comment = ' ' WHERE ID = :W_ID This works fine on one iSeries server and throws...

    sim400380 pointsBadges:
  • Problem Running SQLRPGLE program in Batch: Works Fine Interactively

    Hello all, We currently have a program that runs in batch. Last night, we had the following error occur: RNQ0103: The target for a numeric operation is too small to hold the result. The program works perfectly when run interactively. When the program was originially written, I compensated for the...

    Dcantwell480 pointsBadges:
  • Embedded SQL number of days between dates

    C/EXEC SQL                                C+ INSERT INTO SERIOVR60                  C+ SELECT HTSERN, HTPART, HTQTY, HTSTKL,  C+ HTSTS,  HTADAT,                        C+ substr(HTPART, 1, 11) AS HTMODEL,      C+ HTADAT -...

    NickHutcheson11,485 pointsBadges:
  • Help needed for connect statement using sqlrpg

    Hi All, I need to do some checking in 2 different AS400 servers. I will read the data from one server(say local) then using connect type 2, connect to the other server(say remote), check the data and then returns back to my local server. I'm using sqlrpg for this and created 2 pgms for this. One...

    160780 pointsBadges:
  • Can you embed SQL statements in RPG program

    I am new to AS/400 and we have a project wherein we have to display the records grouped by some fields. Is it possible to write sql statements within RPG program?? How???

    Shwesmile20 pointsBadges:
  • What does this mean when SQLCOD = -206? I need to write 2 sets embedded SQL statement in my program.

    what does this mean when SQLCOD = -206. I need to write 2 sets embedded SQL statement in my program. first one is one and I was able to fetch data but the 2nd one has error just right after I declare cursor. Here are the statements EVAL SQLSTMT2 = SELECT_H_2 + WHERE_H_2; + AND_H_A; EXEC SQL PREPARE...

    Huana5 pointsBadges:
  • Printing a PDF image from BLOB using SQLRPLGE

    How to print a PDF image stored in BLOB from SQLRPGLE?

    AS400rpgle15 pointsBadges:
  • SQL and RPG 400 (SQLRPG) Variable lengths help required.

    Please could someone help me with the following, I am new to SQL and have been tasked with the following:- I am writing an RPG program where the user will be able to do a search by entering up to 15 characters to find part numbers. I know how to do this using SQL but I am struggling with this when...

    AS400Kate15 pointsBadges:
  • Trimming just one leading zero (if present) in SQLRPGLE

    I have a SQLRPGLE program and have 6A character field. How to I trim just one leading zero(if present) Eg- if 001300 then I should insert 01300. Thanks!

    Anjita5 pointsBadges:
  • SELECTION OF UNIQUE RECORDS FROM FILE USING SQLRPGILE CODE

    I HAVE TO DO THE BELOW STEPS USING SQLRPG,PLZ HELP TO HANDLE THE UNIQUE RECORDS : 1. Delete records from Production LFPRIPMH/D file and those policy numbers are available in LFPS402S (unique policy number) 2. Insert into Production LFPRIPMH/D files from Before migration image (LFPRIPMH/D), where...

    AS400RAHUL5 pointsBadges:
  • Very simple SQLRPGLE not working

    I must be missing something simple. Any ideas ? Here's the code. C/exec sql C+ Update MFLLIB/ITMAST C+ Set IM_ITEMID = 'ST150EML' C+ Where IM_ITEMID = 'ST150E ' C/end-exec C Eval *inlr = *on   I simplified the update for test purposes.  No halts but no update.  Of course I can do the update via...

    aceofdelts2,550 pointsBadges:
  • AS/400 and Oracle Access Manager

    I have a strange behavior in an SQLRPGLE program accessing iSeries DB2 and Oracle via Oracle Access Manager. The program is very simple and reads values from two Oracle Tables in this way : a. SELECT .... into ..... FROM Table1 WHERE ..... return OK : 1 row as expected with my two fields filled. b....

    Technet30 pointsBadges:
  • SQLRPGLE Prepare

    When using the prepare statement I'm creating a string that contains my select statement... I want to compare a numeric field within my string. For example I have batch# which is numeric, how can I say where batch# = 21

    Bzito10 pointsBadges:
  • SQL-RPG

    Hi Every body ! I have been working on V4R4M0, Now have to work on SQL-RPG Programs. I don't know, how to write queries and other things . Can some one help me to learn SQL-RPG with good meterial ?

    Abdulonas400125 pointsBadges:
  • Compiling Eval-Corr in SQLRPGLE

    I'm attempting to use Eval-Corr for the first time.  But, when I compile a Srcmbr as a SQLRPGLE type, I get compile error: "RNF5014 30 Operation code is not valid; specification is ignored.", but when I change the srcmbr to RPGLE, no compile errors occur. Any idea why and how I can get the...

    GVincen5 pointsBadges:
  • Problem Running SQLRPGLE program with one parameter in Batch: Works Fine Interactively

    Hi, i have problems with calling an SQLRPGLE program with only one parameter. an alphanumeric field length 40. the SQLRPGLE is running fine interactively but in batch mode, the parameter is right filled with packed caracters and it causes problems in my procedure. i’ve verified calling program,...

    Laurentjudic55 pointsBadges:
  • Page at a time subfile

    I want to code loading a single page subfile in SQLRPGLE. How do I handle the page up and page down key, posotion to in that program? thanks, NG

    Nutangujar895 pointsBadges:
  • Using SRCDBG with an SQLRPGLE module

    I'm trying to debug a RPGLE module created with CRTSQLRPGI. The STRDBG program returns an error message stating the program "cannot be accessed". There is no DBGVIEW option on the CRTSQLRPGI command, so even if I get the debug to work. will I see any source data? Thanks.

    Grp5 pointsBadges:
  • file user open exceptions for printer file

    i'm opening a program defined printer file in SQLRPGLE.. i get error file is already open.... if that is the case, then i'm trying to write in that file but now this gives me exception that attempting to write in closed file...   Please help

    Nutangujar895 pointsBadges:
  • progam change date updated for SQLRPGLE program

    Can anyone tell me where I can fird the reason that the 'program last change date' is updated in an SQLRPGLE program when it is run?  It showed up on an audit and the auditors say it is unacceptable.  I am looking for proof that this the way it is from some kind of official source, or a way to...

    Sodafountain25 pointsBadges:

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.

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

Following