|
|
|
Forum Newbie
Group: Forum Members
Last Login: 5/15/2009 3:58:26 PM
Posts: 2,
Visits: 3
|
|
Teradata Table structure:
CREATE SET TABLE Table1,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
field1 SMALLINT NOT NULL,
field2 DECIMAL(15,2) NOT NULL,
field3 DECIMAL(15,2) NOT NULL),
UNIQUE PRIMARY INDEX IXCSL1 ( field1 );
Record in Teradata
field1 | field2 | field3
1 | -123456789.31 | 56745111.78
Mainframe file Layout:
01 field2 PIC -(12)9.
01 field3 PIC -(12)9.
Output mainframe file for the Teradata records should look like
field1 | field2
blankspaceblankspace-123456789 | blankspaceblankspaceblankspaceblankspace56745112
I am trying to extract records from Teradata to Mainframe using BTEQ XPORT.
I have used various combinations of cast, format; I can think of. But I am not getting the desired result.
Any help will be appreciated.
|
|
|
|
|
Supreme Being
Group: PAC and SFT Members
Last Login: 9/9/2009 4:34:06 PM
Posts: 407,
Visits: 889
|
|
Use "Teradata style" cast:
field1 (FORMAT '-(12)9') (CHAR(13))
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 5/15/2009 3:58:26 PM
Posts: 2,
Visits: 3
|
|
|
Wowowo.. It worked!!! Thank you so much!!
|
|
|
|