ContributionsMost RecentMost LikesSolutionsRe: org.joda.time.LocalDateTime error for DB2 Insert Generic JDBC snaps Re: org.joda.time.LocalDateTime error for DB2 Insert bojanvelevski: Date.parse(‘2022-03-17 05:10:10’,‘yyyy-MM-dd HH:mm:ss’).toLocaleDateTimeString({‘format’:‘yyyy/MM/dd HH:mm:ss’}) Thank you, bojanvelenski. Is there any snap for DB2 bulkupload which is similar to MySQL when migrating the data from DB2 MySQL , i have used Bulkload snap and it mapped the columns automatically. when I am doing the revese sync mapping , I dont see the Bulk load snap for DB2 …and compain about th other columns which are are part of the table definition present in the Mapper. is there any snap which is equivalent to MySQL bulk upload for DB2. org.joda.time.LocalDateTime error for DB2 Insert Hi, I had an issue with DateTime conversion issues Insert records when migrating data from MySQL to DB2. MYSQL dateformat : 2022-03-17 05:10:10 DB2 timeformat 2022/03/17 05:10:10 I am getting the following error Failure: SQL operation failed, Reason: Type class org.joda.time.LocalDateTime is not supported in dialect DB2, Resolution: Please check for valid Snap properties and input data. could some one let me know what is transofrmation I need to do for MySQL to DB2. from DB2 to MySQL i used substring to parse and concatenate and the same is not working from MySQL to DB2. Thank you, sandy. How to log the rejected records while migrating the data Hi , We have migrated the data from DB2 to MySQL AWS cloud. For 1 table there were duplicaate records in DB2 as there were no primary keys or index keys deifned. But we have set composite keys in cloud DB. While migrating the duplicate records were not migrated. Is there a way to capture/log the rejected records while data migration. Thank you Re: Bidirectional data sync (Two way data Sync between the databases) Thank you … Bidirectional data sync (Two way data Sync between the databases) Hi , we are migrating applications from DB2 to Azure SQL. I have a situation where I need to sync tables data in both ways DB2 to Azure SQL and AZure SQL to DB2. The tables doesnt have any timestamp fields (created or updated). Is there anyway we could achieve the delta changes thru SNAP logic tool ( especially with UPDATE, DELETE’s ) Re: TRIM spaces for DB2 select Wow…Thank you, bojanvelevski. The expression that you have suggested is working… . TRIM spaces for DB2 select Hi, we are migrating DB2 tables into AWS Aurora MySQL database. I am using Generic JDBC select SNAP to select the data from the DB2 database .we had an issue with data migration for the DB2 char fields . The Char fields selected from DB2 has the trailing spaces, which are getting inserted into MySQL. Is there anyway we could trim the trailing space of all the fields without individually specifying it in MAPPER SNAP to TRIM the spaces. we have around 40 tables and some of the tables has more than 20 fields … Some of the tables Primary key fields are Char data type and is required to trim… Please let me know if there is any solution or the specific settings in the SNAP to trim the selected data in simpler way Is there a way to update the Mainframe IMS tables using Snaplogic Hi , I had a requirement where we have to migrate the data from AWSCloud RDS (MySQL) to Mainframe IMS tables. Can we do it using with snaplogic to interact with IMS tables.