Announcement

Collapse
No announcement yet.

Search Result

Collapse
25 results in 0.0309 seconds.
Keywords
Members
Tags
sqlrpgle x
  •  

  • 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

  • paolinosal
    started a topic Base64 Encode e decode
    in SQL

    Base64 Encode e decode

    HI all,

    I was trying the systools function base64 encode and decode but I have a little problem with the decode...

    here's a test case:

    Code:
    Create Table Testbase64(Rowid Int Not Null Generated Always As Identity (Start With 1, Increment By 1, No
    Cache), Fieldutf8
    ...
    See more | Go to post

  • stevenkontos
    started a topic Email Validation in RPG

    Email Validation in RPG

    It's not easy. A pretty thorough search of the internet turned up some code that would not compile. In theory, if it could compile, we are still looking at 200 lines of code or so to call a C++ function, with all of its header specifications, to execute a regular expression. A regular expression is...
    See more | Go to post

  • AS400 / iSeries programmer / administrator from Bremen searches festival employment

    Search festival employment to 03. 04. 2017 in Bremen, or post code 28. (because of company site closing to 31. 03. 2017)
    Year of birth in 1969, manly
    qualified data processing businessman with 24-year-old work experience

    Knowledge:
    Computer languages: CL / CLLE, RPG/RPGLE,...
    See more | Go to post

  • Vectorspace
    started a topic Dynamic SQL - conditional build vs embedded conditions
    in SQL

    Dynamic SQL - conditional build vs embedded conditions

    I'm working on an SQL program that will read data from a file into a subfile. There are lots of optional conditions that the user can input.

    I'm looking at two approaches.

    The obvious way is dynamically including only the relevant conditions when I build the SQL string,...
    See more | Go to post

  • Vectorspace
    started a topic Embedded SQL Access Paths and For Update Of
    in SQL

    Embedded SQL Access Paths and For Update Of

    I've been an RPGLE programmer for a while, but the company I work for who taught me RPG does not use embedded SQL. I am only just starting to teach myself.

    According to this article: http://www.itjungle.com/fhg/fhg010709-story02.html
    If you update a table through a cursor, SQL...
    See more | Go to post

  • techas400
    started a topic SQL insert into 2 libraries with 1 query
    in SQL

    SQL insert into 2 libraries with 1 query

    I have the following query in SQLRPGLE for DB2:

    Code:
      INSERT INTO ITEMS2 (PROGRAM, VLDFILE, VLDFLD, 
        SELFILE, SELFLD) VALUES(:SCAPP   , 'CSTMR', 'CYC',
        'BYC', 'BYCC');
    I would like this query to be run in 2 libraries as in FIRST/ITEMS2 and...
    See more | Go to post

Our Sponsors

Collapse
Working...
X