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: 368
How do you perform a
Select top N * from as400table
type query against an as400/db2 database
© Stack Overflow or respective owner
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
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
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 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
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
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
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
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
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
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
