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

...

[dlanz12345]

I have a query which takes less than a second to execute from iNavigator. When I run the same query from a php script and then loop through it using:

$numRows = 0;
while ($row = db2_fetch_assoc($stmt))
{
//Do stuff
$numRows++;
}
echo

...

[Poddys]

Something that I thought would be fairly easy to accomplish has taken me a week and I just keep hitting roadblocks every step of the way. I am hoping that someone has been able to achieve this and can maybe offer some tips.

The scenario is that our corporate web site (PHP using the DB2...

[Gary B]

Hi Everyone,

Please forgive me and let me know if this is posted twice, my first post didn't seem to work.

I have an sql command that seems to be taking a long time to process. My RPG program processes ~ 500k records and runs in less than 1 minute, love my i.

However...

[WarrenN]

Not sure if this should go here or in DDS, but I'm trying to find all records in a table that include illegal characters in any of their fields. There are a little over 1 million records in this table, so hand checking all of them isn't very practical. Does anyone know of a way to detect all illegal...

[techas400]

Is it possible to compute a file member removal in a rpgle program from a development lpar.

eg: RMVM FILE(LIB/FILE1) MBR(PAR1981181)
and performing updation on a different file in a different lpar altogether?

UPDATE "SCDTA.CORP"/AR#RMTPRL9
SET...

[Gary B]

Merry Christmas everyone!

I have an FTP situation I've not run into before and cannot find anything on this anywhere.

I need to pick up multiple files from a remote server (not an i).
I do not know the file names and the names will never be the same name.
I'd like...

[jamief]

     H dftactgrp( *no )  OPTION(*NODEBUGIO)                                                         
                                                                                                    
       //---------------------------------------------

...

[abercrombieande]

I have a few tables that I would like to estimate the size savings on if I drop a few columns. What is the best way to estimate the savings?

[BhargavSushant]

which command to use for checking that if data area already exist in Library.

[jamief]

   // need to update oefpicks --                                 
    exec sql update oefpicks set  OFFLIGHT = 'P',                
                                  OFPUSER = :@user,              
                                  OFPICKIP = :ipaddress, 

...

[jamief]

Please take a look at Graeme's site nice work and a nice tutorial in form of .PDF.
excellent work.

http://mysite.verizon.net/Graeme_Birchall/index.html

jamie...

[abercrombieande]

I am going crazy why cant I drop a column

ALTER TABLE DWUSRLIB.DMPROVDT  DROP COLUMN DIM_PROVDR_EXP_DATE;

SQL State: 57014
Vendor Code: -952
Message: [SQL0952] Processing of the SQL statement ended. Reason code 10. Cause . . . . . : The SQL operation was ended before...

[abercrombieande]

I have two table as defined below

TABLE 1
--COLA
--COLB
--COLC

TABLE 2
--COLA
--COLB
--COLC

Table 1 COLA is autonumber.
When I try to run

alter table TABLE2 add contraint CSTID foreign key

...

[Lenny2113]

Hi all.

We are using iSeries and only now converting from System36 to ILE. Most applications are written in COBOL.
All data access is done via native "Read / Write".
I am considering switching to Databases and SQL as opposed to PF and LF.

I came...