AS/400 'SELECT 1' Equivalent

Posted by bryan_cook on Stack Overflow See other posts from Stack Overflow or by bryan_cook
Published on 2010-03-16T13:35:42Z Indexed on 2010/03/16 13:46 UTC
Read the original article Hit count: 174

Filed under:

as400

|

ibm

I'm trying to help a friend troubleshoot connection problems with an AS/400. He'd like to run a query against the AS/400 that will always return a record, (similar to a SELECT 1 against MSSQL).

He's attempted running SELECT 1 but without luck ... I'm assuming that the AS/400 expects a FROM TableName ...

Can anyone provided assistance? Is there a system table/file that always exists that he can run a SELECT TOP 1 (or it's equivalent) against? I've never interacted with an AS/400 so I'm a bit out of my element ... was hoping SO could give me a quick answer ...

Thanks in advance!

© Stack Overflow or respective owner

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

Related posts about ibm

An Open Letter from Lyle Ekdahl, Group Vice President and General Manager, Oracle's JD Edwards

as seen on Oracle Blogs - Search for 'Oracle Blogs'
From Lyle Ekdahl, Group Vice President and General Manager, Oracle's JD Edwards As you may have heard, we recently announced some changes to the way Oracle will offer licensing of technology products with JD Edwards EnterpriseOne. Specifically, we have withdrawn from new sales the product known… >>> More
Websphere federated repository for Active Directory

as seen on Server Fault - Search for 'Server Fault'
Hi, What I am trying to achieve is to have Websphere 6.1 use Active Directory users authentication. Websphere is running on Windows 2008 R2. What I've done already: Succesfully setup a federated repository for Windows Active Directory (LDAP); Create a realm definition for the federated repository… >>> More
IBM InfoPrint 1532 Printer And IBM InfoPrint 1532 Laser Toner - Amazing Functionality And Affordabil

as seen on Article City - Search for 'Article City'
The IBM InfoPrint 1532 printer is the advanced version of the Express printer models. IBM introduced additional features to the InfoPrint monochrome laser series and this printer came about. This dev... [Author: Ben Pate - Computers and Internet - March 21, 2010] >>> More
IBM Keynote: (hardware,software)–>{IBM.java.patterns}

as seen on Oracle Blogs - Search for 'Oracle Blogs'
On Sunday evening, September 30, 2012, Jason McGee, IBM Distinguished Engineer and Chief Architect Cloud Computing, along with John Duimovich IBM Distinguished Engineer and Java CTO, gave an information- and idea-rich keynote that left Java developers with much to ponder.Their focus was on the challenges… >>> More
Getting NoClassdef on HMAC_SHA1 in Webpshere

as seen on Stack Overflow - Search for 'Stack Overflow'
We have WAS 6.0 (I know) .2.43 ND running in multiple regions. Our Dev-B region runs fine, but Dev-C throws a java exception when we make web-calls (at least this is what the developer tells me)...Same code in both regions and I checked the obvious suspects (Global security, SSL ciphers etc) and… >>> More