How to do SQL select top N ... in AS400

Posted by James Moore on Stack Overflow See other posts from Stack Overflow or by James Moore
Published on 2010-05-17T15:32:54Z Indexed on 2010/05/17 15:40 UTC
Read the original article Hit count: 397

Filed under:

iseries

|

as400

|

sql

How do you perform a

Select top N * from as400table

type query against an as400/db2 database

© Stack Overflow or respective owner

Related posts about iseries

QNTC and Windows Server 2008 R2

as seen on Server Fault - Search for 'Server Fault'
I am having a really hard time getting an iSeries (AS/400) machine talking to my new Windows Server 2008 R2 box using the QNTC file system on the iSeries. I had similar problems getting it to initially talk to a Windows Server 2003 machine, but enabling the local Guest account on the 2003 box solved… >>> More
Very strange iSeries Provider behavior

as seen on Stack Overflow - Search for 'Stack Overflow'
We've been given a "stored procedure" from our RPG folks that returns six data tables. Attempting to call it from .NET (C#, 3.5) using the iSeries Provider for .NET (tried using both V5R4 and V6R1), we are seeing different results based on how we call the stored proc. Here's way that we'd prefer… >>> More
Changing iSeries Device and PC console password.

as seen on Stack Overflow - Search for 'Stack Overflow'
I am setting up first console session on iSeries. How do reset console password on PC and iSeries without access to a console? Thank you Ashok >>> More
AS 400 Performance from .Net iSeries Provider

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey all, First off, I am not an AS 400 guy - at all. So please forgive me for asking any noobish questions here. Basically, I am working on a .Net application that needs to access the AS400 for some real-time data. Although I have the system working, I am getting very different performance results… >>> More
Error when connecting to AS400 (ISeries)

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to connect to a AS400 server using the .net classes. I have added a reference to IBM.Data.DB.iSeries and I use the following code: var conn = new iDB2Connection("DataSource=111.111.111.111;UserID=xxx;Password=xxx; DataCompression=True;"); conn.Open(); But I get the following… >>> More

Related posts about as400

Error when connecting to AS400 (ISeries)

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to connect to a AS400 server using the .net classes. I have added a reference to IBM.Data.DB.iSeries and I use the following code: var conn = new iDB2Connection("DataSource=111.111.111.111;UserID=xxx;Password=xxx; DataCompression=True;"); conn.Open(); But I get the following… >>> More
AS400 Java Java program completed with exit code 1

as seen on Stack Overflow - Search for 'Stack Overflow'
Every attempt to run a java program on our AS400 (I5 OS VR4, JVM 1.4.2) result in the same error message: Java program completed with exit code 1 Any suggestions? >>> More
Using OLEDB parameters in .NET when connecting to an AS400/DB2

as seen on Stack Overflow - Search for 'Stack Overflow'
I have been pulling my hair out trying to figure out what I can't get parameters to work in my query. I have the code written in VB.NET trying to do a query to an AS/400. I have IBM Access for Windows installed and I am able to get queries to work, just not with parameters. Any time I include a parameter… >>> More
Delphi TBytesField - How to see the text properly - Source is HIT OLEDB AS400

as seen on Stack Overflow - Search for 'Stack Overflow'
We are connecting to a multi-member AS400 iSeries table via HIT OLEDB and HIT ODBC. You connect to this table via an alias to access a specific multi-member. We create the alias on the AS400 this way: CREATE ALIAS aliasname FOR table(membername) We can then query each member of the table this… >>> More
Monitor Exchange Email Address and run scripts

as seen on Server Fault - Search for 'Server Fault'
Okay... Not sure how "out there" this thought is... Right now to send a pager message (aka text message), a user logs into our AS400... logs into the program... enters user name and message and hit's F10 to send. With a little looking, it seems that you can run remote commands to the AS400 via… >>> More