DSXchange

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.
"

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

When use | delimiter its working fine.

only issue with Fixed widtth

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

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

we are using VARCHAR

ALL columns should be CHAR to read fixed width file.

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

Hi


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

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.