Fixed width columns (Non Delimited file)
Moderators: chulett, rschirm, roy
Fixed width columns (Non Delimited file)
Hi All,
I'm trying to read data from the fixed width file via the FTP stage,
I'm getting the following error: Internal Error function 'utf_to_row()' failed
I defined all the column types as char and Not Nullable as required.
Also the column lengths are included correctly.
NOTE: reading a delimited file via FTP causes no problems.
Please suggest me the solution for this.
Thanks in Advance
NHV
I'm trying to read data from the fixed width file via the FTP stage,
I'm getting the following error: Internal Error function 'utf_to_row()' failed
I defined all the column types as char and Not Nullable as required.
Also the column lengths are included correctly.
NOTE: reading a delimited file via FTP causes no problems.
Please suggest me the solution for this.
Thanks in Advance
NHV
Hi And Welcome Aboard ,
Searching this forum will get you lots of posts with great info.
What Os you use?
What exact DS version?
What is the OS of the system you try to ftp from?
What happens when you try to process this file after you manually ftped it to your DS server?
Searching this forum will get you lots of posts with great info.
What Os you use?
What exact DS version?
What is the OS of the system you try to ftp from?
What happens when you try to process this file after you manually ftped it to your DS server?
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Re: Fixed width columns (Non Delimited file)
As a guess, I would say - no, you didn't.nhv wrote:Also the column lengths are included correctly.
All it takes is one wrong one to hork the whole thing up. The other tidbit - assuming it works the same as the Sequential File stage - is it uses the information in the Display Size column - not the Size size column to drive itself.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Hi,
What Os you use - Unix
What exact DS version - 7.5
What is the OS of the system you try to ftp from - Unix
What happens when you try to process this file after you manually ftped it to your DS server- It works fine.
I used these manually ftped files in seq stage and it works perfect
Regards,
Nirav
What Os you use - Unix
What exact DS version - 7.5
What is the OS of the system you try to ftp from - Unix
What happens when you try to process this file after you manually ftped it to your DS server- It works fine.
I used these manually ftped files in seq stage and it works perfect
Regards,
Nirav
Re: Fixed width columns (Non Delimited file)
Hi Craig,
Yes, I have mentioned the correct lengths under Display Size.
Regards.
nhv
Yes, I have mentioned the correct lengths under Display Size.
Regards.
nhv
-
- Participant
- Posts: 60
- Joined: Sat Jan 24, 2004 12:52 pm
- Location: Mount Carmel, IL
Hai nhv,
In the output properties
check against metadata --- yes
line termination --- [CR][LF] (DOS Style Termination)
Fixed width column --- yes
space between columns --- 0
All the other properties are to be default
In the ouput column give the length of the row (fixed width)
you can also check, if the file contains ^m in the end of line
Sri
In the output properties
check against metadata --- yes
line termination --- [CR][LF] (DOS Style Termination)
Fixed width column --- yes
space between columns --- 0
All the other properties are to be default
In the ouput column give the length of the row (fixed width)
you can also check, if the file contains ^m in the end of line
Sri