Loading the schema file
Moderators: chulett, rschirm, roy
Loading the schema file
Hi,
I have a schema file saved as .txt which looks like this.
record
{final_delim=end, delim=',', quote=double}
(
STORE:nullable int32;
SKU:nullable int32;
DEPT:nullable int32;
DATE:nullable string[8];
UNIT_COST:nullable decimal[20,4];
UNIT_RETAIL:nullable decimal[20,4];
PROMOTION:nullable int32;
CLEARANCE:nullable int32;
PROMO_START_DATE:nullable string[8];
PROMO_END_DATE:nullable string[8];
PROMO_PRICE:nullable decimal[20,4];
CLEAR_START_DATE:nullable string[8];
CLEAR_PRICE:nullable decimal[20,4];
CLEAR_END_DATE:nullable string[8];
COST_COMPLEMENT:decimal[15,4];
)
But when i use this in sequential file stage by importing the schema i wont get the actual names.
I am getting the column names like this.
Field001 Varchar(255)
Field002 Varchar(255)
Field003 Varchar(255)
Field004 Varchar(255)..
Any idea why this is happening. Or do i need to change anything in the schema file.
Thanks,
I have a schema file saved as .txt which looks like this.
record
{final_delim=end, delim=',', quote=double}
(
STORE:nullable int32;
SKU:nullable int32;
DEPT:nullable int32;
DATE:nullable string[8];
UNIT_COST:nullable decimal[20,4];
UNIT_RETAIL:nullable decimal[20,4];
PROMOTION:nullable int32;
CLEARANCE:nullable int32;
PROMO_START_DATE:nullable string[8];
PROMO_END_DATE:nullable string[8];
PROMO_PRICE:nullable decimal[20,4];
CLEAR_START_DATE:nullable string[8];
CLEAR_PRICE:nullable decimal[20,4];
CLEAR_END_DATE:nullable string[8];
COST_COMPLEMENT:decimal[15,4];
)
But when i use this in sequential file stage by importing the schema i wont get the actual names.
I am getting the column names like this.
Field001 Varchar(255)
Field002 Varchar(255)
Field003 Varchar(255)
Field004 Varchar(255)..
Any idea why this is happening. Or do i need to change anything in the schema file.
Thanks,
- Jaysheel -
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ray,
This was used to check the use of schema files.
I tried to work on my previous topic and was tryng to use the resolution provided there.
viewtopic.php?t=123729
Never worked on schema files till now.
So asking help.
Thanks,
This was used to check the use of schema files.
I tried to work on my previous topic and was tryng to use the resolution provided there.
viewtopic.php?t=123729
Never worked on schema files till now.
So asking help.
Thanks,
- Jaysheel -