Base64 Encode e decode

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

[aliceraunsbaek]

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:

Exec SQL delete from table1 where lastUse < current timestamp - 7 days;

But, I would like something like:

MyStatement = 'delete

...

[krymen]

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

DSPFD      FILE(*ALL/*ALL) TYPE(*ATR) OUTPUT(*OUTFILE) +
             FILEATR(*PRTF) OUTFILE(MDTOS/DSPFDATRF) + 

...

[abercrombieande]

I have two iSeries sytsems A & B both on V7 and one SQLRPGLE program. The program is mostly SQL. When it is compiled on system A and runs on A it completes in a matter of minutes. When it is compiled on system A and runs on B it appears to be stuck on a SQL statement. It sits there for hours and...

[iSeries_Pgmr]

Hi; I have created two programs; one in RPGLE and SQLRPGLE (/free format) sql statements. I tested both programs and I can pass parms in and get the expected results from them. But, when I call the SQLRPGLE GETDO program from the RPGLE program Call 'Getdo' ...