iseries

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? ...

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%...

Transactions on iSeries using .NET provider

Hello guys, i have multiple inserts to do so i want to do them in a transaction by calling a stored procedure on the iseries. I can't get it to work, it auto commits every insert i do so i figured i would try to do a transaction with just a simple file first and then go from there. The file is productest/cepf05 and when i first did the ...

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...

Binding DB2 (iSeries) DATE/TIME/TIMESTAMP columns to a WinForms DataGridView

I am trying to pull the contents of an AS/400 file back to a data-bound .NET WinForms DataGridView (VS 2010). The query itself is no problem, and I am able to bind everything using the DataSource property of the grid. Data comes back with no issues. The problem I am having is that all date/time fields come back as string literals, mak...

Equivalent of LIMIT for DB2

How do you do LIMIT in DB2 for iSeries? I have a table with more than 50,000 records and I want to return records 0 to 10,000, and records 10,000 to 20,000. I know in SQL you write LIMIT 0,10000 at the end of the query for 0 to 10,000 and LIMIT 10000,10000 at the end of the query for 10000 to 20,000 So, how is this done in DB2? Wha...

Fluent NHibernate with DB2 problem

I have a project that is using Fluent NHibernate. When I try to use the DB2Configuration to connect to a DB2 database I receive the following error when trying to build the SessionFactory: "The IDbCommand and IDbConnection implementation in the assembly IBM.Data.DB2 could not be found. " The assembly that is included in my install of I...

jt400 not converting € sign properly

I'm using jt400 to connect to an iSeries Database with CP1148 encoded tables. While the conversion of Umlauts, etc works just fine it happens to fail converting the Euro sign correctly (String displays ¤). Here are my connection properties: blocking enabled=true;block size=30;date format=eur;translate binary=true I also tried adding ...