sequential file with fixed with column view data error
Moderators: chulett, rschirm, roy
sequential file with fixed with column view data error
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.
"
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.
"
If you look at the file in an editor, is it actually fixed width?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
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 inmandyli wrote:When use | delimiter its working fine.
only issue with Fixed width
Code: Select all
tags to preserve any whitespace.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers