DSXchange

Are you using TRANSFOREMER in the job?? Compiler path may not be properly defined.To verify this, create a job without transformer and test it. If it compiles, fix the c++ compiler issue Thanks for your reply. i Have tested,without transformer its working fine.I am facing this problem with transfor...

Hi , I am getting below error when compiling the Datastage job. Can anyone help me to sortout the issue.below is the error for your reference. Thanks in advance Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 00:24:28(000) <main_program> IBM WebSphere DataStage Enterprise Editio...

Add a peek output stage in addition to your Oracle stage. Identify a row that isn't working correctly, and see what the contents are in the Peek stage. Is the string too large? Nulls in other columns? Key constraints in the Database? Thanks for your reply. doc_notes column datatype in database is v...

If (IsNull(lk_trim_trans.doc_notes)) Then TrimLeadingTrailing(lk_trim_trans.doc_notes) Else TrimLeadingTrailin(lk_trim_trans.doc_notes) What you are doing here is trying to Trim the NULL which is not possible. Your transform logic should be If (IsNull(lk_trim_trans.doc_notes)) Then SetNull() Else T...

hi, my job design is 2 datasets------>join--------->Transformer---------->oracle totally ihave 29 columns to insert.if i used 28 columns its going fine,whenever i used that 29th column then records are getting rejected.its nullable column. so i hard coded that column with value which is coming from ...

I'll readily agree with our most active participants. Those sources do not have standard connection stages because they do not have a fixed format that is easy to handle within DataStage. Rather than building custom components within DataStage for performing the processing from those sources, I wou...

hi,
can we use mail and html or URL as a source in Datastage.If possible please tell me how to acheive this.

Thanks in advance.

chulett wrote:Substring, conversion, math, conversion, concatenation. Probably in a Transformer with stage variables. ...

if u dontmind can you please elobratye it.

i am not able to understand.

thanks for your replies.

Sainath.Srinivasan wrote:So what comes after FFFFE8627324488B81035F2D16C99999 ?

so can you please suggest me what i need to do

i need to generate the unique number for that every time.

please help me out in this.

I am not asking about the datatype but I am asking about type of value stored in that column. If you want to do as you mentioned in first post you should first check these things 'FFFFE' is just a prefix or its a hexadecimal value. will the last 10 values always be digits? Thank you actul requireme...

priyadarshikunal wrote:this seems to be a hexadecimal value instead of just increasing 1 like in decimal. Is that the case?

thanks for your post.

its a varchar datatype in the database.

Hi,
Input value is: FFFFE8627324488
i want output as

FFFFE8627324489
FFFFE8627324490
FFFFE8627324491
FFFFE8627324492

so anyone please suggest me how to do this in datastage.

Thanks in advance.

Sainath.Srinivasan wrote:You can call an ls command and obtain the file size.

This value can be used in a nested condition to determine the flow. ...

Thanks for your replies

anyway i got the solution

find d:/new.txt -type f -size +memorysize

Thanks for all your replies.

Hi,
i want to find file size greater than 0 kb

if the file size is greater than 0kb then only i want to send that file as an attachment.

my server is in windows environment.

please help me on this.

Thanks in advance.

chulett wrote:I don't understand why people don't realize that these kind of "minimum configuration" type questions are usually impossible to answer. There's never enough details, there are way too many variables and one man's minimum is another man's molasses.

Thanks for all you guys