Announcement

Collapse
No announcement yet.

Search Result

Collapse
18 results in 0.0056 seconds.
Keywords
Members
Tags
  • You can also choose from the popular tags.

sqlrpgle x

  • 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

  • techas400
    started a topic CONST definition -Urgent

    CONST definition -Urgent

    Guys,

    What does this statement mean?

    Code:
    D  SQLROUTE       C                   CONST('QSYS/QSQROUTE')               SQL
    Please help.

    Theres a call to SQLROUTE later in the program. How exactly does this function.

    Code:
    C
    ...
    See more | Go to post

  • kausix777
    started a topic DSPF in SQLRPGLE - SQL1001 error

    DSPF in SQLRPGLE - SQL1001 error

    This is the first time I was trying an SQLRPGLE program with a DSPF.
    There is no subfile involved.

    This is the DSPF declaration:
    Code:
    FUT436SD   CF   E             WORKSTN INDDS(Indicators)
    The DSPF has certainly been compiled and it exists (library masked)....
    See more | Go to post

  • surisimha
    started a topic Records not fetched in SQLRPGLE
    in SQL

    Records not fetched in SQLRPGLE

    Few records were not fetched from a Physical file in SQPRPGLE program which makes use of cursor (Declare, Open, fetch and close) to fetch records. Records which gets skipped were actually locked by some other batch process/programs to update them. (at that time)

    When I checked the joblog,...
    See more | Go to post

  • aliceraunsbaek
    started a topic Constraints makes table read only with FEU
    in SQL

    Constraints makes table read only with FEU

    I have two tables:
    Code:
              Exec SQL create table FilOprHyp (
                                Id         numeric(3 , 0) not null,
                                Tekst      char(45) not null,
                              Constraint unikt_id Primary key (Id)
    ...
    See more | Go to post

  • aliceraunsbaek
    started a topic Error state persists
    in SQL

    Error state persists

    I'm trying to make an update on a table which fails (as it should because of constraints). This causes an sql error.

    I then try to select all rows in a table using a declare. When I check the state it says there is an sql error.
    The error however is from the attempted update (I...
    See more | Go to post

  • SQLRPGLE: How to update/delete without host variables? (sql is in a string)

    Can anyone tell me how to best run a delete/inster/update that has been stored in a string?

    E.g.:
    I can code the following:
    Code:
    Exec SQL delete from table1 where lastUse < current timestamp - 7 days;
    But, I would like something like:
    Code:
    MyStatement = 'delete
    ...
    See more | Go to post

  • krymen
    started a topic Wrong Var value - SQLRPGLE
    in SQL

    Wrong Var value - SQLRPGLE

    Hello all,

    This is my first post, so i hope to do it correctly.

    I have executed this command, to obtain the atributes o my PRTF's
    PHP Code:
    DSPFD      FILE(*ALL/*ALL) TYPE(*ATR) OUTPUT(*OUTFILE) +
                 FILEATR(*PRTF) OUTFILE(MDTOS/DSPFDATRF) + 
    ...
    See more | Go to post

Our Sponsors

Collapse
Working...
X