| # | Date | Forum | Type | Thread | Post |
|---|
| 9 | 01 Jun 2016 @ 07:29 PDT | Tools | Reply | Strange production scenario | sorry about the data alignment .
SRC_SYS_ACCT_NB
EFF_DT
5/31/2016
5/31/2016... |
| 8 | 01 Jun 2016 @ 07:26 PDT | Tools | Topic | Strange production scenario | Hi ,
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... |
| 7 | 02 Dec 2015 @ 12:20 PST | Database | Topic | how 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... |
| 6 | 03 Feb 2015 @ 10:09 PST | Tools | Topic | FAST LOAD Failing in mainframe job | Hi,
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 ... |
| 5 | 05 Dec 2013 @ 02:35 PST | Tools | Topic | FLoad , trying to load spaces to decimal | i 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 ... |
| 4 | 21 May 2013 @ 12:39 PDT | Tools | Topic | Find record position for Fastload | Incase 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... |
| 3 | 18 Feb 2013 @ 12:38 PST | Database | Reply | casting 6 digit integer to date | Thanks Rajeev and Deiter it works. We changed the script in production.
|
| 2 | 14 Feb 2013 @ 03:58 PST | Database | Topic | casting 6 digit integer to date | This is a situation i'm facing in production. one batch job has failed in the following query
/*************************************************************/
&... |
| 1 | 30 Jul 2012 @ 02:13 PDT | Database | Reply | Size 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 ?
... |
|
|