ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Search Result

Collapse
31 results in 0.0025 seconds.
Keywords
Members
Tags
sqlrpgle x
  •  

  • tbrantley
    started a topic Using Clob Fields in SQL
    in SQL

    Using Clob Fields in SQL

    Has anyone tried using a clob field inside of SQL?

    I'm moving the data from the YAJL copyBufStr function into a clob variable.

    Once I try to use the clob variable inside the SQL statement I get the error below.

    Length in varying-length, LOB, or XML host variable...
    See more | Go to post

  • Need help with SQLRPGLE program to obtain active job details

    I have written a program using the new SQL based features to obtain status from the Active jobs on my system. My routine is to check for active subsystems before a shutdown. If they are found and active, I want to know if there are any jobs running in that subsystem as sometimes the shutdown, ends...
    See more | Go to post

  • user13482104
    started a topic Problems with an INSERT with embedded SQL

    Problems with an INSERT with embedded SQL

    Hello dear community,
    I'm currently having trouble with an insert. I can't get an insert. In the debug I saw that the SQLCOD was set to -7008 (object-name NOT VALID FOR
    OPERATION (reason code)). I've attached an image. Can someone tell me what I'm doing wrong? I create the file in QTEMP...
    See more | Go to post

  • Work with Compile Commands - Multiple Commands

    Hello all,

    I am trying to compile my .SQLRPGLE program from the i Project section in RDI. The only issue I am running into is that I need to add my library before it compiles otherwise it fails to compile because my library list is not in the default library list.

    The default...
    See more | Go to post

  • Alexis.A
    started a topic Problem with interactive program and debbug

    Problem with interactive program and debbug

    Hello,

    I have an interactive program that is not working properly.
    In my program, I fill in a temporary file (via SQL) and then I process the file.

    Here is the SQL :
    EXEC SQL insert into wfictmp1
    (wservic, wimmeub, wnumcop, wdattrt)
    select servic, immeub,
    ...
    See more | Go to post

  • mgarczynski
    started a topic Need some feedback on using a Service Program

    Need some feedback on using a Service Program

    I found a service program which will wrap text for output and call it LINEWRAP. There is a Module and Service program in my library list. I also followed the instructions to create an SQL procedure. The program works fine with Interactive SQL. However, when try to code it in my SQLRPGLE program,...
    See more | Go to post

  • mgarczynski
    started a topic Executing QCMDEXC within RPGLE

    Executing QCMDEXC within RPGLE

    I'm trying to issue a command using QCMDEXC within an RPGLE program. The command will send an status email.
    CLUNODE = NODES

    The failed message is CPD0047 List or expression not valid for parameter SUBJECT. I am guessing it does not like the extra single quote in the Subject...
    See more | Go to post

  • mgarczynski
    started a topic Using order by with embedded SQL RPGLE.
    in SQL

    Using order by with embedded SQL RPGLE.

    I am trying to populate a subfile with data read from a master file in a particular order. The user can switch order by pressing the appropriate Function Key. The problem is the data populates the subfile based on the first statement processed all the time. I have cleared the array before launching...
    See more | Go to post

  • Carpiem
    started a topic Why REGEXP_COUNT returns a wrong value?
    in SQL

    Why REGEXP_COUNT returns a wrong value?

    Hello all,

    I'm puzzled why REGEXP_COUNT returns weird results, for example take this query:

    PHP Code:
    select regexp_count('1','[A-Z]')
    from SYSIBM.SYSDUMMY1 

    Regular expression [A-Z] means it accepts a letter from A to Z. But 1 is no letter, and the result of...
    See more | Go to post

  • QZDASOINIT Stored Procedure Running Slow

    Hello,
    I have a weird behaviour on a stored procedure running in QUSRWRK subsystem.
    When I run the above stored procedure from ACS(Run SQL Script) it takes 21 minutes to execute.

    [ 31/12/2020, 18:49:16 ] Run Selected...
    CALL spgetQtyOnHand ('020', '2020-01-01' , '2020-12-31'...
    See more | Go to post

  • Prepared SQL for Single Row into Data Structure; without cursor. Possible?

    I am attempting to use a prepared statement to fetch information (a single row) about a location; based on a given ID. The location ID is either passed via parameter, or directly entered and read from the display/user interface.

    I have tried stepping through the RDi debugger. I see the...
    See more | Go to post

  • vijayrmca
    started a topic Need to put the same query as DB2 in SQLRPGLE

    Need to put the same query as DB2 in SQLRPGLE

    All,

    I am having one DB2 query

    SELECT year(current date)*10000 +
    month(current date)*100 +
    day(current date-1 days),count(*) FROM mstfile.

    Above query gives me the result as 20200108 ,100 as output...
    See more | Go to post

  • Implementing Rest service with Json String and Scott's yajl library

    Hi,

    I am developing a program using Scott's yajl libraries to process the Json String into DB2 table. I have two questions,

    1. More generic, we are using V 7.2 - Is it ideal to use yajl libraries or we need to consider using DATA-INTO and Json tables for efficiency. Json...
    See more | Go to post

  • CaptainRon
    started a topic DataStructure SORT on two different fields.....

    DataStructure SORT on two different fields.....

    So I have a Data structure array. I can sort on one field using the SORTA command with %subarr. Can I add another field WITHOUT combining the two fields together in a one field sort? To basically sorting on two fields or three etc..... Again without combining into one field. If I can in SQL do you...
    See more | Go to post

  • fountaintech
    started a topic SQL 305 error with coalesce in RPGLE
    in SQL

    SQL 305 error with coalesce in RPGLE

    I have what I thought was a simple statement (below)

    H ALWNULL(*INPUTONLY)

    select rhwhs,rhvnno,rhbol,rhcanm,rhrcdt,rhsnno,vennam,
    cast (coalesce(apevthh,0) as numeric(2,0)) as apevthh,
    cast (coalesce(apevtmm,0) as numeric(2,0)) as apevtmm

    from
    ...
    Search the world's information, including webpages, images, videos and more. Google has many special features to help you find exactly what you're looking for.
    See more | Go to post

Our Sponsors

Collapse
Working...
X