Hi All,
I am researching Kerberos in the IBM midrange environment. I am a developer.
I have client server desktop application. Front end java(using JT400 api) and backend Rpgle(PCML). So the client is using a mixture JDBC Sql and backend rpgle program calls.
My...
Announcement
Collapse
No announcement yet.
Search Result
Collapse
25 results in 0.0071 seconds.
Keywords
Members
Tags
-
March 15, 2022, 09:28 AMThis topic by lcortesbsr has been deleted by mjhaston
-
Baby Steps Kerberos
-
Why REGEXP_COUNT returns a wrong value?
Hello all,
I'm puzzled why REGEXP_COUNT returns weird results, for example take this query:
PHP Code: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...
-
Oracle 11i to DB2 on IBM i - Migration
Good Morning/ Evening All,
Need your expert advice.
We have a requirement wherein we have to migrate the data from Oracle 11i to DB2 on IBM i (on V7R2). Need your guidance for the below:
1. Is there any IBM proprietary tool which can help us in the migration? Or...
-
Need to put the same query as DB2 in SQLRPGLE
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...
-
STRPCCMD leaving black 5250 screen
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...
-
Override System Default Value - Date Column
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...
-
Journals from one system to another
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...
-
Enabling user to end writer and vary off printer
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...
-
Getting a Token Error When Running on iSeries
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...
-
Base64 Encode e decode
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:
Code:Create Table Testbase64(Rowid Int Not Null Generated Always As Identity (Start With 1, Increment By 1, No Cache), Fieldutf8
-
db2_fetch_assoc() fails mid-way through looping through results
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:
Code:$numRows = 0; while ($row = db2_fetch_assoc($stmt)) { //Do stuff $numRows++; } echo
-
Synchronise DB2 With MySQL Database
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...
-
SQL Update First Occurrence only?
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...
-
Finding records with illegal characters
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...
Our Sponsors
Collapse