DSXchange

Hi,

Thanks for your input.
I have widths and its working fine.

-schema record {record_delim='\n', record_length=fixed, delim=none} ( A:nullable string[1] {width=1}; B:nullable string[15] {width=15}; C:nullable string[2] {width=2}; D:nullable string[8] {width=8}; E:nullable string[8] {width=8}; F:nullable string[5] {width=5}; G:nullable string[13] {width=13}; H:...

schema record {record_delim='\n', record_length=fixed, delim=none} ( A:nullable string[1] {width=1}; B:nullable string[5] {width=5}; C:nullable string[5] {width=5}; D:nullable string[30] {width=2}; E:nullable string[9] {width=1}; F:nullable string[3]; ) The first line of record is below abc 32123ffc...

Error reading on import.
Bad record delimiter after fixed-length record: expected "\n", got " "
Import error at record 0.
The runLocally() of the operator failed.

The Fatal errors im facing

Bad record delimiter Fixed width length "\n" got " " trying to load fixed width file thru sequential file but getting the above error. Im sure the record lenth is correct. I beleive the mode of file transfer is wrong. when i tried to check the file format in unix its showing-Engl...

I have two columns in one table(A1) and another in A2. A1 A2 ------- --------- abc bcd cde ----- ----- --------- csdc ghng 34 dfvfd bfgb wer vcfdcv bgf 65 vdf gfr 567 vg ggrf 575 v yhgr 765

Hi,

can any one suggest me How to View lookup fileset data which is in .fs Format?

Thanks
laknar

Hi,

can any one suggest me the Design of SCD2.

how can i generate Surr Key for Next load.

DB2------------------>Transformation------------->Dataset


Yes String columns are nullable

and Iam Calling from a transform Stage.

vbfjdsbvfd ffdjbd kghjkfdbv vdcv Iam using the below logic if (count of space >=0 ) and (Checking for the last word is alphabetical or not) and (also length of data >2) then we are last word of the data. else if if the above condition is not satisfied then we go second word else if firstword ..... ...

Hi ,

Job Finished without warnings,

But its throwing the below Fatal Error,

Requirements failure: null string argument.

Can any one help me why this error.

Its urgent Plz.

Hi,

When iam trying to log in datastage director I got below message.

Error calling subroutine: DSR_PROJECT (Action=17); check DataStage is setup correctly in project support (Subroutine failed to complete successfully (30107))

Please explain me regarding the error message.

I tried to use make subrecord stage. But iam not able to execute correctly. while executing iam getting the Following error. Sequential_File_8: Error when checking operator: Input "SubRecord_Column" is not a value field. In the Stage i used SubRecord_Column as the OUTPUT: Sub Record Output...

aAbcd gduifghd gdgdfgdf gdfbg jjmjgu ndfn tyjutyj ndvgnghm nvhnvfhn eraydehj ngfn aAbcd ueryutyuty ouiouip rueryury werwetwet nmvnmbv vxczvxcv.... aAbcd ...... I want to consolidate more no of rows into single row by using the Promote subRecord Stage and Make Vector stage. e.g aAbcd gduifghd gdgdfg...

i want to run the more no of sequences at the same time