as400

Capturing onkeydown in Javascript

I have a web front-end to an AS/400 CGI application which allows the use of some of the F1-F24 keys (depending on the page) as well as page-up, page-down etc - these are passed to the underlying application which handles them appropriately. For instance, on a given page, a user could either press the F3 button or press the F3 key - both ...

Connect to AS400 using .NET

Hi Guys, I am trying to build a .NET web application using SQL to query AS400 database. This is my first time encountering the AS400. What do I have to install on my machine (or the AS400 server) in order to connect? (IBM iSeries Access for Windows ??) What are the components of the connection string? Where can I find sample codes o...

AS400 Emulator or Virtual Machine

Do these exist? Can you recommend one? ...

setting up a default value of a column in select statement

hi actually i have 2 tables table1 and table2 table1 name city addr. table2 name city addr. ph.no now ph.no field is an extra field in table 2 so i want to show field ph.no with a default value of 12345 in the output of select query on table1 as i want to append that output into an outfile. help me out ..I am using db2 as400 dat...

Delete records from multiple tables

Consider these several tables: tab1 ------- userid email address environment tab2 ------- ecode company policy tab3 ------- id pan no. dl no. Here tab1 is the parent table. I want to delete all the userid of tab1 from tab2 and tab3. Either userid will be in tab1 or tab2 or both. These tables are environment specific means environme...

How to set a timeout in connect/send ? ( as400 iseries v5r4, rpg )

From this rpg socket tutorial we created a socket client in rpg that calls a java server socket The problem is that connect()/send() operations blocks and we have a requirement that if the connect/send couldn't be done in a matter of a second per say, we have to just log it and finish. If I set the socket to non-blocking mode (I think...

How to create an alarm and signal handler in RPG ? ( AS400 iSeries v5r4 )

A valuable answer will include the rpg code that does something like this volatile bool interrupted; main() { sigaction(SIG_ALARM, myhandler) // register handler alarm(3) // set the alarm sleep(5) // blocking call, sleep just as an example. alarm(0) // disable the alarm } myHandler() { interrupted=true } I think you've got t...

iSeries + ASP.NET web application - Do I need any special license for iSeries?

I know how to access the iSeries using VB.NET. I use an OLE DB connection to connect to it. Now I am developing an ASP.NET web application using VB.NET that is going to use the iSeries for the database. Is there any special web license I need to access the iSeries over the web in this fashion? It's really just the web server accessing th...

fetching connection from JNDI >15 minutes!

I have this weird problem, web application connecting to AS400 DB2 server through JNDI, getting connection from JNDI happens to last for about 930-960 seconds!!! Usually it takes 4ms to get a connection, and from time to time it spans to 15 minutes... it has no special rule of when/why it happens. We are using JTOpen jt400.jar driver ver...

I'm trying to create a as400/Iseries Telnet Client, and can't find any documentation.

I am attempting to create a telnet client that I can use to transfer green screen RPGLE apps to fancier client applications. I am able to establish a sockets connection and I have sent in a default "enter" command to access the log in screen but I don't know where to began to interpret where the fields are, where the server id of the ses...

share a same sql connection among multiple executables

I, I am looking for a way to share a sql connection between two (or more) C/C++ executables. By sql connection sharing, i mean to have a transactional context in common : the A module can start the transaction, the B module do some work, and the C can commit the transaction. Of course, if a module wants it, it can throw an exception a...

Create a delimitted string from a query in DB2

I am trying to create a delimitted string from the results of a query in DB2 on the iSeries (AS/400). I've done this in T-SQL, but can't find a way to do it here. Here is my code in T-SQL. I'm looking for an equivelant in DB2. DECLARE @a VARCHAR(1000) SELECT @a = COALESCE(@a + ', ' + [Description], [Description]) FROM AP.Checkbooks SEL...

Does a I Series have a limit to the number of telnet connections?

Does a I Series have a limit to the number of telnet connections? Like a a license limit or user limit or something I should be aware of? ...

Paramertize Fetch First n Rows Only in DB2

I'm trying to do the following: select * from table fetch first @param rows only @param is an int. DB2 would not have it. I've heard of concatenating it with ||, but I can't seem to get that to work. Anyone have experience with this? (PS I saw a similar question (http://stackoverflow.com/questions/2621420/db2-wont-all...

Zend Server on Iseries Apache httpd.config

I am evaluating Zend server on the Iseries. I am currently using Zend Core. I am unable to restrict accesses to directories in the htdocs folder. With Core I was able to restric accesses with the following: <LocationMatch /DirectoryName> Require valid-user AuthType Basic AuthName SecureArea PasswdFile %%SYSTEM%% UserID %%CLIENT%...

I need to find out the name of a DDS Screen that a given telnet session is on? (I Series)

I am looking for a program or API call that will give me, with absolute accuracy, the name of the Workstation Display File (and Its Record Type) that is being used by a given Job. I have the Job information (such as Job Name, Job User, and Job Number. This will allow me to quickly identify the Display File that a given job to assist in p...

asp.net gridview using parameter query to as400

I'm trying to retrieve as400 data into a gridview by passing a value to a parameter from data stored in a session variable, gathered from a text box. If I hardwire the query selection, it works fine, but trying to pass the parmameter gives the error: SQL0206: Column @myParm not in specified tables. I don't get this error when using tabl...

shell command for executing stored procedure in DB2 OS400

what is the shell command for executing stored procedure in DB2 OS400. CALLPRC PRC(SPNAME) PARM('','',5,'','') RTNVAL() what is this one?? ...

Convert to Text Format In Excel

Hi, I'm extracting some data from AS400 using excel macro. In the AS400, this particular column (Ref), shows 20100729000078154 but when I extracted it to excel, it will be 2.01007E+16. I need to hv 20100729000078154 as my final output. This is the macro that I used to extract the info from AS400 :- Sub Extract() Dim StrSQl As String ...

Calling As400 procedure in SSIS

HI All, I have created one simple stored procedure in AS400. It has only one input parameter and I compiled and created it successfully. Now I need to call this procedure in SSIS to move data from source to destination. Here my source is As400 procedure and destination is Sql server table.I have goggled lot to find how to call the proc...