DSXchange

Hi,

The post had detailed explanation. Thank you.

I was looking for a command where I could export certain set of jobs to one isx file. These jobs could exist in different folders in DataStage project.

Your help is appreciated.

Thank you

Hi, I have the below conditions inorder to filter records using the transformer stage. This works fine in Development environment of 8.7 but fails in Test 8.7 environment. Stage Variable - svFLAG ---> If NullToEmpty(ERR_IND) = 'Y' then 'ERR' Else 'T' The transformer has 2 links as output - First lin...

I am encountering the same issue.. the environment parameter mentioned is set to false in both 8.1 and 8.7.

Thanks.

Hi All,

I am trying to export a job with its executable. Now when when I try importing it using import selected option I do not see the executable file.

This is a multiple instance sequence which is called in another sequence. Not sure why this happens.

Thanks & Regards,
Devi

Hi All,

I had a very simple question..

I have field of datatype Decimal (15,4)
Can I read a number value of 2774389000000 in this field?

I am trying to understand the Varchar length accepted to read the value.

Thanks

hhmm did not work..

Hi All, We are currently facing an issue with our datastage jobs. After performing the required transformations we do a self lookup on the table and then filter records as insert and update. The job has an update and insert flow to perform this. The insert flow using upsert method with the update qu...

We are using 8.0 how do i implement this here.

Well.. guess its vertical pivot.

Please elobrate how to use pivot stage in this case..

Hi All, I have a scenario to handle. Please suggest approach to design the job. Input: Column1 Column 2 Column3 4321 X1 3 4321 X2 4 4321 X3 6 Output Required: Column1 Column2 Column3 Column4 4321 3 4 6 The source is dynamic where the column2 and column3 can have new values for Column1 indicating the...

Yes, C1 column is an input column.

I tried the second option and it works.

Thanks & Regards,
Devi

Hi All, I have a scenario where I get the number of decimal points dynamically. For example: If the incoming column value for C1 is 2 then C2 must be multipled by C2*0.01 If the incoming column value for C1 is 4 then C2 must be multipled by C2*0.0001 Basically i need to multiple C2 in this way C2 * ...

Well, I used the attachement option: Please see below with the values given. Senders email address: good4@gmail.com Recipient email address: good4@gmail.com Email Suject: Error and Reprocess Records of Schedule #jp_SchdName# for Batch Number: #$UDV_BATCH_NUM# Attachments: #$UDV_INPUT_DIR#/#jp_SchdNa...

Any help on this issue...

Hi All, I have a email notification stage in the sequence thats sending an attachement to the user. The job aborts with the following message. When i re-run the job again it runs to success and sends the attachment. Any issue with the stage due which this happens? Please advice. PRS_STG_S_ERROR_STAT...