Why REGEXP_COUNT returns a wrong value?

[Carpiem]

Hello all,

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

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

[henrymiller]

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

[jason.aleski]

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

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