#DateForumTypeThreadPost
901 Jun 2016 @ 07:29 PDTToolsReplyStrange production scenariosorry about the data alignment .    SRC_SYS_ACCT_NB EFF_DT 5/31/2016 5/31/2016...
801 Jun 2016 @ 07:26 PDTToolsTopicStrange production scenarioHi ,    We have encountered a strange data issue in Prod. We are trying to load a history table using BTEQ.  The history table has  PRIMARY INDEX( ACCT_NB ) UNIQUE IN...
702 Dec 2015 @ 12:20 PSTDatabaseTopichow is my job handling spaces in SMALLINT??? There is a mainframe MLOAD job , the source file has spaces for a 'prd_cd' value . when i query the table i am not seeing spaces for prd_cd they are all '0'. There is no default val...
603 Feb 2015 @ 10:09 PSTToolsTopicFAST LOAD Failing in mainframe jobHi,   I am trying to load a CSV file to a teradata table using FLOAD. I did an FTP of the file from my desktop to the mainframe server. The values in the file are comma separated. The Fload ...
505 Dec 2013 @ 02:35 PSTToolsTopicFLoad , trying to load spaces to decimali have a mainframe file that has spaces in the last column , these spaces needs to be loaded to the teradata table decimal column Decimal(15,6). The mainframe job uses Fload , the fload is failing ...
421 May 2013 @ 12:39 PDTToolsTopicFind record position for FastloadIncase of  fastload error I am facing difficulty in getting exact line number (record number) in a large file of more than 1 million records .   The ERR1 table is showing the column nam...
318 Feb 2013 @ 12:38 PSTDatabaseReplycasting 6 digit integer to dateThanks Rajeev and Deiter it works. We changed the script in production.
214 Feb 2013 @ 03:58 PSTDatabaseTopiccasting 6 digit integer to dateThis is a situation i'm facing in production. one batch job has failed in the following query     /*************************************************************/  &...
130 Jul 2012 @ 02:13 PDTDatabaseReplySize of partitions and PPI performance Hi,   Need help with partitions. Will the data in the NORANGE partitions automatically be moved to a new Partition that is created with an Alter table command ?    ...