Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Case Sensitivity Issue
Thanks BrianTyler, The first seems to b the best option. Unfortunately we are working on an iSeries box (AS/400 v5r2) I am more familiar doing something like this in Oracle on UNIX. We also need to add a field to a table to be populated via trigger entering date/time in julian date format... -
Data Access between DB2 databases
Hi I would like to know how I could go about pulling data from a DB2 database on our one AS/400 box to another DB2 database on another box - via the LAN - something akin to ODBC calls from Windows. Thanks -
Case Sensitivity Issue
Hi there The Applications we use (web-based) allow the users to enter data into tables that are a combination of upper and lower case. This causes a problem when you have to start searching for data as it is case sensitive. To mod all the application to convert the text to upper case before...
