JTOpen is the open source version of the IBM Toolbox for Java licensed program product, and contains the identical code. Both have been tested on a wide variety of platforms, including AIX, IBM i, Linux, Solaris, and Windows.
Questions tagged [jt400]
121 questions
1
vote
1 answer
Issues writing text file to IFS though jt400
All I'm trying to do is to drop a log on IFS
Here is my code:
def write(target_filename, data)
stream = com.ibm.as400.access.IFSFileOutputStream.new(AS400.sys, target_filename)
stream.write(data.to_java_bytes)
stream.flush
…
Ruslan
- 1,919
- 21
- 42
1
vote
1 answer
AS400 system connection with JNDI
I can figure out how to connect to an AS400 through jt400 with JNDI resources just fine:
Connection conn = null;
Statement stmt = null;
try {
Context ctx = (Context) new InitialContext().lookup("java:comp/env");
conn =…
Shawn
- 513
- 9
- 18
1
vote
1 answer
Create a IBM i Java Toolkit RecordFormat from an IBM i File
Can a jt400 RecordFormat object be created just by pointing to a System i db file with a Path?
I can create the RecordFormat and add the Field definitions but I'd like to just say "create a RecordFormat just like that File in that Library"
I did not…
Christopher Smith
- 197
- 1
- 18
1
vote
2 answers
AS400 jt400 get RAM usage
I am just experimenting with the jt400.jar to receive system information from an AS400.
I figured out how to connect and how to receive values by using the class SystemStatus and how to read SystemValues. (only need to find an explanation for those…
LStrike
- 1,598
- 4
- 26
- 58
1
vote
2 answers
AS400 library/file (member) JDBC query
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…
tmtest
- 1,541
- 3
- 15
- 14
1
vote
2 answers
JT400 - Get spool file generated by a command
I am developing a java class with JT400 and trying to get the result of the command “dspmsg qsysopr" with:
AS400 as400 = new AS400(system, user, password);
CommandCall cmd = new CommandCall(as400);
cmd.runCommand("dspmsg qsysopr");
I found out that…
1
vote
5 answers
Get last changed date of AS400 DDS file in Java
Hello I'm working with Java connecting to an IBM AS400.
I want to read the timestamp of the last change of a DDS file, e.g. the timestamp of the last SQL operation (INSERT INTO MyLib/MyDDS VALUES (...)).
In the 5250 terminal, I can go to "work with…
KeKru
- 444
- 3
- 13
1
vote
2 answers
See actual code of function in DB2 for IBM i
Hello guy I create a function in DB2 UDB for AS/400 version 07.01.0000 V7R1m0
I use a windows with dbvisualizer to connect the server.
My function is...
CREATE FUNCTION JVAOBJ.BNOWPAPOL(POL VARCHAR(10)) RETURNS DECIMAL(7,7) LANGUAGE SQL NOT
…
jasilva
- 730
- 3
- 17
- 45
1
vote
1 answer
Need to get Object's creation date and time from AS400 in Java application
I am trying to get information about created date and time for a set of objects in AS400. I have created an outfile using DSPOBJD in AS400. Below is code snippet for getting information about one object. Now, after this i will have to open…
true_programmer
- 43
- 1
- 9
1
vote
2 answers
JT400 - Display content of a SpooledFile
I try to display the content of a SpooledFile with the library jt40.
I use this code :
public static void printJogLog(AS400 as400, Job j) {
SpooledFile spooledFile = new SpooledFile(as400, "QPJOBLOG", 1, j.getName(), j.getUser(),…
YLombardi
- 1,755
- 5
- 24
- 45
1
vote
1 answer
Conflict between JT400 and UCanAccess?
Since I have added to reference libraries ucanaccess-2.0.3.jar (eclipse Luna), I receive this error while executing my program:
Exception in thread "main" java.lang.NoClassDefFoundError: Could not initialize class…
AndreaTaroni86
- 549
- 12
- 27
1
vote
1 answer
AS400 Job's Thread details
I've already been retrieved details of a specific AS/400 job by its job number. I have a problem. I want to get that specific jobs thread detail. Some jobs have multi threading. I need to get specific job's list of multi threads and thread details.…
Dzshean
- 314
- 6
- 23
1
vote
1 answer
IBM as400 spooled file reading
Is there any way to get spooled file data without other details (Page number, End of report line , file details lines)
My Code :
AS400 sys = new AS400();
SpooledFile sf = new SpooledFile( sys, // AS400
…
sheanD
- 191
- 5
- 19
1
vote
2 answers
Can't convert Spooled file data - Java (JT400)
I'm Tried to convert (Read) *SCS Spooled File Using Java (JT400) but when i trying to convert it , i got this error message
"com.ibm.as400.access.AS400Exception: CPF3394 Cannot convert spooled file data."
Anyone know how to fix this ?
…
sheanD
- 191
- 5
- 19
1
vote
1 answer
How Get Spooled File list separately from it's format - Java ( JT400 )
I get Spooled list to java using jt400. but i want to get Advanced Spooled file( *.TIFF image formatted Spooled files) list and normal Spooled (Can read Text) file list separately. Anyone know how to do that ?
Thanks in Advance!
…
sheanD
- 191
- 5
- 19