comp.sys.ibm.as400.misc - IBM AS/400 miscellaneous topics.
Hello, Looking ahead a bit. We are thinking of doing our month end/year end on Dec 30th. We have 2 or 3 employees who might work on Sat 12/31, but would like to do their work as of 1/1. I wasn't at this company last year. In the past, they have changed the sysval of QDATE to change the date on their jobs/sessions, instead of using a CHGJOB. I guess it's worked fine in the past, but I think the CHGJOB would be better than CHGSYSVAL?? Obviously, if we CHGSYSVAL, it eliminates the need to do a CHGJOB on each session, it'll be the correct date automatically. Is there any "gotchas" if the CHGSYSVAL is used? Like I said it makes the need for CHGJOB unnecessary, but I wasn't sure if there was anything else that would be affected. When they were done working for the day they would just do a CHGSYSVAL and change the date back to 12/31. George Applegate XXXX@XXXXX.COM
Hi everyone, Has anyone come across a problem where on Linux using DB2 9.1 Express- C with the packaged jcc-JDBC driver that it fails correctly to parse a returned date value? I'm simply calling resultSet.getDate(paramIndex) and it's giving me a date that's way off. The reason that I find this bizarre is that I can see the correct date value being transferred over the wire (localhost) using the Wireshark packet-sniffer; also because it parses timestamp values correctly from the same statement. This is exposed in a unit-test which is run with a classpath that includes the following files: DB2_HOME/java/db2jcc.jar DB2_HOME/java/db2jcc_licence_cu.jar The result-set is returned as a cursor from a stored procedure which reads from a temporary table. The value is read from a column in that table declared as type DATE. I'm sure I'm missing something pretty obvious so I thought I'd ask first before getting to involved in rooting out the problem! Cheers Michael
Hi, Using UDB 8.2 there is a procedure called get_db_config. What I would like to do is to retrieve a certain value from the DB Config in a SQL Statement. To give some more detail, I created a view which will show me my complete bufferpool configuration. However, now with V8.2 I would like to show the value from BUFFPAGE for the size of the bufferpool if the npages in syscat.bufferpools is null. Now how can I do this? I thought on creating a function which would call the get_db_config procecure but I do not know how to then get the result from the procedure in the function to be able to return the result. Anyone any ideas on this? Thanks.
Hi, I am trying to connect to a MS SQL 2000 (or SQL 2005) Server to retreive data from a database table and bring back into the iSeries for processing. This has to be a real time process and not a overnight down load. At the moment I am only interested in read access only. The connection has to be initiated by the iSeries. Thanks David