Stack Overflow
Stack Overflow

Questions tagged [jt400]

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.

121 questions
1
vote
1 answer

Sending "ASC" and "QUOTE TYPE C 1252" commands to AS400 FTP server from Java code

When I'm using cmd to put a file into AS400, after connecting with ftp, I went like this: ftp cd /home ftp prompt 1 ftp ASC ftp QUOTE TYPE C 1252 ftp mput * ftp bye Everything is working fine. The file is well encoded. Now, when I'm trying to do…
Nikodev
  • 13
  • 3
1
vote
0 answers

JT400 unable to connect from IBMi machine but working from Windows machine

JT400 - The JDBC connection is working fine when connecting to a IBMi machine from windows machine. DriverManager.registerDriver(new com.ibm.as400.access.AS400JDBCDriver()); String sysname = "xxx.xxx.xx.xxx"; String xref = "IBMISQLLIB"; String url =…
Kishore_2021
  • 645
  • 12
  • 38
1
vote
1 answer

IBM i RPG programs are referencing the wrong library after calling them using a JT400 connection pool

I have a Java application that calls CL programs, which then run several RPG programs on an IBM i system, using the JT400 library. At first, i opened a new connection each time, like this and closed it when done: new AS400(hostname, username,…
Carrier Pigeon Protocol
  • 1,285
  • 1
  • 5
  • 8
1
vote
1 answer

How to Query a date timestamp field with a timestamp string in sql

I am attempting to query an as400 sql database on a date field, with the jt400 npm package. On table t, mydate is a timestamp string that should equal the key, but for some reason it is not working. On a previous query I am getting the value of key.…
Mardok
  • 1,360
  • 10
  • 14
1
vote
0 answers

How to specify a local custom SSL truststore for JTOpen?

We have a java client (mule app) which is using JTOpen for connecting to the AS400 system. The connection is secured with SSL. The driver is using the JRE truststore (jssecacerts, cacerts) by default. We would like to specify a custom truststore…
spoonboy
  • 2,570
  • 5
  • 32
  • 56
1
vote
1 answer

setting jt400 server job library list, jobq and outq from a Job Description instead of the user profile

I have a web application that replaces a 5250 application. I use jt400 for JDBC and other various IBM i services. In the 5250 app, if a user had more than one role or business unit, A separate User Profile was created that referenced the…
Christopher Smith
  • 197
  • 1
  • 18
1
vote
2 answers

Get CPU utilization of all jobs with JT400

I need to get the CPU utilization % of all jobs using JT400. But I can't manage to get a list of jobs at once since loadStatistics() is only available at job level not on the list (more time efficient). With below code snipped I can get the CPU% per…
BioBier
  • 84
  • 1
  • 11
1
vote
2 answers

ibm jt400 get data queue number of entries

I'm using Data Queues in AS400/iSeries and read from one using jdbc jt400 library. As it's a producer(AS400)/consumer(myapp) pattern, I want to check how many entries in the data queue are now, and measure if my app is working fast enough or I need…
Eduardo
  • 33
  • 5
1
vote
2 answers

Avoiding hard coding Schema in DB2/400 Stored Procedure

I'm creating Stored Procedures to replace Legacy app programs for an IBM i. I'm calling the stored procedure from a Java Web App. I'm using the jt400 JDBC driver My JDBC URL is jdbc:as400://myhost/;libraries=*LIBL,MYLIB;prompt=false The stored…
Christopher Smith
  • 197
  • 1
  • 18
1
vote
1 answer

JT400 error CPF3CF1 calling API QtocRtvTCPA in QTOCNETSTS.SRVPGM

I am trying to call the API QtocRtvTCPA in /QSYS.LIB/QTOCNETSTS.SRVPGM in v7r3 via jtOpen/jt400. parameter[3] is defined as ErrorCode in the API https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/apis/qtocrtvtcpa.htm Every attempt I have…
user1838913
  • 103
  • 6
1
vote
1 answer

Is there a Message File that is guaranteed to be on every IBM i OS?

I am trying to write a unit test for reading message files (for node-jt400 which wraps open-jt400 to javascript.) I am wondering if there is a Message File (MSGF) that can be used that is likely to be on any IBM i computer (Say a temporary MSGF that…
Cody Ｇ
  • 8,368
  • 2
  • 35
  • 50
1
vote
1 answer

Calling i-series program from Java yields invalid output

I'm using the jtopen/jt400 toolkit to call programs on an IBM i-series r5v4 (aka AS/400) from Java (actually: JRuby, but I've seen the same problem in pure Java). This works just fine for some programs, while for other programs, the output bytes…
Confusion
  • 16,256
  • 8
  • 46
  • 71
1
vote
1 answer

How to set printing tray / drawer in as400?

I am trying to print a spool file from the IBM AS400 / System I. Creating a spool file and printing works fine. However changing the Source drawer does not seem to any any effect. Printer has 5 trays set up. Tried all numbers from 1 to 5. There's…
Ruslan
  • 1,919
  • 21
  • 42
1
vote
1 answer

JayDeBe: Store a date into an AS400/DB2 (jt400 driver)

I'm trying to enter a date value into a date field of our AS400/DB2 via JayDeBe. When I try with a literal SQL value everything works fine curs.execute(''' UPDATE mytable SET city = ?, mydate = date(to_date('1999-05-03',…
Volker Böhm
  • 21
  • 5
1
vote
2 answers

JDBC statement pooling with DB2 does not have significant time difference

I'm using JDBC db2 driver, a.k.a. JT400 to connect to db2 server on Application System/400, a midrange computer system. My goal is to insert into three Tables, from outside of IBM mainframe, which would be cloud instance(eg. Amazon WS). To make the…
prayagupa
  • 30,204
  • 14
  • 155
  • 192
1 2
3
…
8 9