Log4J in AS/400
Hi, I am looking for a logging mechanism in AS/400 similar to log4j. I am thinking of writing a wrapper to the log4j in AS/400. Can someone please let me know if there is such a tool present already? Thanks, Sam ...
as400
Calling AS400 SP from ASP .NET webservice
I have an external stored procedure (SP) in AS400 with IN and OUT prameters.When my SP is called from webservice with IN and OUT parameters, it shows me an error (Attempted to read or write protected memory).But when the webservice has all the parm as IN mode and calls my SP it works properly. ...
Fetching data from excel sheet in AS/400
I am using AS/400 with Reflections for IBM. Here is my question: How can the data from an excel sheet be transfered to an AS/400 session. From there I should be a ble to create macros to add the info to where ever it needs to be inserted. ...
AS400 RPG Simulator
Hi, I have a urgent requirement to call an RPG Program from java. As suggested in this http://stackoverflow.com/questions/184864/accessing-rpg-on-iseries-from-java question. I am planning to use JTOpen. But unfortunately I dont have access to any of theses systems. So is there any way I can test the java program ? Are there any RPG sim...
MQ EOL Data conversion
we are sending data trough MQ from a z/OS/CICS system to an AS400. Original encoding of the message is CCSID 500 with a MQSTR Format. The client application is getting the message with the CONVERT option and CCSID 819. Data is almost converted correctly except for the end of line caracter. Any idea? The z/OS is sending 0D (CR) as end o...
DB2 - How to call a stored procedure in IBM System i Access for Windows GUI Tool
I would like to test a DB2 stored procedure running on an AS400 system. I have the IBM System i Access for Windows installed and can run SQL commands against the DB2 database. My question is: What is the syntax to execute a stored procedure that takes in a parameter and returns a result as an output parameter and print the value to the...
Error while Invoking ASO400 RPG From Java
With respect to my yesterday's question on invoking RPG program using Java, the below exception is through from RPG Program. **Application error. RNX9001 unmonitored by ZM30000R at statement N, instruction X'0000'.* I have used the code that was posted in that question and after changing by the suggestions that were given in answers. ...
How to view logical file with multiple Recordformats In AS/400?
I have made a multiformat logical file in as400. When I run it, only one record format fields are displayed. Second record format fields are not seen. what is the procedure to see all record format fields? ...
primary and full procedural files in rpg
difference between primary and full procedural files in terms of functioning ....in rpg ...
development tools for as400
Is there any development tools for as400? ...
How to clear the screen on an AS400?
Is there any method to clear the screen in RPG for the AS400? I'm looking for something with the same result as clrscr() in C. ...
Trimming variable in CLLE
How to trim a variable in CLLE?? Thanks Arpit ...
DB2 - How to run an ad hoc select query with a parameter in IBM System i Access for Windows GUI Tool
I would like to run some ad hoc select statements in the IBM System I Navigator tool for DB2 using a variable that I declare. For example, in the SQL Server world I would easily do this in the SQL Server Management Studio query window like so: DECLARE @VariableName varchar(50); SET @VariableName = 'blah blah'; select * from TableName ...
Simple query in DB2 for AS400
This is a very easy query (I think) but I stil can't do it. I have some data like this: A B C 1 1100 5 1 1100 5 1 500 1 2 1200 4 2 1200 4 2 600 1 3 1300 3 3 1300 3 3 700 1 And I want to return the ...
handling page up in single page subfile
i am unable to handle page up option in single page sub file ....dont know how to go back to the previous rrn so that previous page can be displayed .... ...
AS/400 'SELECT 1' Equivalent
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?...
Error when connecting to AS400 (ISeries)
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 exceptions Running 64 bit: "The provid...
Validate the type of data
How to validate data in RPG code like if a field is of char type then how to validate that it should only take alphabets..... ...
Using OLEDB parameters in .NET when connecting to an AS400/DB2
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 in my query (ex. @MyParm) it does...
Call MiSys Equation API from BizTalk
How can I call MiSys Equation API from BizTalk or .NET? Equation is a banking system hosted on ISeries AS/400 server. is the Host Integration server way to go? ...