Questions tagged [iseries]
IBM mid-range computers, previously called AS/400
59 questions
0 votes
0 answers
21 views
Exporting a whole iSeries database to reinject it in PostgreSQL
I am trying to recover a client's data hosted on an iSeries server. It is very probably a DB2. There are 2000+ tables to transfer. I have access with jdbc and tried with DBeaver (which gives the best ...
- 197
2 votes
0 answers
1k views
Fixing data pivot/grouping with db2
I have a pretty straightforward sql query that I'm running on DB2 I-series 4 which is just performing some simple joins. The issue is that my materials table has it so that multiple material/color ...
- 121
0 votes
1 answer
88 views
DB2 AS400, Hammer DB setup issue
I am working with Hammer DB to connect to remote DB2 AS400. However, I am running into issue in build schema. [IBM][CLI Driver][AS] SQL0204N "QSYS.ANAND" is an undefined name. SQLSTATE=...
- 3
0 votes
0 answers
120 views
My linked server from as400 disconnects every time SQL Server is restarted
Every time I restart SQL Server, my linked server which is linked with AS400 gets disconnected. Every time it gets disconnected, I simply refresh the provider and I'm good to go. But, sometimes if I'm ...
siddharth rao
0 votes
1 answer
962 views
Create table with EBCDIC encoding in db2 i series
I am working with AS400 system. I need to create tables with different encoding for validation task. I tested with CREATE TABLE TESTSCH.EBCDIC_TBL ( COLUMN1 VARCHAR(100), COLUMN2 INTEGER ) CCSID ...
- 3
0 votes
0 answers
927 views
SQL Linked Server "IBM DB2 for i IBMDASQL OLE DB Provider" / IBMDASQL Stopped Working - No Errors
We have a linked server to pull data from an AS400 that worked every day for years, but randomly stopped working last night. When we do test connection / run a test open query against the linked ...
0 votes
1 answer
43 views
why does the order of fields return 0 rows, but move the field does
I have two queries that return the same data, only the calculating field with the case is moved. I am using the Access Client Solutions "run query" to execute the query. If I run this one ...
- 1
0 votes
1 answer
193 views
iSeries journaling performance
I am responsible for a legacy application deployed on an iSeries V7R3. The application is fairly high volume, 2 million or so transactions per month. The database for this app spans multiple libraries ...
- 103
0 votes
2 answers
2k views
Add days to date (char column with decimal) in DB2
I have a table named INVOICE_ET which has column of below definition INVDATE CHARACTER 10 result of select INVDATE from INVOICE_ET is as below INVDATE 2021-07-31 In another table INVOICE_DY, I have ...
- 21
3 votes
1 answer
180 views
I need the identical lines to merge
Previous question: Return row with values if nothing fits the conditions I almost got this working. The problem that I have is that this variant of query does not merge the line from the SELECT with ...
- 33
0 votes
2 answers
92 views
Return row with values if nothing fits the conditions
I have his query that works fine, but I need it to return a line when nothing is found to suit the conditions: SELECT D.CODPRO, D.VALPRO, COALESCE(SUM(d.UVCLIV), 0) AS SUM FROM FGE50LM0TV.GESUPE E ...
- 33
0 votes
2 answers
805 views
Pending changes from a finished job
I'm getting the following error: Uncommitted changes pending for file MYTABLE in library MYLIB. CPF325E Cause . . . . . : Uncommitted changes are pending for file MYTABLE in library MYLIB for ...
- 281
0 votes
1 answer
506 views
Create View giving SQL7029
If relevant, I'm using IBM i V7R1M0. I have some code in C#: var generateSqlSql = $@" CALL QSYS2.GENERATE_SQL( '{obj.Name}', '{obj.Library}', 'VIEW', CREATE_OR_REPLACE_OPTION => '...
- 281
1 vote
0 answers
1k views
IBM db2 FOR XML equivalent
I've been trying to Query an item with its sublist all in one go and one way is to use for xml and subquery. I've been using this strategy with sql server and works fine. The relationship is Order ...
- 43
2 votes
2 answers
9k views
How can I lock row for reading/updating in DB2?
I am trying to resolve a race condition in my application. I have a table that is used as a work queue and many threads and read/update it. The following query is executed from application. First it ...
- 141