|
Ok what I want to do is this I have a file "FILEA" with following format. I want to read FILEA and write the whole record from FILEA in one field of FILEB. Is it possible to compress the FILEA data before writing to FILEB? FileA Format Fields Length COHDRR 87 579 FileB Format Fields Length COHDRR 1 variable length -----Original Message----- From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of java400-l-request@xxxxxxxxxxxx Sent: Wednesday, January 14, 2004 10:37 AM To: java400-l@xxxxxxxxxxxx Subject: JAVA400-L Digest, Vol 2, Issue 10 Send JAVA400-L mailing list submissions to java400-l@xxxxxxxxxxxx To subscribe or unsubscribe via the World Wide Web, visit http://lists.midrange.com/mailman/listinfo/java400-l or, via email, send a message with subject or body 'help' to java400-l-request@xxxxxxxxxxxx You can reach the person managing the list at java400-l-owner@xxxxxxxxxxxx When replying, please edit your Subject line so it is more specific than "Re: Contents of JAVA400-L digest..." Today's Topics: 1. Is it possible to compress a record using Java / RPGLE (Tanveer, Mohammad) 2. Re: Is it possible to compress a record using Java / RPGLE (Mike Silvers) 3. com.ibm.db2.jdbc.app.DB2JDBCException: Function sequence error (Ashish Kulkarni) 4. RE: com.ibm.db2.jdbc.app.DB2JDBCException: Function sequence error (Gary L Peskin) 5. RE: com.ibm.db2.jdbc.app.DB2JDBCException: Function sequence error (Ashish Kulkarni) 6. Re: LOB fields (James H H Lampert) 7. RE: LOB fields (Colin Williams) 8. Unknown SQL connect error (leischj@xxxxxxxxxxxxxxxx) 9. RE: Unknown SQL connect error (Colin Williams) 10. updatable ResultSets (Glenn Holmer) ---------------------------------------------------------------------- message: 1 date: Tue, 13 Jan 2004 12:24:38 -0600 from: "Tanveer, Mohammad" <mtanveer@xxxxxxxxxxxxxxxxxx> subject: Is it possible to compress a record using Java / RPGLE Is there a way to compress/uncompress a record using ZIP utilities of Java or any other OS/400 API and save it in a variable length field? I have tried java GZIPOutputStream but it seems like its not zipping it. Thanks in advance ------------------------------ message: 2 date: Tue, 13 Jan 2004 13:27:52 -0500 from: "Mike Silvers" <msilvers@xxxxxxxxxxx> subject: Re: Is it possible to compress a record using Java / RPGLE It sounds like you are trying to save an IFS object (the zip file) to the DB2 database in a character field. These two structures store information on the AS400 in different ways. You should save the zip file on the IFS, then save the path to the zip file in the variable length field if you need a reference to the location of the zip file. ----- Original Message ----- From: "Tanveer, Mohammad" <mtanveer@xxxxxxxxxxxxxxxxxx> To: <java400-l@xxxxxxxxxxxx> Sent: Tuesday, January 13, 2004 1:24 PM Subject: Is it possible to compress a record using Java / RPGLE > Is there a way to compress/uncompress a record using ZIP utilities of Java > or any other OS/400 API and save it in a variable length field? I have > tried java GZIPOutputStream but it seems like its not zipping it. > > Thanks in advance > > > > _______________________________________________ > This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list > To post a message email: JAVA400-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/java400-l > or email: JAVA400-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/java400-l. > > ------------------------------ message: 3 date: Tue, 13 Jan 2004 10:44:33 -0800 (PST) from: Ashish Kulkarni <kulkarni_ash1312@xxxxxxxxx> subject: com.ibm.db2.jdbc.app.DB2JDBCException: Function sequence error Hi I am getting following error when i try to create a prepareStatement or callableStatement using native driver from JTopen, AS400 system V5R2 full error description This was working 2 days ago, and no updates done on system any suggestions com.ibm.db2.jdbc.app.DB2JDBCException: Function sequence error. at java/lang/Throwable.<init>(Throwable.java:195) at java/lang/Exception.<init>(Exception.java:41) at java/sql/SQLException.<init>(SQLException.java:40) at com/ibm/db2/jdbc/app/DB2Exception.<init>(DB2Exception.java:49) at com/ibm/db2/jdbc/app/DB2Connection.prepareCall(DB2Connection.java:2440) at com/ibm/db2/jdbc/app/DB2Connection.prepareCall(DB2Connection.java:2378) at com/ibm/db2/jdbc/app/DB2Connection.prepareCall(DB2Connection.java:2335) at com/pfizer/maps/data/purchase/POData.getChangeData(POData.java:106) at com/pfizer/maps/data/CreatePdfForPO.generatePDF(CreatePdfForPO.java:156) at com/pfizer/maps/data/PORPGToJava.createPDF(PORPGToJava.java:67) at com/pfizer/maps/data/PORPGToJava.pdfOnly(PORPGToJava.java:177) ===== A$HI$H __________________________________ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus ------------------------------ message: 4 date: Tue, 13 Jan 2004 11:01:24 -0800 from: "Gary L Peskin" <garyp@xxxxxxxxxxxx> subject: RE: com.ibm.db2.jdbc.app.DB2JDBCException: Function sequence error Your connection is most likely closed or has too many open statements. Try calling isClosed() on the connection before prepareCall and see what it returns. Gary > -----Original Message----- > From: java400-l-bounces@xxxxxxxxxxxx > [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Ashish Kulkarni > Sent: Tuesday, January 13, 2004 10:45 AM > To: java400-l@xxxxxxxxxxxx > Subject: com.ibm.db2.jdbc.app.DB2JDBCException: Function > sequence error > > > Hi > I am getting following error when i try to create a > prepareStatement or callableStatement using native driver > from JTopen, > AS400 system V5R2 > full error description > This was working 2 days ago, and no updates done on > system > any suggestions > com.ibm.db2.jdbc.app.DB2JDBCException: Function > sequence error. > at java/lang/Throwable.<init>(Throwable.java:195) > > at java/lang/Exception.<init>(Exception.java:41) > > at java/sql/SQLException.<init>(SQLException.java:40) > > at > com/ibm/db2/jdbc/app/DB2Exception.<init>(DB2Exception.java:49) > > at > com/ibm/db2/jdbc/app/DB2Connection.prepareCall(DB2Connection.j > ava:2440) > > at > com/ibm/db2/jdbc/app/DB2Connection.prepareCall(DB2Connection.j > ava:2378) > > at > com/ibm/db2/jdbc/app/DB2Connection.prepareCall(DB2Connection.j > ava:2335) > > at > com/pfizer/maps/data/purchase/POData.getChangeData(POData.java:106) > > at > com/pfizer/maps/data/CreatePdfForPO.generatePDF(CreatePdfForPO > .java:156) > > at > com/pfizer/maps/data/PORPGToJava.createPDF(PORPGToJava.java:67) > > at > com/pfizer/maps/data/PORPGToJava.pdfOnly(PORPGToJava.java:177) > > > > ===== > A$HI$H > > __________________________________ > Do you Yahoo!? > Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes > http://hotjobs.sweepstakes.yahoo.com/signin> gbonus > > _______________________________________________ > This > is the Java Programming on and around the iSeries / AS400 > (JAVA400-L) mailing list To post a message email: > JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change > list options, > visit: http://lists.midrange.com/mailman/listinfo/java400-l > or email: JAVA400-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/java400-l. > ------------------------------ message: 5 date: Tue, 13 Jan 2004 11:43:58 -0800 (PST) from: Ashish Kulkarni <kulkarni_ash1312@xxxxxxxxx> subject: RE: com.ibm.db2.jdbc.app.DB2JDBCException: Function sequence error Hi thanx , some where in program the connection was getting closed, thanx i got it working Ashish --- Gary L Peskin <garyp@xxxxxxxxxxxx> wrote: > Your connection is most likely closed or has too > many open statements. Try > calling isClosed() on the connection before > prepareCall and see what it > returns. > > Gary > > > -----Original Message----- > > From: java400-l-bounces@xxxxxxxxxxxx > > [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf > Of Ashish Kulkarni > > Sent: Tuesday, January 13, 2004 10:45 AM > > To: java400-l@xxxxxxxxxxxx > > Subject: com.ibm.db2.jdbc.app.DB2JDBCException: > Function > > sequence error > > > > > > Hi > > I am getting following error when i try to create > a > > prepareStatement or callableStatement using native > driver > > from JTopen, > > AS400 system V5R2 > > full error description > > This was working 2 days ago, and no updates done > on > > system > > any suggestions > > com.ibm.db2.jdbc.app.DB2JDBCException: Function > > sequence error. > > at java/lang/Throwable.<init>(Throwable.java:195) > > > > > at java/lang/Exception.<init>(Exception.java:41) > > > > > at > java/sql/SQLException.<init>(SQLException.java:40) > > > > at > > > com/ibm/db2/jdbc/app/DB2Exception.<init>(DB2Exception.java:49) > > > > at > > > com/ibm/db2/jdbc/app/DB2Connection.prepareCall(DB2Connection.j > > ava:2440) > > > > at > > > com/ibm/db2/jdbc/app/DB2Connection.prepareCall(DB2Connection.j > > ava:2378) > > > > at > > > com/ibm/db2/jdbc/app/DB2Connection.prepareCall(DB2Connection.j > > ava:2335) > > > > at > > > com/pfizer/maps/data/purchase/POData.getChangeData(POData.java:106) > > > > at > > > com/pfizer/maps/data/CreatePdfForPO.generatePDF(CreatePdfForPO > > .java:156) > > > > at > > > com/pfizer/maps/data/PORPGToJava.createPDF(PORPGToJava.java:67) > > > > at > > > com/pfizer/maps/data/PORPGToJava.pdfOnly(PORPGToJava.java:177) > > > > > > > > ===== > > A$HI$H > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! Hotjobs: Enter the "Signing Bonus" > Sweepstakes > > http://hotjobs.sweepstakes.yahoo.com/signin> > gbonus > > > > _______________________________________________ > > This > > is the Java Programming on and around the iSeries > / AS400 > > (JAVA400-L) mailing list To post a message email: > > JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, > or change > > list options, > > visit: > http://lists.midrange.com/mailman/listinfo/java400-l > > or email: JAVA400-L-request@xxxxxxxxxxxx > > Before posting, please take a moment to review the > archives > > at http://archive.midrange.com/java400-l. > > > > _______________________________________________ > This is the Java Programming on and around the > iSeries / AS400 (JAVA400-L) mailing list > To post a message email: JAVA400-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: > http://lists.midrange.com/mailman/listinfo/java400-l > or email: JAVA400-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the > archives > at http://archive.midrange.com/java400-l. > __________________________________ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus ------------------------------ message: 6 date: Tue, 13 Jan 2004 14:24:16 -0800 (PST) from: "James H H Lampert" <jamesl@xxxxxxxxxxx> subject: Re: LOB fields Colin Williams said: . . . > If you use the LOB facilities available in the database, the system can > create links to the IFS object, and can also protect the object so that it > can only be accessed using the database reference, really depends on what > your trying to acheive, and how sophisticated you want the app to be . . . Yes, the field in question is a CLOB field. I managed to populate it in my test file from SQuirreL (a rather interesting Java SQL client that can talk to the AS/400, to keep this marginally on-topic), and the value comes up in SQuirreL, the way I typed it in, but if I then look at it using an experimental version of QuestView that can open files with LOB fields, all I find in my CLOB is a bunch of hex zeroes, followed by "*POINTER," followed by some EBCDIC spaces. Nothing to indicate where the CLOB content is. Does anybody here know where to look? -- JHHL ------------------------------ message: 7 date: Wed, 14 Jan 2004 08:37:03 -0000 from: Colin Williams <colin.williams@xxxxxxxxxxxx> subject: RE: LOB fields James, There is a redbook that explains how this LOB stuff works http://www.redbooks.ibm.com/redbooks/SG245409.html Cheers Colin.W -----Original Message----- From: James H H Lampert [mailto:jamesl@xxxxxxxxxxx] Sent: 13 January 2004 22:24 To: java400-l@xxxxxxxxxxxx Subject: Re: LOB fields Colin Williams said: . . . > If you use the LOB facilities available in the database, the system > can create links to the IFS object, and can also protect the object so > that it can only be accessed using the database reference, really > depends on what your trying to acheive, and how sophisticated you want > the app to be . . . Yes, the field in question is a CLOB field. I managed to populate it in my test file from SQuirreL (a rather interesting Java SQL client that can talk to the AS/400, to keep this marginally on-topic), and the value comes up in SQuirreL, the way I typed it in, but if I then look at it using an experimental version of QuestView that can open files with LOB fields, all I find in my CLOB is a bunch of hex zeroes, followed by "*POINTER," followed by some EBCDIC spaces. Nothing to indicate where the CLOB content is. Does anybody here know where to look? -- JHHL _______________________________________________ This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/java400-l or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l. For the latest on Bertram Books products and services and for up-to-the-minute book news visit www.bertrams.com This e-mail and any attachments may contain information that is confidential and privileged and is solely for the use of the intended recipient. If you are not the intended recipient please notify the sender and delete this e-mail and any attachments immediately ------------------------------ message: 8 date: Wed, 14 Jan 2004 09:17:28 -0600 from: leischj@xxxxxxxxxxxxxxxx subject: Unknown SQL connect error Hello. I am encountering a problem while trying to connect to a database using JDBC. I believe it's happening on the the getConnection call, but it may also be on the DriverManager.registerDriver call. If the *DATABASE server is not running, I get this message: The application requester cannot establish the connection. (Connection refused: connect). I'm seeing a slightly different message, and I don't know what the cause is. Everything we've checked on this particular system seems to be OK. The message is this: The application requester cannot establish the connection. (Not able to pass connection to server job. Unknown or unrecoverable error occured.) Does anybody have experience with this particular SQL error or have any ideas about why this would happen? Thanks! Jason Leisch ------------------------------ message: 9 date: Wed, 14 Jan 2004 15:23:56 -0000 from: Colin Williams <colin.williams@xxxxxxxxxxxx> subject: RE: Unknown SQL connect error Sounds like a network problem of some kind Cheers Colin.W -----Original Message----- From: leischj@xxxxxxxxxxxxxxxx [mailto:leischj@xxxxxxxxxxxxxxxx] Sent: 14 January 2004 15:17 To: java400-l@xxxxxxxxxxxx Subject: Unknown SQL connect error Hello. I am encountering a problem while trying to connect to a database using JDBC. I believe it's happening on the the getConnection call, but it may also be on the DriverManager.registerDriver call. If the *DATABASE server is not running, I get this message: The application requester cannot establish the connection. (Connection refused: connect). I'm seeing a slightly different message, and I don't know what the cause is. Everything we've checked on this particular system seems to be OK. The message is this: The application requester cannot establish the connection. (Not able to pass connection to server job. Unknown or unrecoverable error occured.) Does anybody have experience with this particular SQL error or have any ideas about why this would happen? Thanks! Jason Leisch _______________________________________________ This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/java400-l or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l. For the latest on Bertram Books products and services and for up-to-the-minute book news visit www.bertrams.com This e-mail and any attachments may contain information that is confidential and privileged and is solely for the use of the intended recipient. If you are not the intended recipient please notify the sender and delete this e-mail and any attachments immediately ------------------------------ message: 10 date: Wed, 14 Jan 2004 10:36:49 -0600 from: Glenn Holmer <gholmer@xxxxxxxxxxxxxx> subject: updatable ResultSets This question is about code that runs on an AS/400 in a program that acts as an RMI server. The method is not synchronized. With this code: stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); sqlStmt = "SELECT WIPNO, LOWEST, HIGHEST " + "FROM WMSLIB.SERIALNO " + "WHERE WIPNO = '" + wipNo + "' FOR UPDATE"; rs = stmt.executeQuery(sqlStmt); am I guaranteed (by using "FOR UPDATE") that the record I read will be locked until it is either written back or the result set is closed? If not, how can I achieve this? -- ____________________________________________________________ Glenn Holmer gholmer@xxxxxxxxxxxxxx Programmer/Analyst phone: 414.908.1809 Weyco Group, Inc. fax: 414.908.1601 ------------------------------ _______________________________________________ This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) digest list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/java400-l or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l. End of JAVA400-L Digest, Vol 2, Issue 10 ****************************************
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
