#DateForumTypeThreadPost
1320 Aug 2013 @ 11:08 PDTToolsReplyMload error - 2794 - UPI is an identity columnHi Cheeli, Dups can arise as GEN BY DEFAULT will not generate an identity value if insert row has a value for the IC.  To guarantee uniqueness, specify GENERATED ALWAYS and NO CYCLE.  T...
1219 Aug 2013 @ 12:57 PDTToolsReplyMload error - 2794 - UPI is an identity columnHi Cheeli, What's the IC definition? Thanks! --Ivy.
1114 Aug 2013 @ 05:11 PDTToolsReplyMload through Informatica - errorlimit, errorcode 6705, restore tgt table if auxiliary table dropped in application phaseHi Cheeli, Yes, MultiLoad will termiante if error limit exceeds.  Please check the column definition of the column "abc" in the target table and/or the user default charset set on ...
1009 Jul 2013 @ 10:46 PDTToolsReplyMload - Informatica - cannot insert NULL value into NOT NULL columnHi Cheeli, Can you provide some more details like products' versions, mload scripts(maybe be generated by Informatica in your case), job outputs/logs which conatins the error 'cannot inser...
915 Apr 2013 @ 11:47 PDTToolsReplyTools and UtilitesHi, If you are using MultiLoad, you can take advantage of the "FOR <n>" or "THRU <n>" option in IMPORT command. For example, if there are 3 records in your data fi...
804 Apr 2013 @ 01:00 PDTToolsReplyHow to load Chinese Character in Mainframe(Zos) by using mload?Hi, Here is the explanation of mainframe CLI0543: CLI0543 External security reported a security violation Explanation: The logon request was rejected by the TDP SECLOGON feature. Notes: This er...
721 Mar 2013 @ 02:37 PDTToolsReplyHow to load Chinese Character in Mainframe(Zos) by using mload?Hi, You can try using UTF8 session charset to load your data on mainframe. The way to evoke UTF8 on mainframe is: //MLOAD    EXEC PGM=MLOAD, // PARM='CHARSET=UTF8' //SY...
626 Feb 2013 @ 01:33 PSTToolsReplymload and character setsHi, Can you share which error you got when using MLOAD for your case? If you data file and MLOAD script are in UTF8, you can use "-i utf8 -c  utf8" to MultiLoad the data. Tha...
522 Feb 2013 @ 12:01 PSTToolsReplyError: Error table already exists - Eventhough it was not present in the warehouse.Hi, Which version of MLOAD are you using? And, if possible, can you share your MLOAD script? Thanks! --Ivy.
414 Jan 2013 @ 04:50 PSTToolsReplyMLOAD UPSERTHi, Multiload does not do row redistribution, so the modified rows must stay on the same AMP.  Any operations that cause a row to have to be moved to a different AMP are disallowed. Thanks! ...
308 Jan 2013 @ 03:02 PSTToolsReplyInternal session block while loading thru TPUMP utilityHi kkk, There is no default value for Number os sessions; it must be specified. If you want to load the tables concurrently, and the tables do not share the same primary index, the use of SERILAZ...
227 Dec 2012 @ 11:55 PSTToolsReplyInternal session block while loading thru TPUMP utilityThere could be row hash lock contention between sessions. Please check if SERIALIZEON option is presented in the script. The SERIALIZEON option is useful when a TPump job is targeting multipl...
126 Dec 2012 @ 09:52 PSTToolsReplyInternal session block while loading thru TPUMP utilityHi kkk, Can you please send me your TPump script? I will take a further investigation. Thanks! --Ivy, TPump developer.

Pages