Need to put the same query as DB2 in SQLRPGLE

[vijayrmca]

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

[Vinoth]

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

[CaptainRon]

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

[fountaintech]

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

[paolinosal]

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:

Create Table Testbase64(Rowid Int Not Null Generated Always As Identity (Start With 1, Increment By 1, No
Cache), Fieldutf8

...

[stevenkontos]

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

[Einstein_69]

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

[Vectorspace]

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

[Vectorspace]

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

[techas400]

I have the following query in SQLRPGLE for DB2:

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

[techas400]

Guys,

What does this statement mean?

D  SQLROUTE       C                   CONST('QSYS/QSQROUTE')               SQL

Please help.

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

C

...

[kausix777]

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

This is the DSPF declaration:

FUT436SD   CF   E             WORKSTN INDDS(Indicators)

The DSPF has certainly been compiled and it exists (library masked)....

[surisimha]

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

[aliceraunsbaek]

I have two tables:

          Exec SQL create table FilOprHyp (
                            Id         numeric(3 , 0) not null,
                            Tekst      char(45) not null,
                          Constraint unikt_id Primary key (Id)

...

[aliceraunsbaek]

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