sequential file with fixed with column view data error

mandyli · Post by **mandyli** » Thu Aug 05, 2010 9:00 am

Hi

I want to generate a sequential file with fixed with column,but when I want to see the record in the datastage using view data I am getting the following print screen error.I am giving 0x20 value in $APT_STRING_PADCHAR. when I ran the job it works fne.

"
It has 1 operator:
op0[1p] {(sequential APT_CombinedOperatorController:
(Sq_Sears_Transaction_Tender)
(_EowGenerator)
(_Head)
(_PEEK_IDENT_)
(_ABORT_IDENT_)
) on nodes (
Compute1[op0,p0]
)}
It runs 1 process on 1 node.
##W IIS-DSEE-TFIG-00169 10:58:44(000) <Sq_Sears_Transaction_Tender,0> Short input record
##W IIS-DSEE-TOIX-00154 10:58:44(001) <Sq_Sears_Transaction_Tender,0> Import warning at record 0.
##W IIS-DSEE-TOIX-00018 10:58:44(002) <Sq_Sears_Transaction_Tender,0> Import unsuccessful at record 0.
##W IIS-DSEE-TFIG-00169 10:58:44(003) <Sq_Sears_Transaction_Tender,0> Short input record
##W IIS-DSEE-TOIX-00154 10:58:44(004) <Sq_Sears_Transaction_Tender,0> Import warning at record 1.
##W IIS-DSEE-TOIX-00018 10:58:44(005) <Sq_Sears_Transaction_Tender,0> Import unsuccessful at record 1.
##W IIS-DSEE-TFIG-00169 10:58:44(006) <Sq_Sears_Transaction_Tender,0> Short input record
##W IIS-DSEE-TOIX-00154 10:58:44(007) <Sq_Sears_Transaction_Tender,0> Import warning at record 2.
##W IIS-DSEE-TOIX-00018 10:58:44(008) <Sq_Sears_Transaction_Tender,0> Import unsuccessful at record 2.
##W IIS-DSEE-TFIG-00169 10:58:44(009) <Sq_Sears_Transaction_Tender,0> Short input record
##W IIS-DSEE-TOIX-00154 10:58:44(010) <Sq_Sears_Transaction_Tender,0> Import warning at record 3.
##W IIS-DSEE-TOIX-00018 10:58:44(011) <Sq_Sears_Transaction_Tender,0> Import unsuccessful at record 3.
##W IIS-DSEE-TFIG-00169 10:58:44(012) <Sq_Sears_Transaction_Tender,0> Short input record
##W IIS-DSEE-TOIX-00154 10:58:44(013) <Sq_Sears_Transaction_Tender,0> Import warning at record 4.
##W IIS-DSEE-TOIX-00018 10:58:44(014) <Sq_Sears_Transaction_Tender,0> Import unsuccessful at record 4.
##I IIS-DSEE-TOIX-00193 10:58:44(015) <Sq_Sears_Transaction_Tender,0> No further reports will be generated from this partition until a successful import.
##I IIS-DSEE-TOIX-00163 10:58:44(016) <Sq_Sears_Transaction_Tender,0> Import complete; 0 records imported successfully, 100 rejected.
##I IIS-DSEE-TFOR-00094 10:58:44(017) <Sq_Sears_Transaction_Tender,0> Output 0 produced 0 records.
##I IIS-DSEE-TFOR-00163 10:58:44(018) <_EowGenerator,0> Input 0 consumed 0 records.
##I IIS-DSEE-TFOR-00094 10:58:44(019) <_EowGenerator,0> Output 0 produced 0 records.
##I IIS-DSEE-TFOR-00163 10:58:44(020) <_Head,0> Input 0 consumed 0 records.
##I IIS-DSEE-TFOR-00094 10:58:44(021) <_Head,0> Output 0 produced 0 records.
##I IIS-DSEE-TFOR-00163 10:58:44(022) <_PEEK_IDENT_,0> Input 0 consumed 0 records.
##I IIS-DSEE-TFOR-00094 10:58:44(023) <_PEEK_IDENT_,0> Output 0 produced 0 records.
**VIEWDATA ROW LIMITER HIT**
>##E IIS-DSEE-TFOR-00089 10:58:44(024) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
"

chulett · Post by **chulett** » Thu Aug 05, 2010 9:16 am

What does your actual file look like? Can you post a small number of rows from it?

mandyli · Post by **mandyli** » Thu Aug 05, 2010 9:23 am

When use | delimiter its working fine.

only issue with Fixed widtth

ArndW · Post by **ArndW** » Thu Aug 05, 2010 9:43 am

If you look at the file in an editor, is it actually fixed width?

vinothkumar · Post by **vinothkumar** » Thu Aug 05, 2010 9:45 am

What are the datatypes you are using in your metadata. If VARCHAR is there change as CHAR.

mandyli · Post by **mandyli** » Thu Aug 05, 2010 10:07 am

we are using VARCHAR

keshav0307 · Post by **keshav0307** » Thu Aug 05, 2010 7:07 pm

ALL columns should be CHAR to read fixed width file.

chulett · Post by **chulett** » Thu Aug 05, 2010 7:28 pm

mandyli wrote:When use | delimiter its working fine.

only issue with Fixed width

If it has delimiters, then it's not really a "fixed width" file. Stick with a delimited read. If you really want more help with this, post some sample records as requested so we can see exactly what it is you are dealing with. Wrap them in

Code: Select all

 tags to preserve any whitespace.

mandyli · Post by **mandyli** » Fri Aug 06, 2010 2:58 pm

Hi

Thanks for your reply. I not reading from file . I am writing into fixed width file.

chulett · Post by **chulett** » Fri Aug 06, 2010 5:41 pm

OK, sorry, not sure where I got the impression you were reading one. Unless there's a setting that overrides this, as previously noted you can't create a "fixed width" file from variable character fields - use CHAR instead. And let us know all of the settings you are using in your target Sequential file stage.