DSXchange

Hi all, I am using a fixed width file, which has only one column of length 200. I have some records which have length as 30,some as 45 some as 90 and some as 40. When i run this job, i get the following fatal error : Sequential_File_11,0: Short read encountered on import; this most likely indicates...

ray.wurlod wrote:Have you tried two functions?

Code: Select all

string_trim[" ",begin](string_trim[" ",end](MyString))

...

It does not allow me to combine two commands.

I get the same error as Balaji gets

I need to capture the highest key generated during the execution of a surrogate key generator. It would be nice if somebody can give me a suggestion on this. I have a transformer after the Surrogate key generator.

Thanks in advance,

Ajith

My error. Should have been: NewEmpname: nullable string[max=255]=string_trim[" "](Empname) The default trimmable character is APT_STRING_PADCHAR ... I tried that too, It is trimming only the trailing spaces not the leading ones. I seriously don't know what to do now, I have to do Trimming...

select count(*) from Hol_Tab where hol_ind <>'Y'

or something like that?


It is just a matter of a query anyway

Don't forget the colon. NewEmpname: nullable varchar(255)=string_trim(Empname) When you use "nullable varchar" instead of "nullable string" it gives out an error.Error parsing modify adapter: Error in binding: Could not find type: "varchar" I searched all the threads t...

Transformer_2,0: Parsing parameters "" for schema type "decimal": Expected precision; got: <eof> Parsing parameters "" for schema type "decimal": Expected precision; got: <eof> Parsing parameters "" for schema type "decimal": Expected prec...

:D Both describes the same issue!

Hi ArndW The Unix Server that i am using is HP-UX Although $LD_LIBRARY_PATH is having $DSHOME/lib in both dev and prod files, i am finding another variable $SHLIB_PATH in my dev file. SHLIB_PATH = $LD_LIBRARY_PATH But this variable is missing in production file. I heard that HP-UX needs SHLIB_PATH i...

Thanks ArndW for your quick reply...
I have checked dsenv files in production and enviornment.
In both files $LD_LIBRARY_PATH is having $DSHOME/lib

Hi All I am having some 500 tables in DB2 with considerable amount of data. (Assume all tables have at least 50000 records) I want to migrate the all the tables to SQL server. If we go for data migration project in Datastage parallel edition, we have to create 500 jobs. Do we have any better options...

How to create duplicate rows from input dataset with respect to a condition Hi All, I have a Order start date (ORDER_ST_DT DATE) and an order completion date (ORDER_END_DT DATE). If the difference between start and completion date is greater than 5 then that record has to be duplicated that much tim...

Thx churlett, for your prompt reply. But , here I have a problem . I have to populate them to an oracle table, and the table should contain all the values the xml file contains. So the problem is--- in the shema for this xml <Privilege> <User id= 10 /> <permission> <Action="View" /> <Actio...

Somebody please help me out here .....

We are facing an issue while transforming data from XML file to data base with two columns repetition. Source file has data <Privilege> <User id= 10 /> <permission> <Action="View" /> <Action="Modify" /> </permission> <Area list> <Area ="Area1" /> <Area ="Area2"...