On AS400 in interactive SQL in a 5250 session, select * from myfile returns rows from one member only when myfile has more than one member. How can I get rows from a specific member? Important: in the end I'd like to do this over JDBC with jt400 so really I want a solution that'll work there. Thanks. ...
Is there any way I can use AS400 style library/file style naming over JDBC with jt400? I want to be able to run queries like: SELECT * FROM MYLIBRARY/MYFILE Thanks ...
Using JDBC (with jt400 driver / connection, naming=system) I'm running these SQL statements: "CREATE ALIAS QTEMP/SOURCETEMP FOR " + library + "/" + file + " (" + member + ")" "SELECT SRCDTA FROM QTEMP/SOURCETEMP" "DROP ALIAS QTEMP/SOURCETEMP" This works. However, when the member String has a . in it this confuses everthing. Is there...
Situation is pretty serious, we have a table in DB2 on AS400 which has defined foreign key to another table, so we are entering record which have regular ID of referenced table so when we enter SQL insert through front end tool everything went fine. Problem arises when this insert is to be done through java application which uses Sprin...
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 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 ...