DSXchange

Hi All Iam Using STP stage to update the table. Iam doing select from the table and collect the data in a cursor and passing the cursor as input to the next procedure in if condition to update the table. My job is executing successfully for both data found and no data found cases. But I want the job...

Hi my error is main_program: Error parsing modify adapter: Error in binding: Error in destination field selector: Expected integer, got: ":" Expected destination field selector, got: ")"; input: WORK_DATE [:date] = date_from_string(workdate)[%yy-%mm-%dd] ; same for timestamp also...

Hi
Iam also getting the same error,
i tried all the ways -no use
sri

In unix file i can see the output, but in datastage its showing error
Thanks
sri

Hai sri
Use in this , it works for me
Field(inputstring, "@", DCount(inputstring,"@" ), 1)

Sri

Hi All iam trying to read the sequential file iam getting following error /detld2/etl/ascential/Ascential/DataStage/Configurations/default.apt ##W TFPA 000017 16:50:31(002) <main_program> Warning: the value of the PWD environment variable (/detld2/etl/ascential/Ascential/DataStage/DSEngine) does not...

Hi Ray
iam trying to change the datatype from raw to string
but according to the paralleljob developer guide , there is no way to convert varbinary to string
1)convert to int32 or int 8
2)from this convert to string I Guess
Thanks
Sri

Hi Ray,
I got the detail record perfect,
I am trying in the modify stage and the error is

main_program: Error parsing modify adapter: Error in binding: Error in destination field selector: Expected integer, got: ":"; input:
recid[:string]=rejected

thanks a lot

Hi I did the same as ray said, apply the schema and i got the header and trailer inthe reject liknk, here the data is storting in the raw format(varbinary). now iam trying to modify the datatype from raw to string using the modify stage, so i can seperate the header and trailer. There are no delimit...

Hi Ray,
please can u explain me in more detail , i have to use the shell script in before routine, and reject header,footer in reject link then use modify stage?
Thanks
Sri

Hi all, iam getting a sourefile with header,detail and trailer.its a fixed widthcolumn file. Input format FHDR 453 ssb ---------header recid(4) fileid(4) filename(3) 3452671 boston invest--Detail cusip(7)place(10)type(15) FTLR 6028 0.989899---Trailer trrecid(4)totalfile(5)totalamt(10) inheader alway...

Hi all
Iam working in mq stage , if the job is successful the i have to send a message to websphere, if it fails i have to send message to database ,can u please help in this

Thanks in advance
sri