Search results for query: *

Is it possible to update a DB2 table on the mainframe from MS Access? The data source will be coming from Sybase and the eventual target is DB2. Is it possible to use Access to create the same table structures, connect to sybase and populate the data and then connect to db2 to populate with...

We are converting data from Sybase running on Sun Solaris box to DB2 running on the mainframe. Is it possible to use MS Access to create the mainframe DB2 table structure, connect to Sybase and populate the tables. Then connect to the mainframe DB2 database and populate those tables from the...

We are converting from a Sybase database to DB2 and I am working to create extract files of the data to load to DB2. All tables with only column definitions from the source and target loaded fine. There are other tables where the first column is defined as char and the last column is defined...

Thank you for your help!

I dumped with the command dump transaction master with no_log

When executing a script to update our database, the sql is being suspended due to the transaction log on master being full. Once I dump the log on master, not the database I am updating, our queries work fine. The master database has no options set and I cannot add any to master however the...

Is it possible to cast a String to an Integer? I initially defined a variable as an int but received a CastClassException error when trying to sort the object. If I define the element of the class as String, I do not receive the error however the values are not sorted as I expect (i.e...

Below is the compareTo method from my BondSummary class. I had to change the definition of my variable yearsToMature to Integer from int due to an error I was receiving. public int compareTo(java.lang.Object obj) { BondSummary bsummary = (BondSummary)obj; return...

I have retrieved a resultset from the database in order of id number and years to mature, which is a calculated field. As I go through this resultset, I summarize data based on the order retrieved and add each unique element to an object class. Prior to printing the data, I want to now sort...

Thank you! This worked great. If possible, will you please explain what the if syntax is saying? If the second column is not (unsure at this point) then execute the gsub command. Thank you again.

We are processing a file using the gsub function to do a substitution of a column, removing special characters and replacing them with a null ("") value. I need to modify this script to also replace a space found in the 2nd column with the null value. The problem: if the column...