The IBM i is a proprietary platform from IBM, which runs on their Power Systems and Pure Systems, and contains a DB2 database integrated into the IBM i OS.
I would like to run some ad hoc select statements in the IBM System I Navigator tool for DB2 using …
sql db2 ibm-midrange iseries-navigatorI am trying to run an SQL that contains if-else statement in AS400 but it doesn't work. I am creating …
sql view ibm-midrangeactually i have 2 tables table1 and table2 table1 name city addr. table2 name city addr. ph.no now ph.no …
sql ibm-midrangeOn AS400 in interactive SQL in a 5250 session, select * from myfile returns rows from one member only when myfile has …
sql jdbc db2 ibm-midrange jt400I'm new at working on an as400 and I have a query the joins across 4 tables. The query itself is …
sql ibm-midrange db2-400I am working on a join condition between 2 tables where one of the columns to match on is a concatentation …
sql optimization db2 ibm-midrangeI am not very familiar with iseries/DB2. However, I work on a website that uses it as its primary …
sql ibm-midrange data-conversionI would like to connect to a DB2 database, specifically an iSeries version, using .Net and C# by referencing a .…
.net database db2 ibm-midrangeI have a series of ASCII flat files coming in from a mainframe to be processed by a C# application. …
c# .net ibm-midrange flat-file comp-3I know that in standard SQL you can do this: update top (100) table1 set field1 = 1 (reference: how can I Update …
sql db2 ibm-midrange