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

[CaptainRon]

All, this works just fine
STRPCCMD PCCMD(&URL) PAUSE(*NO)

Except when you call it from the 5250 screen and it opens up a browser the 5250 screen is black and waiting on you to click it before it will display the screen back to where you called the CL from.
Anyone else...

[VigneshMohan]

The system defined default value for a date column in DB2/iSeries is always "current date". How can we change that to '01/01/0001' (*LOVAL) ?

When I insert a record via RPGLE, the date fields always default to *LOVAL.
Whereas, when I insert a record using SQL (or an ETL...

[CaptainRon]

So I have been doing Journals forever and using them to see what has happened to a file etc. We have a production system that has journaling turned on. What I want to do is extract specific files ( I already know how to do all that ) to the test system. I can do this by extracting the production...

[CaptainRon]

b/c of some weird unknown reason. We have an HP printer that when it runs out of paper it needs varied off and back on. This user does not have authority to the device. How can I in a CL program allow them to do this? I have tried GRTACCAUT but that does not work. Gives me an error saying they...

[StevenDyke]

The following sql statement runs from an external IDE but gives me an error on line 15 position 14 When ran in the iSeries environment:
Error: Position 14 Token SUM was not valid. Valid tokens: ) ,.

0011.00 UPDATE OIPAYFILES/EMPLOYEE SET PRURN2 = PRURN1 - (PRURN5 + (SELECT
0012.00...

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