999 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
1
answer
114
views
REGEX_EXTRACT() with multiple capturing groups not returning what's expected
The following code shows my problem, I need to extract the JOBD value (with in reality variable and matches \w{1, 10}
with A (N, STR) as (
values
(1, 'SBMJOB MYJOB'),
...
0
votes
1
answer
105
views
DB2 (i Series) how to write SELECT query on bit data using hex string value
I'm trying to troubleshoot some C# .NET code that interacts with a DB2 database on iSeries/AS400. These tables have several fields that are type CHAR() FOR BIT DATA which are populated as a hex byte ...
0
votes
1
answer
129
views
Add a field with sequence number based on RRN?
Question specifically for AS400, DB2
I have a file called RECIPES with no key. Example
Recipe Number/Ingredient number/Ingredient Qty/Sequence No
1000 111211 Sugar 0
...
1
vote
1
answer
100
views
IBM DB2 HTTP_POST for SOAP request, SOAPAction Header invalid
Just trying to get a response from the appropriate place, but I am getting an error related to the header "SOAPAction" (website changed);
values QSYS2.http_post(
'https://portal.website.asmx'...
1
vote
1
answer
194
views
Spring boot upgrade DB2 connection Warning
I am working on upgrading a Spring boot app from 1.5. to 3.4. The App is connected to IBM Iseries Db2 database, while upgrading running the app though Im able to connect to the database I am getting ...
1
vote
1
answer
51
views
How to recover original characters from data with broken characters?
We have a bunch of translations loaded in our Database which are showing broken characters where there should be accented latin characters like 'É'. I'm not sure where the encoding went wrong but we ...
1
vote
1
answer
52
views
I'm trying to update the sequence no of the file after deleteing a record from it in SQL DB2
WITH RowNumbers AS
(
SELECT
ROW_NUMBER() OVER (ORDER BY G TLINE) AS row_num,
gtline, gttran
FROM
GPOTRSP
)
UPDATE b
SET b.gtline = a.row_num
FROM GPOTRSP b ...
0
votes
0
answers
305
views
Error connecting to DB2 using IBM.Data.DB2.iSeries
Trying to connect to DB2 using the Nuget pkg IBM.Data.DB2.iSeries 7.1.0 by Cristopher Gunn. The program throws an exception "The type initializer for 'IBM.Data.DB2.iSeries.iDB2Trace' threw an ...
2
votes
1
answer
417
views
List all privileges a user has for a specific table (DB2 AS400)
Using a db2 database hosted on an IBM AS400 Version:V5R4M0 I'm having trouble trying to list permissions a user has on a specific table.
Here IBM lists different ways to do so, but I get a file not ...
1
vote
1
answer
271
views
Connecting Jetbrains Datagrip to DB2 Version 7.5 encoding error
I am new to this so excuse and obvious issues. The only driver I can get a successful connection with is the JTOpen driver. I assume this is because our database version is so old. Anyhow, whats ...
0
votes
3
answers
196
views
System Power / AS400 - Embedded sql Cursor initial Fetch is slow
On my System Power / AS400,
i'm using embedded sql in an RPGLE Program to write a Subfile.
On a large selection the initial fetch is to slow.
When i scroll the speed is good.
Even though i only select ...
0
votes
0
answers
38
views
Get DB2 AS400 version number [duplicate]
I am doing a migration from a DB2 AS400 to SQL Server 2014 database
I want to use SSMA for DB2 client (DB2ToSQL) migration tool
I need to find out if the DB2 version supports SSMA for DB2 client (...
0
votes
1
answer
244
views
ODBC driver on Azure app service for ASP.NET Core 8 Web API
I have deployed an ASP.NET Core 8.0 Web API hosted on Azure web app service (Windows). It connects to IBM's DB2 i series database and gets the data. I am using ODBC connection, the drivers are setup ...
0
votes
1
answer
318
views
How to disable autocomit with ibm db2 for i in SqlAlchemy
How do i turn off autocommit with ibm_db_sa and sqlalchemy?
If the table has journaling on, this is not required, but this one table does not have journaling on, as such, autocommit must be OFF.
I ...
0
votes
3
answers
324
views
restore an ibm db2 from a savf file
I have a .savf file that someone created from an IBM DB2 S400 server to transmit a database to me.
I installed db2 server community edition on Ubuntu. My install works, as I was able to create a test ...