• How to handle record lock using embedded SQL?

    I am using SQLRPGLE program,need to handle record lock in sql statement ..plz suggest?

    Samule400160 pointsBadges:
  • CPF5032 and SQL RPG

    How do I unlock the data file to avoid halt ? CL used to sort file and call an RPG that cleared a field (followed by further processing). When I switch to an SQLRPG to clear the field, I get CPF5032 in the next program. Yes, I tried the UNLOCK op code in the SQLRPG but same result. No halt using...

    aceofdelts1,950 pointsBadges:
  • 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...

    sim400305 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...

    Dcantwell470 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,380 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:
  • SQL RPGLE – How to override data set data structure at run time

    I currently have an SQL RPGLE routine that receives a SELECT statement as a parameter and then fetches the data set into a data structure based on the file. This only works over a single file as the datastructure is created at compile time and has to be based on filea. I would like to make this...

    NarkedDiver20 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...

    aceofdelts1,950 pointsBadges:
  • RPQSQL / SQLRPG

    Any body please help Wanted to know the advantage and disadvantage using RPGSQL / SQLRPG I've heard that this is the new one its not only RPG but become one with SQL. Thanks in advance

    TG50 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:

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